Main Office: | 800.631.0410 | |
---|---|---|
Sales Office: | 800.533.3893 |
This course starts by building an understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. It continues by creating a simple multidimensional OLAP cube and progressively adding features to help improve, secure, deploy, and maintain an Analysis Services database. Core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards are covered. In depth coverage of using MDX with Analysis Services to deliver high-performance business intelligence solutions is included. The student will learn how to assemble time-based business metrics and then customize an Analysis Services cube through the MDX scripts. Depending on student backgrounds, advanced MDX queries will be covered as time allows.
At the end of this course, students will be able to:
This course is designed for Developers, Designers, or anyone interested in working with data warehouse data.
Instructor led with 50% lecture and 50% lab.
Code | Course Title | Duration | Level | |
---|---|---|---|---|
ORDSCD |
ORACLE 10g/11g DISCOVERER DESKTOP For End Users |
2 Days |
I |
Details |
SSASBI |
Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions |
5 Days |
I |
Details |
DWHASP |
Data Warehousing (DW) – Advanced SQL Queries & Performance |
2 Days |
I |
Details |
ORDSCP |
ORACLE 10g / 11g BI DISCOVERER PLUS for End Users |
2 Days |
I |
Details |
DWHFUN |
Data Warehousing Fundamentals |
3 Days |
I |
Details |
SSPTDW |
SQL Server Performance and Tuning for Data Warehouses |
5 Days |
III |
Details |
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.