Contact Us: 978.250.4983
Software Skills Training, Inc.

Analyzing Data with Power BI, DAX, and Power Query M

Attend face-to-face, remote-live or via on-demand training

Analyzing Data with Power BI, DAX, and Power Query M

Duration: 5 Days

US Price: $2795 *California residents and government employees call for pricing.

Delivery Options: Attend face-to-face in the classroom, remote-live or via on-demand training.

Registration: Click here to register for face-to-face or remote-live sessions, or click here to register for on-demand training.

Schedule View the course schedule

Description

This course gives students a solid understanding of data analysis with Power BI, DAX, and Power Query M. Attending this course will prepare students with the in-depth language skills needed to tackle even the toughest Data Analysis needs in Power BI.

Topics include creating visualizations, connecting to Excel files, creating a Power BI dashboard, developing reports using the Power BI desktop App, using DAX syntax, accessing data in Azure SQL Data Warehouses, and using the Power BI Mobile App and the Developer API.

Students will learn beginner and intermediate techniques for adding calculations to their Power BI Data models using DAX. Our hands-on labs provide practical exercises that cover some of the common data modelling problems that users may face, and how DAX can be used to solve those. Students will experience flattening out an OLTP database into a star schema by using DAX, resolving common granularity issues with data models, and learn how Measures can be used to solve advanced calculation problems that languages like SQL are unable to tackle.

Students will also learn about the M language that Power Query uses behind its graphical user interface, and how writing M directly can enable advanced queries against the data-sources that populate a model with its data.

Students who want Power BI training but do not need coverage of DAX and Power Query M should instead attend the Analyzing and Presenting Data with Power BI course rather than this course.

Prerequisites

Before attending this course, students must have:

  • Some prior experience working with data in Microsoft Excel, Microsoft Access, or SQL Databases
  • Some exposure to basic programming constructs (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Familiarity with Microsoft Office applications - particularly Excel

Course Overview

Introduction to Self-Service BI Solutions
  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service BI
  • Microsoft tools for self-service BI
Introducing Power BI
  • The Power BI service
  • Developing reports using the Power BI Desktop app
  • Using report items to create dashboards on the Power BI portal.
  • The Power BI data model
  • Using Excel as a data source for Power BI
  • Using databases as a data source for Power BI
Shaping and Combining Data
  • Power BI desktop queries
  • Shaping data
  • Combining data from different tables in your dataset
Modeling Data
  • Relationships between data tables
  • DAX syntax and queries
  • Calculations and measures
Interactive Data Visualizations
  • Creating Power BI reports
  • Creating a Power BI dashboard
  • Managing a Power BI solution
Direct Connectivity
  • Cloud data
  • Using Power BI direct connectivity to Azure SQL data warehouses, and big data sources such as Hadoop
  • Using Power BI with SQL Server Analysis Services data, including Analysis services models
The Developer API
  • The developer API
  • Using custom visuals
Power BI Mobile App
  • Using the Power BI mobile app
  • Power BI embedded
DAX Fundamentals
  • DAX Capabilities and Common DAX Use Cases
  • DAX Formula Syntax Fundamentals
  • Formula Evaluation Order
  • DAX Operators
  • DAX Operator Precedence
  • DAX Data Types
  • DAX Type Conversions
  • DAX Functions
  • Nested Function Execution Order
  • Naming Requirements
Basic DAX Calculations
  • Calculated Columns
  • Evaluation Context and Row Context
  • Working with Relationships
  • Using RELATED() and RELATEDTABLE()
  • Using Ad-hoc Relationships with USERELATIONSHIP()
  • Flattening Models with Calculated Columns
  • Calculated Tables
Advanced DAX Calculations
  • Measure Use Cases
  • Implicit Measures
  • Calculated Measures
  • Evaluation Context and Filter Context
  • Implicit Filter Context
  • Explicit Filter Context
  • Filtering with Calculate() and Filter()
  • Undoing Filters with All()
  • Iterator Fundamentals
  • Working with built-in Iterator Functions
  • Using Nested Iterators
DAX and Modeling
  • Resolving Model Granularity Issues
  • Flattening Models
  • Row Level Security with Row Filters
  • Avoiding Ambiguous Relationships with Role Playing Tables
M and Power Query
  • Power Query Basics
  • Using the Formula Bar in Power Query
  • Using the Advanced Editor in Power Query
  • PowerQuery's Standard Function Library
  • M Language
  • Case Sensitivity in Power Query and M
  • Single Literal Values
  • Intrinsic Values
  • Structured Values: Lists, Records, and Tables
  • M Language Operators
  • Commenting Code in M
  • Using the Let Statement
  • Variable Naming in M
  • M's Each Statement
  • Creating Columns in M
  • Conditional Constructs in M
  • M Functions

Related Training

Course
Analyzing and Presenting Data with Power BI
SQL Server 2017 Reporting Services

Training Locations

Choose a city below to view a schedule. If you have any questions, please call us at 978-250-4983 between 9:00 am - 5:00 pm EST.