50491 End to End Microsoft Business Intelligence: An exploration
of the entire stack
(taught by the book
author Ron Davis)
Five DaysInstructor-led
About this Course
This instructor-led course provides students with the knowledge and
skills to develop Microsoft End-to-End business solutions using SQL
Server 2008 R2 in an integrated environment with SharePoint 2010 and
Office 2010. The course introduces the students to Microsoft Unified
Data Model, SQL 2008 R2 Analysis Services, Integration Services,
Reporting Services, Report Builder 3.0, SharePoint 2010 Integration,
Reporting Services Content Types, PerformancePoint Services, Dashboard
Designer, Excel Services, Power Pivot and Data Mining.
Audience Profile
This course is intended for DBAs, Developers and Business
Intelligence Professionals seeking an introduction to the Microsoft BI
Stack whether for new or existing projects or migration to the Microsoft
environment or having a desire to view the new features in the entire
stack.
At Course Completion
After completing this clinic, students will be able to:
Describe the Microsoft Business Intelligence stack Explain the Unified Dimension Model and when it can and cannot be
used. Use the new Business Intelligence Features in SQL 2008 R2 Create a SSAS Project using the Microsoft Unified Dimension Model Create a Data Mart using Business Intelligence Studio Create a Integration Services project and load a Data Mart Load a Data Mart from a flat file. Model Dimensions, Measures and Cubes Understand the pros and cons of Integration into SharePoint Create a Report using Report Builder 3.0 Load and Manage Reports with SharePoint Utilize the Business Intelligence add-ins for Excel
Discover, design and implement KPIs Understand the role of SQL Server Analysis Services in measurement for
KPIs Implement Time Intelligence features to query such as Year-To-Date,
Last 6 Months etc. Use Excel Services and Excel Workbooks in Scorecards or as a data
source Utilize the document management capabilities of SharePoint 2010 for
objects for versioning, document retention and reverting. Use Dashboard Designer
Gain a generalized understanding of MDX to write basic queries Generate Visual Reports and tie them into Dashboards Utilize decomposition trees Understand what the advantages of having SharePoint as the platform
are. Use dynamic hierarchies in Scorecards Implement User Menus in Scorecards Utilize PowerPivot to analyze data Understand the basics of Data Mining and the BI plug ins for Excel
Prerequisites
Before
attending this course, students should have:
An understanding of the benefits of business intelligence.
Additional Reading
To help you prepare for this class, review the following resources: Delivering Business Intelligence with Microsoft SQL Server
Course Outline
Module 0: Course Overview
This module explains how the class will be structured and introduces
course materials and additional administrative information.
Lessons
Introduction Course Materials Facilities Prerequisites What We'll Be Discussing
Module 1: The Business Intelligence Stack
Lessons
SQL 2008R2 Business Intelligence Platform SQL Analysis Services SQL Reporting Services Performance Management Tools SharePoint 2010 Multidimensional Space MDX Data Mining Understanding the Terminology
Lab 1: The Business Intelligence Stack
Explore Business Intelligence Development Studio Connect into a SQL Server Analysis Services Cube Use SQL Server Management Studio
Explore SharePoint 2010
Module 2: Unified Data Model
Lessons
UDM Defined User Experience: Relational vs. UDM Advantages Trouble in River City
Lab 2: Unified Data Model
Creating a Data Mart using Business Intelligence Development Studio. Enabling Table Compression
Module 3: SQL Server Integration Services
Lessons
Major Components New or Changed Features Script Task SSIS and ETL
Best Practices
Lab 3: Lab SSIS Projects
Create A SSIS Project Add a Data Source Create A Data Flow
Create Another Data Flow Load Data via a SQL Statement
Populating the Fact Table Loading Manufacturing Facts
Handling Errors Inventory Fact Flow
Define an OLAP Cube Working with Measures and Measure Groups Time and Hierarchies Relating Dimensions Build Deploy and Browse the Cube Multiple Partitions Set Storage Design Aggregations Default Members
Managing Reports with SharePoint 2010 Creating Subscriptions Viewing Reports via SharePoint 2010 Report Builder 3.0
Module 6: MDX (Optional) Lessons What is MDX? MDX Query Editor Select Statement Key Concepts Sets Functions Time Intelligence
Lab 6: MDX (Optional Module) Understand the Cell Write a Tuple MDX Sets Write a SELECT statement Write a Function Implement Time Module 7: SharePoint and Business Intelligence
Lessons
What is SharePoint? What Does SharePoint Bring to the BI? Key SharePoint Concepts SharePoint Architecture Content Types Workflows in Business Intelligence Document Management features in Business Intelligence The Business Center
Lab 7: SharePoint and Business Intelligence
Setting up A Business Center Managing reports with SharePoint Creating Subscriptions to reports Using the Document Management features
Module 8: PerformancePoint Services 2010
Lessons
Integration with SharePoint Server 2010 Common Service Application Framework New PerformancePoint Features Storage Security Time Intelligence and Dynamic Filters Linking of Web Parts KPI Details Report Retired Features Scorecards in PPS KPI Collections Dashboard Design Guidelines
Lab 8: PerformancePoint Services 2010
Use SharePoint to create a site collection Configure Central Administration for PerformancePoint Services Create and Explore a PerformancePoint Business Intelligence Center Create a Basic Dashboard Deploy the Dashboard Explore the Dashboard in PPS Dashboard Designer Internals Dashboard Designer Interface First Class Objects Main Window Properties Dashboard Designer Features
Module 9: Excel Services 2010
Lessons
Integration with SharePoint Server 2010 Storage Security Single version of the truth Excel Web Services New capabilities
Lab 9: Excel Services 2010
Deploy a Excel spread sheet for a single version of the truth Utilize excel Web Services Create a UDF
Module 10: Excel PowerPivot
Lessons Integration with SharePoint Server 2010 Understanding Modeling
Lessons Key Terms in Data Mining Types of Data Mining Algorithms The Algorithms Excel and The BI Extensions Visio 2007
Lab 11: Lab Excel 2010 and Data Mining BI
At Course Completion