BI learning, Bi class, BI Courses, BI Training, office 2010 training, training office 2010, Learn Office 2010 - Course

Microsoft BI Bootcamp: SQL Server 2008 R2 and Office 2010

Next date

20 February - 24 February 2012 Australia, Melbourne

Length: 5 days
Language: English
Mentor: Francisco A González Díaz
List price: A$ 3500 (AUD)

Following dates

12 March - 16 March 2012 Australia, Brisbane Mentor: Francisco A González Díaz
List price: A$ 3500 (AUD)
Promotional Price: A$ 2975.00 (AUD) by 21 February 2012 register
26 March - 30 March 2012 Australia, Sydney Mentor: Francisco A González Díaz
List price: A$ 3500 (AUD)
Promotional Price: A$ 2975.00 (AUD) by 06 March 2012 register
16 April - 20 April 2012 Australia, Perth Mentor: Francisco A González Díaz
List price: A$ 3500 (AUD)
Promotional Price: A$ 2975.00 (AUD) by 27 March 2012 register

INFORMATION COURSE OUTLINE

Download a PDF of this Outline

Other Versions of this course

Microsoft BI Bootcamp: SQL Server 2008, and Office System 2007 and PerformancePoint Server 2007 Microsoft BI Bootcamp: SQL Server 2005, and Office System 2007 and PerformancePoint Server 2007

DescriptionWritten 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.

Target 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.

PrerequisitesThe 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 ObjectivesThrough 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.

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

Section A: Introduction to Microsoft Business Intelligence

Module A01: Introducing Microsoft Business Intelligence Defining 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 Services Reviewing ETL FundamentalsIntroducing IntegrationServices ComponentsDesigning ETL PackagesLab B02A - Developing Package Control FlowLab B02B - Developing Data Flow

Module B03: Introducing Advanced Integration Services Features Advanced 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 Dimensions Reviewing 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 Solutions Performance 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 Reports Basic 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.0 Developing 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 Reports Optimizing Report ExecutionSecuring Report Server Items and DataDelivering Reports with SubscriptionsLab D04A - Managing and Delivering Reports

Module D05: Programming Reporting Services Accessing 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 Excel Creating Reports in ExcelPublishing to Excel ServicesLab E01A - Analyzing and Reporting with ExcelLab E01B - Working with Excel Services

Module E02: Working with PowerPivot Introducing 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