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
A/B Testing for Business Analysts
Explore A/B testing methodologies to make data-driven decisions for business strategies.
Describe building automation with Microsoft Power Automate
Microsoft Power Automate builds process automation. Power Automate allows anyone with knowledge of the business process to create repeatable flows that, when triggered, and perform the process for them.
Dashboard in a Day – Online workshop
This Learning Path is designed for use with the Dashboard in a Day instructor-led course. For more information on attending this free, instructor-led course, see https://aka.ms/DIAD. On that page, you can Register for an event.
Gain insights from your data by using Kusto Query Language
Write advanced queries in Kusto Query Language to help you gain insights from your data. Use the aggregation functions count, dcount, countif, sum, min, max, avg, percentiles, and others. Communicate these results visually in charts.
Introduction and prerequisites for Power BI – Online workshop
This module guides you through the steps of installing the required software on your computer so that you can complete this course.
Describe the capabilities of Microsoft Power BI
Learn how you can use Power BI to easily build reports and dashboards with interactive visualizations and AI-driven insights. See how other organizations have used this solution to drive business results with actionable insights.
There are no reviews yet.