• Presenter
    • Peter Myers
  • Duration
    • 5 days
  • Price (ex GST)
    • $3,375

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.

After 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 25 practical hands-on labs to build a complete BI solution by the end of the workshop.

Course Location Saxons in Sydney CBD
Level 10, 10 Barrack St Sydney
Course Times 9am-5pm
Who should attend those who work for an ISV, SI, or enterprise customer
Pre Requisites
  • Active development experience with C# and/or VB.NET
  • Basic understanding of SQL and relational database technology

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, Office, SharePoint and PerformancePoint. Other scenarios, such as developing custom reporting and analytic tools, or implementing enterprise data warehouses, are not covered in great detail.

The workshop utilizes pre-release versions of Microsoft software, which may affect the accuracy, completeness or stability of portions of this workshop. Every effort will be made to insure that participants get the most recent information and the most stable environment possible in the workshop.

Course Objectives

Through interactive presentations and concrete hands-on labs, attendees will learn:

  • How to use Microsoft SQL Server 2008 to build and manage data marts which provide a consolidated view of business intelligence information.
  • How to use the 2007 Microsoft Office system, Office SharePoint Server 2007, and Office PerformancePoint Server 2007 to provide a rich data analysis, visualization and performance management experience for end users.
  • How to use dimensional modeling techniques and Visio 2007 database modeling tools to create data models in SQL Server 2008 for hosting consolidated BI information.
  • How to build consolidated data marts using SQL Server 2008 Integration Services to extract, transform, and load business-critical information into SQL Server 2008 databases from disparate sources such as business applications and corporate databases.
  • How to use SQL Server 2008 Reporting Services to develop predefined and ad hoc relational reports that simplify access to business-critical information, and how to publish and share those reports using Office SharePoint Server 2007 report libraries.
  • How to use SQL Server 2008 Analysis Services to create a unified dimensional model that simplifies analytical access to business-critical information stored in SQL Server 2008, and how to publish and collaborate on findings using SQL Server 2008 Reporting Services and Excel Services in Office SharePoint Server 2007.
  • How to use SQL Server 2008 Analysis Services to create data mining models that explore, uncover and predict patterns in a BI solution.
  • How to use Excel 2007, Visio 2007 and ProClarity Professional Desktop for advanced data analysis and visualization.
  • How to build dashboards in Office SharePoint Server 2007 that expose business-critical information in compelling ways, and how to build and deploy custom dashboards by creating site templates and custom Web parts.
  • How to use Office PerformancePoint Server 2007 to provide integrated performance-management solutions with scorecarding, planning and analysis functionality.

Agenda

Day 1

Topic Description
Module 1
Microsoft BI Strategy Overview
  • Defining Business Intelligence (BI)
  • Introducing the Microsoft BI Platform
  • Introducing the BI Developer's Toolset
  • Introducing Adventure Works Cycles Company
Module 2
Introduction to Dimensional Modeling Techniques
  • Designing the Dimensional Model
  • Introducing Additional Design Concepts
  • Lab 02A - Database Modeling (Creating the Reseller Sales Database Diagram)
Module 3
Introduction to ETL Techniques Using SSIS
  • Reviewing ETL Fundamentals
  • Introducing SSIS Components
  • Designing ETL Packages
  • Lab 03A - Control Flow (Loading the Sales Quota Fact Table, Part 1)
  • Lab 03B - Data Flow (Loading the Sales Quota Fact Table, Part 2)
Module 4
Advanced SSIS
  • Advanced Data Flow
  • Manageability Features
  • Programmability
  • Lab 04A - Slowly Changing Dimensions (Loading the Employee Dimension)

Day 2

Module 5
Introduction to SSRS
  • Reporting Fundamentals
  • Introducing Reporting Services (SSRS)
  • Basic SSRS Report Design
  • Lab 05A - Creating Managed Reports (Developing a Report for Publication)
Module 6
Advanced SSRS
  • Introducing Report Interactivity
  • Extending Reports with Custom Logic
  • Optimizing Report Execution
  • Managing the Report Server with Utilities
  • Lab 06A - Advanced Managed Reports (Enhancing the Report Design)
  • Lab 06B - Advanced SSRS Features (Managing and Distributing Reports)
Module 7
Designing a Report Model for ad hoc Reporting
  • Introducing Report Builder
  • Reviewing Report Models
  • Creating Reports with Report Builder
  • Lab 07A - Report Builder (Self-Service Reporting)
Module 8
Publishing and Accessing Reports Using SSRS
  • Reviewing Report Deployment Options
  • Accessing Reports in SSRS
  • Accessing Reports Programmatically
  • Embedding Reports in .NET Applications
  • Lab 08A - Programmatic Report Deployment (Using the RS Utility)
  • Lab 08B - Using the ReportViewer Control (Smart Client Integrated Reporting)

Day 3

Module 9
Introduction to the UDM
  • Reviewing OLAP Fundamentals
  • Understanding Database Components
  • Performance Tuning
  • Programming SSAS
  • Lab 09A - Building a Basic Cube (The Cube Wizard)
  • Lab 09B - Working with Dimensions (Enriching the Dimension Space)
  • Lab 09C - Calculations, KPIs and Actions (Enriching the Cube Space)
  • Lab 09D - Dimension and Cube Processing (Managing Data Processing)
  • Lab 09E - Cube Deployment (Developing an Installer Package)
Module 10
Accessing the UDM from SSRS and Excel Services
  • Accessing the UDM from SSRS
  • Accessing the UDM from Excel 2007
  • Lab 10A - UDM Reporting (Developing Reports for Reuse)
  • Lab 10B - UDM Reporting (Developing Excel Reports Based on the UDM)

Day 4

Module 11
Advanced Data Analysis using Excel 2007 and ProClarity 6.3
  • Analyzing Data with Excel 2007
  • Analyzing Data with ProClarity 6.3
  • Lab 11A - Advanced Data Analysis (Analyzing with Excel 2007)
  • Lab 11B - Advanced Data Analysis (Analyzing with ProClarity 6.3)
Module 12
Introduction to SSAS Data Mining Models
  • Introducing Data Mining
  • Integration with SQL Server 2008 Components
  • Data Mining Programmability
  • Lab 12A - Embedded Data Mining (Applied Mining for Meaning)
  • Lab 12B - Integrated Data Mining (Integrating Mining Results)
Module 13
Building Dashboards in Office SharePoint Server 2007
  • Reviewing Dashboard Fundamentals
  • Understanding the BI Features
  • Lab 13A - Building SharePoint Dashboards (Creating a SharePoint Dashboard Page)

Day 5

Module 14
Monitoring KPIs using PerformancePoint Server 2007 Scorecards
  • Reviewing Performance Management Fundamentals
  • Introducing PerformancePoint Monitoring
  • Building a Scorecard
  • Deploying a Scorecard
  • Lab 14A - Designing a PerformancePoint 2007 Scorecard (Creating the Reseller Sales Scorecard)
Module 15
Analyzing Performance using PerformancePoint Server 2007
  • Configuring Reports
  • Building Dashboards
  • Deploying Dashboards
  • Lab 15A - Designing a PerformancePoint 2007 Dashboard (Creating the Reseller Sales Dashboard)

Acknowledgements

Adam Cogan