1 – Introduction to Business Intelligence and Data Modeling
- Elements of an Enterprise BI Solution
- The Microsoft Enterprise BI Platform
- Planning an Enterprise BI Project
- Lab : Exploring a BI Solution
- Exploring the Data Warehouse
- Exploring the Analysis Services Data Model
- Exploring Reports
2 – Creating Multidimensional Databases
- Introduction to Multidimensional Analysis
- Creating Data Sources and Data Source Views
- Creating a Cube
- Overview of Cube Security
- Lab : Creating a Multidimensional Database
- Creating a Data Source
- Creating and Modifying a Data Source View
- Creating and Modifying a Cube
- Adding a Dimension
3 – Working with Cubes and Dimensions
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Hierarchies
- Lab : Defining Dimensions
- Configuring Dimensions and Attributes
- Creating Hierarchies
- Creating a Hierarchy with Attribute Relationships
- Creating a Ragged Hierarchy
- Browsing Dimensions and Hierarchies in a Cube
- After completing this module, you will be able to:
- Configure dimensions
- Define attribute hierarchies
- Sort and group attributes
4 – Working with Measures and Measure Groups
- Working with Measures
- Working with Measure Groups
- Lab : Configuring Measures and Measure Groups
- Configuring Measures
- Defining a Regular Relationship
- Configuring Measure Group Storage
- After completing this module, you will be able to:
- Configure measures
- Configure measure groups
5 – Introduction to MDX
- MDX Fundamentals
- Adding Calculations to a Cube
- Using MDX to Query a Cube
- Lab : Using MDX
- Creating Calculated Members
- Querying a Cube by Using MDX
6 – Enhancing a Cube
- Working with Key Performance Indicators
- Working with Actions
- Working with Perspectives
- Working with Translations
- Lab : Customizing a Cube
- Implementing an Action
- Implementing Perspectives
- Implementing a Translation
7 – Implementing an Analysis Services Tabular Data Model
- Introduction to Analysis Services Tabular Data Models
- Creating a Tabular Data Model
- Using an Analysis Services Tabular Data Model in the Enterprise
- Lab : Implementing an Analysis Services Tabular Data Model
- Creating an Analysis Services Tabular Data Model Project
- Configuring Columns and Relationships
- Deploying an Analysis Services Tabular Data Model
8 – Introduction to DAX
- DAX Fundamentals
- Enhancing a Tabular Data Model with DAX
- Lab : Using DAX to Enhance a Tabular Data Model
- Creating Calculated Columns
- Creating Measures
- Creating a KPI
- Implementing a Parent-Child Hierarchy
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
- Publishing and Viewing a Report
- Lab : Creating a Report with Report Designer
- Creating a Report
- Grouping and Aggregating Data
- Publishing a Report
10 – Enhancing Reports with SQL Server Reporting Services
- Showing Data Graphically
- Filtering Reports by Using Parameters
- Lab : Enhancing a Report
- Adding a Chart to a Report
- Adding Parameters to a Report
- Using Data Bars and Sparklines
- Using a Map
11 – Managing Report Execution and Delivery
- Managing Report Security
- Managing Report Execution
- Subscriptions and Data Alerts
- Troubleshooting Reporting Services
- Lab : Configuring Report Execution and Delivery
- Configuring Report Execution
- Implementing a Standard Subscription
- Implementing a Data-Driven Subscription
12 – Delivering BI with SharePoint PerformancePoint Services
- Introduction to SharePoint Server as a BI Platform
- Introduction to PerformancePoint Services
- PerformancePoint Data Sources and Time Intelligence
- Reports, Scorecards, and Dashboards
- Lab : Implementing a SharePoint Server BI Solution
- Creating a SharePoint Server Site for BI
- Configuring PerformancePoint Data Access
- Creating PerformancePoint Reports
- Creating a PerformancePoint Scorecard
- Creating a PerformancePoint Dashboard
13 – Performing Predictive Analysis with Data Mining
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating a Data Mining Model
- Consuming Data Mining Data
- Lab : Using Data Mining to Support a Marketing Campaign
- Using Table Analysis Tools
- Creating a Data Mining Structure
- Adding a Data Mining Model to a Data Mining Structure
- Validating a Data Mining Model
- Using a Data Mining Model in a Report