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