SSASE SQL Server Analysis Services Essentials

Overview

This one-day instructor-led course teaches participants how to develop, deploy and implement an analytical and reporting solution using SQL Server Analysis Services. 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