A 5 day course as an introduction to Business Intelligence with Microsoft SQL Server. During the course delegates will use SQL server tools to create and populate a simple data warehouse using Integration Services. Then to create data models using Analysis Services, and finally to report on the data models using Reporting Services.

This introductory course gives the basics of the concepts and tools for creating a Data Warehouse.

This course can be followed by a workshop to cover the finer details of working with Integration Services, Analysis Services or Reporting Services.

Custom courses can also be created to focus on just one part of the Microsoft BI Stack. Please call to discuss your requirements.

Course Outline

• Introduction to Business Intelligence
• Designing a Data Warehouse
  • Characteristics of a Star Schema
  • Fact and Dimension tables
  • Slowly changing data
• Using Integration Services to populate a Data Warehouse
  • Import/Export wizard
  • Creating a control flow
  • Creating a data flow
  • Managing changing data
• Creating a Multi-Dimensional Model using Analysis Service
  • Using the wizard to create a cube
  • Managing dimensions
  • Managing Cubes
• Creating a Tabular Data Model
  • Populating the data model
  • Managing dimensions
  • Using DAX
• Reporting using Reporting Services
  • Using the wizard to create a report
  • Creating a tabular report
  • Creating graphical reports
  • Adding interaction to reports
  • Publishing and managing reports