Accelerated Microsoft Business Intelligence: From SQL 2008 through SharePoint and Office 2007

Course:  MSBI
Duration:  4 Days
Level:  I
Course Summary

This four day course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Reporting Services Content Types, Business Data Catalog, and Business Intelligence with Excel 2007 and Visio 2007.

« Hide The Details
What You Can Expect

After completing this course, students will be able to:

  • Describe the Microsoft Business Intelligence stack
  • Explain the Unified Dimension Model and when it can and cannot be used.
  • Use the new Business Intelligence Features in SQL 2008
  • Create a SSAS Project using the Microsoft Unified Dimension Model
  • Create a Data Mart using Business Intelligence Studio
  • Create a Integration Services project and load a Data Mart
  • Load a Data Mart from a flat file.
  • Model Dimensions, Measures and Cubes
  • Understand the pros and cons of Integration into SharePoint
  • Create a Report using Report Builder 2.0
  • Load and Manage Reports with SharePoint
  • Understand and Create a Shared Service Provider in SharePoint
  • Understand and Create a Business Data Catalog in SharePoint
  • Set permissions on objects within SharePoint
  • Utilize the Business Intelligence add-ins for Excel 2007
Who Should Take This Course

This course is intended for DBAs, Developers and Business Intelligence Professionals seeking an introduction to the Microsoft BI Stack whether for new or existing projects or migration to the Microsoft environment.

Recommended Prerequisites

Before attending this course, students must have:

  • A working knowledge of RDBMS
  • A working knowledge of Business Intelligence Studio
  • A working knowledge of Excel and the Office Ribbon
  • Understanding of the goals of Business Intelligence
« Hide The Details
Related Courses
Code Course Title Duration Level
SQL Server 2012 Business Intelligence Overview
2 Days
SQL Server Analysis Services 2014/2012 - Tabular model with DAX
3 Days
SQL Server Analysis Services 2014/2012 - Advanced DAX Analytics
2 Days
SQL Server Analysis Services 2014/2012 - Advanced Data Analysis and Optimization
3 Days
SQL Server Reporting Services 2014/2012 - Extensions and Programming
3 Days
SQL Server Reporting Services 2014/2012 - Advanced Reporting
3 Days
SQL Server Reporting Services 2014/2012 - Jedi Master Level
2 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]