First time here? Take a quick tour of our comprehensive Online Training.
» Take Tour

See what people have been saying about us.
» Feedback

MSBI
INTRODUCTION
  • Introduction SQL Server 2012.
  • SQL-Architecture.
  • GAM, SGAM, Pages, Extents.
  • Database engine,
  • Multiple instances,
  • Sql server2012 editions,
  • SQL Server 2012 databases and Objects,
  • Sql Server Physical Structure.
  • MSBI studio.
  • What is new for MSBI  in SQL Server 2012?
MS-BI (SSIS, SSAS, SSRS)
SSIS Objectives
  • Plan data transfer and staging solutions for an ETL operation
  • Plan an SSIS Solution
  • Design and implement data flows
  • Incorporate logging, error handling and reliability into a package
  • Optimize an SSIS Solution
  • Deploy an SSIS Solution

Contents: Planning for ETL

  • Identifying Data Sources and Destinations
  • Evaluating Source Data
  • Identifying Staging Requirements

Planning an SSIS Solution

  • Planning Packages
  • Planning Package Development
  • Designing Package Control Flow

Designing Data Flow

  • Understanding Data Flow
  • Designing Data Flow Operations
  • Handling Data Changes

Logging, Error Handling and Reliability

  • Logging ETL Operations
  • Handling Errors in SSIS
  • Implementing Reliable ETL Processes with SSIS

Optimizing an SSIS Solution

  • Monitoring SSIS Performance
  • Optimizing SSIS Packages
  • Scaling Out SSIS Packages

Deploying and Operating an SSIS Solution

  • Deploying SSIS Packages
  • Operating an SSIS Solution

SSAS Objectives:

  • Describe how SQL Server Analysis Services can be used to implement Analytical solutions
  • Create multidimensional analysis solutions with SQL Server Analysis Services
  • Implement dimensions in an Analysis Services solution
  • Implement measures and measure groups in an Analysis Services solution
  • Query a multidimensional Analysis Services solution
  • Customize an Analysis Services cube
  • Deploy and secure an Analysis Services database
  • Maintain a multidimensional Analysis Services solution
  • Implement Data Mining solution

Contents: Introduction to Microsoft SQL Server 2012 Analysis

Services

  • Overview of Data Analysis Solutions
  • Over of SQL Server 2012 Analysis Services
  • Installing SQL Server 2012 Analysis Services

Creating Multidimensional Analysis Solution

  • Developing Analysis Services Solutions
  • Data Sources and Data Source Views
  • Creating a Cube

Working with Dimensions

  • Configuring Dimensions
  • Defining Hierarchies
  • Sorting and Grouping Attributes

Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups

Querying Multidimensional Analysis Solutions

  • MDX Fundamentals
  • Adding Calculations to a Cube

Customizing Cube Functionality

  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

Deploying and Securing an Analysis Services Database

  • Deploying an Analysis Services Database
  • Securing an Analysis Services Database

Maintaining a Multidimensional Solution

  • Configuring Processing Settings
  • Logging, Monitoring and Optimizing an Analysis Services Solution     
  • Backing Up and Restoring an Analysis Services Database

Introduction to Data Mining

  • Overview of Data Mining
  • Creating a Data Mining Solution

 

 

Testimonials

Thank you for having this. I would not have had an extended education if there was not online learning..Rama Krishna
My online course was terrific! You really do get to know the other students. I talked to more people because it was a smaller class. There was a great sense of community.........Ravinder Reddy
Superb..........Subhash
...10 out of 10 stars.....Dipu Padey
...the best out there.....Santosh.M
I found online learning more convenient then the traditional classroom because I work full-time and getting to classroom across town in traffic is problematic.......Divya
...a very effective way to learn.....Rajesh
Have a testimonial about a ACEONLINEMENTORS services? If so, send us an e-mail at feedback@aceonlinementors.com with your testimonial and how you benefited from our training.......
more testimonials..