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.
Here's What You'll Get
With The Course
Over 5 hours of comprehensive training
Resource pack
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
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
- 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
Your Instructor
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
For Teams
Enterprise DNA
Center of Excellence