Power BI Dashboard; Power BI Sales and Inventory Report
4.7 (10 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.
575 students enrolled

Power BI Dashboard; Power BI Sales and Inventory Report

Learn how to create a Power BI Inventory and Sales report in Power BI desktop. Transform and Analyze Data in Power BI.
4.7 (10 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.
575 students enrolled
Created by VR eLearning
Last updated 4/2020
English
Current price: $97.99 Original price: $139.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 13 articles
  • 20 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
  • At the end of this course, students will be able to create measures and columns in Power BI.
  • Work in the Power Query editor and use M-language formulas to perform calculations.
  • Students will create various graphs and charts.
  • Analyze data in Power BI.
  • Transform raw data into stunning interactive reports.
  • Create relationships between tables.
  • Use OneDrive for business to store files and sync files to the cloud.
Requirements
  • Have a computer with a Windows Operating System
  • You need a reliable internet connection
  • Already have Power BI desktop installed
  • Already have Power BI login details
  • Know the very basics of Power BI, such as how to navigate through the Power BI ribbon.
Description

Power BI is the business analytic service by Microsoft. 

Start a career in Business Intelligence and learn valuable BI skills in this course.  Develop a mix of specific Power BI skills.

Analytical and business intelligence skills are geared towards presenting and communicating data to others.

Power BI tools are used to make better decisions. Extract actionable insights from KPI's which can be visualized and presented during meetings in a business environment.

In this course, you will learn how to:

  • Get your free Microsoft 365 office account.

  • Get access to OneDrive for Business.

  • Save your working files in OneDrive, or if you prefer, work form Excel which is saved on your local computer.

  • Create a theme in Power BI.

  • Build relationships between tables.

  • Use Power Query M-Language formulas to perform calculations.

  • Create various graphs and charts such as a:

    1. Pie chart

    2. Clustered column chart

    3. Whaffle chart

    4. Dot Plot visual

    5. Slicers

    6. Bar charts

    7. Pareto graph

    8. Mekko visual

  • Create various measures and calculated columns.

  • Learn about bookmarks and the mobile phone layout.

  • Publish the report to the Power BI service.

  • Automatically sync the Power BI files to the cloud - no need to publish the report.


Sign up for this course if you want to increase your Power BI skills.


Who this course is for:
  • Beginner to Intermediate Power BI users who wants to create a report in Power BI desktop.
Course content
Expand all 60 lectures 03:56:39
+ Facebook stock price trend. Power BI warm-up
6 lectures 14:51
Regarding the Warm-Up
00:12
Downloadable resources for the Warm-Up exercise
00:06
Add the Pulse Chart Visual
07:06
Your Warm-Up challenge
00:11

Answer the questions regarding the Pulse Chart.

Power BI Pulse Chart
1 question
Further Note
00:18
+ Power BI General Settings
3 lectures 02:27
Power BI Settings
01:01
Get Data From Excel Files
00:47
How to get the course certificate of completion.
00:39
+ Power BI file preparation
10 lectures 15:33
Get the downloadable resources.
00:06
Your challenge in this course.
00:11
Sign Up for a free Microsoft 365 Office account
03:44
Sign Up to get Access to OneDrive for Business.
00:13
Install OneDrive for Business and Sync files to the cloud
02:51
Install OneDrive for Business.
00:48

Follow along with this video.

First create a .json file.....

Create a Power BI theme from your company logo image.
05:28
Practice: Create the Theme in Power BI.
01:11
Import the theme file in Power BI
00:50
Install the theme in Power BI.
00:10
+ Prepare and Import the files from OneDrive for Business.
8 lectures 29:52
Changes to the Power BI ribbon.
01:06
View: The Power BI Ribbon.
02:10
Import files from OneDrive.
05:02
Practice: Import files from OneDrive
01:27
Load other data files.
03:55
Build relationships between the tables in Power BI
04:52
Create a Date Table in Power BI
09:44
Calculated Columns and Measures in Power BI
01:36
+ Power BI Create Sales Delivery Calculated Columns and Power Query Columns
6 lectures 46:06
Sales Delivery Calculations
06:36
Orderfill M-Language Formulas
05:57
Orderfill - Visual Power BI
11:30
Pie Chart Power BI
02:33
Clustered Column Chart in Power BI
07:34
Waffle Chart Returns by Category
11:56
+ Create the Order Days page.
5 lectures 31:10
Dot Plot Visual with Sales Measures Power BI
07:04
Add a Slicer to the Power BI page
02:50
Power BI Variables
06:46
Fixing the blank column in Power BI.
10:01
+ Pareto Analysis in Power BI
4 lectures 15:02
The summarize DAX function.
01:55
Summarize and RankX with the Multi Axis Chart
03:34
Pareto Chart in Power BI
04:53
The Mekko Visual in Power BI
04:40
+ Inventory Analysis in Power BI
5 lectures 25:35
Merge queries in Power BI. Prepare data for the inventory analysis page.
04:54
Inventory Movement table in Power BI
05:27
Fixing a missing column in Power BI
02:35
Calculate the Stock on Hand
06:40
Accumulation of the Purchase Order quantity
05:59
+ The Buy-Outs Page
3 lectures 12:19
Calculate the Buyout Quantity and Buyout Value
04:56
Calculate the Buyout Percentage in Power BI
03:13
Filter and drill-down in Power BI
04:10