Microsoft Power BI - DAX Super User

Having collected your data and the basics in the Microsoft Power BI - Data Analysis course, you now need to analyze with DAX. DAX (Data Analysis Expression) is the language to use with Power Bi, which allows you to massage, calculate, and get the results you require to the people who make the decisions within your organization.

Duration: 1 Day

Objectives:

With the skills gained in this course, you will be able to apply data communications concepts, terminology, and technologies, in a prefessional setting and build interactive visuals that can show trends, future forecasts, and deep analysis. This will get the results you need at the time you need them.

Prerequisites:

You must have completed the Microsoft Power BI - Data Analysis course or have equivalent training or practical experience before registering for this course. Having problem solving skills and the ability to do complex calculations will be required as this course requires being able to analyze large amounts of data.

This course requires that the student have the latest version of Power BI installed on their system.

Outline

• Connecting Data Sources and Creating Datasets
  • Data Connector Library
  • Configuring Data Source Settings
  • Understanding the PQE (Power Query Editor)
  • Rolling Calendar
  • Combining Queries
  • Building Hierarchies
  • DAX Shortcut Keys
  • Dedicated Measures Table
• Data Modeling and Relationships
  • Define Data Modeling
  • Normalization and Relationships
  • Types of Relationships
  • Managing Relationships
  • Understanding Filter Flow
  • Star and Snoflacke Schemas
  • Data and Lookup Tables
• Calculating with DAX Functions
  • Calculated Columns vs Measures
  • Best Practices for DAX
  • Conditional and Logical Functions
  • IS Functions
  • Date and Time Functions
  • Conversion Functions
  • Math and Statistical Functions
  • Text Functions
  • Infamous Calculate Functions
  • Iterator Functions
  • Time Intelligence
  • Table and Filter Functions
• Visualizing Your Data Results
  • Living in the Matrix
  • Trends and Forecasting
  • Geo-Sync your Data with Maps
  • Key Metrics with KPI Visuals
  • Report Filtering Options/li>
  • Designing for Smart Phones
  • Interactive Reports

ON-TRACK Corporate Training has a diverse and flexible schedule that can be customized to your needs. We offer group courses (both public and corporate), one-on-one training, virtual (on-line) classroom (Zoom etc.) and on-site training options. We also have easily accessible on-line training videos on OnTrackTV.