50491A: End to End Microsoft Business Intelligence
Course Length: Five Days
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 course, 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
Prerequisites:
Before attending this course, students should have:
•An understanding of the benefits of business intelligence.
Course Outline:
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 : 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 : 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
•Samples
•SSIS and ETL
•Transformers
•Best Practices 1
•Best Practices 2
Lab : 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
Module 4: SQL Server Analysis Services
Lessons
•Key Concepts
•Schemas
•Measures
•Dimensions
•Cube Processing
•Partitions
•Proactive Caching
•Aggregations
Lab : Lab SSAS Key Concepts
•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
Module 5: SQL Server Reporting Services
Lessons
•Integration with SharePoint
•Report Builder 3.0
•Tablix
•Charts
Lab : Lab SQL Server Reporting Services
•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 : MDX (Optional Module)
•Understand the Cell
•Write a Tuple
•MDX Sets
•Write a SELECT statement
•Write a Function
•Implement Time
Module 7: 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 : 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 8: Excel and Visio Services 2010
Lessons
•Integration with SharePoint Server 2010
•Storage Security
•Single version of the truth
•Excel Web Services
•New capabilities
Lab : Excel Services 2010
•Deploy a Excel spread sheet for a single version of the truth
•Utilize excel Web Services
•Create a Strategy map with Visio Services
Module 9: Excel PowerPivot
Lessons
•Integration with SharePoint Server 2010
•Understanding
•Modeling
Lab : PowerPivot 2010
•Explore Excel PowerPivot
Module 10: Data Mining
Lessons
•Key Terms in Data Mining
•Types of Data Mining Algorithms
•The Algorithms
•Excel and The BI Extensions
•Visio 2007
Lab : Lab Excel 2010 and Data Mining BI
•Utilize the Excel Data Mining Tools
Additional Reading
To help you prepare for this class, review the following
resources:
Delivering Business Intelligence with Microsoft SQL Server
|
