What you'll learn

Know what Power BI is and how to efficiently navigate and interact with its tools and functions
Know how to enter and import data
Know how to visualise data in a quick and easy manner
Know how to build a dashboard

Course content

5 sections • 17 lectures • 1h 59m total length

Lesson 1 - Getting Started6:47
You will learn about:
How Power BI is laid out
Features and tools to use within various tabs and panes
3 primary views each serving a specific user purpose
Basic navigation and user interactions to get familiar with the layout
Power BI User Interface

Lesson 2 - Entering Data5:55
You will learn about:
How to create a basic dataset
How to create a basic table visual
Lesson 3 - Formatting of Table Visual3:46
You will learn about how to adjust the font, size and colour formats of the table visual.
Lesson 4 - Importing Excel data7:58
You will learn about:
How to import data from excel
How to use the imported data to build a column chart
Lesson 5 - Table View and Model View5:52
You will learn about:
What the Table View and Model View is respectively
When to use these two views
Lesson 6 - Refreshing the dataset5:06
You will learn about:
Why refreshing the dataset is important
How to update your visuals if there are changes made to the dataset
When to manage the refreshing of the dataset
Lesson 7 - Changing data sources5:58
You will learn about:
What happens to your visual if its data source changes
How to rectify data source errors due to a change in its source
Power BI Basics

Lesson 10 - Introduction to Data Analysis Expressions (DAX)2:59
You will learn about what Data Analysis Expressions (DAX) is and why it should be used
Lesson 11 - Creating a new Column9:54
You will learn how to create a Column calculation using a fictitious dataset on Product Sales
Lesson 12 - Creating a new Measure6:03
You will learn how to create a Measure calculation using a fictitious dataset on Product Sales
Manipulating Data

Lesson 13 - Introduction to Dashboards6:27
You will learn about what dashboards are and what to consider when building one
Lesson 14 - Net Profit Margin and Cost Revenue Ratio Charts14:51
You will learn about how to start building a dashboard efficiently making specific use of the format painter to lessen the time spent in making format changes using a fictitious dataset on Product Sales
Lesson 15 - Revenue and Units Produced vs Sold charts11:01
You will continue with building your dashboard making use of the page duplication capability to prevent the effort needed to create visuals from scratch using a fictitious dataset on Product Sales
Lesson 16 - Dashboard Completion and Course Conclusion5:52
You will complete the build of your dashboard using a fictitious dataset on Product Sales and recap the learning journey to conclude this course
Dashboards
Bonus Lecture0:35

Requirements

Works with Microsoft Excel
Must have the Power BI Desktop application installed on PC
No Power BI experience needed. This course covers everything you need to know for you to begin using Power BI proficiently

Description

Welcome to Introduction to Microsoft Power BI!

If you have zero or very little experience and is interested in learning Power BI from scratch then you have found the right course!

In this course, you will have the opportunity to learn Power BI in a structured and simple manner getting a solid understanding on the basics through to advanced concepts leaving you with a level of proficiency that allows you to work with Power BI independently.

This course aims to deliver three main Learning Concepts, namely:

Theory - You will learn about Power BI's user interface and how to perform basic navigation.
Engagement - You will learn and engage with the different tools and functions in Power BI.
Application - You will become proficient in knowing how to apply knowledge and teachings learned.

By the end of this course, you will know:

What Power BI is and how to efficiently navigate and interact with its tools and functions
What the different tools and functions are and how they can be used
How to enter and import data to create visualisations
How to build dashboards efficiently

My name is Suhail Gangaram and I will be your teacher for this course.

I look forward to learning with you in your Power BI journey. Good luck!

Who this course is for:

For people who have zero or very little experience with Power BI
For anyone working with data
For anyone wanting to improve the way they present and deliver valuable insights

What you'll learn

Explore related topics

Course content

Getting Started1 lecture • 7min

Power BI Basics6 lectures • 35min

Transforming Data2 lectures • 21min

Manipulating Data3 lectures • 19min

Dashboards5 lectures • 39min

Requirements

Description

Who this course is for: