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
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 Power Pivot 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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.