3.86 out of 5
3.86
832 reviews on Udemy

Microsoft Power BI: Latest 2020 Beginner to Expert Modules

Transform, analyze & visualize data with Microsoft Power BI Desktop: hands-on demos, projects & 1-on-1 Power BI support
Instructor:
William McGuffey Academy
56,927 students enrolled
English [Auto]
Understand the business intelligence workflow from end-to-end
Blend and transform raw data into beautiful interactive dashboards
Connect Microsoft Power BI to data sources
Create Barcharts, Treemaps, Donut Charts, Waterfall Diagrams & Piecharts
Showcase your skills with three full-scale course projects (with step-by-step solutions)
At the end of this course students will be able to analyse data from different data sources and create their own datasets

In this course we are going to show you how to SUPERCHARGE your Power BI skills, and learn to create INTERACTIVE Dashboards and INCREDIBLE reports.

In this course we are going to teach you the following:

  • Using the Table and Matrix visualizations for cross-filtering and drill-downs

  • Creating Drill through between different sheets. For example you could be reviewing a list of Products and want to select one Product to view a summary of this product

  • Themes – Learn how to add Power BI Themes from the Community Theme Gallery

  • Changes in Custom Visuals – We look at how to easily add Custom Visualizations from the new Microsoft Office Store

  • Creating Apps – Learn how to easily share your dashboards and reports using Power BI apps and App workspaces

  • Relative Date Filters – In this lesson we show how to easily create a dashboard displaying Microsoft stock data. Easily filter your data to display the last 7 days, last 14 days, last month or previous 3 months using relative date filters

  • Drill Through – Create drill throughs between different pages in a report

  • Ribbon Chart – Learn to use the new Ribbon Chart to visualize the ranking of items across dates ranges or other categories.

Microsoft Power BI is the easiest to use reporting, data analysis and interactive dashboard tool available today! Microsoft Power BI is available for free – all you need to do is sign up!

There is no coding required! Power BI allows you to do that but it’s not necessary.

In this guided learning course you will start form zero to hero in 6 hours and you will learn:

  • the ETL capabilities of Microsoft Power BI (“get messy data easily into the right format”)

  • Master simple and very advanced DAX (Power BI language, similar to like excel formulas) calculations

  • Create outstanding visualizations and reports

  • Derive valuable highly profitable insights

In this course I will teach you how to easily turn your data into powerful intelligence and insight to drive your business decisions. Power BI uses simple drag and drop techniques that make it a breeze to create reports and dashboard. I will also show you how easy it is to publish your dashboards and to access them through your smartphone, tablet or laptop.

This course is for anybody who works with data and wants to learn how to quickly and easily get to speed with the cloud version of Power BI or learn the more powerful Power BI Desktop Designer.

The course has the following topics:

  • Introduction to Power BI and how to signup

  • How to create your first online report and dashboard

  • How to download the Power BI Desktop Designer

  • Loading, transforming and filtering data in Power BI

  • Creating tables and reports

  • Using filters and slicers

  • Learning how to use a wide range of graphs and visualizations

  • Creating relationships between tables of data

  • Creating powerful calculations, key metrics, and key performance indicators

  • Creating interactive dashboards

  • Publishing dashboards to Power BI

In this course, we use a step by step video-based approach to show you how to create reports, analyze data and develop interactive dashboards. The videos are extremely easy to follow and data is provided so you can follow the instructions at the same time.

Introduction to Data Visualization

1
Introduction to Data Visualization
2
Why Should we be Interested in Visualization
3
Abelas Chart Selection Diagram Part-1
4
Abelas Chart Selection Diagram Part-2
5
Some Principles of Effective Visualization

Visualization using Excel

1
Interactive Dashboard in Excel
2
Visualization on Chicago Crime Data Part-1
3
Visualization on Chicago Crime Data Part-2

Getting Started with Data Visualization

1
Common terminology in Data Visualization
2
Chart Components Chart Title
3
Chart Components Chart Area to Axis
4
Axis Title to Data Labels
5
Combo Chart
6
Stack Column Chart
7
Heat Maps

Creating Column Chart in Excel

1
Creating Column Chart in Excel
2
Column Chart Part-1
3
Column Chart Part-2
4
Column Chart Part-3

Creating Stacked Bar Chart in Excel

1
Creating Stacked Bar Chart in Excel Part-1
2
Creating Stacked Bar Chart in Excel Part-2
3
Creating Stacked Bar Chart in Excel Part-3

Creating Heatmap in Excel

1
Creating Heatmap in Excel
2
Crime Rates

Creating Combo Chart in Excel

1
Creating Combo Chart in Excel Part-1
2
Creating Combo Chart in Excel Part-2
3
Creating Combo Chart in Excel Part-3
4
Creating Combo Chart in Excel Part-4

Excel-Interactive Dashboard Using Slicers

1
Excel-Interactive Dashboard Using Slicers Part-1
2
Excel-Interactive Dashboard Using Slicers Part-2
3
Excel-Interactive Dashboard Using Slicers Part-3
4
Excel-Interactive Dashboard Using Slicers Part-4

Installation of Power BI

1
Power BI Installation
2
Installation Process
3
Power Bi Launch

Loading an Excel Data Into Power BI

1
Loading an Excel Data Into Power BI Part-1
2
Loading an Excel Data Into Power BI Part-2
3
Loading an Excel Data Into Power BI Part-3
4
Loading an Excel Data Into Power BI Part-4

Walkthrough of Power BI Tool

1
Walkthrough of Power BI Tool Part-1
2
Walkthrough of Power BI Tool Part-2
3
Walkthrough of Power BI Tool Part-3
4
Walkthrough of Power BI Tool Part-4
5
Walkthrough of Power BI Tool Part-5

Loading Access Data to Power BI

1
Loading Access Data to Power BI

Loading CSV File to Power BI

1
Loading CSV File to Power BI Part-1
2
Loading CSV File to Power BI Part-2
3
Loading CSV File to Power BI Part-3

Creating Bar Charts in Power BI

1
Creating Bar Charts in Power BI Part-1
2
Creating Bar Charts in Power BI Part-2
3
Creating Bar Charts in Power BI Part-3
4
Creating Bar Charts in Power BI Part-4

Creating Date Tables in Power BI

1
Creating Date Tables in Power BI

Creating Relationships and Data Models in Power BI

1
Creating Relationships and Data Models in Power BI Part-1
2
Creating Relationships and Data Models in Power BI Part-2

Creating Pie Charts in Power BI

1
Pie Charts in Power BI Part-1
2
Pie Charts in Power BI Part-2

Use of Power Query in Power BI

1
Use of Power Query in Power BI Part-1
2
Use of Power Query in Power BI Part-2
3
Use of Power Query in Power BI Part-3

Creating Slicers in Power BI

1
Creation of Slicers in Power BI Part-1
2
Creation of Slicers in Power BI Part-2
3
Creation of Slicers in Power BI Part-3

Merging and Appending Data in Power BI

1
Merging and Appending Data in Power BI Part-1
2
Merging and Appending Data in Power BI Part-2
3
Merging and Appending Data in Power BI Part-3
4
Merging and Appending Data in Power BI Part-4

Creating Maps in Power BI

1
Creating Maps in Power BI Part-1
2
Creating Maps in Power BI Part-2
3
Creating Maps in Power BI Part-3
4
Creating Maps in Power BI Part-4
5
Creating Maps in Power BI Part-5

Integrating R in Power BI

1
Integrating R in Power BI Part-1
2
Integrating R in Power BI Part-2
3
Integrating R in Power BI Part-3
4
Integrating R in Power BI Part-4

Visualization in Excel

1
Visualization in Excel Part-1
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.9
3.9 out of 5
832 Ratings

Detailed Rating

Stars 5
238
Stars 4
243
Stars 3
224
Stars 2
64
Stars 1
62
01fcdac0d97cf4795d5685ada2117985
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion
Don't Miss Any Course Join Our Telegram Channel Join Channel
+ +