Power BI: Sales Analysis and Inventory Management
3.2 (3 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.
20 students enrolled

Power BI: Sales Analysis and Inventory Management

Design Visualizations in Power BI desktop and publish to Power BI Service on the Cloud.
3.2 (3 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.
20 students enrolled
Last updated 10/2018
English
English [Auto]
Current price: $16.99 Original price: $24.99 Discount: 32% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 1 downloadable resource
  • 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
  • Skills to use Power BI desktop Visualization Charts and upload them to Power BI Service on the cloud to make them available to the public.
Requirements
  • Basic knowledge of Excel.
Description

Power BI has excellent visualizations charts to compare data of different units (like quantity and money) using Combined Charts.  The georeference maps allow you to explore data geographically located. A relationship between two or more tables is built using links to master-detail, primary and foreign keys.  Publish the reports to Power BI Service on the Cloud.  Build Dashboards to present a summary of your information to the users. 

Who this course is for:
  • IT and Business Managers interested to analyze data in Sales and Inventory.
Course content
Expand all 12 lectures 03:17:55
+ Introduction to Power BI. Visualizations, Charts, Desktop, Cloud
1 lecture 16:03

-Power BI Desktop and Service. 
-Publish Reports and Dashboards within organization on the Internet.
-Reports and Dashboards Charts in Power BI.   
-Download the attached Excel file, powerbicourse01.xlsx to practice the course exercises.



     

Preview 16:03
+ Data Sources: Excel, Databases and BI cubes. Visual charts and publishing on the
1 lecture 17:48

Data Sources: Excel, Databases and BI cubes. Visual charts and publishing on the Internet.

     

Data Sources: Excel, Databases and BI cubes. Visual charts and publishing on the
17:48
+ Sales Quantity and Total Invoiced in money using Combined Charts. Analyze the
1 lecture 15:35

Sales Quantity and Total Invoiced in money using Combined Charts.   Analyze the product with clients, dates and stores.



     

Sales Quantity and Total Invoiced in money using Combined Charts. Analyze the
15:35
+ Top N filters to get the best and worst sales products, clients and stores.
1 lecture 16:02

Top N filters to get the best and worst sales products, clients and stores.



     

Top N filters to get the best and worst sales products, clients and stores.
16:02
+ Data segmentation to present different results on a Sales-Product Chart to view
1 lecture 16:24

Data segmentation to present different results on a Sales-Product Chart to view to focus in details.



     

Data segmentation to present different results on a Sales-Product Chart to view
16:24
+ Add a calculated column to the data model. Tables and Matrix Visualizations
1 lecture 16:33

-Tables and matrix display of Sales per Product and Client.
   - Add a calculated column to the model.  Multiply Quantity and Cost to get Total Invoice.  Get the Revenue from Quantity, Cost and Sale Price.



     

Add calculated column. Display data with tables and matrix.
16:33
+ Geo reference locations and Dispersion Charts to compare quantity and money
1 lecture 19:08

-Geo reference locations of Stores and Products to visually display results on a map.
-Dispersion charts to see the sales results in bubbles chart.



     

Geo reference locations and Dispersion Charts to compare quantity and money
19:08
+ Waterfall charts.Change of sales and Purchase Orders along time
1 lecture 16:42

Waterfall charts to see the change of sales in time and by different locations.

     Waterfall charts to analyze the Purchase Order to stock Inventory during a period of time.     

Waterfall charts.Change of sales and Purchase Orders along time
16:42
+ Funnel charts
1 lecture 15:28

Funnel charts to analyze the contribution of Product Sales per Store and Client.



     

Funnel charts
15:28
+ Grouping display. Click on a variable Chart to display details in another.
1 lecture 15:37

Grouping display to click on a particular PRODUCT to display the details of Sales and Store in another Chart.
      Analyze product cost per Provider to optimize the Inventory Purchase Orders.
       Date hierarchies to explore Sales per Quarter, Month and Year. 



     

Grouping display. Click on a variable Chart to display details in another.
15:37