Course Overview
You’re already using Microsoft’s cloud reporting and business analytics suite, Power BI, to analyze your organization’s data and share insights, and you’re now ready to learn the advanced techniques that you need to create complex analytics from across your enterprise. This is live, instructor-led training that can be delivered in-person or remotely.
This two-day course* focuses specifically on using DAX (Data Analysis Expressions) to increase the power and complexity of the calculations and presentation of data in a Power BI Desktop data model. It can be delivered in combination with Advisicon Academy’s Intermediate MS Power BI course.
In this course, participants will learn to:
- Learn basic concepts of data modeling
- Learn the consequences of data model design decisions
- Learn concepts of calculated columns and measures
- Gain familiarity with standard DAX patterns & CALCULATE
- Gain an understanding of evaluation contexts & their impact on calculations
- Develop the ability to parse data modeling formulas
*If you wish to customize the course content or duration, please reach out to us directly.
Who Should Attend
This course is designed for moderately-experienced Power BI users. As a prerequisite, students should have at least limited familiarity with Power BI or the data connection capabilities of Microsoft Excel or successful completion of Introduction to Power BI & Intermediate MS Power BI.
Course Materials
Course materials are comprised of a lecture, demo, and lab, no textbook necessary. Attendees may also earn Professional Development Credits from the Project Management Institute (PMI®).
Learning Objectives
Functional Basics
• Power BI modeling
• Design consequences
• Data storage architecture
• Data model optimization
• Data type handling consequences
DAX Evaluation Context
• Understand different kinds of evaluation contexts
• Use iterator functions and CALCULATE to create sophisticated measures
Data Modeling Best Practices
• Query folding
• Data compression techniques
• Use of relationships
Time Intelligence
• Parsing advanced DAX formulas
• Use standard DAX patterns
• Intro to further learning resources
DAX Calculated Columns & Measures
• Differences between columns & measures
DAX CALCULATE Function
• Basic use of CALCULATE
DAX Best Practices
• Importance of writing efficient DAX measures
Bring Your Own Data
• Explore solutions to Power BI problems under the course instructor’s guidance
Pain Points This Course Helps!
⚡ I need my reports to support a wider range of situations!
Learning DAX will equip you to select, join, and filter data in a dynamic way.
⚡There’s no story to my data!
We’ll teach you the art and science behind transforming your data into insightful information.
⚡ Building my reports is laborious and tedious!
Learn how to build Power BI reports once that you can reference many times.
⚡My reports are slow!
Advisicon’s DAX Data Modeling course will help you identify opportunities to reduce the size of your data model while still supporting your users’ lust for more and deeper insights.
⚡ It takes too long to get new reports developed by our analysis team.
Our Power BI training will equip you to create compelling analyses of any data you can access.
Course Instructors and Accreditation
We are Microsoft Certified Professionals with Gold Competencies in Data Analytics and Project and Portfolio Management–Microsoft’s highest partner ranking. This course will be taught by an experienced instructor who has deployed & configured Power BI reporting in a wide variety of businesses.
Advisicon’s goal is to improve your processes and technologies, thus creating measurable results. For over 30 years, we have successfully helped customers learn, scale, and grow.
