Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Description

This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.

Benefit

After completing this course, students will be able to: • Plan a BI solution. • Plan SQL Server BI infrastructure. • Design a data warehouse. • Design an extract, transform and load (ETL) solution. • Design analytical data models. • Plan a BI delivery solution. • Design a Reporting Services solution. • Design a Microsoft Excel-based reporting solution. • Plan a SharePoint Server BI solution. • Monitor and optimize a BI solution. • Operate a BI solution.

Content

-

Course

Planning a BI SolutionThis module enables students to plan the components of a BI Solution.Lessons • Elements of a BI Solution • Planning a BI Project • The Microsoft BI Platform Lab : Planning BI Solutions After completing this module, you will be able to: • Describe the components of a BI Solution. • Identify the components of a BI Solution. • Plan a BI Project.

Planning SQL Server Business Intelligence InfrastructureThis module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.Lessons • Considerations of BI Infrastructure • Planning Data Warehouse Hardware Lab : Planning BI Infrastructure After completing this module, you will be able to: • Describe the components of a BI Infrastructure and where you would use them. • Plan for the hardware requirements of a data warehouse implementation.

Designing a Data WarehouseThis module describes how to design a data warehouse given a set of user requirements.Lessons • Data Warehouse Design Overview • Designing Dimension Tables • Design FACT tables Lab : Designing a Data Warehouse Logical Schema After completing this module, you will be able to: • Design a data warehouse. • Design dimension tables. • Design Fact tables. • Design a logical schema for a data warehouse.

Designing an ETL solutionThis lesson describes how to design an extract, transform and load (ETL) solution.Lessons • ETL Overview • Planning for Data Extraction • Planning for Data Transformations • Planning for Data Loading Lab : Designing an ETL Solution After completing this module, you will be able to: • Describe the components of an ETL solution. • Design an ETL solution.

Designing Analytical Data ModelsThis module describes how to design analytical data models for specific BI scenarios.Lessons • Introduction to Analytical data Models • Designing Analytical Data Models Lab : Designing Analytical Data ModelLab : Designing Dimensions and Hierarchies After completing this module, you will be able to: • Describe the features of an analytical data model. • Design an analytical data model.

Planning a BI Delivery SolutionThis module describes how to choose an appropriate delivery solution for a given scenario.Lessons • Considerations for BI delivery • Common Reporting Scenarios • Choosing a Reporting Tool Lab : Planning a BI Delivery Solution After completing this module, you will be able to: • Describe the components of a BI delivery solution. • Describe some common reporting scenarios. • Choose an appropriate delivery solution for a given scenario.

Designing a Reporting Services SolutionThis module describes how to design a reporting services solution.Lessons • Planning a Reporting Solution • Designing Reports • Planning Report Consistency Lab : Designing a Reporting Services Solution After completing this module, you will be able to: • Plan for a reporting Services solution. • Design reports for a reporting services solutions. • Plan for consistency of reporting

Designing an Excel Based reporting SolutionIn this module students will learn how to design a reporting solution using Excel.Lessons • Using Excel for Data Reporting and Analysis • PowerPivot in Excel • Power View in Excel Lab : Designing and Excel Reporting Solution After completing this module, you will be able to: • Describe key features of excel reporting solutions. • Use PowerPivot in Excel to create reports. • Use Power View in excel to create reports.

Planning a SharePoint Server BI SolutionThis module introduces the use of SharePoint Server as a BI solution.Lessons • Introduction to SharePoint Server as a BI Platform • Planning Security for a SharePoint Server BI Solution • Planning Reporting Services Configuration • Planning PowerPivot Configuration • Planning for PerformancePoint Services Lab : Implementing a SharePoint Server BI SolutionLab : Implementing PerformancePoint Services After completing this module, you will be able to: • Describe the components of a SharePoint Server BI solution. • Plan security for a SharePoint Server BI solution. • Plan reporting solutions for a SharePoint Server BI solution. • Describe the components of a PerformancePoint Solution. • Implement PerformancePoint services.

Monitoring and Optimizing a BI SolutionAt the conclusion of this module you will be able to optimize and monitor a BI solution.Lessons • Overview of BI Monitoring • Monitoring and Optimizing the Data Warehouse • Monitoring and Analyzing Analysis Services • Monitoring and Optimizing Reporting Services Lab : Monitoring and Optimizing a BI Solution After completing this module, you will be able to: • Describe the options for monitoring and optimizing a BI solution. • Be able to monitor and optimize a BI solution.

Operating a BI SolutionAt the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.Lessons • Overview of BI Operations • ETL Operations • Data Warehouse Operations • Analysis Services Operations • Reporting Services Operations Lab : Operating a BI Solution After completing this module, you will be able to: • Describe the components to be managed in a BI Solution. • Be able to manage the components of a BI solution.

Methodology

1
• Presentation • Discussion • Practice Activities • Case Studies

Evaluation

1
• Pre test • Post test

Duration

5 Days

Target Audience

IT Professionals

Schedule

Sep 2017Dec 2017
04-0811-15