Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (20467)
Cours disponible en français ou en anglais - Training available in French or in English
Durée: 5 jours
Objectifs du cours :
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.
Compétences acquises :
Module 1: Planning a BI Solution
This module enables students to plan the components of a BI Solution.
After completing this module, you will be able to:
Module 2: Planning SQL Server Business Intelligence Infrastructure
This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.
After completing this module, you will be able to:
Module 3: Designing a Data Warehouse
This module describes how to design a data warehouse given a set of user requirements.
After completing this module, you will be able to:
Module 4: Designing an ETL solution
This lesson describes how to design an extract, transform and load (ETL) solution.
After completing this module, you will be able to:
Module 5: Designing Analytical Data Models
This module describes how to design analytical data models for specific BI scenarios.
After completing this module, you will be able to:
Module 6: Planning a BI Delivery Solution
This module describes how to choose an appropriate delivery solution for a given scenario.
After completing this module, you will be able to:
Module 7: Designing a Reporting Services Solution
This module describes how to design a reporting services solution.
After completing this module, you will be able to:
Module 8: Designing an Excel Based reporting Solution
In this module students will learn how to design a reporting solution using Excel.
After completing this module, you will be able to:
Module 9: Planning a SharePoint Server BI Solution
This module introduces the use of SharePoint Server as a BI solution.
After completing this module, you will be able to:
Module 10: Monitoring and Optimizing a BI Solution
At the conclusion of this module you will be able to optimize and monitor a BI solution.
After completing this module, you will be able to:
Module 11: Operating a BI Solution
At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.
After completing this module, you will be able to:
Connaissances requises :
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
Cours disponible en français ou en anglais - Training available in French or in English
Durée: 5 jours
Objectifs du cours :
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.
Compétences acquises :
Module 1: Planning a BI Solution
This module enables students to plan the components of a BI Solution.
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.
Module 2: Planning SQL Server Business Intelligence Infrastructure
This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.
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.
Module 3: Designing a Data Warehouse
This module describes how to design a data warehouse given a set of user requirements.
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.
Module 4: Designing an ETL solution
This lesson describes how to design an extract, transform and load (ETL) solution.
After completing this module, you will be able to:
- Describe the components of an ETL solution.
- Design an ETL solution.
Module 5: Designing Analytical Data Models
This module describes how to design analytical data models for specific BI scenarios.
After completing this module, you will be able to:
- Describe the features of an analytical data model.
- Design an analytical data model.
Module 6: Planning a BI Delivery Solution
This module describes how to choose an appropriate delivery solution for a given scenario.
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.
Module 7: Designing a Reporting Services Solution
This module describes how to design 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
Module 8: Designing an Excel Based reporting Solution
In this module students will learn how to design a reporting solution using Excel.
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.
Module 9: Planning a SharePoint Server BI Solution
This module introduces the use of SharePoint Server as a BI solution.
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.
Module 10: Monitoring and Optimizing a BI Solution
At the conclusion of this module you will be able to optimize and monitor 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.
Module 11: Operating a BI Solution
At the conclusion of this module you will be able to plan management and maintenance operations of 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.
Connaissances requises :
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- A basic understanding of dimensional modeling (star schema) for data warehouses
- Basic server hardware knowledge
- The ability to create Integration Services packages that include control flows and data flows
- The ability to create a basic multidimensional cube with Analysis Services
- The ability to create a basic tabular model with PowerPivot and Analysis Services
- The ability to create Reporting Services reports with Report Designer
- The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
- Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel