Autoplay
Autocomplete
Previous Lesson
Complete and Continue
DAX Studio For Power BI and SSAS - Beginner to Advanced
Course Introduction
Let's get started
Resource Pack
Introduction (3:03)
Installation and Data Model Introduction
Installing DAX Studio (6:00)
Installing Tabular Editor 3 (3:01)
Installing SQL Server (10:48)
Loading Data and Introduction (4:43)
Guided Tour of DAX Studio
Connecting DAX Studio (8:33)
Ribbons and Panes (20:34)
Important Settings (9:32)
Querying Tabular Model with DAX Studio
What is a DAX Query (2:57)
EVALUATE (6:56)
DEFINE (5:02)
Debug Commas, Comments, Formatting DAX (5:04)
MEASURE (15:29)
COLUMN (9:13)
TABLE (12:35)
ORDER BY (4:18)
START AT (5:26)
TOPNSKIP (3:02)
ADDMISSINGITEMS (3:42)
DQ For AAS (Composite Models) (5:31)
Loading Data From SSAS with DAX (5:52)
Additional Topics
Extracting Result of a Query (11:10)
Query Parameters & Merge XML (3:23)
Testing RLS & OLS (6:27)
Exporting to Database or Text File (4:49)
Connecting to Data Model with Port Number (7:05)
Analyze in Excel (2:22)
Right Click Options (5:57)
Visualizing Filter Context (5:09)
ALT and SHIFT Trick (1:05)
Loading Performance Analyzers Data
Integrating Performance Analyzer Data (9:36)
Load Performance Analyzer (3:49)
All Queries (13:17)
Query Builder
Query Builder (9:48)
Dynamic Management Views
Introduction (11:44)
Loading to Power BI (9:54)
Prebuilt Power BI Report (7:29)
Conclusion and Final Words
Conclusion (3:14)
Feedback
Course Survey
Certification
Certificate & Badge
Exporting to Database or Text File
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock