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.
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.
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
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.
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.
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
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
- Download a PDF of this outline