1-Day (COURSE-BI-ANALYSISSERVICES)
Description
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 or seminars, please visit our booking page.
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.
Course Outline
Day 1
Module AS201: Introduction to SQL Server Analysis Services
- Introduction to OLAP
- Building Analysis Services cubes
- LAB: Creating a cube
Module AS202: Designing Dimensions
- Enhancing cube dimensions
- Implementing dimension hierarchies
- LAB: Enhancing cube dimensions
Module AS203: Calculations, KPIs, Actions and Processing
- Basic MDX Concepts
- Calculations
- Key Performance Indicators
- Actions
- LAB: Calculations, KPIs and Actions
- Cube processing concepts
- Incremental fact and dimension processing
- LAB: Cube processing
- Deploying Cubes
- LAB: Cube deployment
Module AS204: Introduction to Analysis Services Data Mining
- Introduction to Data Mining
- Business applications of data mining
- Data mining algorithm comparison
- LAB: Implementing Data Mining