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.
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.
Author Name: Eugene Meidinger
Author Description:
Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Table of Contents
- Course Overview
1min - Understanding What Makes DAX so Unique
14mins - Planning Your Data Governance: Power BI, Power Pivot, or SSAS Tabular?
18mins - Thinking in Columns, Not Rows
29mins - Adding Business Logic with Calculated Columns and Measures
29mins - Filtering Data Using CALCULATE
27mins - Looping Over Data with Iterators
30mins - Analyzing History with Time Intelligence
26mins
User Reviews
Be the first to review “Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS”
Related Products
Use visuals in Power BI
Create and customize visuals to present data in compelling and insightful ways.
Explore data in Power BI
Turn your business intelligence data into data insights by creating and configuring Power BI dashboards.
Discovering Predictive Analytics with Alteryx
Learn predictive analytics techniques using Alteryx to enhance business decision-making.
Marketing Analytics
Gain insights into marketing analytics tools and techniques for measuring campaign effectiveness and ROI.
Describe how to build applications with Microsoft Power Apps
Learn about the value and capabilities of Microsoft Power Apps and ways citizen and professional developers use this technology to build simple applications for their business.
Write multi-table queries by using Kusto Query Language
Write advanced queries in Kusto Query Language to gain deeper insights by combining data from several tables. Learn how to use the table-level operators lookup, join, union, and materialize, and the new aggregation functions arg_min and arg_max. Also, learn how to communicate these results visually in charts.
There are no reviews yet.