Description
Written and presented by industry experts, this
intensive five-day workshop gives professional
developers the information and hands-on experience they
need to deliver state-of-the-art, integrated reporting
and analytics solutions using Microsoft Business
Intelligence.
Delivering the right information in the right format at
the right time to all users in the
organization—that is Microsoft’s Business
Intelligence (BI) strategy and vision for enterprise
information management. Microsoft’s integrated BI
tools enable developers to create effective solutions
that information workers use every day to find
meaningful patterns in the vast sea of data they collect
and to use that insight to quickly respond to changing
business conditions.
On completion of this workshop attendees will be able to
position different types of Business Intelligence
solutions, from enterprise data warehousing to data
marts to real-time operational reporting and analytics.
Attendees will learn how to design and build powerful
integrated solutions that provide users with rich
reporting, analysis, visualization and performance
management capabilities by targeting operational data
from an existing line-of-business application using the
Microsoft Business Intelligence platform.
Attendees will work through 32 practical hands-on labs
to build a complete BI solution by the end of the
workshop.
Audience
The presentations and labs have been designed
specifically to give professional developers—those
who work for an ISV, SI, or enterprise
customer—the information they need to deliver
integrated solutions on the Microsoft BI platform.This
course is also relevant and useful for those interested
to understand and evaluate Microsoft’s Business
Intelligence offerings.
Prerequisites
The following skills and knowledge will help attendees
have a positive experience in the workshop:
-
Active development experience with C# and/or VB.NET
-
Basic understanding of Excel, SQL and relational
database concepts
**Please Note:
This workshop is designed for professional developers
with little or no experience building BI solutions. If
you already have extensive experience building solutions
on the Microsoft BI platform, you may find portions of
this workshop to be a review of material that you are
already familiar with.
The workshop focuses on a specific scenario:
supplementing an existing line-of-business application
with integrated reporting and analytics functionality
using SQL Server, Excel, PowerPivot, ProClarity, and
SharePoint (Excel Services and PerformancePoint
Services). Other scenarios, such as developing custom
reporting and analytic tools, or implementing enterprise
data warehouses, are not covered in great detail.
Course Objectives
Through interactive presentations and concrete hands-on
labs, attendees will learn:
-
How to use Microsoft SQL Server 2008 R2 to build and
manage data marts which provide a consolidated view of
organizational data.
-
How to use dimensional modeling techniques and Visio
2010 database modeling tools to create data models in
SQL Server 2008 R2 for hosting consolidated BI
information.
-
How to build consolidated data marts using SQL Server
2008 R2 Integration Services to extract, transform,
and load business-critical information into SQL Server
2008 R2 databases from disparate sources such as
business applications and corporate databases.
-
How to use SQL Server 2008 R2 Analysis Services to
create a Unified Dimensional Model (cube) that
simplifies analytical access to business-critical
data, and how to publish and collaborate on findings
using SQL Server 2008 R2 Reporting Services and
SharePoint 2010 Excel Services.
-
How to use SQL Server 2008 R2 Reporting Services to
develop predefined and ad hoc relational reports that
simplify access to business-critical information.
-
How to use SQL Server 2008 R2 Analysis Services to
create data mining models that explore, discover and
predict patterns in a data.
-
How to use PowerPivot to load and prepare disparate
data sources, and produce rich and responsive reports.
-
How to share PowerPivot reports in SharePoint 2010.
-
How to use SharePoint 2010 PerformancePoint Services
to provide integrated performance management solutions
with scorecard and analysis functionality.
-
How to build custom dashboards in SharePoint 2010 that
expose business-critical information in compelling
ways.
-
How to use ProClarity Desktop Professional for
advanced data analysis and visualization.
Course Outline
Section A: Introduction to Microsoft Business
Intelligence
-
Module A01: Introducing Microsoft Business
IntelligenceDefining Business Intelligence
(BI)Introducing the Microsoft BI PlatformIntroducing
the BI Developer’s ToolsetIntroducing Adventure
Works
Section B: Data Warehouse Design and ETL with
Integration Services
-
Module B01: Introducing Dimensional Modeling
TechniquesDesigning the Dimensional ModelIntroducing
Additional Design Concepts Lab B01A - Exploring the
Data Warehouse Schema with Visio
-
Module B02: Designing ETL Solutions with Integration
ServicesReviewing ETL FundamentalsIntroducing
IntegrationServices ComponentsDesigning ETL
PackagesLab B02A - Developing Package Control FlowLab
B02B - Developing Data Flow
-
Module B03: Introducing Advanced Integration Services
FeaturesAdvanced Data FlowManageability
FeaturesProgrammabilityLab B03A - Using the Slowly
Changing Dimension Component
Section C: Cubes and Data Mining with Analysis Services;
-
Module C01: Developing Analysis Services Cubes and
DimensionsReviewing OLAP FundamentalsUnderstanding
Database ComponentsLab C01A - Creating a Basic CubeLab
C01B - Configuring the Dimensions and Dimension
UsageLab C01C - Enriching the Cube with Calculations
and Actions
-
Module C02: Processing and Deploying Analysis Services
SolutionsPerformance Tuning; Programming Analysis
ServicesLab C02A - Managing Dimension and Cube
ProcessingLab C02B - Developing a Database Installer
Package
-
Module C03: Developing Analysis Services Data Mining
Models Introducing Data MiningIntegration with SQL
Server 2008 R2 ComponentsData Mining
ProgrammabilityLab C03A - Developing and Querying Data
Mining ModelsLab C03B - Integrating Data Mining with
Integration Services
Section D: Reporting Solutions with Reporting Services
-
Module D01: Introducing Reporting ServicesReporting
Fundamentals; Introducing Reporting Services
-
Module D02: Authoring Reporting Services ReportsBasic
Report Design; Introducing Report
InteractivityExtending Reports with Custom Logic;
Introducing Report Builder 3.0Lab D02A - Authoring
Reports Based on Relational Databases, Part 1Lab D02B
- Authoring Reports Based on Relational Databases,
Part 2Lab D02C - Authoring Reports Based on CubesLab
D02D - Authoring Reports Based on Data Mining Models
-
Module D03: Delivering Ad Hoc Reporting With Report
Builder 1.0Developing Report Models; Introducing
Report Builder 1.0Creating Reports with Report Builder
1.0Lab D03A - Developing a Report ModelLab D03B -
Authoring Reports Based on Report Models
-
Module D04: Managing and Delivering Reporting Services
ReportsOptimizing Report ExecutionSecuring Report
Server Items and DataDelivering Reports with
SubscriptionsLab D04A - Managing and Delivering
Reports
-
Module D05: Programming Reporting ServicesAccessing
Reports in Reporting ServicesAccessing Reports
ProgrammaticallyEmbedding Reports into .NET
ApplicationsLab D05A - Managing Report Content with
ScriptLab D05B - Embedding Reports with the
ReportViewer Control
Section E: Self-Service Business Intelligence with
Office and ProClarity
-
Module E01: Creating and Sharing Reports with
ExcelCreating Reports in ExcelPublishing to Excel
ServicesLab E01A - Analyzing and Reporting with
ExcelLab E01B - Working with Excel Services
-
Module E02: Working with PowerPivotIntroducing
PowerPivotLoading Data into PowerPivotCreating
PowerPivot ReportsIntroducing DAXWorking with
PowerPivot in SharePointLab E02A – Creating a
PowerPivot ModelLab E02B – Creating Reports
Based on a PowerPivot ModelLab E02C - Enriching a
PowerPivot Model with Calculations Lab E02D - Working
with PowerPivot in SharePoint
-
Module E03: Creating SharePoint DashboardsReviewing
Dashboard FundamentalsIntroducing the SharePoint BI
FeaturesLab E03A - Creating a SharePoint Dashboard
-
Module E04: Advanced Cube Analysis with ProClarity
Desktop ProfessionalIntroducing PerformancePoint
Services (PPS)Building ScorecardsDefining PPS
ElementsLab E04A - Creating PerformancePoint KPIs and
a ScorecardLab E04B - Creating PerformancePoint
Reports and Dashboards
Technologies
The workshop will empower developers to exploit the BI
functionality in the following technologies:
- SQL Server 2008 R2 Database
- ServicesSQL Server 2008 R2 Integration
- ServicesSQL Server 2008 R2 Reporting Services
-
SQL Server 2008 R2 Analysis Services (OLAP and Data
Mining)Office Visio 2010
- Office Excel 2010SharePoint 2010
- SharePoint 2010 Excel Services
- SharePoint 2010 PerformancePoint Services
- PowerPivot for Excel 2010
- PowerPivot for SharePoint 2010
- ProClarity Professional Desktop 6.3
Location Details
Course Materials
- Download a PDF of this outline
Related Links