Microsoft BI Solutions – Executive Overview

Course:  MSBIE
Duration:  2 Days
Level:  I
Course Summary

In this course, students will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server Reporting Services. Implementing SSAS solutions have shown to

boost data retrieval and report generation from SQL Server by up to 1000%.

« Hide The Details
Topics Covered In This Course

What is Microsoft BI?

OLAP Modeling

Using SSAS in Bids

Cube Storage and Aggregation


SSAS Administration

Introduction to Data Mining

Introduction to Reporting Clients

What You Can Expect

At the end of this course, students will be able to:

  • Learn the core concepts in building solutions using Microsoft Business Intelligence
  • Understand OLAP (cube) modeling and data mining
  • See how to develop solutions using Business Intelligence Development Studio (BIDS)
  • Understand advanced storage design including MOLAP, ROLAP, and HOLAP
  • Learn the fundamentals of MultiDimensional Expressions (MDX)
  • See best practices for SSAS administration using SQL Server Management Studio (SSMS) and XMLA (XML for Analysis)
Recommended Prerequisites

This course does not require any prior experience with Microsoft BI solutions. It is assumed that students have working experience with basic relational database concepts (e.g., tables, queries, and indexing); data transformation services; Excel 2003; and SharePoint Server 2003.

Training Style


« Hide The Details
Related Courses
Code Course Title Duration Level
Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions
5 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]