1 - Planning a BI Solution
Elements of a BI SolutionPlanning a BI ProjectThe Microsoft BI PlatformLab: Planning BI Solutions
2 - Planning BI Infrastructure
Considerations of BI InfrastructurePlanning Data Warehouse HardwareLab: Planning BI Infrastructure
3 - Designing a Data Warehouse
Data Warehouse Design OverviewDesigning Dimension TablesDesign FACT tablesLab: Designing a Data Warehouse Logical Schema
4 - Designing an ETL Solution
ETL OverviewPlanning for Data ExtractionPlanning for Data TransformationsPlanning for Data LoadingLab: Designing an ETL Solution
5 - Designing Analytical Data Models
Introduction to Analytical data ModelsDesigning Analytical Data ModelsLab: Designing Analytical Data ModelLab: Designing Dimensions and Hierarchies
6 - Planning a BI Delivery Solution
Considerations for BI deliveryCommon Reporting ScenariosChoosing a Reporting ToolLab: Planning a BI Delivery Solution
7 - Designing a Reporting Services Solution
Planning a Reporting SolutionDesigning ReportsPlanning Report ConsistencyLab: Designing a Reporting Services Solution
8 - Designing an Excel Based Reporting Solution
Using Excel for Data Reporting and AnalysisPowerPivot in ExcelPower View in ExcelLab: Designing and Excel Reporting Solution
9 - Planning a Sharepoint Server BI Solution
Introduction to SharePoint Server as a BI PlatformPlanning Security for a SharePoint Server BI SolutionPlanning Reporting Services ConfigurationPlanning PowerPivot ConfigurationPlanning for PerformancePoint ServicesLab: Implementing a SharePoint Server BI SolutionLab: Implementing PerformancePoint Services
10 - Monitoring & Optimizing a BI Solution
Overview of BI MonitoringMonitoring and Optimizing the Data WarehouseMonitoring and Analyzing Analysis ServicesMonitoring and Optimizing Reporting ServicesLab: Monitoring and Optimizing a BI Solution
11 - Operating a BI Solution
Overview of BI OperationsETL OperationsData Warehouse OperationsAnalysis Services OperationsReporting Services OperationsLab: Operating a BI Solution
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
The primary audience for this course is database and business intelligence (BI) professionals who are familiar with data warehouses and enterprise BI solutions built with SQL Server technologies. Experienced data analysts who want to learn how to use Microsoft technologies for self-service analysis and reporting will also benefit from attending this course.
This course requires that you meet the following prerequisites: Knowledge of data warehousing and data modeling principles and familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.