Microsoft SQL Server Analysis Services

• The course is intended for database specialists and analysts who are tasked with advanced data analysis and want to take advantage of technology SQL Server Analysis Services

• Describe Analysis Services
• Create multidimensional databases
• Work with cube and create dimensions
• Work with measures and measure groups
• Descripe transactions and concurrency
• Use basic syntax of MDX language
• Extend cube attributes
• Analysis Services mantenance
• Data mining overview
• Use basic syntax of DAX language
• Analysis Services Tabular model
• How to choose right model

• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of Transact-SQL
• Basick knowledge of data warehouses

Analysis Services Overview

• Overview
• Basic concepts

Multidimensional database

• Datasource
• Datasource view
• Creation of cubes and dimensions

Advanced techniques of cube and dimension creation

• Advanced cube creation
• Advanced dimension creation

Work with measures

• Measures
• Measure groups

MDX fundamentals

• MDX basic concepts
• MDX basic syntax
• Calculated members

Cube extensions

• KPI
• Actions
• Perspectives
• Translation

Analysis Services management

• Deploy
• Security
• Processing
• Automating tasks

Datamining fundamentals

• Datamining structures
• Datamining models

Datamining fundamentals

• Datamining structures
• Datamining models

PowerPivot

• PoverPivot overview
• How to create InMemory model using Excel

DAX fundamentals

• Extending data model using DAX
• Advanced DAX
• Using DAX on agregated level

Analysis Services Tabular model

• Working with Tabular model
• Tabular vs. multidimensional
• Tabular model maintenance

How to choose right data model

• Model comparsion
• Discusion with students

Previous courses

Implementation of a data warehouse and ETL processes using Microsoft SQL Server Integration Services. [GOC645]

Next courses

DAX language and data model creation for Power BI and SQL Server Analysis Services [GOC644]

Related courses

Microsoft Power BI Desktop [PBID]

Microsoft Power BI Desktop - Advanced Techniques [PBID2]

Data Engineering on Microsoft Azure [MOC DP-203]

Microsoft Power BI Data Analyst [MOC PL-300]