Esquema Detallado del Curso
Module 1: Introduction to Business Intelligence and Data Modeling
- Elements of an Enterprise BI Solution
- The Microsoft Enterprise BI Platform
- Planning an Enterprise BI Project
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
- Configuring 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
- MDX Fundamentals
- Adding Calculations to a Cube
- Using MDX to Query a Cube
Module 6: Enhancing a Cube
- Working with Key Performance Indicators
- Working with Actions
- Working with Perspectives
- Working with Translations
Module 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
Module 8: Introduction to DAX
- DAX Fundamentals
- Enhancing a Tabular Data Model with DAX
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
- Publishing and Viewing a Report
Module 10: Enhancing Reports with SQL Server Reporting Services
- Showing Data Graphically
- Filtering Reports by Using Parameters
Module 11: Managing Report Execution and Delivery
- Managing Report Security
- Managing Report Execution
- Subscriptions and Data Alerts
- Troubleshooting Reporting Services
Module 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
Module 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
Labs
- Exploring a BI Solution
- Creating a Multidimensional Database
- Defining Dimensions
- Configuring Measures and Measure Groups
- Using MDX
- Customizing a Cube
- Implementing an Analysis Services Tabular Data Model
- Using DAX to Enhance a Tabular Data Model
- Creating a Report with Report Designer
- Enhancing a Report
- Configuring Report Execution and Delivery
- Implementing a SharePoint Server BI Solution
- Using Data Mining to Support a Marketing Campaign