This course features the latest Power BI Desktop (version: 2.84.981.0, released on 28 Aug 2020) so rest assured that you are going to learn about the most up-to-date features of Power BI Desktop.

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 access to not only Power BI Pro features but also other wide range of Microsoft solutions.

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

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

Cheers,

Bing

Who this course is for:
Anyone who has 0 to intermediate level knowledge about Power BI
Advanced Power BI users who'd like to practice with real life case study and to learn best practice of building professional looking dashboard

What you'll learn
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