Mastering DAX Studio

DAX Studio is the productivity tool every DAX, Power BI and Power Pivot developer should be using

4.23 (548 reviews)
Udemy
platform
English
language
Other
category
instructor
2,865
students
2 hours
content
Feb 2023
last update
$49.99
regular price

What you will learn

How to write queries and export results (or complete tables) to CSV or SQL Server

How to use dynamic management views to better understand your data model

How to capture all queries generated by your Power BI report and review and execute them in DAX Studio

Performance monitoring

How to consistently format your DAX code

Description

If you are a DAX developer, DAX Studio is a must have tool. This course allows you to get the most of DAX Studio. You'll learn how to execute queries, export data to CSV and SQL Studio, troubleshoot queries, capture all queries coming from Power BI, perform performance monitoring, dynamic management views and more...

Content

Introduction

Introduction
What's Covered / What's Included?

Downloading and Installing

Download DAX Studio and Install

Getting Started

Getting Started

Connecting to a Data Model

Connecting to a Data Model

Dynamic Management Views (DMVs)

Dynamic Management Views in DAX Studio and SSMS

Executing Queries / Exporting Data

Executing Queries in DAX Studio
Exporting Data

Debugging, Query Tracing & Performance Monitoring

Basic Debugging Features in DAX Studio
Query Tracing
Performance Monitoring

SQL Server Management Studio (SSMS)

Brief overview of SQL Server and SQL Server Management Studio

Wrap Up

Miscellaneous Items and Wrap up

Bonus Section

Bonus Lecture

Screenshots

Mastering DAX Studio - Screenshot_01Mastering DAX Studio - Screenshot_02Mastering DAX Studio - Screenshot_03Mastering DAX Studio - Screenshot_04

Reviews

Tony
October 11, 2023
This course material was great and a great quick overview of DAX Studio. There are two things I did not like. The text on the screen while the instructor was in DS was really small. The other is that it was really fast; which did not allow time for each section for me to try what he was trying without pausing. Recommend one Zip file for all related files so its one download.
Virginia
May 30, 2023
Good information on DAX Studio- all Data Analysts need to learn the tools that will help them develop better DAX code. I would recommend this course to all students who are learning DAX.
Waddel
May 21, 2023
He does not zoom in on his calculations and result. The fonts are so tiny that I lost interest in the course.
Anja
January 11, 2023
Für die Einführung nach Dax Studio war der Kurs gut geeignet. Er gibt einen ausführlichen Überblick über die Funktionsweise. Ein Hinweis auf die Metrics Funktionen wären gut gewesen. Ich habe auch Hinweise vermisst, wie Eingaben optimiert werden können, wenn fest gestellt wurde, dass bestimmte Funktionen sehr lange dauern.
Jean
January 2, 2023
Excellente formation: contenu bien structuré, informations très intéressantes, exercices appropriés et bonne diction. Félicitations!
Joshua
October 31, 2022
Great info, but the production quality where there were cuts in the narration made me feel like I was missing something. It made me anxious at times.
Dadang
October 22, 2022
bagus ilmu baru, jujur baru kenal dengan Dax Studio. tapi menyenangkan bisa mengikuti acara ini. terimakasih .
Olatoye
September 3, 2022
I learnt a great deal. Although I'm not new to writing DAX queries, I have no prior knowledge of using DAX Studio and always felt intimidated. This course helped me alleviate all that.
Baranyai
August 24, 2022
This is a useful, practical course that summarizes well the use and main functions of DAX studio. There could be a little more practical content instead of the MSSM Studio part, which is also useful, but a separate topic.
Puseletso
June 25, 2022
Learned a lot and the instructor is thorough and communicates his points clearly with full knowledge and understanding
Paul
May 3, 2022
This is about what I expected from the course. A good overview and starting guide to DAX Studio. However, I think the structure of the lectures could be reordered and flow better. It should build on the basic functionality and uses of DAX Studio before presenting DMV and SSMS. I recommend skipping lecture 7 and come back to it after 17. I would also recommend the author have one contoso.pbix file (instead of multiple) with different pages for each lecture. It's a little confusing to have multiple contoso.pbix files throughout the course, all named the same and have different measures in each.
Morgan
April 26, 2022
No continuity in explaining the basic functionalities . Randy mentioned in the the first chapter that this is for beginners in DAX, but it was really hard to follow and learn about the different functions. This is just a "conversation" about DAX Studio and not a hands-on course in which you get to solve a set of problems/challenges methodically.
Juan
April 19, 2022
Another great course from Randy Minder, I have taken most of his courses and he never dissapoints, clear and concise explanations, very useful content, highly recommended, thanks amigo Randy, greetings from Mexico!
Jonas
December 28, 2021
Randy is teaching us from A-Z on how Dax Studio works. It is a awesome tool that help BI developers to debug your datamodels and so much more!! Thanks Randy
Purnima
November 10, 2021
The course by Randy Minder on Dax Studio is very informative, engaging, and succinct. It is very well paced and organized. I am a newbie in this field and didn’t find difficult to understand the concepts. I loved the exercises at the end of the course. One enhancement I would suggest is to label the resources and exercises for better housekeeping. After going through this course, I signed up for two more courses by him. I hope that those courses will be as good as this is.

Charts

Price

Mastering DAX Studio - Price chart

Rating

Mastering DAX Studio - Ratings chart

Enrollment distribution

Mastering DAX Studio - Distribution chart

Related Topics

2572170
udemy ID
9/22/2019
course created date
2/8/2020
course indexed date
Bot
course submited by