This five-day instructor-led course teaches students how to design and implement a BI infrastructure for enterprise data models and reports. The course discusses design, installation, and operations of a BI platform, including Microsoft SQL Server Analysis Services, SQL Server Reporting Services, and Microsoft SharePoint Server.
Click here to print this page »
This course requires that you meet the following prerequisites:
- At least 2 years’ experience of working with relational databases, including:
- Designing a normalized database.
- Creating tables and relationships.
- Querying with Transact-SQL.
- Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
- Some exposure to basic programming constructs (such as looping and branching).
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Detailed Class Syllabus
Module 1: Introduction to Business Intelligence and Data Modeling
Introduction to Business Intelligence
The Microsoft Enterprise BI Platform
Module 2: Creating Multidimensional Databases
Introduction to Multidimensional Analysis
Creating Data Sources and Data Source Views
Creating a Cube
Overview of Cube Security
Module 3: Working with Cubes and Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Hierarchies
Module 4: Working with Measures and Measure Groups
Working with Measures
Working with Measure Groups
Module 5: Introduction to MDX
Adding Calculations to a Cube
Using MDX to Query a Cube
Module 6: Customizing Cube Functionality
Implementing Key Performance Indicators
Module 7: Implementing an Analysis Services Tabular Data Model
Introduction to Tabular Data Models
Creating a Tabular Data Model
Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
Module 8: Introduction to Data Analysis Expression (DAX)
Using DAX to Create calculated Columns and Measures in a Tabular Data Model
Module 9: Implementing Reports with SQL Server Reporting Services
Introduction to Reporting Services
Creating a Report with Report Designer
Grouping and Aggregating Data in a Report
Showing Data Graphically
Filtering Reports Using Parameters
Module 10: Automating Report Execution and Delivery
Managing Report Security
Managing Report Execution
Delivering Reports with Subscriptions and Data Alerts
Troubleshooting Reporting Services
Module 11: Delivering BI with SharePoint PerformancePoint Services
Introduction to SharePoint Server as a BI Platform
Planning Security for a SharePoint Server BI Solution
Planning for PerformancePoint Services
Module 12: Performing Predictive Analysis with Data Mining
Overview of Data Mining
Using the Data Mining Add-in for Excel
Creating a Custom Data Mining Solution
Validating a Data Mining Model
Connecting to and Consuming Data Mining Data