Register your product to gain access to bonus material or receive a coupon.
Video accessible from your Account page after purchase.
Over 9 hours of video content
In this course, Michiel Rozema and Madzy Stikkelorum help you understand the core concepts of DAX and how to design, build, debug, and optimize DAX calculations.
Overview:
Since its launch, Power BI has quickly become the leading platform for business intelligence. With powerful self-service capabilities and integrated data preparation, analytics, and visualization features, Power BI enables business users to gain insights like no other. One of the core strengths of the platform is the DAX calculation language, which is available in Excel as well. While Power BI is designed to allow for easy entry, implementing sophisticated analyses with DAX can be a daunting task. If you work with data, you can use Power BI or Excel to implement sophisticated models to analyze and get insights from your data. To do this, you will need to learn to build calculations with the DAX language.
This course helps you to understand the foundational concepts in DAX and to design your own DAX calculations step by step. The course includes many exercises to practice your DAX skills. The central challenge in business intelligence is to translate the way your business works to appropriate data aggregations; this course will enable you to do just that.
Skill Level:
Learn How To:
Course requirement:
Who Should Take This Course:
About Pearson Video Training:
Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Sams, and Que Topics include: IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.
Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.
Introduction
Lesson 1: Understand the Role of DAX
1.1 Understand the five-Layer model for business intelligence
1.2 Use DAX in Power BI
1.3 Use DAX in Excel
Lesson 2: Design Semantic Models
2.1 Understand the column store
2.2 Choose data types
2.3 Design efficient tables
2.4 Understand relationships
2.5 Define an effective model structure
2.6 Decide on model architecture
2.7 Exercises
Lesson 3: Learn the Basics of DAX
3.1 Extend a model with calculated columns
3.2 Extend a model with calculated tables
3.3 Understand measures
3.4 Use basic aggregations
3.5 Apply operators
3.6 Implement conditional logic
3.7 Exercises
Lesson 4: Organize DAX Calculations
4.1 Use a measure table and folders
4.2 Add metadata
4.3 Work with the DAX editor
4.4 Exercises
Lesson 5: Create Visual Calculations
5.1 Understand AutoExist
5.2 Leverage the visual matrix
5.3 Add a visual calculation
5.4 Use more advanced visual calculations
5.5 Navigate the visual matrix with DAX
5.6 Exercises
Lesson 6: Understand Filters, Context, and CALCULATE
6.1 Explore filters
6.2 Understand row context
6.3 Understand query context
6.4 Use filter context with CALCULATE
6.5 Exercises
Lesson 7: Build More Advanced Calculations
7.1 Use ALL functions
7.2 Change relationship behavior
7.3 Leverage KEEPFILTERS
7.4 Use variables in DAX
7.5 Exercises
Lesson 8: Use Time Intelligence
8.1 Create a date table
8.2 Understand time intelligence
8.3 Use common time intelligence functions
8.4 Exercises
Lesson 9: Understand DAX Table Functions
9.1 Use table aggregations
9.2 Leverage virtual tables
9.3 Understand row context in table functions
9.4 Retrieve summarized tables
9.5 Change context for table evaluation
9.6 Exercises
Lesson 10: Apply Table Functions Within CALCULATE
10.1 Understand filters and tables
10.2 Change context with virtual tables
10.3 Understand lineage
10.4 Exercises
Lesson 11: Use WINDOW Functions
11.1 Understand what changing context does
11.2 Understand INDEX, OFFSET, and WINDOW
11.3 Use PARTITIONBY and MATCHBY
11.4 Exercises
Lesson 12: Implement Parameters
12.1 Use numeric range parameters
12.2 Implement field parameters
12.3 Exercises
Lesson 13: Create and Use Calculation Groups
13.1 Understand calculation groups
13.2 Add calculation items
13.3 Use dynamic formatting
13.4 Create conditional calculation items
13.5 Exercises
Lesson 14: Use the DAX Query View
14.1 Use Performance Analyzer
14.2 Understand a visual's DAX query
14.3 Use the DAX query view
14.4 Apply quick queries and INFO functions
14.5 Debug measures
14.6 Exercises
Lesson 15: Learn from DAX Exercises
15.1 Understand lesson 2 exercises: semantic models
15.2 Understand lesson 3 exercises: basic DAX
15.3 Understand lesson 4 exercises: organize calculations
15.4 Understand lesson 5 exercises: visual calculations
15.5 Understand lesson 6 exercises: context
15.6 Understand lesson 7 exercises: advanced calculations
15.7 Understand lesson 8 exercises: time intelligence
15.8 Understand lesson 9 exercises: table functions
15.9 Understand lesson 10 exercises: table filters
15.10 Understand lesson 11 exercises: WINDOW functions
15.11 Understand lesson 12 exercises: parameters
15.12 Understand lesson 13 exercises: calculation groups
15.13 Understand lesson 14 exercises: DAX query view
Summary