Introduction to Business Intelligence and Data Modeling
o Introduction to Business Intelligence
o The Microsoft Business Intelligence Platform
Implementing Reports with SQL Server Reporting Services
o Introduction to Reporting Services
o Creating a Report with Report Designer
o Grouping and Aggregating Data in a Report
o Showing Data Graphically
o Filtering Reports by Using Parameters
o Publishing and Viewing a Report
Supporting Self Service Reporting
o Introduction to Self Service Reporting
o Shared Data Sources and Datasets
o Report Parts
Managing Report Execution and Delivery
o Managing Report Security
o Managing Report Execution
o Subscriptions and Data Alert
o Troubleshooting Reporting Services
Creating Multidimensional Databases
o Introduction to Multidimensional Analysis
o Creating Data Sources and Data Source Views
o Creating a Cube
o Overview of Cube Security
Working with Dimensions
o Configuring Dimensions
o Defining Attribute Hierarchies
o Sorting and Grouping Attributes
Working with Measures and Measure Groups
o Working with Measures
o Working with Measure Groups
Introduction to MDX
o MDX Fundamentals
o Adding Calculations to a Cube
o Using MDX to Query a Cube
Customizing Cube Functionality
o Working with Key Performance Indicators
o Working with Actions
o Working with Perspectives
o Working with Translations
Implementing a Tabular Data Model with Microsoft PowerPivot
o Introduction to Tabular Data Models and PowerPivot Technologies
o Creating a Tabular Data Model by Using PowerPivot for Excel
o Sharing a PowerPivot Workbook and Using PowerPivot Gallery
Introduction to DAX
o DAX Fundamentals
o Using DAX to Create Calculated Column and Measures in a Tabular Data Model
Implementing an Analysis Services Tabular Data Model
o Introduction to Analysis Services Tabular Data Model Projects
o Developing an Analysis Services Tabular Data Model in SQL Server Data Tools
Creating Data Visualizations with Power View
o Introduction to Power View
o Visualizing Data with Power View
Performing Predictive Analysis with Data Mining
o Overview of Data Mining
o Creating a Data Mining Solution
o Validating a Data Mining Solution
o Consuming a Data Mining Solution
