Platform Access

DAX Studio For Power BI and SSAS - Beginner to Advanced

Master the ultimate tool for executing and analyzing DAX queries against various sources including Power BI and SSAS. This tool is extremely powerful and allows you to go beyond writing just DAX Code for measures, calculated columns, or calculated tables.

Enroll Now
DAX Studio For Power BI and SSAS - Beginner to Advanced, DAX studio course for Power BI and SSAS

Here's What You'll Get

With The Course

Over 5 hours of comprehensive training

R For Power BI Users

 Resource pack

DAX Studio For Power BI and SSAS - Beginner to Advanced

Move ahead in your Power BI journey with a brand new course on DAX Studio

  • Tabular is super-fast when compared to relational data model, so that means we can use the existing data in Tabular models to generate new data
  • Pair it with the export data functionality of DAX Studio to prepare a wide range of desired reports

Details Of What You Will Learn

During This Course

  • Describe - the process of connecting external tool to Power BI, Excel, SSAS
  • Perform - DAX query efficiently
  • Learn - DMV's to find out every detailed information about your data model
  • Work - with Performance Analyzer
  • Test - user roles with DAX Studio
  • Export - data from Power BI, SSAS, Power Pivot, PBI Service using DAX Studio
DAX Studio For Power BI and SSAS - Beginner to Advanced

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

DAX Studio For Power BI and SSAS Users - Beginner to Advanced

LEARN HOW TO

Utilize the key features within the

DAX Studio For Power BI and SSAS

DAX Studio For Power BI and SSAS - Beginner to Advanced
  • External tool that you can use with Power BI, Power Pivot and SSAS
  • Extremely powerful and allows you to go beyond writing just DAX Code
  • Build a summary report from your data model
  • Export data functionality of DAX Studio to prepare a wide range of desired reports
  • Several keywords that are only exposed to external tool like DAX Studio

Course Curriculum

1. Course Introduction

  • Let's get started
  • Resource Pack
  • Introduction

2. Installation and Data Model Introduction

  • Installing DAX Studio
  • Installing Tabular Editor 3
  • Installing SQL Server
  • Loading Data and Introduction

3. Guided Tour of DAX Studio

  • Connecting DAX Studio
  • Ribbons and Panes
  • Important Settings

4. Querying Tabular Model with DAX Studio

  • What is a DAX Query
  • EVALUATE
  • DEFINE
  • Debug Commas, Comments, Formatting DAX
  • MEASURE
  • COLUMN
  • TABLE
  • ORDER BY
  • START AT
  • TOPNSKIP
  • ADDMISSINGITEMS
  • DQ For AAS (Composite Models)
  • Loading Data From SSAS with DAX

5. Additional Topics

  • Extracting Result of a Query
  • Query Parameters & Merge XM
  • Testing RLS & OLS
  • Exporting to Database or Text File
  • Connecting to Data Model with Port Number
  • Analyze in Excel
  • Right Click Options
  • Visualizing Filter Context
  • ALT and SHIFT Trick

6. Loading Performance Analyzers Data

  • Integrating Performance Analyzer Data
  • Load Performance Analyzer
  • All Queries

7. Query Builder

  • Query Builder

8. Dynamic Management Views

  • Introduction
  • Loading to Power BI
  • Prebuilt Power BI Report

What our Students Say

Your Instructor

Antriksh Sharma - Power BI

Antriksh Sharma

  • 2+ years of experience in Power BI, Power Pivot, Power Query and SSAS
  • 2+ years of experience in DAX, optimizing DAX, and SQL language. Likes to read DAX blogs, articles, and books in free time.
  • Keen interest in Data Modelling, Data preparation, and Data clean-up using various tools.
  • 1+ years of experience in Core Python and approx. 6 months of experience in Pandas/NumPy/Matplotlib/Seaborn etc. Python libraries for Data Analytics.
  • Super User at Microsoft’s Power BI community platform with over 80 solutions, 50 PBI solutions at Enterprise DNA’s community, and approx. 30 PBI solutions on other platforms. Passionately believes in sharing everything he knows.
  • 4+ years of experience in excel automation through VBA, likes to read VBA blogs in free time.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA Membership Subscription.

  • Can I purchase a single course instead of the full Enterprise DNA membership? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full membership here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA Membership or CoE access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

Membership

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

membership enterprise dna

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace