The Master's Program: Business Intelligence (BI) Curriculum

Below is a description of SetFocus' Microsoft Business Intelligence Training curriculum for The Master's Program.

Utilizing SetFocus customized curriculum, we have organized a comprehensive and integrated Microsoft Business Intelligence training program which thoroughly covers the key technologies that you need to make the transition to this new world of Microsoft Business Intelligence implementation.  In addition to the outline below SetFocus has developed labs, projects, and exams to test appropriate knowledge transfer.

For a detailed description of the labs, projects, and exams incorporated into SetFocus' Master's Program: Business Intelligence Track curriculum, please contact an Admissions Representative today.


Querying and Programming using MS SQL Server 2008 Transact SQL

  • Retrieving Data
  • Grouping Data
  • Joining tables
  • Sub queries
  • Modifying Data
  • Implementing Data Integrity by Using Constraints and Triggers
  • Implementing Views
  • Implementing Stored Procedures


Advanced Querying and Programming using MS SQL Server 2008 Transact SQL

  • SQL 2005 new features workshop 
  • SQL 2008 new features workshop 
  • Hierarchies and recursive querying 
  • Working with dates 
  • Concurrency and locking 
  • Query performance tuning 
  • Database security and encryption 
  • Spatial data


Data Warehousing Concepts
  • Dimensional Modeling Primer
  • Retail Sales
  • Inventory
  • Procurement
  • Order Management
  • Customer Relationship Management
  • Accounting
  • Human Resources Management
  • Financial Services


Microsoft SQL Server Integration Services

  • Guided tour of SSIS
  • Control Flow
  • Data Flows
  • Variables and Configurations
  • Advanced Control Flow
  • Error logging and handling
  • Advanced Data Flow
  • Package Deployment
  • Package Management
  • Scripting and custom components
  • Best Practices
  • Going Beyond ETL

Customized SSIS Project

Microsoft SQL Server Analysis Services

  • What is Business Intelligence?
  • OLAP Modeling
  • Using SSAS in BIDS
  • Intermediate SSAS
  • Advanced SSAS
  • Cube Storage and Aggregation
  • Introduction to MDX Queries
  • MDX Expressions
  • Introduction to Data Mining
  • SSAS Administration
  • Advanced Administration and Optimization
  • Introduction to SSAS clients

MDX Queries

  • Introduction to MDX
  • Calculated Members and Named Sets
  • Common Calculations and Selections
  • MDX Query Context and Execution
  • Named Sets and Set Aliases
  • Sorting and Ranking in MDX

Customized SSAS Project

Microsoft SQL Server Reporting Services

  • Introduction to SSRS
  • Basic Report Creation
  • Intro to Relational Data Sources
  • Intro to OLAP Data Sources
  • Report Calculations, Formatting and Miscellaneous Report Editing
  • SSRS configuration, Deploying reports, URL syntax, and exporting
  • Report Globals
  • Report Parameters
  • Report Expressions and Dynamic Formatting and Images
  • Report Grouping and Sorting
  • Advanced Relational Data Sources (using T-SQL and Stored Procs)
  • Advanced OLAP Data Sources (using MDX)
  • Other Data Sources (XML services)
  • Matrix Control
  • Basic Charting
  • Advanced Charting
  • SubReports
  • Advanced Page Layout control
  • Extending with Code
  • Report Manager Overview
  • Report Manager: Roles and Security
  • Report Manager: Snapshots and Subscriptions
  • Sharepoint Integration

Business Intelligence with SharePoint and Performance Point Server

  • Introduction to PerformancePoint Server
  • Performance Management
  • Creating Scorecards
  • Creating Reports and Scorecards
  • Importing SSRS Reports
  • Creating a SharePoint Site Collection
  • Incorporating SSRS reports into SharePoint
  • Incorporating Excel spreadsheets into SharePoint via Excel Services
  • Incorporating Excel spreadsheets into PerformancePoint

Customized SSRS/PPS/SP Project

Customized Final Team Project


Note: This curriculum is subject to change without notice.