4.47 out of 5
4.47
9439 reviews on Udemy

Power BI A-Z: Hands-On Power BI Training For Data Science!

Learn Microsoft Power BI for Data Science and Data Analytics. Build visualizations and BI reports with Power BI Desktop
Instructor:
Kirill Eremenko
71,952 students enrolled
English [Auto] More
Connect Microsoft Power BI to data sources
Create Barcharts
Create Treemaps
Create Donut Charts
Create Waterfall Diagrams
Create Piecharts

Learn data visualization through Microsoft Power BI and create opportunities for you or key decision makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.

You’ll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.

Use Power BI to Analyze and Visualize Data So You Can Respond Accordingly

  • Connect Power BI to a Variety of Datasets
  • Drill Down and Up in Your Visualization and Calculate Data
  • Visualize Data in the Form of Various Charts, Plots, and Maps

Convert Raw Data Into Compelling Data Visualizations Using Power BI

Because every module of this course is independent, you can start in whatever section you wish, and you can do as much or as little as you like.

Each section provides a new data set and exercises that will challenge you so you can learn by immediately applying what you’re learning.

Content is updated as new versions of Power BI are released. You can always return to the course to further hone your skills, while you stay ahead of the competition.

Contents and Overview

This course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.

To be able to find trends in your data and make accurate forecasts, you’ll learn how to work with hierarchies and timeseries.

Also, to make data easier to digest, you’ll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.

In order to begin visualizing data, you’ll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.

You’ll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.

Finally, you’ll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brickcharts and more.

By the time you complete this course, you’ll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.

You’ll be fully prepared to collect, examine, and present data for any purpose, whether you’re working with scientific data or you want to make forecasts about buying trends to increase profits.

Welcome to the Course

1
Installation
2
BONUS: Learning Paths
3
Some Additional Resources!!
4
Get the materials

Your First Bar Chart

1
The business Challenge - Who Gets The Annual Bonus?
2
Connecting Power BI to a Data File - CSV File
3
Updates on Udemy Reviews
4
Navigating Power BI
5
Drilling down and up in hierarchies
6
Advanced drilling in hierarchies
7
Adding Colours
8
Adding A Calculated Column
9
Adding Labels and Formatting
10
Your first bar chart

Timeseries, Aggregation, and Filters

1
Downloading and connecting to the dataset
2
Working with timeseries
3
Understanding aggregation and granularity
4
Creating an area chart & learning about highlighting
5
Filters and Slicers in Power BI
6
Timeseries, Aggregation, and Filters

Maps, Scatterplots and Interactive BI Reports

1
Joining data in Power BI
2
Understanding how LEFT, RIGHT, INNER, and OUTER joins work
3
Joins with duplicate values
4
Joining on multiple fields
5
Creating a map, working with hierarchies, lats and lons
6
Power BI: Calculated Columns vs Calculated Measures

In this lecture, Kirill explains the differences between calculated columns vs. calculated measures in PowerBI on the example of the European map

7
Creating a scatter plot
8
Combining charts, filters and slicers
9
Adding a Donut Chart
10
Maps, Scatterplots and Interactive BI Reports

Creating an Interactive Business Intelligence Report

1
Downloading the dataset and connecting Power BI
2
Mapping: How To Set Geographical Roles
3
Creating Table Calculations for Gender
4
Creating Bins and Distributions for Age
5
Creating Bins and Distributions for Balance
6
How to create a Treemap chart
7
Creating a Customer Segmentation Dashboard
8
Controlling Report Interactivity
9
Analyzing the Customer Segmentation Dashboard
10
Creating an Interactive Business Intelligence Report

Leveraging Custom Visuals

1
The Challenge: Visualizing the European Debt Crisis
2
Installing a Custom Visual for Power BI
3
Mechanics of a Chord Chart
4
Setting up the second Chord Chart
5
Adding Treemaps
6
Exploring the visualization
7
THANK YOU bonus video

Bonus Lectures

1
***YOUR SPECIAL BONUS***
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!
4.5
4.5 out of 5
9439 Ratings

Detailed Rating

Stars 5
4751
Stars 4
3562
Stars 3
936
Stars 2
148
Stars 1
52
59ea6c40b98d681e60878c32f529c670

Includes

4 hours on-demand video
4 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion