Power Bi Masterclass From Scratch In 180 Minutes

Learn how to use Microsoft Power BI Desktop, Power BI Services, Power BI Mobile in 180 Minutes

What you'll learn

You will learn how to build Reports and Dashboards with Power BI

You will be able to connect various data sources and visualize your data

You will be able to learn how to cleanse the data with Power Query Editor

You will be able to jump start your Power BI journey in 180 minutes

You will be able to learn all the available features in Power BI

You will be able to learn how to create the Data Modelling in Power BI

You will be able to learn how to create DAX functions in Power BI

You will be able to learn all the available default visuals in Power BI as well as custom visuals

You will be able to learn how to how to work with Power BI Service

You will be able to learn how to create a Report & Dashboard in 180 minutes

You will learn about Power BI Desktop, Power BI Online Services, Power BI Mobile

You will be able to learn all the Formatting options for visuals

Requirements

You need a computer

No Prior Experience Required

Some modules may require sign up via work or student email address

The only eligibility requirement is a genuine interest in learning Power BI

Description

Power BI Masterclass from Scratch in 180 MinutesWelcome to the Power BI Masterclass from Scratch in 180 Minutes! This course is designed for anyone looking to master Power BI quickly and efficiently. In just 180 minutes, you’ll gain a comprehensive understanding of Power BI's core features and become confident in using them to analyze and visualize data.Throughout the course, you will learn:Power Query Editor: Import, clean, and transform data to prepare it for analysis.Data Modeling: Understand how to create and manage relationships, tables, and data structures.DAX (Data Analysis Expressions): Master DAX to build powerful calculations and formulas.Visualizations: Learn to create and customize a variety of charts and visual elements to present your data effectively.Visual Formatting: Master visual formatting techniques to make your reports more interactive and visually appealing.Power BI Service: Learn how to publish, share, and collaborate on your reports using Power BI Service.Power BI Mobile: Explore how to access and interact with your reports on mobile devices for on-the-go insights.By the end of this course, you will be able to confidently create interactive reports, build data models, apply complex calculations, and share your work across platforms with ease.Whether you're a business analyst, data enthusiast, or someone looking to enhance their data visualization skills, this course will give you everything you need to get started with Power BI and take your data skills to the next level.

Overview

Section 1: Introduction

Lecture 1 Course Introduction

Lecture 2 About Power BI

Lecture 3 Setup the environment and settings update

Lecture 4 Power BI Desktop Walkthrough

Lecture 5 Resources

Section 2: Power Query Editor

Lecture 6 Get Data and Cleanse the Data with Power Query Editor

Section 3: Data Modeling

Lecture 7 How is data compressed in Power BI?

Lecture 8 Data Modeling

Section 4: Data Analysis Expressions (DAX)

Lecture 9 Creating a new table, column, and measure with DAX

Section 5: How to use all types of default charts in Power BI and custom visuals

Lecture 10 Canvas Settings & Visual Formatting

Lecture 11 Working with all types of charts

Lecture 12 How to find and resolve errors while working

Section 6: Hands-on experience with Power BI features

Lecture 13 Filters in Power BI (Basic & Advanced)

Lecture 14 Hierarchies in Power BI

Lecture 15 Drill Through in Power BI

Lecture 16 Edit Interactions in Power BI

Lecture 17 Bookmarks in Power BI

Lecture 18 Tooltips in Power BI (System & User defined)

Lecture 19 Sync Slicers in Power BI

Lecture 20 How to use measures in a slicer with field parameters in Power BI

Lecture 21 Conditional Formatting in Power BI

Lecture 22 Other options: Text box, buttons, shapes, images, visual interaction options

Section 7: Artificial Intelligence and Machine Learning features in Power BI

Lecture 23 Key Influencer

Lecture 24 Decomposition Tree

Lecture 25 Q&A

Lecture 26 Smart Narrative

Lecture 27 Column from Example

Section 8: Create a report with all the learnings

Lecture 28 Report Creation

Section 9: Power BI Service

Lecture 29 Creating a workspace and publishing a report to Power BI Service

Lecture 30 Creating a Dashboard in Power BI Service

Lecture 31 How to share Power BI reports in Power BI Service

Lecture 32 How to create an app in Power BI Service to share reports and dashboards

Lecture 33 Gateway & Schedule Refresh in Power BI Service

Section 10: Power BI Mobile

Lecture 34 How to use Power BI Mobile

Section 11: Course Exercise

Lecture 35 Exercise

Lecture 36 Thank You Note

Anyone who is interested in learning data visualization with Power BI