Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Applied DAX: Business Metrics and Analytical Solutions

Packt via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Effort

6 weeks, 1 hour a week
Sessions

Self-Paced
Level

Beginner
Subtitles

English

Found in

Part of

DAX for Humans

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

Advance your DAX skills by applying them to real-world business scenarios across customer analytics, human resources, project management, finance, and operations. This course demonstrates how DAX can drive actionable insights in diverse domains. Learners will discover how to use DAX to solve practical business problems, including calculating customer metrics, analyzing HR data, managing project performance, and performing financial and operational analysis. The course covers a variety of industry-relevant measures and techniques, such as Net Promoter Score, lifetime value, absenteeism, schedule variance, currency exchange, and equipment effectiveness. By mastering these applications, learners will be able to translate business requirements into effective DAX solutions. Through scenario-based explanations and step-by-step walkthroughs, the course emphasizes the practical use of DAX in business analytics. Learners gain confidence in applying DAX to real data challenges and interpreting results for decision-making. This course is part two of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. While it delivers standalone value and practical skills, learners seeking a more integrated and in-depth progression may benefit from completing the full Specialization. This Specialization is based on the book DAX for Humans, by Greg Deckler. Packt is one of the world's most prolific publishers of cutting-edge technical content. For over two decades we've made it our mission to curate and publish the knowledge of only the very best technical experts. We focus on real-world courses that help our customers get the job done, with coverage that extends across a wide range of established and cutting-edge technical topics. If you're an individual or an organisation that embraces learning by doing, Packt is the perfect fit for you.

Syllabus

Customers
- This module delves into key customer metrics such as Net Promoter Score, lifetime value, acquisition cost, and funnel drop-off rates. Learners will gain hands-on experience using DAX techniques to calculate and interpret these KPIs, empowering them to make data-driven decisions that enhance customer retention and business growth.
Human Resources
- This module introduces key human resources metrics such as turnover rate, absenteeism, utilization, and pay equality. Learners will discover how to interpret these indicators to assess workforce performance and make informed, data-driven decisions that support organizational goals.
Projects
- This module introduces key project management metrics and tools, such as burndown charts, KPIs, and Earned Value Management, to help monitor progress and resource allocation. Learners will gain practical skills in evaluating project performance, understanding schedule and cost variances, and identifying resource overallocation. By the end, you'll be equipped to track and assess project health effectively.
Finance
- This module introduces essential financial concepts and metrics, including revenue, costs, gross margin, and key performance indicators. Learners will explore practical topics such as currency exchange, periodic billing, and financial ratios to better assess organizational health. The module also covers calculations like compound interest and reverse year-to-date to support informed financial decision-making.
Operations
- This module introduces key operational performance metrics such as order cycle time, mean time between failure, and overall equipment effectiveness. Learners will discover how to interpret these KPIs to assess efficiency, reliability, and inventory management within business operations. Practical examples and DAX calculations are provided to support data-driven decision-making.
Distance and Space
- This module introduces key spatial concepts and calculations relevant to geographic data analysis in Power BI. Learners will explore coordinate systems, bearings, and methods for determining proximity and relationships between data points using DAX. Practical applications include converting between coordinate types, calculating distances, and implementing spatial logic for business intelligence scenarios.