The Complete Power BI Practical Course 2020
4.3 (473 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,238 students enrolled

The Complete Power BI Practical Course 2020

Power BI: Jump start your career as Power BI developer
4.3 (473 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,238 students enrolled
Created by 365 Careers
Last updated 5/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7.5 hours on-demand video
  • 5 articles
  • 42 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to create data models inside Power BI
  • Get a good solid understanding of DAX
  • How to build beautiful and interactive dashboards that can be presented to clients
  • How to shape your data to meet the needs of the business
  • Get a full exposure of the dashboard creation and sharing process
Requirements
  • A computer, both Windows and Mac users are welcome
Description

Learn how to work with Power BI the practical way!

This course is designed for students who like to learn by doing.

Packed with real-life business scenarios along with quizzes and projects to build, this course will give you the solid understanding required to jump start your career as Power BI developer.

We will not only teach you how to create stunning dashboards, but we will also introduce you to data modelling, data transformations, teach you how to write DAX, set up calculated columns and measures, generate roles, and of course share your dashboards with your team or clients.

Power BI allows you to connect to hundreds of data sources and quickly analyse your data for free. And, although Power BI desktop may not be available for Mac, this course will show you an easy solution that allows you to use Power BI desktop on your Mac for free for the next 12 months!

This course is suitable for complete beginners, intermediate and advanced users, as we’ll guide you every step of your journey with easy to understand explanations.

Click 'Buy now' and start your Power BI journey today!

Who this course is for:
  • Power BI beginners
  • Power BI advanced users
  • People interested in a career in business intelligence
Course content
Expand all 80 lectures 07:44:10
+ Power BI Setup
3 lectures 15:22
Power BI for MAC
05:40
Power BI for Mac Part 2
06:45
How to Install Power BI
02:57
+ Connecting to Data Sources
11 lectures 57:58
Introduction to Data Sources
00:56
The Query Editor
03:26
Import vs DirectQuery
04:22
Importing Data from Excel Files
08:56
First Data Model
05:57
Active vs Inactive Relationships
09:14
Entering Data Manually
03:21
Roles
02:36
Refreshing Data
05:46
Hierarchies
09:09
Ask a Question
04:15

Time to test your knowledge

Quiz Time
6 questions
+ Practical Task Three
3 lectures 18:16

Please create a model inside Power BI, data can be found inside Project Files -> 1. Data Extracts -> Section Three Data Extract. All tables need to be imported.

Create a dim_Date table using the ShipDate from fact_InternetSales and create the following columns inside:

  1. Year

  1. Month

  1. MonthName

  1. DayOfWeek

  1. Quarter

  1. YearQuarter

Connect the dim_Date table with fact_InternetSales on ShipDate

Create the following visuals using the Ask a Question option:

Sales Amount by Currency, sorted by currency name

*Sales Amount by Month - sort it by the correct Month Order, not alphabetical order

Matrix Table to show Sales Amount by Email Address per Currency

BONUS POINTS if you can figure out how to increase the font size of the visuals on Titles, Values and Axis, and also change the Style of the Matrix table

Task Three
00:29
Task Three, Part 2
07:14
+ Data Modelling
18 lectures 01:42:04
Introduction to Data Modelling
00:34
DAX
00:34
Calculated Columns
02:07
Measures
05:46
The Star Schema
05:06
The Snowflake Schema
02:52
Investigating the Filter Flow
03:23
Related vs Relatedtable
05:45
Bi-directional Cross-filtering
05:52
Calculate
04:27
Time Intelligence, Part 1
08:42
Time Intelligence, Part 2
10:47
All
04:00
Filter
06:50
Iterators
07:53
Logical operators
07:46
Switch
09:09
Text Functions
10:31

Time to test your knowledge

Quiz Time
6 questions
+ Practical Task Four
4 lectures 26:34
Task Four
00:33
Task Four, Part 1
08:38
Task Four, Part 2
10:08
Task Four, Part 3
07:15
+ Creating Our First Data Visualization Report
14 lectures 01:37:00
Introduction
00:41
Report View
04:27
Slicers
10:44
Bar Chart
10:38
Bookmarks
08:54
Conditional Formatting
07:04
Field Formatting
04:38
Gauge Chart
05:53
Card Visuals Part 1
09:24
Card Visuals Part 2
13:24
Drillthrough
06:35
Filters
04:20
Map Vizuals
05:42
Custom Colors
04:36

Time to test your knowledge

Quiz Time
6 questions
+ Practical Task Five
5 lectures 20:38

Your task is to create a dashboard that looks aesthetically pleasing. Files can be located in Section Five Data Extracts, please import all columns from the excel file.

The dashboard should contain:

  • Header, background color to be #101D42

  • Slicer with Colors from dim_Product, to be placed inside the Header

  • Measures table (using DAX) with measures for Products Sold, Total Customers, Total Sales Amount

  • Three boxes to show Total Sales Amount, Products Sold and Amount of Customers. Each box should have the same background color as the Header, and also contain an image (images can be found in 5.Report Designer - 3. Icons). The values need to be shown inside the card visual. Boxes, images and values need to be aligned accordingly, values’ font size should be increased.

  • Two boxes with the same background color as Header. The first box should contain a donut chart showing the split between Male and Female, switch off the title from the donut chart and use Text Box. The text inside Text Box should say “Total Products Sold Male/Female Split”, font size to be bold, 24px, color to be #DB162F . Donut labels should be increased to 14 px. The donut colors should be white 20% Darker for Male and for Female use #DB162F. The second box should have a title called “Total Products Sold by Country”, same font size and color settings as the first box. Total products sold by country should be displayed using a bar chart. Title should be switched off from the bar chart, font size should be increased on both y and x axis.

Task Five
01:04
Task Five, Part 1
02:55
Task Five, Part 2
02:35
Task Five, Part 3
06:21
Task Five, Part 4
07:43
+ Practical Task Six, Final Project
15 lectures 01:44:02
  1. Import all five tables from the Excel File called “Section Six Data Extract” into Power Query Mode

  1. Create “Username” column inside dim_Customer table from the email address column. We are only looking for the text before the “@” symbol. The column should also be labeled “Username”

  1. Scan the dim_Customer table and look out for columns with lots of Null values and remove them from the table

  1. Import the tables into the model and check the connections between tables, make sure that every table is connected

  1. Create #Measures table using DAX

  1. Create dim_Date table using “fact_InternetSales[ShipDate]” column and create the following columns “Year”, “Month”, “Month Name”, “Day of Week”, “Quarter”, “Year/Quarter”. Make sure that the Month column is sorted correctly

  1. Dynamic measure for selected currency, based on the selected currency the measure should return the sales amount in the selected currency, if no currency has been selected the measure should say “No currency selected”.

  1. Dynamic measure for title that should say “Sales Amount in [Selected Currency] vs All Currencies“, alternatively it should say “Please Select Currency from the Dropdown Menu”

  1. Create measures for Previous One Month, Previous Three Months and Previous Six Months

  1. Measure that will tell us the time the report was last opened, text should say “Executed: Date and Time”

  1. Header (background color optional) with line color #e8d400

  1. Insert logo (located inside 3.Images) inside the header and resize it accordingly

  1. Create buttons for “Clear Filters” (apply red outline on this button only), “Users” (apply outline using color #e8d400 on the rest of the buttons), “Currency”, “Sales Territory”. Buttons need to be positioned inside the header

  1. Executed Measure to be placed inside the header on the right using Card Visual and resized accordingly, text should be on one line.

  1. Create dropdown menus using bookmarks for Users, Currency and Sales Territory. The dropdown menus should have outline color of #e8d400 and an arrow pointing up to close the menu(arrow can be located inside 3.Images). Each of the dropdowns should contain the option to search inside the filter.

  1. Create a bookmark that clears all the filters and apply it to “Clear Filters” button

  1. Import Timeline Slicer into the visualisations panel. The visual can be located inside 4.Custom Visual. The slicer should be positioned below the header. Change the selected cells color to #e8d400

  1. Create three boxes – first one to show Sales Amount in Selected Currency, second one to show Sales Amount for All Currencies in Previous Month, Sales Amount for All Time for All Currencies. Each box should have the same outline color of #e8d400. Text should be aligned in the middle, font size to be increased based on user preference. Sales Amount for Last Month and Sales Amount for All Time should not be filtered when choosing currency or region from the Header menu.

  1. *Find out how to Increase Canvas Size to 1720h x 1280w

  1. Position the Dynamic Title Measure in the middle inside a card visual with appropriate font size.

  1. Using Line and stacked column chart create a visual that shows all Sales Amount in All Currencies, split by month name. Bar color to be #293537. Font size to be increased accordingly. *Inside the chart we should show the selected currency from the dropdown menu as a dot. Marker size to be 10 pixels. The dot color should be #e8d400. The chart should also have a Legend. Legend to be positioned in Top Center. Data lables should be visible for the bars, but not for the dots. The visual should have a placeholder in the background with line color #e8d400

  1. Additional Dynamic Title Measure to be created. This title should tell us Total Products sold in the selected country or alternatively Total Products Sold Worldwide. This should be triggered by the Sales Territory Dropdown button from the Header

  1. Number of Products Sold by Country to be shown inside a map visual. Change the color of the country to #e8d400. The visual should have a placeholder in the background with line color #e8d400

  1. Create a table that shows the SalesTerritory along with the Sales Amount as %, Total Sales Amount, Sales for Previous One Month, Previous Three Months, Previous Six Months. Font size to be increased accordingly, outline to be removed. Column headers to be colored in #e8d400. Totals should have the same background color as per headers. Remove the outline from Totals as well. SalesTerritoryCountry background color to be changed to the same color as Totals. All headers should be capitalised. Apply conditional formatting to the Total Sales Amount %. If values are between 0 and less than or equal to 0.2 make it red, if it is greater than or equal to 0.3 and less than 0.5, make it #e8d400, if it is greater than or equal to 0.5 and less than or equal to 1, make it green

  1. Test out the dashboard, make sure that everything works in sync. Bonus points if you can figure out how to change the boxes inside the Currency dropdown from a box to “Single Select” so that users can only choose one Currency from the dropdown menu at a time.

Task Six
03:27
Final Project, Part 1
02:16
Final Project, Part 2
05:30
Final Project, Part 3
05:54
Final Project, Part 4
07:26
Final Project, Part 5
08:02
Final Project, Part 6
06:12
Final Project, Part 7
05:47
Final Project, Part 8
14:33
Final Project, Part 9
03:28
Final Project, Part 10
07:18
Final Project, Part 11
08:19
Final Project, Part 12
08:15
Final Project, Part 13
06:20
Final Project, Part 14
11:15