SolidQ - Microsoft BI Immersion: SQL Server 2012 and Office 2010

See the SolidQ BI Bootcamp

Description

Written and presented by industry experts, this intensive five-day course gives professional developers the knowledge and hands-on experience they need to start producing state-of-the-art, integrated reporting and analytics solutions using Microsoft Business Intelligence (BI).

Delivering the right information in the right format at the right time to all users in the organization—that is Microsoft’s BI strategy and vision. Microsoft’s integrated BI products enable developers to create effective solutions that information workers can use to find meaningful patterns in the vast sea of data they collect, and to use these insights to quickly respond to changing business conditions.

On completion of this course attendees will be able to understand different types of BI solutions, from enterprise data warehousing to data marts to real-time operational reporting and analytics. Attendees will learn how to design and develop powerful integrated solutions that provide information workers with rich reporting, analysis, visualization and performance management capabilities.

Attendees will have a unique opportunity to complete practical hands-on labs that build a complete end-to-end BI solution.

Target Audience

The presentations and hands-on labs have been specifically designed to provide professional developers the knowledge they need to produce integrated solutions based on the Microsoft BI platform.

This course is also relevant and useful for those interested to understand and evaluate Microsoft’s BI products.

Prerequisites

Before attending this course, it is recommended that attendees have the following skills:

• T-SQL and database design knowledge
• Familiarized with Microsoft Office 2010.

Note: This course 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 course to be a review of material that you are already familiar with.

The course focuses on a specific scenario: supplementing an existing line-of-business application with integrated reporting and analytics functionality using SQL Server, Excel, PowerPivot, and SharePoint (Excel Services, Visio Services, PerformancePoint Services and Power View). Other scenarios, such as developing custom reporting and analytic tools, or implementing enterprise data warehouses, are not covered in depth.

Course Objectives

Upon completion of this course, students will know how to:

• Design and manage data marts to provide a consolidated view of organizational data.
• Populate data marts by developing SQL Server 2012 Integration Services solutions to extract, transform, and load business-critical information sourced from disparate data sources, such as business applications and corporate databases.
• Develop SQL Server 2012 Analysis Services data models that provide high query performance, encapsulate business rules, and simplify access to business data.
• Develop SQL Server 2012 Analysis Services data mining models to explore, discover and predict patterns in data.
• Develop, manage and deliver SQL Server 2012 Reporting Services reports.
• Create rich, interactive reports in Excel 2010, and publish these to SharePoint 2010.
• Create PowerPivot workbooks to relate local, ad hoc or corporate data stores.
• Publish and manage PowerPivot workbooks in SharePoint 2010.
• Create data-driven diagrams in SharePoint 2010 Visio Services.
• Create SharePoint 2010 dashboards to expose business-critical information in compelling ways.
• Create SharePoint 2010 PerformancePoint Services performance management solutions with scorecard and analytics functionality.
• Create rich, visually impressive reports using Power View.

Course Summary Outline

DAY 1

A. Introduction to Microsoft Business Intelligence

Module A01: Introduction to Microsoft Business Intelligence

• Defining Business Intelligence (BI); Introducing the Microsoft BI platform; Introducing the BI developer’s toolset; Introducing Adventure Works

B. Data Warehouse Design and ETL with Integration Services

Module B01: Introducing Dimensional Modeling Techniques

• Designing dimensional models; Introducing additional design concepts | Lab B01A – Exploring the Data Warehouse Schema with Visio

Module B02: Introducing Master Data Services

• Introducing Master Data Services | Lab B02A – Creating a Master List

Module B03: Introducing Data Quality Services

• Reviewing data quality concepts; Introducing Data Quality Services | Lab B03A – Creating a Knowledge Base

DAY 2

Module B04: Designing ETL Solutions with Integration Services

• Reviewing ETL Fundamentals; Introducing Integration Services components; Designing ETL packages | Lab B04A – Developing a Package Control Flow | Lab B04B – Developing a Data Flow

Module B05: Introducing Advanced Integration Services Design

• Advanced data flow design; Introducing the manageability features; Deploying Integration Services solutions; Programming Integration Services | Lab B05A – Implementing Advanced Package Design

C. Data Modeling with Analysis Services

Module C01: Designing Analysis Services BI Semantic Models

• Introducing the BI Semantic Model; Developing multidimensional projects; Developing tabular projects | Lab C01A – Developing a Tabular Project

Module C02: Processing and Deploying Analysis Services Solutions

• Model processing; Model security; Project deployment; Programming Analysis Services | Lab C02A – Deploying and Managing a Tabular Database

DAY 3

D. Data Mining with Analysis Services

Module D01: Designing Analysis Services Data Mining Models

• Introducing data mining; Integration with SQL Server; Data Mining programming | Lab D01A – Developing and Querying Data Mining Models | Lab D01B – Integrating Data Mining with Integration Services

E. Reporting Solutions with Reporting Services

Module E01: Introducing Reporting Services

• Reporting fundamentals; Introducing Reporting Services

Module E02: Authoring Reporting Services Reports

• Introducing basic report design; Managing report deployment; Working with report parts; Introducing report interactivity; Extending reports with custom logic; Reporting from Analysis Services models | Lab E02A – Authoring Reports Based on Relational Data, Part 1 | Lab E02B – Authoring Reports Based on Relational Data, Part 2 | Lab E02C – Authoring Reports Based on BI Semantic Models | Lab E02D – Authoring Reports Based on Data Mining Models

DAY 4

Module E03: Managing and Delivering Reporting Services Reports

• Optimizing report execution; Securing report server items and data; Working with data alerts; Delivering reports with subscriptions | Lab E03A – Working with Data Alerts | Lab E03B – Managing and Delivering Reports

Module E04: Programming Reporting Services

• Defining URL access; Scripting with the RS Utility; Accessing reports programmatically; Embedding reports into .NET applications | Lab E04A – Managing Report Content with Script | Lab E04B – Embedding Reports with the ReportViewer Control

F. Self-Service Business Intelligence

Module F01: Creating and Sharing Reports with Excel

• Creating reports with Excel; Introducing Excel Services; Publishing Excel workbooks to SharePoint | Lab F01A – Analyzing and Reporting with Excel | Lab F01B – Working with Excel Services

Module F02: Working with PowerPivot

• Introducing PowerPivot; Creating PowerPivot data models; Creating PowerPivot reports; Introducing DAX; Working with PowerPivot in SharePoint | Lab F02A – Creating a PowerPivot Workbook | Lab F02B – Creating a Report Based on a PowerPivot Workbook | Lab F02C – Working with PowerPivot in SharePoint

DAY 5

Module F03: Working with Visio Services

• Introducing Visio Services in SharePoint | Lab F03A – Creating and Publishing a Data-Driven Process Diagram

Module F04: Creating SharePoint Dashboards

• Reviewing dashboard fundamentals; Introducing the SharePoint BI web parts | Lab F04A – Creating a SharePoint Dashboard

Module F05: Creating PerformancePoint Services Dashboards

• Introducing PerformancePoint Services (PPS); Building scorecards; Defining PPS elements | Lab F05A – Creating PerformancePoint KPIs and a Scorecard | Lab F05B – Creating PerformancePoint Reports and a Dashboard

Module F06: Working with Power View

• Introducing Power View; Optimizing a tabular BI Semantic Model for Power View | Lab F06A – Optimizing a Tabular BI Semantic Model for Power View | Lab F06B – Working with Power View

Location Details

Melbourne	TBC
Sydney	SSW Offices | Directions

Other SolidQ Courses

• Optimization/Performance Tuning and Troubleshooting
• Accelerated SQL Server 2012 Integration Services
• T-SQL Fundamentals