Using PowerBI and PowerQuery to Create Dynamic Dashboards

In today’s busy world, we are all presented with overwhelming amounts of data, and we are given the task of making sense of that data. It can be a very time-consuming task to pull all of this data together and somehow make sense of this large amount of data.

Microsoft has come up with 2 great tools, PowerQuery and PowerBI, which can help you gather your data, and report on it in many ways.

This course will show you how to gather and manipulate your data using PowerQuery, and then how to make the data visually appealing and dynamic with PowerBI. PowerQuery is really built into the desktop version of PowerBI.

Topics covered:
Downloading PowerBI
Tour of screen

Importing data from:
Excel
Normal data
Formatted data
Text
Access
SQL Server
Web

Building and managing different visuals
Adding and managing Slicers
Add columns
Delete column
Merge columns
Split columns
Date fields
Number fields
Text fields
Conditional columns

Quick measure:
Filters
Running Total
Year to Year Change

Category:

In today’s busy world, we are all presented with overwhelming amounts of data, and we are given the task of making sense of that data. It can be a very time-consuming task to pull all of this data together and somehow make sense of this large amount of data.

Microsoft has come up with 2 great tools, PowerQuery and PowerBI, which can help you gather your data, and report on it in many ways.

This course will show you how to gather and manipulate your data using PowerQuery, and then how to make the data visually appealing and dynamic with PowerBI. PowerQuery is really built into the desktop version of PowerBI.

Topics covered:
Downloading PowerBI
Tour of screen

Importing data from:
Excel
Normal data
Formatted data
Text
Access
SQL Server
Web

Building and managing different visuals
Adding and managing Slicers
Add columns
Delete column
Merge columns
Split columns
Date fields
Number fields
Text fields
Conditional columns

Quick measure:
Filters
Running Total
Year to Year Change