Microsoft SQL Server Analysis Services - SSAS (Tabular DAX)

Overview

Visualise Data in Excel using SQL Server Analysis Services (SSAS) with DAX. What you'll learn:

Extract data from multiple tables.Create connections between the tables.Develop the model using DAX functions.Create analyses in Excel.

This course covers the Tabular model in SQLServer Analytical Services.Please note:

This course is not affiliated with, endorsed by, or sponsored by Microsoft.We'll install SQLServer Developer onto your computer, which previously used to cost $100, together with the SSASextension.We'll then create our first analysis using SQLServerin just a matter of minutes.After this introduction, we'll go into some detail into how to create your analyses in Excel, including advanced Pivot Table options that most people don't even know about, but which are very useful. This includes slicers, timelines, and non-Visual Totals.Then we'll develop DAXformulas, to further extend the model.

A lot of the formulas are based on Excel formulas, but there are several additional things too. We'll create calculated columns, which are replicated in each row, and measures, which are summary calculations.

We'll have a look at logical, aggregations, statistical, mathematical, text, information, filter and value, and time intelligence functions.Finally, I'll show you how you can do similar things in Microsoft Excel.By the end of this course, you will be able to create reliable analyses in Visual Studio, deploy them into SQLServer Analytical Services, drilled down the results quickly in Excel,and you'll beable to help others with their data analysis.

Syllabus

• Introduction to Microsoft SQL Server Analysis Services (SSAS)
Overview of SQL Server Business Intelligence
Multidimensional vs. Tabular Models
• Setting Up the Environment
Installing SQL Server and SSAS
Configuring the SQL Server Database
Introduction to SQL Server Data Tools (SSDT)
• Understanding the Tabular Model
Introduction to the Tabular Model Architecture
Differences between Tabular and Multidimensional Models
Key Features of the Tabular Model
• Data Source Configuration
Connecting to Different Data Sources
Establishing Relationships Between Data Tables
Refreshing and Processing Data
• Introduction to DAX (Data Analysis Expressions)
Basic Syntax and Functions
Calculated Columns vs. Measures
Evaluation Context: Row and Filter Context
• Advanced DAX Functions
Time Intelligence Functions
Filter Functions
Iterator Functions
• Creating and Managing Measures
Defining Standard Measures
Utilizing Advanced DAX for Complex Measures
Performance Considerations
• Implementing Security in Tabular Models
Role-Based Security
Row-Level Security (RLS)
• Enhancing Model Performance
Optimizing Data Models
Effective Use of Hierarchies and Calculated Columns
Using Query Diagnostics
• Creating Data Visualizations
Introduction to Power BI
Connecting Power BI to Tabular Models
Designing Interactive Reports and Dashboards
• Deployment and Administration
Deploying a Tabular Model Solution
Monitoring and Managing a Tabular Instance
Backup and Restore Procedures
• Best Practices in SSAS Tabular Modeling
Design Patterns and Anti-Patterns
Versioning and Model Documentation
Model Maintenance and Updates
• Course Conclusion
Review of Key Concepts
Resources for Further Learning
Final Q&A Session

Taught by

Phillip Burton • 800,000+ students so far

Subjects

Business