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

Coursera

Foundations of DAX: Core Concepts and Essential Data Skills

Packt via Coursera

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Build a strong foundation in DAX by mastering its core concepts and essential data manipulation techniques. This course introduces the DAX language and guides learners through fundamental operations with dates, text, numbers, and time. This course is designed for Power BI users seeking to understand DAX from the ground up. Learners will explore the basics of DAX, including creating measures, leveraging variables, and working with key functions for data lookup, grouping, and logical operations. The course then delves into practical applications such as handling dates and calendars, manipulating text, performing numerical calculations, and managing time and duration data. By the end, learners will be equipped to confidently use DAX for a wide range of foundational business scenarios. The course uses clear explanations and real-world examples to make DAX concepts accessible and practical. Learners progress step-by-step from introductory topics to more advanced foundational skills, ensuring a solid grasp of DAX essentials. This course is part one 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

  • Introducing DAX
    • This module introduces the fundamentals of DAX in Power BI Desktop, guiding learners through practical calculations, data interaction, and visualization creation. Learners will explore how DAX formulas work, how to use measures and variables, and how to leverage Power BI's interface for effective data analysis.
  • More Core Concepts
    • This module delves into advanced DAX concepts, including filtering techniques, logical and information functions, and best practices for selecting columns and handling measure totals in Power BI. Learners will enhance their ability to debug DAX calculations, optimize data models, and ensure accurate reporting. By the end, you'll be equipped to tackle more complex analytical scenarios with confidence.
  • Dates and Calendars
    • This module guides learners through the creation and use of calendar tables in Power BI, focusing on advanced date calculations using DAX offsets rather than traditional time intelligence functions. Learners will practice implementing period-to-date and previous period measures, and handle special cases such as leap years for robust time-based analysis.
  • Text
    • This module delves into DAX text functions, teaching you how to manipulate, extract, and validate text data for dynamic and insightful Power BI reports. You'll learn practical techniques for string operations, pattern analysis, and transforming text into tables to enhance data modeling and reporting clarity.
  • Numbers
    • This module delves into essential numerical functions in DAX, covering rounding techniques, statistical calculations, and best practices for accurate data analysis in Power BI. Learners will explore how to manipulate, aggregate, and format numbers to enhance business intelligence reporting.
  • Time and duration
    • This module delves into handling time and duration data in DAX, including creating time tables, performing arithmetic with time values, and converting between different time formats such as decimal and Unix time. Learners will gain practical skills for analyzing durations, calculating work hours, and managing time-based data in Power BI.

Taught by

Packt - Course Instructors

Reviews

Start your review of Foundations of DAX: Core Concepts and Essential Data Skills

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.