Home / Courses / Microsoft Technology / 50511A: The Microsoft Business Intelligence 2010 Stack

SQL

50511A: The Microsoft Business Intelligence 2010 Stack

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
•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 SQL Server Analysis Services
•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
•Differences Between Environments
•Tablix
•Charts
Lab : Lab SQL Server Reporting Services
•SSRS Projects Report Wizard
•Report Builder 3.0
•Creating Charts
 

Module 6: MDX (0ptional)
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
•Dashboard Designer Internals
•Dashboard Designer Interface
•First Class Objects
•Main Window
•Properties
•Dashboard Designer Features
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
 

Module 8: Excel Services, Business Connectivity Services
Lessons
•Integration with SharePoint Server 2010
•Storage Security
•Single version of the truth
•Excel Web Services
•New capabilities in Excell Services
•Business Connectivity Services
Lab : Excel Services 2010
•Deploy a Excel spread sheet for a single version of the truth
•Utilize Excel Web Services
•Business Connectivity 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 Algorithm
•Excel and The BI Extensions
•Visio 2010
Lab : Lab Excel 2010 and Data Mining BI
•Utilize the Excel Data Mining Tools

Course Registration

 

5 days
$2,750.00

 

Course Outline

 

Request