1-Day (COURSE-BI-ANALYSISSERVICES)
During this 1-day course, you will learn to design, develop, and deploy analytical solutions using SQL Server Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution. An introduction to the use of data mining is also provided.
SQL Server Analysis Services (SSAS) enables IT Professionals to rapidly build and deploy powerful analytical solutions that enable business users to analyze business data and achieve competitive advantage. SSAS enables rapid application development, increases performance and functionality, and reduces the costs and complexity of operation. This course focuses on teaching IT professionals the skills and best practices required to design and develop a well performing and successful analytical solution using SQL Server Analysis Services.
For details on booking courses, please send an e-mail.
Target Audience
This course is intended for IT Professionals that are responsible for designing, developing, and deploying business intelligence solutions. The target audience for this course is database warehouse, decision support, and business intelligence solution architects, IT professionals, and business intelligence developers who want to learn the details of how to use the capabilities provided by SSAS to build analytical applications.
While based on SQL Server 2008 R2, the course is equally applicable to those working with SQL Server 2005, SQL Server 2008. Differences in the versions will be highlighted.
Prerequisites
While this course is targeted at database professionals with some experience with data warehouse solutions, this workshop requires no prior experience with any version of SQL Server Analysis Services.
Course Objectives
Upon completion of this course, the student will be able to:
Describe the process of building a business intelligence solution and identify where and how SSAS fits into the process.
Create effective SSAS cubes complete with calculations, actions, aggregations, and more.
Design solutions in SSAS that are both scalable and secure.
Successfully manage and deploy SSAS cubes in a development/test/production environment.