1 - Introduction to Business Intelligence and Data Modeling
Elements of an Enterprise BI SolutionThe Microsoft Enterprise BI PlatformPlanning an Enterprise BI ProjectLab : Exploring a BI Solution
2 - Creating Multidimensional Databases
Introduction to Multidimensional AnalysisCreating Data Sources and Data Source ViewsCreating a CubeOverview of Cube SecurityLab : Creating a Multidimensional Database
3 - Working with Cubes and Dimensions
Configuring DimensionsDefining Attribute HierarchiesSorting and Grouping HierarchiesLab : Defining Dimensions
4 - Working with Measures and Measure Groups
Working with MeasuresWorking with Measure GroupsLab : Configuring Measures and Measure Groups
5 - Introduction to MDX
MDX FundamentalsAdding Calculations to a CubeUsing MDX to Query a CubeLab : Using MDX
6 - Enhancing a Cube
Working with Key Performance IndicatorsWorking with ActionsWorking with PerspectivesWorking with TranslationsLab : Customizing a Cube
7 - Implementing an Analysis Services Tabular Data Model
Introduction to Analysis Services Tabular Data ModelsCreating a Tabular Data ModelUsing an Analysis Services Tabular Data Model in the EnterpriseLab : Implementing an Analysis Services Tabular Data Model
8 - Introduction to DAX
DAX FundamentalsEnhancing a Tabular Data Model with DAXLab : Using DAX to Enhance a Tabular Data Model
9 - Implementing Reports with SQL Server Reporting Services
Introduction to Reporting ServicesCreating a Report with Report DesignerGrouping and Aggregating Data in a ReportPublishing and Viewing a ReportLab : Creating a Report with Report Designer
10 - Enhancing Reports with SQL Server Reporting Services
Showing Data GraphicallyFiltering Reports by Using ParametersLab : Enhancing a Report
11 - Managing Report Execution and Delivery
Managing Report SecurityManaging Report ExecutionSubscriptions and Data AlertsTroubleshooting Reporting ServicesLab : Configuring Report Execution and Delivery
12 - Delivering BI with SharePoint PerformancePoint Services
Introduction to SharePoint Server as a BI PlatformIntroduction to PerformancePoint ServicesPerformancePoint Data Sources and Time IntelligenceReports, Scorecards, and DashboardsLab : Implementing a SharePoint Server BI Solution
13 - Performing Predictive Analysis with Data Mining
Overview of Data MiningCreating a Data Mining SolutionValidating a Data Mining ModelConsuming Data Mining DataLab : Using Data Mining to Support a Marketing Campaign
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:
Implementing analytical data models, such as OLAP cubes.
Implementing reports, and managing report delivery.
Creating business performance dashboards.
Supporting data mining and predictive analysis.