Microsoft SQL Server 2012: Designing Buisness Intelligence Solutions
Längd: 5 Days Kurskod: M20467 Version: A
Sammanfattning:
Denna 5-dagarskurs lär dig hur du designar och implementerar en BI-Infrastruktur. Kursen tar upp och diskuterar design, installation och underhåll av en BI-plattform. Kursen mappar mot Microsofts certifiering 70-647: Designing Business Intelligence Solutions with Microsoft SQL Server 2012, och tillsammans med praktisk erfarenhet hjälper den dig att förbereda för certifieringen.
Kursen är till för dig som jobbar med BI och beslutsstöd och som behöver designa BI-lösningar. Arkitekter som behöver designa hur en BI-infrastruktur relaterar till andra system som används har stor nytta av denna kurs. Du får även lära dig hur du designar Online Analytical Processing (OLAP) kuber och integrerar det med Microsoft SharePoint eller övriga applikationer. Man lär sig även att tillämpa dessa kunskaper i en Windows Azure SQL Server-databas.
Målsättning:
Plan the components of a BI solution. Design an Excel reporting solution.
Plan a BI infrastructure. Design a data warehouse. Plan a SharePoint Server BI solution. Design an ETL solution. Plan analytical data models. Monitor and optimize a BI solution. Plan a BI delivery solution. Design a Reporting Services solution. Plan for BI operations
Förkunskaper:
Ha grundläggande förståelse för dimensional modeling (star schema) i Data Warehouse
Kunna skapa en multidimensionell kub med Analysis Services Kunna skapa en tabellmodell med PowerPivot och Analysis Services
Kunna skapa Reporting Services med Report Designer
Kunna implementera autentisering och Permissions i SQL Server databasmotorn, Analysis Services och Reporting Services Vara bekant med SharePoint Server och Microsoft-applikationer, speciellt Excel Elever som går denna kurs kan med fördel tidigare ha gått följande kurser: 10777 - Microsoft SQL Server 2012: Data Warehouse
Innehåll:
Module 1: Planning a BI Solution This This module explains how to design an ETL This module explains how to design a
modules discusses how to plan the solution for a data warehouse. Reporting Services solution.
components of a BI solution. line line
line
Lessons Lessons
Lessons: line line
line Planning a Data Warehouse Planning a Data Warehouse Infrastructure
Elements of a BI Solution Infrastructure Planning an ETL Infrastructure
Planning a BI Project Planning an ETL Infrastructure Planning Analysis Services Infrastructure
The Microsoft BI Platform Planning Analysis Services Infrastructure Planning Reporting Services Infrastructure
Lab : Planning a BI Solution Planning Reporting Services Lab : Planning a BI Infrastructure
Exercise 1: Scoping a BI Solution. Infrastructure Exercise 1: Determining Required Servers
Exercise 2: Reviewing a Suggested Solution Lab : Planning a BI Infrastructure Exercise 2: Determining Data Warehouse After completing this module, students will Exercise 1: Determining Required Server Hardware Requirements
be able to: Servers Exercise 3: Reviewing a Suggested
Describe elements of a BI Solution. Exercise 2: Determining Data Warehouse Solution
Describe considerations for a BI project. Server Hardware Requirements After completing this module, students will Describe how Microsoft products can be Exercise 3: Reviewing a Suggested be able to:
used to implement a BI solution. Solution Plan a data warehouse infrastructure
After completing this module, students Plan an ETL infrastructure
Module 2: Planning a BI Infrastructure will be able to: Plan Analysis Services infrastructure
line Plan a data warehouse infrastructure Plan Reporting Services infrastructure
Plan an ETL infrastructure Designing a Logical Schema
This modules explains how to plan an Plan Analysis Services infrastructure Designing a Physical Schema Lab : appropriate BI infrastructure for a given set of Plan Reporting Services infrastructure Designing a Data Warehouse Logical
BI services. Designing a Logical Schema Schema
line Designing a Physical Schema Lab : Exercise 1: Identifying Required
Designing a Data Warehouse Logical Dimensions
Lessons Schema Exercise 2: Identifying Measures and
line Exercise 1: Identifying Required Hierarchies
Planning a Data Warehouse Infrastructure Dimensions Exercise 3: Designing a Data Warehouse
Planning an ETL Infrastructure Exercise 2: Identifying Measures and Schema
Planning Analysis Services Infrastructure Hierarchies Exercise 4: Reviewing a Suggested
Planning Reporting Services Infrastructure Exercise 3: Designing a Data Warehouse Solution
Lab : Planning a BI Infrastructure Schema Lab : Designing a Data Warehouse
Exercise 1: Determining Required Servers Exercise 4: Reviewing a Suggested Physical Schema
Exercise 2: Determining Data Warehouse Solution Exercise 1: Planning Database Storage
Server Hardware Requirements Lab : Designing a Data Warehouse Exercise 2: Designing Partitioning
Exercise 3: Reviewing a Suggested Solution Physical Schema Exercise 3: Designing Indexes
After completing this module, students will Exercise 1: Planning Database Storage Exercise 4: Reviewing a Suggested
be able to: Exercise 2: Designing Partitioning Solution
Plan a data warehouse infrastructure Exercise 3: Designing Indexes After completing this module, students will
Plan an ETL infrastructure Exercise 4: Reviewing a Suggested be able to:
Plan Analysis Services infrastructure Solution Select a data modeling approach.
Plan Reporting Services infrastructure After completing this module, students Design a physical data warehouse schema
Designing a Logical Schema will be able to: Planning for Data Extraction
Designing a Physical Schema Lab : Select a data modeling approach. Planning for Data Transformation Designing a Data Warehouse Logical Design a physical data warehouse Planning for Data Loading
Schema schema Planning for SSIS Package Deployment
Exercise 1: Identifying Required Dimensions Planning for Data Extraction Lab : Designing an ETL Solution Exercise 2: Identifying Measures and Planning for Data Transformation Exercise 1: Reviewing Data Sources
Hierarchies Planning for Data Loading Exercise 2: Creating Source-to-Target
Exercise 3: Designing a Data Warehouse Planning for SSIS Package Deployment Maps
Schema Lab : Designing an ETL Solution Exercise 3: Planning ETL Processes
Exercise 4: Reviewing a Suggested Solution Exercise 1: Reviewing Data Sources Exercise 4: Reviewing a Suggested Lab : Designing a Data Warehouse Physical Exercise 2: Creating Source-to-Target Solution
Schema Maps After completing this module, students will
Exercise 1: Planning Database Storage Exercise 3: Planning ETL Processes be able to:
Exercise 2: Designing Partitioning Exercise 4: Reviewing a Suggested Plan data extraction in an ETL solution.
Exercise 3: Designing Indexes Solution Plan data transformation in an ETL
Exercise 4: Reviewing a Suggested Solution After completing this module, students solution.
After completing this module, students will will be able to: Plan data loading in an ETL solution.
be able to: Plan data extraction in an ETL solution. Plan SSIS package deployment
Design a physical data warehouse schema solution. Design Considerations
Planning for Data Extraction Plan data loading in an ETL solution. Lab : Comparing Analytical Data Models Planning for Data Transformation Plan SSIS package deployment Exercise 1: Creating a Multidimensional
Planning for Data Loading Options for Analytical Models Data Model Model
Planning for SSIS Package Deployment Design Considerations Exercise 2: Creating a Tabular Model
Lab : Designing an ETL Solution Lab : Comparing Analytical Data Models Lab : Designing Data Models Exercise 1: Reviewing Data Sources Exercise 1: Creating a Multidimensional Exercise 1: Designing Dimension
Exercise 2: Creating Source-to-Target Maps Model Attributes
Exercise 3: Planning ETL Processes Exercise 2: Creating a Tabular Model Exercise 2: Designing Data Model Exercise 4: Reviewing a Suggested Solution Lab : Designing Data Models Aggregations and Storage After completing this module, students will Exercise 1: Designing Dimension Exercise 3: Reviewing a Suggested
be able to: Attributes Solution
Plan data extraction in an ETL solution. Exercise 2: Designing Data Model After completing this module, students will Plan data transformation in an ETL solution. Aggregations and Storage be able to:
Plan data loading in an ETL solution. Exercise 3: Reviewing a Suggested Describe options for analytical models.
Plan SSIS package deployment Solution Describe considerations for cube design.
Options for Analytical Models Data Model After completing this module, students Considerations for BI Delivery Choosing a
Design Considerations will be able to: Delivery Approach
Lab : Comparing Analytical Data Models Describe options for analytical models. Lab : Planning a BI Delivery Solution Exercise 1: Creating a Multidimensional Describe considerations for cube design. Exercise 1: Assessing Reporting
Model Considerations for BI Delivery Choosing Requirements
Exercise 2: Creating a Tabular Model a Delivery Approach After completing this module, students will
Lab : Designing Data Models Lab : Planning a BI Delivery Solution be able to:
Exercise 1: Designing Dimension Attributes Exercise 1: Assessing Reporting Describe considerations for planning a BI
Exercise 2: Designing Data Model Requirements delivery solution.
Aggregations and Storage After completing this module, students Choose an appropriate technique for a
Exercise 3: Reviewing a Suggested Solution will be able to: given scenario.
After completing this module, students will Describe considerations for planning a BI Designing Reports
be able to: delivery solution. Considerations for Report Execution
Describe options for analytical models. Choose an appropriate technique for a Planning a Reporting Solution
Describe considerations for cube design. given scenario. Lab : Designing a Reporting Services
Considerations for BI Delivery Choosing a Designing Reports Solution
Delivery Approach Considerations for Report Execution Exercise 1: Planning a Reporting Services
Lab : Planning a BI Delivery Solution Planning a Reporting Solution Solution
Exercise 1: Assessing Reporting Lab : Designing a Reporting Services Exercise 2: Planning a Report Delivery
Requirements Solution Environment
After completing this module, students will Exercise 1: Planning a Reporting Exercise 3: Configuring Report Execution
be able to: Services Solution After completing this module, students will
Describe considerations for planning a BI Exercise 2: Planning a Report Delivery be able to:
delivery solution. Environment Plan a reporting solution.
Choose an appropriate technique for a given Exercise 3: Configuring Report Execution Describe considerations for report data.
scenario. After completing this module, students Describe considerations for report
Designing Reports will be able to: execution.
Considerations for Report Execution Plan a reporting solution. Using Excel for Data Reporting and Planning a Reporting Solution Describe considerations for report data. Analysis
Lab : Designing a Reporting Services Describe considerations for report PowerPivot in Excel
Solution execution. Power View in Excel
Exercise 1: Planning a Reporting Services Using Excel for Data Reporting and Lab : Designing an Excel Reporting
Solution Analysis Solution
Exercise 2: Planning a Report Delivery PowerPivot in Excel Exercise 1: Planning Excel Features
Environment Power View in Excel Exercise 2: Analyzing a Cube with Excel
Exercise 3: Configuring Report Execution Lab : Designing an Excel Reporting Exercise 3: Using PowerPivot
After completing this module, students will Solution Exercise 4: Using Power View
be able to: Exercise 1: Planning Excel Features After completing this module, students will
Plan a reporting solution. Exercise 2: Analyzing a Cube with Excel be able to:
Describe considerations for report data. Exercise 3: Using PowerPivot Use Excel to analyze data. Describe considerations for report execution. Exercise 4: Using Power View Use PowerPivot to analyze data. Using Excel for Data Reporting and Analysis After completing this module, students Use Power View to analyze data.
PowerPivot in Excel will be able to: Introduction to SharePoint Server as a BI
Power View in Excel Use Excel to analyze data. Platform
Lab : Designing an Excel Reporting Solution Use PowerPivot to analyze data. Planning Security for a SharePoint Server Exercise 1: Planning Excel Features Use Power View to analyze data. BI Solution
Exercise 2: Analyzing a Cube with Excel Introduction to SharePoint Server as a BI Planning Reporting Services Configuration
Exercise 3: Using PowerPivot Platform Planning PowerPivot Configuration
Exercise 4: Using Power View Planning Security for a SharePoint Server Planning for PerformancePoint Services
be able to: Planning Reporting Services Solution
Use Excel to analyze data. Configuration Exercise 1: Planning SharePoint Server
Use PowerPivot to analyze data. Planning PowerPivot Configuration Security
Use Power View to analyze data. Planning for PerformancePoint Services Exercise 2: Configuring Reporting Services Introduction to SharePoint Server as a BI Lab : Planning a SharePoint Server BI in SharePoint Server
Platform Solution Exercise 3: Managing PowerPivot Data
Planning Security for a SharePoint Server BI Exercise 1: Planning SharePoint Server Refresh
Solution Security Exercise 4: Reviewing PowerPivot Activity
Planning Reporting Services Configuration Exercise 2: Configuring Reporting Exercise 5 (Optional) Creating a
Planning PowerPivot Configuration Services in SharePoint Server PerformancePoint Dashboard
Planning for PerformancePoint Services Exercise 3: Managing PowerPivot Data After completing this module, students will
Lab : Planning a SharePoint Server BI Refresh be able to:
Solution Exercise 4: Reviewing PowerPivot Describe key considerations for using
Exercise 1: Planning SharePoint Server Activity SharePoint for BI
Security Exercise 5 (Optional) Creating a Describe key considerations for security
Exercise 2: Configuring Reporting Services PerformancePoint Dashboard when using SharePoint for BI
in SharePoint Server After completing this module, students Plan the deployment and configuration of
Exercise 3: Managing PowerPivot Data will be able to: Reporting Services in SharePoint
Refresh Describe key considerations for using Integration Mode
Exercise 4: Reviewing PowerPivot Activity SharePoint for BI Plan the deployment and configuration of
Exercise 5 (Optional) Creating a Describe key considerations for security PowerPivot
PerformancePoint Dashboard when using SharePoint for BI Plan PerformancePoint Services in a
After completing this module, students will Plan the deployment and configuration of SharePoint site
be able to: Reporting Services in SharePoint
Describe key considerations for using Integration Mode Module 8: Designing an Excel-Based
SharePoint for BI Plan the deployment and configuration of Reporting Solution
Describe key considerations for security PowerPivot line
when using SharePoint for BI Plan PerformancePoint Services in a
Plan the deployment and configuration of SharePoint site This module explains how to design a
Reporting Services in SharePoint Integration reporting solution that uses Excel.
Mode Module 5: Designing Analytical Data line
Plan the deployment and configuration of Models
PowerPivot line Lessons
Plan PerformancePoint Services in a line
SharePoint site This module explains how to design analytical Planning a Data Warehouse Infrastructure data models for specific BI scenarios. Planning an ETL Infrastructure
Module 3: Designing a Data Warehouse line Planning Analysis Services Infrastructure
line Planning Reporting Services Infrastructure
Lessons Lab : Planning a BI Infrastructure
This module explain how to design a data line Exercise 1: Determining Required Servers
warehouse for a given set of user Planning a Data Warehouse Exercise 2: Determining Data Warehouse
requirements. Infrastructure Server Hardware Requirements
line Planning an ETL Infrastructure Exercise 3: Reviewing a Suggested
Planning Analysis Services Infrastructure Solution
Lessons Planning Reporting Services After completing this module, students will
line Infrastructure be able to:
Planning a Data Warehouse Infrastructure Lab : Planning a BI Infrastructure Plan a data warehouse infrastructure Planning an ETL Infrastructure Exercise 1: Determining Required Plan an ETL infrastructure
Planning Analysis Services Infrastructure Servers Plan Analysis Services infrastructure
Planning Reporting Services Infrastructure Exercise 2: Determining Data Warehouse Plan Reporting Services infrastructure
Lab : Planning a BI Infrastructure Server Hardware Requirements Designing a Logical Schema
Exercise 1: Determining Required Servers Exercise 3: Reviewing a Suggested Designing a Physical Schema Lab :
Exercise 2: Determining Data Warehouse Solution Designing a Data Warehouse Logical
Server Hardware Requirements After completing this module, students Schema
Exercise 3: Reviewing a Suggested Solution will be able to: Exercise 1: Identifying Required
After completing this module, students will Plan a data warehouse infrastructure Dimensions
be able to: Plan an ETL infrastructure Exercise 2: Identifying Measures and
Plan a data warehouse infrastructure Plan Analysis Services infrastructure Hierarchies
Plan an ETL infrastructure Plan Reporting Services infrastructure Exercise 3: Designing a Data Warehouse
Plan Analysis Services infrastructure Designing a Logical Schema Schema
Plan Reporting Services infrastructure Designing a Physical Schema Lab : Exercise 4: Reviewing a Suggested
Designing a Logical Schema Designing a Data Warehouse Logical Solution
Designing a Physical Schema Lab : Schema Lab : Designing a Data Warehouse
Designing a Data Warehouse Logical Exercise 1: Identifying Required Physical Schema
Schema Dimensions Exercise 1: Planning Database Storage
Exercise 2: Identifying Measures and Hierarchies Exercise 3: Designing Indexes
Hierarchies Exercise 3: Designing a Data Warehouse Exercise 4: Reviewing a Suggested
Exercise 3: Designing a Data Warehouse Schema Solution
Schema Exercise 4: Reviewing a Suggested After completing this module, students will
Exercise 4: Reviewing a Suggested Solution Solution be able to:
Lab : Designing a Data Warehouse Physical Lab : Designing a Data Warehouse Select a data modeling approach.
Schema Physical Schema Design a physical data warehouse schema
Exercise 1: Planning Database Storage Exercise 1: Planning Database Storage Planning for Data Extraction Exercise 2: Designing Partitioning Exercise 2: Designing Partitioning Planning for Data Transformation
Exercise 3: Designing Indexes Exercise 3: Designing Indexes Planning for Data Loading
Exercise 4: Reviewing a Suggested Solution Exercise 4: Reviewing a Suggested Planning for SSIS Package Deployment
After completing this module, students will Solution Lab : Designing an ETL Solution
be able to: After completing this module, students Exercise 1: Reviewing Data Sources
Select a data modeling approach. will be able to: Exercise 2: Creating Source-to-Target
Design a physical data warehouse schema Select a data modeling approach. Maps
Planning for Data Extraction Design a physical data warehouse Exercise 3: Planning ETL Processes
Planning for Data Transformation schema Exercise 4: Reviewing a Suggested
Planning for Data Loading Planning for Data Extraction Solution
Planning for SSIS Package Deployment Planning for Data Transformation After completing this module, students will
Lab : Designing an ETL Solution Planning for Data Loading be able to:
Exercise 1: Reviewing Data Sources Planning for SSIS Package Deployment Plan data extraction in an ETL solution. Exercise 2: Creating Source-to-Target Maps Lab : Designing an ETL Solution Plan data transformation in an ETL Exercise 3: Planning ETL Processes Exercise 1: Reviewing Data Sources solution.
Exercise 4: Reviewing a Suggested Solution Exercise 2: Creating Source-to-Target Plan data loading in an ETL solution.
After completing this module, students will Maps Plan SSIS package deployment
be able to: Exercise 3: Planning ETL Processes Options for Analytical Models Data Model
Plan data extraction in an ETL solution. Exercise 4: Reviewing a Suggested Design Considerations
Plan data transformation in an ETL solution. Solution Lab : Comparing Analytical Data Models
Plan data loading in an ETL solution. After completing this module, students Exercise 1: Creating a Multidimensional
Plan SSIS package deployment will be able to: Model
Options for Analytical Models Data Model Plan data extraction in an ETL solution. Exercise 2: Creating a Tabular Model
Design Considerations Plan data transformation in an ETL Lab : Designing Data Models
Lab : Comparing Analytical Data Models solution. Exercise 1: Designing Dimension
Exercise 1: Creating a Multidimensional Plan data loading in an ETL solution. Attributes
Model Plan SSIS package deployment Exercise 2: Designing Data Model
Exercise 2: Creating a Tabular Model Options for Analytical Models Data Model Aggregations and Storage
Lab : Designing Data Models Design Considerations Exercise 3: Reviewing a Suggested
Exercise 1: Designing Dimension Attributes Lab : Comparing Analytical Data Models Solution
Exercise 2: Designing Data Model Exercise 1: Creating a Multidimensional After completing this module, students will
Aggregations and Storage Model be able to:
Exercise 3: Reviewing a Suggested Solution Exercise 2: Creating a Tabular Model Describe options for analytical models. After completing this module, students will Lab : Designing Data Models Describe considerations for cube design.
be able to: Exercise 1: Designing Dimension Considerations for BI Delivery Choosing a
Describe options for analytical models. Attributes Delivery Approach
Describe considerations for cube design. Exercise 2: Designing Data Model Lab : Planning a BI Delivery Solution Considerations for BI Delivery Choosing a Aggregations and Storage Exercise 1: Assessing Reporting
Delivery Approach Exercise 3: Reviewing a Suggested Requirements
Lab : Planning a BI Delivery Solution Solution After completing this module, students will
Exercise 1: Assessing Reporting After completing this module, students be able to:
Requirements will be able to: Describe considerations for planning a BI
After completing this module, students will Describe options for analytical models. delivery solution.
be able to: Describe considerations for cube design. Choose an appropriate technique for a
Describe considerations for planning a BI Considerations for BI Delivery Choosing given scenario.
delivery solution. a Delivery Approach Designing Reports
Choose an appropriate technique for a given Lab : Planning a BI Delivery Solution Considerations for Report Execution
scenario. Exercise 1: Assessing Reporting Planning a Reporting Solution
Designing Reports Requirements Lab : Designing a Reporting Services
Considerations for Report Execution After completing this module, students Solution
Planning a Reporting Solution will be able to: Exercise 1: Planning a Reporting Services
Lab : Designing a Reporting Services Describe considerations for planning a BI Solution
Solution delivery solution. Exercise 2: Planning a Report Delivery
Exercise 1: Planning a Reporting Services Choose an appropriate technique for a Environment
Solution given scenario. Exercise 3: Configuring Report Execution
Exercise 2: Planning a Report Delivery Designing Reports After completing this module, students will
Environment Considerations for Report Execution be able to:
After completing this module, students will Lab : Designing a Reporting Services Describe considerations for report data.
be able to: Solution Describe considerations for report
Plan a reporting solution. Exercise 1: Planning a Reporting execution.
Describe considerations for report data. Services Solution Using Excel for Data Reporting and
Describe considerations for report execution. Exercise 2: Planning a Report Delivery Analysis
Using Excel for Data Reporting and Analysis Environment PowerPivot in Excel
PowerPivot in Excel Exercise 3: Configuring Report Execution Power View in Excel
Power View in Excel After completing this module, students Lab : Designing an Excel Reporting
Lab : Designing an Excel Reporting Solution will be able to: Solution
Exercise 1: Planning Excel Features Plan a reporting solution. Exercise 1: Planning Excel Features Exercise 2: Analyzing a Cube with Excel Describe considerations for report data. Exercise 2: Analyzing a Cube with Excel
Exercise 3: Using PowerPivot Describe considerations for report Exercise 3: Using PowerPivot
Exercise 4: Using Power View execution. Exercise 4: Using Power View
After completing this module, students will Using Excel for Data Reporting and After completing this module, students will
be able to: Analysis be able to:
Use Excel to analyze data. PowerPivot in Excel Use Excel to analyze data.
Use PowerPivot to analyze data. Power View in Excel Use PowerPivot to analyze data.
Use Power View to analyze data. Lab : Designing an Excel Reporting Use Power View to analyze data.
Introduction to SharePoint Server as a BI Solution Introduction to SharePoint Server as a BI
Platform Exercise 1: Planning Excel Features Platform
Planning Security for a SharePoint Server BI Exercise 2: Analyzing a Cube with Excel Planning Security for a SharePoint Server
Solution Exercise 3: Using PowerPivot BI Solution
Planning Reporting Services Configuration Exercise 4: Using Power View Planning Reporting Services Configuration Planning PowerPivot Configuration After completing this module, students Planning PowerPivot Configuration
Planning for PerformancePoint Services will be able to: Planning for PerformancePoint Services
Lab : Planning a SharePoint Server BI Use Excel to analyze data. Lab : Planning a SharePoint Server BI
Solution Use PowerPivot to analyze data. Solution
Exercise 1: Planning SharePoint Server Use Power View to analyze data. Exercise 1: Planning SharePoint Server
Security Introduction to SharePoint Server as a BI Security
Exercise 2: Configuring Reporting Services Platform Exercise 2: Configuring Reporting Services
in SharePoint Server Planning Security for a SharePoint Server in SharePoint Server
Exercise 3: Managing PowerPivot Data BI Solution Exercise 3: Managing PowerPivot Data
Refresh Planning Reporting Services Refresh
Exercise 4: Reviewing PowerPivot Activity Configuration Exercise 4: Reviewing PowerPivot Activity
Exercise 5 (Optional) Creating a Planning PowerPivot Configuration Exercise 5 (Optional) Creating a
PerformancePoint Dashboard Planning for PerformancePoint Services PerformancePoint Dashboard
After completing this module, students will Lab : Planning a SharePoint Server BI After completing this module, students will
be able to: Solution be able to:
Describe key considerations for using Exercise 1: Planning SharePoint Server Describe key considerations for using
SharePoint for BI Security SharePoint for BI
Describe key considerations for security Exercise 2: Configuring Reporting Describe key considerations for security
when using SharePoint for BI Services in SharePoint Server when using SharePoint for BI
Plan the deployment and configuration of Exercise 3: Managing PowerPivot Data Plan the deployment and configuration of
Reporting Services in SharePoint Integration Refresh Reporting Services in SharePoint
Mode Exercise 4: Reviewing PowerPivot Integration Mode
Plan the deployment and configuration of Activity Plan the deployment and configuration of
PowerPivot Exercise 5 (Optional) Creating a PowerPivot
Plan PerformancePoint Services in a PerformancePoint Dashboard Plan PerformancePoint Services in a
SharePoint site After completing this module, students SharePoint site
will be able to:
Module 4: Designing an ETL Solution Describe key considerations for using Module 9: Planning a SharePoint Server BI
line SharePoint for BI Solution
Describe key considerations for security line
when using SharePoint for BI
Plan the deployment and configuration of This module explains how to design a Reporting Services in SharePoint SharePoint BI solution.
Integration Mode line
Plan the deployment and configuration of
PowerPivot Lessons
Plan PerformancePoint Services in a line
SharePoint site Planning a Data Warehouse Infrastructure
Planning an ETL Infrastructure
Module 6: Planning a BI Delivery Solution Planning Analysis Services Infrastructure
line Planning Reporting Services Infrastructure
Lab : Planning a BI Infrastructure This module explains how to choose an Exercise 1: Determining Required Servers
appropriate delivery solution for a given Exercise 2: Determining Data Warehouse
scenario. Server Hardware Requirements
line Exercise 3: Reviewing a Suggested
Solution
Lessons After completing this module, students will
line be able to:
Planning a Data Warehouse Plan a data warehouse infrastructure
Infrastructure Plan an ETL infrastructure
Planning an ETL Infrastructure Plan Analysis Services infrastructure Planning Analysis Services Infrastructure Plan Reporting Services infrastructure
Planning Reporting Services Designing a Logical Schema
Infrastructure Designing a Physical Schema Lab :
Lab : Planning a BI Infrastructure Designing a Data Warehouse Logical
Exercise 1: Determining Required Schema
Servers Exercise 1: Identifying Required
Exercise 2: Determining Data Warehouse Dimensions
Server Hardware Requirements Exercise 2: Identifying Measures and Exercise 3: Reviewing a Suggested Hierarchies
Solution Exercise 3: Designing a Data Warehouse
After completing this module, students Schema
will be able to: Exercise 4: Reviewing a Suggested
Plan a data warehouse infrastructure Solution
Plan an ETL infrastructure Lab : Designing a Data Warehouse
Plan Analysis Services infrastructure Physical Schema
Plan Reporting Services infrastructure Exercise 1: Planning Database Storage Designing a Logical Schema Exercise 2: Designing Partitioning Designing a Physical Schema Lab : Exercise 3: Designing Indexes Designing a Data Warehouse Logical Exercise 4: Reviewing a Suggested
Schema Solution
Exercise 1: Identifying Required After completing this module, students will
Dimensions be able to:
Exercise 2: Identifying Measures and Select a data modeling approach.
Hierarchies Design a physical data warehouse schema
Exercise 3: Designing a Data Warehouse Planning for Data Extraction
Schema Planning for Data Transformation
Exercise 4: Reviewing a Suggested Planning for Data Loading
Solution Planning for SSIS Package Deployment
Lab : Designing a Data Warehouse Lab : Designing an ETL Solution
Physical Schema Exercise 1: Reviewing Data Sources
Exercise 1: Planning Database Storage Exercise 2: Creating Source-to-Target Exercise 2: Designing Partitioning Maps
Exercise 3: Designing Indexes Exercise 3: Planning ETL Processes Exercise 4: Reviewing a Suggested Exercise 4: Reviewing a Suggested
Solution Solution
After completing this module, students After completing this module, students will
will be able to: be able to:
Select a data modeling approach. Plan data extraction in an ETL solution. Design a physical data warehouse Plan data transformation in an ETL
schema solution.
Planning for Data Extraction Plan data loading in an ETL solution. Planning for Data Transformation Plan SSIS package deployment
Planning for Data Loading Options for Analytical Models Data Model Planning for SSIS Package Deployment Design Considerations
Lab : Designing an ETL Solution Lab : Comparing Analytical Data Models Exercise 1: Reviewing Data Sources Exercise 1: Creating a Multidimensional Exercise 2: Creating Source-to-Target Model
Maps Exercise 2: Creating a Tabular Model
Exercise 3: Planning ETL Processes Lab : Designing Data Models Exercise 4: Reviewing a Suggested Exercise 1: Designing Dimension
Solution Attributes
After completing this module, students Exercise 2: Designing Data Model
will be able to: Aggregations and Storage
Plan data extraction in an ETL solution. Exercise 3: Reviewing a Suggested Plan data transformation in an ETL Solution
solution. After completing this module, students will
Plan SSIS package deployment Describe options for analytical models. Options for Analytical Models Data Model Describe considerations for cube design.
Design Considerations Considerations for BI Delivery Choosing a
Lab : Comparing Analytical Data Models Delivery Approach
Exercise 1: Creating a Multidimensional Lab : Planning a BI Delivery Solution
Model Exercise 1: Assessing Reporting
Exercise 2: Creating a Tabular Model Requirements
Lab : Designing Data Models After completing this module, students will Exercise 1: Designing Dimension be able to:
Attributes Describe considerations for planning a BI
Exercise 2: Designing Data Model delivery solution.
Aggregations and Storage Choose an appropriate technique for a
Exercise 3: Reviewing a Suggested given scenario.
Solution Designing Reports
After completing this module, students Considerations for Report Execution
will be able to: Planning a Reporting Solution
Describe options for analytical models. Lab : Designing a Reporting Services Describe considerations for cube design. Solution
Considerations for BI Delivery Choosing Exercise 1: Planning a Reporting Services
a Delivery Approach Solution
Lab : Planning a BI Delivery Solution Exercise 2: Planning a Report Delivery
Exercise 1: Assessing Reporting Environment
Requirements Exercise 3: Configuring Report Execution
After completing this module, students After completing this module, students will
will be able to: be able to:
Describe considerations for planning a BI Plan a reporting solution.
delivery solution. Describe considerations for report data.
Choose an appropriate technique for a Describe considerations for report
given scenario. execution.
Designing Reports Using Excel for Data Reporting and
Considerations for Report Execution Analysis
Planning a Reporting Solution PowerPivot in Excel
Lab : Designing a Reporting Services Power View in Excel
Solution Lab : Designing an Excel Reporting
Exercise 1: Planning a Reporting Solution
Services Solution Exercise 1: Planning Excel Features
Exercise 2: Planning a Report Delivery Exercise 2: Analyzing a Cube with Excel
Environment Exercise 3: Using PowerPivot
Exercise 3: Configuring Report Execution Exercise 4: Using Power View
After completing this module, students After completing this module, students will
will be able to: be able to:
Plan a reporting solution. Use Excel to analyze data.
Describe considerations for report data. Use PowerPivot to analyze data. Describe considerations for report Use Power View to analyze data.
execution. Introduction to SharePoint Server as a BI
Using Excel for Data Reporting and Platform
Analysis Planning Security for a SharePoint Server
PowerPivot in Excel BI Solution
Power View in Excel Planning Reporting Services Configuration
Lab : Designing an Excel Reporting Planning PowerPivot Configuration
Solution Planning for PerformancePoint Services
Exercise 1: Planning Excel Features Lab : Planning a SharePoint Server BI Exercise 2: Analyzing a Cube with Excel Solution
Exercise 3: Using PowerPivot Exercise 1: Planning SharePoint Server
Exercise 4: Using Power View Security
After completing this module, students Exercise 2: Configuring Reporting Services
will be able to: in SharePoint Server
Use Excel to analyze data. Exercise 3: Managing PowerPivot Data
Use PowerPivot to analyze data. Refresh
Use Power View to analyze data. Exercise 4: Reviewing PowerPivot Activity Introduction to SharePoint Server as a BI Exercise 5 (Optional) Creating a
Platform PerformancePoint Dashboard
Planning Security for a SharePoint Server After completing this module, students will
BI Solution be able to:
Planning Reporting Services Describe key considerations for using
Planning PowerPivot Configuration Describe key considerations for security Planning for PerformancePoint Services when using SharePoint for BI
Lab : Planning a SharePoint Server BI Plan the deployment and configuration of
Solution Reporting Services in SharePoint
Exercise 1: Planning SharePoint Server Integration Mode
Security Plan the deployment and configuration of
Exercise 2: Configuring Reporting PowerPivot
Services in SharePoint Server Plan PerformancePoint Services in a Exercise 3: Managing PowerPivot Data SharePoint site
Refresh
Exercise 4: Reviewing PowerPivot Activity
Exercise 5 (Optional) Creating a PerformancePoint Dashboard After completing this module, students will be able to:
Describe key considerations for using SharePoint for BI
Describe key considerations for security when using SharePoint for BI
Plan the deployment and configuration of Reporting Services in SharePoint Integration Mode
Plan the deployment and configuration of PowerPivot
Plan PerformancePoint Services in a SharePoint site
Module 7: Designing a Reporting Services Solution
line
Övrig information:
För mer information eller kursbokning, vänligen kontakta oss på telefon. 020-73 73 73 [email protected]
www.globalknowledge.se
