SDG Computing offers custom onsite training covering the use of Microsoft's OLAP/Data warehousing tools, individually or in a variety of combinations. We specialize in showing organizations how to use local cube files to improve OLAP browsing performance and distribute data to the people who need to use it. We recognize that people are at many different places in their knowledge and skill in using Analysis Services. We want to provide you with training that will fit in with your current level of expertise and help you learn more.  

Tim Peterson, the author of Microsoft OLAP Unleashed and Microsoft SQL Server 2000 Data Transformation Services (DTS), is the developer of these courses. He is also our primary trainer.

Here is a sampling of  topics you can choose to address:

Data Modeling for OLAP

The Star Schema - Data modeling for OLAP and Data Warehousing

Cleansing Data

Normalizing Data and Denormalizing Data

Using a Staging Area

Designing the Fact Table

Designing Dimension Tables

Planning for Change in Dimension Tables

OLAP Topics

The Business Purpose for OLAP

The Terminology of OLAP

Using the Analysis Manager

Creating Cubes, Dimensions, Measures, and Calculated Members

Designing Aggregations

Processing Cubes

Implementing OLAP Security

Creating Local Cubes

Using Local Cubes to Optimize Performance

MDX Topics

The Structure of an MDX Statement

The Axes

The Slicers

MDX Functions

Calculated Members and Sets