Microsoft Business Intelligence: Online Courses

COURSE 1 OVERVIEW

Kevin S. Goff, SetFocus Business Intelligence (BI) Practice Manager & Microsoft SQL Server MVP, conducts a comprehensive overview of the BI Master’s Program including demonstrations of the following topics:

  • T-SQL Querying
  • Advanced T-SQL
  • MS SQL Server Integration Services
  • Data Warehousing Fundamentals
  • MS SQL Server Analysis Services
  • MDX Programming
  • MS SQL Server Reporting Services
  • BI With SharePoint 2010 (PerformancePoint * Excel * PowerPivot)

    All demonstrations utilize SQL Server 2008R2, SharePoint 2010 & Office 2010

    		•
    Course 1 Downloads

     
    Course Materials:
    Intro & T-SQL Querying (30 minutes)

     

    Recording 1
    Advanced T-SQL (30 minutes)

     

    Recording 2
    SSIS to BI with SP2010 (3 hours 30 minutes)

     

    Recording 3
    PowerPivot (30 minutes)

     

    Recording 4
     

    COURSE 2 OVERVIEW

    This intermediate-level course covers two of many useful ways SQL Server Integration Services (SSIS) can be used to process data, access different system resources, and incorporate T-SQL statements. The “Using Merge” video also demonstrates a popular pattern in Data Warehousing ETL scenarios. This course is targeted to SQL Server developers and Business Intelligence (BI) professionals.

    Subjects include:

  • Microsoft Business Intelligence – SSIS Multicast

    This 2-part video shows how to use the SSIS Multicast, and also how to deal with the SSIS problem of overwriting Excel destinations. The video is approximately 20 minutes.

  • Microsoft Business Intelligence – Using Merge to Insert and Update

    This 3-part video shows how to integrate a stored procedure that uses a T-SQL MERGE statement to perform a combination INSERT and UPDATE from a staging table. This also demonstrates how to utilize transactions in an SSIS control flow. The video is approximately 30 minutes.

    • Course 2 Downloads

     
    Course Materials:
    SSIS Multicast

     

    Part 1
    Part 2

    Using Merge to Insert and Update

     

    Part 1
    Part 2
    Part 3

    If you enjoyed this we would appreciate your support by providing a recommendation on the SetFocus Products & Services
    page located here: http://www.linkedin.com/company/setfocus/products. Even just a quick thumbs up to recommend the
    product would be much appreciated!