About This Course: With the current explosion of data in today's enterprise environment, traditional methods of querying and reporting on information are no longer sufficient. This course provides the skills to analyze and discover trends in your data warehouse. You learn to create On-Line Analytical Processing (OLAP) cubes using business intelligence tools and to automate their maintenance.
Designing a Unified Dimension Model (UDM)
Storing dimension data in fact tables
Saving space with referenced dimension relationships
Including dimensions with many-to-many relationships
Designing storage and aggregations
Automating processing and deployment
Retrieving data with MDX
Monitoring business performance with KPIs
Enhancing cubes with MDX
Determining the correct model
Performing real-world predictions
Call 1-888-843-8733 or click here »
An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:
"The SQL Server Analysis Services course has been tremendously helpful in learning to navigate in a cube environment and building my own. I use the hands-on exercises on a daily basis! When I returned to work, I repeated the steps we learned in the multi-to-multi relationship exercise and was able to make an unusual dimension relationship to a fact table that no one in my company thought was possible."
- I. Buryak, Database Developer