Data visualization allows you to represent information digitally and graphically, to convey the results of data analysis. Microsoft Power BI is a suite of business analytics tools that help you gain insights from your data. The suite brings together familiar operations from well-known products—including Excel, Access, Power Query, and Power Pivot—to help you quickly get move the basics and on to comprehensive analysis. In this course, Helen Wall guides you through the advanced capabilities of the service. She shows how to work with calculations, leverage the DAX language, create advanced queries, and use the M language to improve the querying process. She demonstrates how to import data from various sources, compose advanced formulas, manage the fields and columns in tables, use X-factor functions, use conditional statements, filter results, design charts, and more.

Topics include:

Power BI Desktop vs. Pro vs. Tableau

Importing data from files or from online

Using Query Editor

Joining tables and creating tables

Formulating via DAX logic

CALCULATE, ALL, FILTER

POWER, DIVIDE, BLANK

SUMX and COUNTX

DATEDIFF, DATESBETWEEN, DATEADD

MTD, QTD, and YTD

Using X-factor functions

Using quick measures and dynamic measures

Using conditional statements

Working with disconnected tables

Designing charts and visualizations