Home >> Courses >> Office Tools >> Using PowerBI and PowerQuery to Create Dynamic Dashboards

Using PowerBI and PowerQuery to Create Dynamic Dashboards

PowerBI

5 (2 ratings) Last Updated:08/2020 English (US) Instructor: Thomas Fragale

Lectures: 2
|
Videos: 2.26 hours
|
Level: All
|
Language: English
|
Last Updated: 08/2020

Skills: Data Analytics Data Analysis Data Modeling

Eduonix Infiniti Subscription Plan

Access this and 2000+ courses for free

Free with Membership

Offer Price:

$2.50

Our Price:

$5.00

Original Price:

~~$30.00~~

You Save:

$25.00 (50%)

Free with Infiniti

Ends in:

00D 00H 00M 00S

2 lectures 2.26 hours English

Learn Risk Free

30 day money back guarantee

$5.00 ~~$30.00~~

About this Course

In todays 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

People interested in this course also viewed

Course Content

Prerequisites

About the Instructor

Thomas Fragale

Courses...

I am a Microsoft Certified Trainer with over 35 years of professional IT experience, and my passion is teaching people how to get the most out of their computer.

Reviews and Ratings

Top Reviews

View More Reviews

Frequently Asked Questions

It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.

A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.

A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.

We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.