Home | About us |
Courses

Overview
Microsoft
PMP
BI
QA
Java
| Corporate Training | Schedule | Registration | Login | Contact Us


Courses - Microsoft

Microsoft - BI Bootcamp

This 4 day, instructor-led training course provides students with the knowledge and skills necessary to begin designing and developing Business Intelligence solutions using Microsoft BI Stack The bootcamp will empower developers to exploit the BI functionality in the following technologies:

  • SQL Server 2005 Database Services
  • SQL Server 2005 Integration Services
  • SQL Server 2005 Reporting Services
  • SQL Server 2005 Analysis Services (OLAP)


    • Course Pre-requisites
    Basic understanding of SQL and relational database technology

    Course Objectives

    Through interactive presentations and concrete hands-on labs, attendees will learn:
  • How to use Microsoft SQL Server 2005 to build and manage data marts.
  • How to build data warehouse using SQL Server 2005 Integration Services to extract, transform, and load information into SQL Server 2005 databases.
  • How to use SQL Server 2005 Reporting Services to develop predefined and ad hoc relational reports.
  • How to use SQL Server 2005 Analysis Services to create a dimensional model that provides business analytics.


    • Course Topics

    Day 1

    Module 1 - Microsoft BI Strategy Overview

       Defining Business Intelligence (BI)
       Introducing the Microsoft BI Platform
       Introducing the BI Developer’s Toolset
       Introducing SampleData Company

    Module 2 - Introduction to Dimensional Modeling Techniques
       Designing the Dimensional Model
       Introducing Additional Design Concepts
       Lab 02A - Database Modeling

    Module 3 - Introduction to ETL Techniques Using SSIS
       Reviewing ETL Fundamentals
       Introducing SSIS Components
       Designing ETL Packages
       Lab 03A - Control Flow
       Lab 03B - Data Flow

    Day 2

    Module 4 - Advanced SSIS

       Advanced Data Flow
       Manageability Features
       Programmability
       Lab 04A - Slowly Changing Dimensions

    Module 5 - Introduction to SSRS
       Reporting Fundamentals
       Introducing Reporting Services (SSRS)
       Basic SSRS Report Design
       Lab 05A - Creating Managed Reports

    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
       Lab 06B - Advanced SSRS Features


    Day 3

    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

    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
       Lab 08B - Using the ReportViewer Control

    Day 4

    Module 9 - Introduction to the UDM

       Reviewing OLAP Fundamentals
       Understanding Database Components
       Performance Tuning
       Programming SSAS
       Lab 09A - Building a Basic Cube
       Lab 09B - Working with Dimensions
       Lab 09C - Calculations, KPIs and Actions
       Lab 09D - Dimension and Cube Processing
       Lab 09E - Cube Deployment

    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
       Lab 10B - UDM Reporting
    Current Schedule
    Course Date
    PMP June 9th
    Microsoft SQL Server June 9th
    Microsoft SharePoint (MOSS) May 19th
    Data warehousing June 20th
    QA Testing May 19th

      ©2005-2007 Novedea. All rights reserved. Call 214-643-2763, Email: training@novedea.com