Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS

DAX is a popular language for any sort of analytical reporting in the Microsoft BI stack. Whether you are using Power BI, Power Pivot, or SSAS, this course will teach you how to model your data with DAX.
Course info
Rating
(62)
Level
Beginner
Updated
Mar 28, 2018
Duration
2h 59m
Table of contents
Description
Course info
Rating
(62)
Level
Beginner
Updated
Mar 28, 2018
Duration
2h 59m
Description

If you want to use Power BI, Power Pivot, or SSAS (tabular mode), you'll need to learn DAX. In this course, Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS, you'll learn the basics of the DAX language. First, you'll learn how DAX works and why it has such good performance. Next, you'll explore how to encapsulate business logic using calculated columns and measures. Finally, you'll discover a variety of ways to manipulate filters or analyze your data. When you're finished this course, you'll have the skills and knowledge of DAX to model and analyze your data with the DAX expression language.

About the author
About the author

Starting out as an accidental DBA and developer, Eugene Meidinger now focuses primarily on BI consulting. He has been working with SQL Server for five years now, and is certified in Querying and Administering SQL Server 2012. He regularly presents at various SQL Saturday events.

More from the author
Querying and Shaping Data in Power BI Using M
Intermediate
2h 37m
Sep 11, 2019
Power BI Data Preparation Playbook
Intermediate
2h 2m
Apr 29, 2019
Deploying and Publishing Power BI Reports
Intermediate
1h 45m
Oct 16, 2018
More courses by Eugene Meidinger
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Eugene Meidinger, and welcome to my course, Getting Started with DAX Formulas in Power BI, Power Pivot, and SQL Server Analysis Services. I'm a business intelligence developer at All-Lines-Technology, and I also co-lead the Pittsburgh Power BI User Group. DAX is an approachable language for distilling your data into bite-sized insights. This course is an introduction to many of the features that make DAX unique. Some of the major topics that we'll cover include: adding business logic to your data model, manipulating filters, and analyzing historical data. By the end of this course, you'll have a mental model of how the DAX engine works underneath the hood, and you'll know how to aggregate and filter with ease. Before beginning this course, you should be familiar with basic report creation in either Power BI, Power Pivot, or SQL Server Analysis Services. I hope you'll join me on this journey to learn DAX with the Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS course at Pluralsight.