CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

LRS-SSAS - Business Intelligence (BI) Using Microsoft SQL Server 2005

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

Presciptive Hands On course emphasizing data mining, warehousing, MultiDimensional Expressions, (MDX), queries and the Unified imensional Model, (UDM). The course also includes information on the analysis of Key Performance Indicators, (KPI), population of cubes using SQL Server Integration Services, (SSIS), and Excel Pivot Tables and Pivot Charts.

Click here for a printer-friendly version of this page

Prerequisites

Student needs to have some experience with Visual Studio and have practical experience with Database Structures, querying techniques and know the key differences between Online Transaction processing, (OLTP) and Online Analytical Processing, (OLAP) databases.

Detailed Class Syllabus

PART I: Business Intelligence

Chapter 1: Equipping the Organization for Effective Decision Making

Chapter 2: Making the Most of What You've Got -- Using Business Intelligence

Chapter 3: Searching for the Source -- The Source of Business Intelligence

Chapter 4: One-Stop Shopping -- The Unified Dimensional Model

Chapter 5: First Steps -- Beginning the Development of Business Intelligence

PART II: Defining Business Intelligence Structures

Chapter 6: Building Foundations -- Creating and Populating Data Marts

Chapter 7: Fill 'er up -- Using Integration Services for Populating Data Marts

PART III: Analyzing Cube Content

Chapter 8: Cubism -- Measures and Dimensions

Chapter 9: Bells and Whistles -- Special Features of OLAP Cubes

Chapter 10: Writing a New Script -- MDX Scripting

Chapter 11: Pulling It Out and Building It Up -- MDX Queries

PART IV: Mining

Chapter 12: Panning for Gold -- Introduction to Data Mining

Chapter 13: Building the Mine -- Working with the Data Mining Model

Chapter 14: Spelunking -- Exploration Using Data Mining

PART V: Delivering

Chapter 15: On Report -- Delivering Business Intelligence with Reporting Services

Chapter 16: Let's Get Together -- Integrating OLAP with Your Applications

Chapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts