Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Microsoft Power BI

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.
Rating: 4.3 out of 54.3 (26 ratings)
628 students
Created by VR eLearning
Last updated 4/2020
English
30-Day Money-Back Guarantee

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

13 sections • 60 lectures • 3h 56m total length

  • Preview03:48

  • Regarding the Warm-Up
    00:12
  • Downloadable resources for the Warm-Up exercise
    00:06
  • Preview06:57
  • Add the Pulse Chart Visual
    07:06
  • Your Warm-Up challenge
    00:11
  • Power BI Pulse Chart
    1 question
  • Further Note
    00:18

  • Power BI Settings
    01:01
  • Get Data From Excel Files
    00:47
  • How to get the course certificate of completion.
    00:39

  • 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
  • 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

  • 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

  • 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

  • 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
  • Preview04:29
  • Fixing the blank column in Power BI.
    10:01

  • 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

  • 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

  • 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

Instructor

VR eLearning
Business Intelligence and online business course creator
VR eLearning
  • 4.3 Instructor Rating
  • 26 Reviews
  • 20,219 Students
  • 1 Course

VR eLearning provides affordable online training to students, across 130 countries.

Our courses are mainly about business intelligence and new business ventures.

Power BI Business Intelligence.

Microsoft Power BI Online Courses.


Our greatest goal is to see you succeed in your business ventures.


Qualifications:

CIMA |  CGMA member

Chartered Institute of Management Accountants.

See you in our next course :)

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.