Course Schedule: | |
Delivering Business Intelligence With Microsoft SQL Server 2005 or 2008
Summary:
This course provides students with the skills necessary to deliver business intelligence. It is based on the Brian Larson book Delivering Business Intelligence with Microsoft SQL Server 2005 published on January 23, 2006 by McGraw-Hill Osborne Media, ISBN: 0072260904 or on the Brian Larson book Delivering Business Intelligence with Microsoft SQL Server 2008 published on November 19, 2008 by McGraw-Hill Osborne Media, ISBN: 0071549447.
Duration:
5 Days/ Lecture & Lab
Audience:
This course is targeted at business intelligence developers and users, data warehouse developers, star schema and cube developers, data modelers, data base analysts, and any other personnel who need to deliver business intelligence.
Topics:
- Equipping the Organization for Effective Decision Making
- Using Business Intelligence
- The Source of Business Intelligence
- The Unified Dimensional Model
- Beginning the Development of Business Intelligence
- Creating and Populating Data Marts
- Using Integration Services for Populating Data Marts
- Cubism – Measures and Dimensions
- Special Features of OLAP Cubes
- MDX Scripting
- MDX Queries
- Introduction to Data Mining
- Working With the Data Mining Model
- Exploration Using Data Mining
- Delivering Business Intelligence With Reporting Services
- Integrating OLAP With Your Applications
- Excel Pivot Tables and Pivot Charts
Prerequisites:
Students should have experience with any relational database management system as well as experience with data warehouses and star schemas. It would be helpful if students are involved with delivering business intelligence
Last Update: July 29, 2010
