SQL Server Analysis Services Essentials
Course Code: SSASE
Course Duration: 1 Day
Overview
This one-day instructor-led course teaches participants how to
implement develop, deploy and implement a SQL Server analytical and
reporting solution using Analysis Services 2008
and 2008 R2. The course provides a practical approach to
solve real-world reporting and analytical scenarios and teaches
participants how to use the Analysis Services development tools to
create an Analysis Services database and an On-Line Analytical
Processing (OLAP) cube, and how to manage an Analysis Services
solution.
Who Should Attend
This course is designed for IT professionals who are already
working with SQL Server and looking to expand their knowledge to
design, develop and implement Business Intelligence solutions using
SQL Server Analysis Services.
Course Objectives
After completing this course, students will be able to:
- Use SQL Server Analysis Services to implement analytical
solutions
- Create multidimensional solutions using SQL Server Analysis
Services
- Implement dimensions and cubes in an Analysis Services
solution
- Develop cubes with calculations and KPI's
- Maintain and support an Analysis Services solution
- Make smarter business decisions with data mining
techniques
Course Prerequisites
Before attending this course, participants should have:
- Previous exposure working with SQL Server
- A basic understanding of dimensional design