Microsoft Learning Logo is a registered trademark of Microsoft. All rights reserved.
Designing Business Intelligence Solutions with Microsoft SQL Server 2014
Schedule
Start | End | Duration | Location | Details |
---|
Course Details
Designing Business Intelligence Solutions with Microsoft SQL Server 2014
Course Code: 20467
Duration: 5 days
Prerequisite:
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
Course 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.
Course Objectives:
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.
Intended Audience:
This course is not designed for students who are new to SQL Server 2014 BI technologies; it is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.
Course Outline:
Module 1: Planning a BI Solution
- Elements of a BI Solution
- Planning a BI Project
- The Microsoft BI Platform
Module 2: Planning SQL Server Business Intelligence Infrastructure
- Considerations of BI Infrastructure
- Planning Data Warehouse Hardware
Module 3: Designing a Data Warehouse
- Data Warehouse Design Overview
- Designing Dimension Tables
- Design FACT tables
Module 4: Designing an ETL solution
- ETL Overview
- Planning for Data Extraction
- Planning for Data Transformations
- Planning for Data Loading
Module 5: Designing Analytical Data Models
- Introduction to Analytical data Models
- Designing Analytical Data Models
Module 6: Planning a BI Delivery Solution
- Considerations for BI delivery
- Common Reporting Scenarios
- Choosing a Reporting Tool
Module 7: Designing a Reporting Services Solution
- Planning a Reporting Solution
- Designing Reports
- Planning Report Consistency
Module 8: Designing an Excel Based reporting Solution
- Using Excel for Data Reporting and Analysis
- PowerPivot in Excel
- Power View in Excel
Module 9: Planning a SharePoint Server BI Solution
- 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
Module 10: Monitoring and Optimizing a BI Solution
- Overview of BI Monitoring
- Monitoring and Optimizing the Data Warehouse
- Monitoring and Analyzing Analysis Services
- Monitoring and Optimizing Reporting Services
Module 11: Operating a BI Solution
- Overview of BI Operations
- ETL Operations
- Data Warehouse Operations
- Analysis Services Operations
- Reporting Services Operations