3.7 out of 5
3.7
24 reviews on Udemy

Masterclass to Build Power BI Dashboards with Case Study

Master fundamental skills of Power BI.Build and share dashboards with real life case study.Free Microsoft 365 license.
Instructor:
Bing Yu
53 students enrolled
English [Auto]
End to end professional dashboard development with Power BI Desktop
Data processing
Data loading with different scenarios
Data transformation with Power Query Editor
Data model creation
Build visualisations from desktop app and from Power BI marketplace
Theme customisation
Dashboard buttons with web URL and actions
Bookmark
Dashboard export
Real life case study
Microsoft 365 free license application
Power BI best practices

This course features the latest Power BI Desktop so rest assured that you are going to learn about the most up-to-date features of Power BI Desktop as well as how to publish your sophisticated dashboards into Power BI cloud-based online services in order to share with colleagues and other users via Email, URL link, Microsoft Teams, SharePoint, PowerPoint and create embedded code to publish your dashboards into your website.

You’ll immediately get your return on investment from budget point of view as I’ll teach you step by step how to apply for a Microsoft free license which gives you free access to not only Power BI Pro features but also other wide range of Microsoft solutions such as Power Apps, Power Automate, Power Virtual Agents, Teams, SharePoint and many more.

Instead of purely lecturing all the functionalities of Power BI like other courses, I’m combining lectures with practices (case study) so you’ll have first-hand learning and applying experience.

At the end of the course, you’ll be able to build on your own beautifully-designed, professional-looking and report-ready dashboards if you follow the steps in my course. You’ll be able to leverage what you’ve learned in your real-life business or personal contexts.

Throughout my course, you’ll be able to learn and apply:

Load data

  • Load data with different formats

  • Load data in one file one sheet

  • Load data in one file multiple sheets

  • Load data in multiple files and multiple sheets

Transform data

  • Cleanse and standardise source data in power query editor

  • Add additional data fields

  • Change data types

  • Format data

Build data model

  • build one single data model with multiple tables

  • build separate data models

Create visualisations

  • Build different chart types from built-in charts

  • Access and use customised charts from Power BI marketplace

  • DAX

  • Format

  • Filters

  • Analytics function

Build dashboards

  • Canvas layout design

  • Cover page creation

  • Buttons with linked functions and URLs

  • Bookmarks

  • Customise theme

  • Dashboard export

  • Top tips

Publish and share

  • Publish dashboards from Power BI desktop to Power BI Cloud-based Online Service

  • Share dashboards via email and manage user access

  • Share dashboards via Microsoft Teams

  • Share dashboards via URL links

  • Share dashboards via embedded codes and publish in your websites

  • Share dashboards via automated PowerPoint Templates

  • Find and recycle published apps from other users

So how does this sound to you? I look forward to welcoming you in my course.

Cheers,

Bing

Course Overview and Bonus Lecture

1
Greetings and Course Overview
2
Bonus Lecture: Microsoft 365 Free Account Setup for Power BI License

With this bonus lecture, you'll learn how to install Power BI Desktop and apply for a free Microsoft 365 account which will give you access to Power BI Pro features.

Load Data with Multiple Business Scenarios

1
Load Data with Multiple Business Scenarios

Make sure to download and save the 6 monthly sales files from January to June 2020 in one folder and save "Gross margin Jan-Feb 2020" and "Sales Jan-Feb 2020" files in a separate folder.

These files will be used as examples to be loaded in Power BI Desktop.

Transform Data with Power Query Editor

1
Royal Cafe Case Study Briefing

This is a case study you'll work on for the rest of the course. Please download the data sources from next lecture and get ready to use them in the next lessons.

2
Transform Data with Power Query Editor

Make sure to download and save the 3 Royal Cafe files in one folder.

Build Data Model

1
Build Data Model

Visualise Data with Different Charts

1
Create Different Types of Visuals

Build and Refine Your Dashboards

1
Refine Your Dashboards Step-by-Step Part 1
2
Refine Your Dashboards Step-by-Step Part 2

Publish and Share Dashboards in Power BI Cloud

1
Publish and Share Dashboards with Power BI Cloud-Based Online Services

In this lesson, you will learn:

  • Publish dashboards from Power BI desktop to Power BI Cloud-based Online Service

  • Share dashboards via email and manage user access

  • Share dashboards via Microsoft Teams

  • Share dashboards via URL links

  • Share dashboards via embedded codes and publish in your websites

  • Share dashboards via automated PowerPoint Templates

  • Find and recycle published apps from other users

Course Summary

1
Course Summary
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!
3.7
3.7 out of 5
24 Ratings

Detailed Rating

Stars 5
15
Stars 4
3
Stars 3
6
Stars 2
0
Stars 1
0
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Masterclass to Build Power BI Dashboards with Case Study
Price:
$98.98 $79

Community

For Professionals

For Businesses

We support Sales, Marketing, Account Management and CX professionals. Learn new skills. Share your expertise. Connect with experts. Get inspired.

Community

Partnership Opportunities

Layer 1
samcx.com
Logo
Register New Account
Compare items
  • Total (0)
Compare
0