Power BI

with Dimitar Shutev

4.8/5

(1740)

Giving you the skills to create stunning dashboards using all Power BI features. Complete with practical tasks and real-life projects.

8 hours 76 lessons

Start course

76 High Quality Lessons

6 Practical Tasks

8 Hours of Content

Certificate of Achievement

Course Overview

The Power BI Course is designed for students who like to learn by doing. Packed with real-life business scenarios along with quizzes and projects to build, this course will give you the solid understanding required to jump start your career as a Power BI developer, business intelligence analyst, or a multiskilled data scientist. It will not only teach you how to create stunning dashboards but will also introduce you to data modelling and data transformations. You will learn how to write DAX, set up calculated columns and measures, generate roles, and, of course, share your dashboards with your team or clients. Power BI allows you to connect to hundreds of data sources and quickly analyze your data for free.

Topics covered

data analysisdata visualizationPowerbiTheory

What You'll Learn

You are interested in starting a career as a Power BI developer, business intelligence analyst, or data scientist? Start right away with the Power BI course and master your skills in creating dashboards, working with data models, and data transformations.

How the BI software functions

Visualize your data

Share insights across your organization

Connect to different data sources

Get familiar with DAX

Create a report

Curriculum

Power BI Overview Free

3 Lessons 7 Min

Power Bi is a business analytics solution that helps you visualize your data, share insights across your organization or embed them in your app or website. In this section, you will get more information about the Power BI software and how it functions. We will see what the differences between the Power BI versions are and which one suits our needs best.

Introduction to Power BI Free

Power BI Desktop vs Power BI Pro Free

Power BI data sources Free
Power BI Setup Free

3 Lessons 16 Min

In the second section, we will set up our Power BI in Windows. We will show alternative options for Mac users and how they can use Power BI completely free of charge for the next 12 months.

Power BI for MAC Free

Power BI for Mac Part 2 Free

How to Install Power BI Free
Connecting to data sources Free

12 Lessons 63 Min

In this section, we are going to investigate the query editor. We will discuss the differences between Import Mode and Direct Query. We’ll learn how to import data from an Excel file, launch Power Query, and how to use it for data transformations. Here, you’ll have the opportunity to build your first data model and examine the relationships available in Power BI. We’ll talk about Active vs Inactive relationships, and how to enter data inside Power BI using DAX code or the native Power BI interface. In addition, we’ll touch base on Role Level Security. We are going to see how data refreshes in Power Bi, whether it’s an SQL server, live connection or an import mode. We’ll explore hierarchies. And, finally, we’ll investigate Q&A inside Power BI by demonstrating how you can ask questions to your data to get some real answers in the form of lines and charts.

Introduction to Data Sources Free

The Query Editor Free

Import vs DirectQuery Free

Importing Data from Excel Files Free

Importing Data from Excel Files - Continued Free

First Data Model Free

Active vs Inactive Relationships Free

Entering Data Manually Free

Roles Free

Refreshing Data Free

Hierarchies Free

Ask a Question Free
Task three

2 Lessons 18 Min

This is our first mini project. In this task, you’ll be asked to create a model inside Power BI and create the following visuals: Sales Amount by Currency, Sales Amount by Month, and a Matrix table which will show us the Sales Amount per Email Address by Currency.

Task Three, Part 1

Task Three, Part 2
Data Modelling

18 Lessons 104 Min

This section will introduce DAX, the language Power BI uses for creating Measures and Calculated columns. We are going to learn the foundations, and then drill into some more sophisticated functions such as time-intelligence, iterators, CALCULATE, FILTERS, data-modelling and more. By the end of this section, you’ll feel confident using DAX language, and you will be able to transfer this knowledge into your own projects.

Introduction to Data Modeling

DAX

Calculated Columns

Measures

Star Schema

Snowflake Schema

Investigating Filter Flow

Related vs Relatedtable

Bi-directional Cross-filtering

Calculate

Time Intelligence, Part 1

Time Intelligence, Part 2

ALL

FILTER

Iterators

Logical Operators

Switch

Text Functions
Task Four

3 Lessons 26 Min

This is our second mini project! Here, we will emphasize using some of the DAX functions that we’ve learned earlier in section 4. Our goals will be to find the total sales for the USA as a number in percentage, to create a button that will switch between values, to change the countries’ order, and build a dynamic text box that changes based on the user’s selection.

Task Four, Part 1

Task Four, Part 2

Task Four, Part 3
Creating Our First Data Visualization Report

14 Lessons 98 Min

In this section, you will learn how to format charts in Power BI. We’re going to explore some of the most popular visualizations and show you how to give your reports the wow factor! This is the section that will take your report designing skills to the next level. We are going to kick things off with the report viewer, moving on to pie charts, tables, card visuals slicers, gauges, filters, maps, conditional formatting, and more! The section wraps up with a mini quiz and a task that will allow you to put your new knowledge into practice.

Introduction

Report View

Slicers

Bar Chart

Bookmarks

Conditional Formatting

Field Formatting

Gauge Chart

Card Visuals, Part 1

Card Visuals, Part 2

Drillthrough

Filters

Map Visuals

Custom Colors
Task Five

4 Lessons 20 Min

In this task, you will practice designing a dashboard that is both functional and aesthetically pleasing. The dashboard will contain: Header, Slicer with Colors to be placed inside, Measures table (using DAX), and other visuals.

Task Five, Part 1

Task Five, Part 2

Task Five, Part 3

Task Five, Part 4
Task Six Final Project

14 Lessons 99 Min

In our final project, you will implement all the knowledge you’ve gained in this course by building a dashboard for our sales team from scratch. The idea behind this dashboard is to create an overview where the user can get a better understanding of their sales, see the month-on-month performance, select a single currency, and see how this currency is performing compared to the others. Users will get to slice and dice between the following sections: Users, Currency and Sales Territory.

Final Project, Part 1

Final Project, Part 2

Final Project, Part 3

Final Project, Part 4

Final Project, Part 5

Final Project, Part 6

Final Project, Part 7

Final Project, Part 8

Final Project, Part 9

Final Project, Part 10

Final Project, Part 11

Final Project, Part 12

Final Project, Part 13

Final Project, Part 14
Bonus - Power BI Service

3 Lessons 13 Min

In the bonus lecture, you’ll have the opportunity to see how to sign up for the Power Bi service and how to use it for free for the next 60 days. We’ll dive into the features of the service, check out its workspaces, and see how we can use them.

Announcement

Power BI Service

Workspaces

Student feedback

4.8/5

1740 ratings

5 stars

1453 (84%)

4 stars

201 (12%)

3 stars

61 (4%)

2 stars

14 (1%)

1 star

11 (1%)

Alessandro Marota

22.03.2023

The course feels a little outdated. Also, some sections have been moved around without considering the impact on references in the actual videos, which is confusing. In terms of the lessons themselves, I appreciated the hands-on approach, however I feel that too much time was spent on explaining basic features of the interface (text and color edits for example), while not enough time was dedicated to a more comprehensive explanation of often complex concepts relating to the DAX formulas. More background informarmation on why these work the way they do would have been veluable for learning. In fact, i found myself resorting to additional online resoufrces quite often in sections 2 to 6, so that I could properly grasp the formulas explained there.

MADHAV KARUN

20.06.2023

topics are explained in complicated way.i also feel videos are not in order.complicated parts are explained earlier then introduction parts are explained later.resources are missing at some videos,which makes learning boring when you are unable to practice along with video. At times i feel choice of words in certain situation brings barrier between explaination and understanding.

Krsto Arsenijevic

24.12.2022

This is one of, if not the worst course in the "Data Science Fundamentals" library. The audio quality is very low, it was hard to understand at multiple situations. The course itself doesn't cover fundamentals and feels very advanced at times. Most of the learnings steps are scattered and my overall impression is that it's disorganized. I expected more.

István Bóka

02.12.2022

I'm a little bit skeptical that Task Four could be completed with the learning materials so far. Seems to me that a few aspects was skipped (e.g. creating a var) With some googling I was able to catch up, but I think the content could be extended for newbies to PowerBI (or mention a prerequisite for this Course)

Ashakah Onome Andrew

28.07.2022

For a beginner like myself. It wasn't easy to just comprehend those formulas. He didn't properly introduce or give us a reason why we will really need those formulas. Especially when we are tasked with a different scenario. My question is, i don't know if the formulas are the same approach for any task.

“This course will give you the solid understanding of Power BI required to boost your career opportunities. You will not only learn how to create stunning dashboards, but you will also get familiar with data modelling, data transformations, writing DAX, setting up calculated columns and measures, generating roles, and, of course, sharing your dashboards with your team or clients.”

Dimitar Shutev

Worked at Amadeus, DXC Technology