Mastering DAX Studio

Name: Mastering DAX Studio
Rating: 3.9 (371 reviews)
Author: Randy Minder

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

updated on icon Updated on Jun, 2024

language icon Language - English

person icon Randy Minder

English [CC]

category icon Business,Business Intelligence

Lectures -24

Resources -6

Duration -2 hours

3.9 ★★★ ★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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...

Goals

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

Prerequisites

A basic understanding of DAX and data models

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
2 Lectures

Introduction 01:13 01:13
What's Covered/What's Included? 01:37 01:37

Downloading and Installing
1 Lectures

Working with DAX Studio
10 Lectures

Debugging, Query Tracing & Performance Monitoring
3 Lectures

SQL Server Management Studio (SSMS)
1 Lectures

Wrap Up
1 Lectures

New Releases
1 Lectures

Time for Some Practice
5 Lectures

Instructor Details

Randy Minder

About me

Microsoft Certified Professional:

Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019 - 80% score)

Exam PL-300: Power BI Data Analyst (December 2022 - 80% score)

Snowflake Core Certification Exam (April 2021 - 90% score)

Seasoned database engineer (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence development, Power BI, Snowflake, Microsoft Fabric and KQL. 20 years of software development using a variety of Microsoft technologies, mostly C#.

2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure.

StackOverflow reputation of 47,000 (top 1%)