Online Training
Power BI Dax
Your key to advanced data calculations
30-31 October 2024
9:00 AM - 12:30 PM AEDT
Next intake: 30-31 October 2024 | 9:00 AM - 12:30 PM AEDT
Overview
DAX (Data Analysis Expressions) is the calculation language of Power BI. DAX enriches existing data, enabling you to perform sophisticated data analysis. It has the power to unlock insights that would not be possible by just dragging values into visuals.
This course will enable participants to enhance existing data models and perform advanced data analysis. Mastering DAX will allow participants to uncover insights and trends that are not easily accessible through basic data manipulation. The course covers a wide range of topics from the basics of DAX to advanced filtering and time series intelligence, ensuring a thorough grasp of DAX functionality.
Participants will also learn to use DAX tools like DAX Studio and DAX Formatter to debug and optimize their queries, making their Power BI reports more efficient and effective. The skills gained from this course will empower attendees to leverage the full power of DAX, making their data analysis more robust and insightful, ultimately leading to better data-driven decisions.
Who Should Attend?
Professionals from diverse backgrounds who require advanced data analysis skills in their rolesLearning Outcomes
Online Training
Power BI Dax
Session details
- Uncover insights that basic data manipulation cannot reveal
- Build more efficient and effective data models using calculated columns, measures, and advanced filtering techniques
- Gain skills to create more informative and visually appealing Power BI reports that provide significant value to stakeholders
Level: Advanced
Familiarity with the topic is required
Key Sessions
- DAX and the data model
- Star Schema & Relationship Cardinality
- Columnar storage and the Power BI Engines
- Data types & Operators
- Creating a Fiscal Calendar
- Variables and Comments
- Date Functions & Text Functions
- Logical Functions (IF & SWITCH)
- Evaluation Context
- Organising Measures in a measures table
- Testing Measures
- Error Handlers (ISERROR, IFERROR)
- Working with Query View / DAX Studio
- EVALUATE and DEFINE MEASURE
- VALUES, ALL & ALLEXECPT
- SUMMARISE & SUMMARISECOLUMNS
- FILTER
- SUM vs SUMX
- RELATED and RELATEDTABLE
- AVERAGEX
- CONCATENATEX
- Understanding CALCULATE
- Applying multiple filter criteria
- Context Transition
- KEEPFILTERS
- ALL & REMOVEFILTERS
- Calculation Sequence
- Activating inactive relationships (USERELATIONSHIP)
- Running Totals with TOTALYTD & DATESYTD
- Year-on-Year / Month-on-Month Comparisons
Meet Your Facilitator
Nicky Bull
Corporate Consultant | Blue Chameleon
Nicky Bull is a dynamic corporate trainer and consultant. She has 15 years of commercial experience as a computer programmer and analyst, and over ten years designing and delivering a range of educational programs. She lectures accounting students at Macquarie University and is the creator of the highly acclaimed Excel for Data Analytics Specialisation on the Coursera platform.
Nicky is passionate about learning and enabling people to use technology confidently and effectively in their workplace. She holds a BSc Hons in Computer Science, a BA in English Literature, and a Postgraduate Certificate in Education.
Register Today
Join this training for professionals working within the Public Sector
Additional discounts are available for group registrations of 10 or more. For group or payment enquiries or custom training solutions, please contact [email protected]
Customised in-house options available for teams
Interested in any of our online trainings?
You can also choose to have them delivered in house. We will work closely with our inspiring session facilitators to tailor the content around the key development areas your team are prioritising, shape the learning outcomes around your core departmental challenges and make the most of your L&D and upskilling budget.
Enquire here for more informationCan't see what you need?
Download our training catalogue to review all available topics
Download full catalogue
