SQL Server Analysis Services Core Skills (1 day)
SQL Server Analysis Services is Microsoft's primary tool for data analysis. This course is designed to take you through the most important components of SSAS, with just the right amount of depth, within a single day.
The course is most suitable for developers that need to learn to work with the Microsoft BI platform or for existing SQL Server developers and DBAs that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.
In the course, you'll see how SQL Server Analysis Services provides options for analysing the data that you have loaded into your data model. You'll learn how to choose between the multi-dimensional and data mining models and the tabular models. You will see how to enhance the design of the models with calculations, perspectives, translations, and actions, then see how to improve the performance of queries through aggregation and how to automate data model processing. Along the way, you'll get an introduction to the powerful options available in SQL Server Data Mining.
While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.
|CITY||DATES||COURSE PRICE||EARLY BIRD PRICE|
|On-demand||Please contact us||
|DAY 1||AS201||INTRODUCTION TO SQL SERVER ANALYSIS SERVICES|
|Introduction to Analysis Services|
|OLAP and Multi-dimensional Analysis vs Tabular Data Models|
|Building Analysis Services Cubes|
|LAB: Creating a Cube|
|DAY 1||AS202||ENHANCING A MULTI-DIMENSIONAL CUBE DESIGN|
|Enhancing Cube Dimensions and Forming Hierarchies|
|Adding MDX Calculations, Key Performance Indicators (KPIs) and Actions|
|Implementing Perspectives, Translations and Cube Write-back|
|LAB: Enhancing an OLAP Cube|
|DAY 1||AS203||CREATING AND ENHANCING A TABULAR DATA MODEL|
|Creating and Importing Tabular Data Models|
|Adding Calculated Columns and Measures with Data Analysis Expressions (DAX)|
|Implementing Hierarchies and Perspectives|
|Implementing Roles for Security|
|LAB: Creating and Enhancing a Tabular Data Model|
|DAY 1||AS204||PROCESSING, AGGREGATIONS AND DATA MINING|
|Processing Multi-dimensional Cubes and Deployed Tabular Data Models|
|Improving Performance Through Aggregations|
|Introduction to SQL Server Analysis Services Data Mining|
|LAB: Processing, Aggregations and Data Mining|