Tutorialspoint
Subscription Includes
$ 39.99   9.99

PowerBI and PowerQuery Dashboards

Created by Thomas Fragale, Last Updated 25-Oct-2020, Language:English

PowerBI and PowerQuery Dashboards

Learn how to start getting great results with PowerBI and PowerQuery

Created by Thomas Fragale, Last Updated 25-Oct-2020, Language:English

What Will I Get ?

  • Learn PowerPivot
  • Learn PowerQuery

Description

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

Course Content

Thomas Fragale

Microsoft Certified Trainer