Power BI

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.

Sign up to
preview the program
for FREE!

Create a free account and start learning data science today.

create free account
Our graduates work at exciting places:
walmart
tesla
paypal
citibank
booking.com

Section 1

Power BI Overview

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.

FREE Introduction to Power BI
FREE Power BI Desktop vs Power BI Pro 15.10.19
FREE Power BI data sources

Section 2

Power BI Setup

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.

FREE Power BI for MAC
FREE Install Power BI

Section 3

Connecting to data sources

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.

FREE The Query Editor
FREE Import vs DirectQuery
FREE Importing Data from Excel Files
FREE First Data Model
FREE Active vs Inactive Relationships
FREE Entering Data Manually
FREE Roles
FREE Refreshing Data
Show all lessons
FREE Hierarchies
FREE Ask a Question
Show fewer lessons

Section 4

Task three

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.

FREE Part 1
FREE Part 2

Section 5

Data Modelling

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.

Premium course icon DAX
Premium course icon Calculated Columns
Premium course icon Measures
Premium course icon Star Schema
Premium course icon Snowflake Schema
Premium course icon Investigating Filter Flow
Premium course icon Related vs Relatedtable
Premium course icon Bi-directional Cross-filtering
Show all lessons
Premium course icon CALCULATE
Premium course icon Time Intelligence
Premium course icon ALL
Premium course icon FILTER
Premium course icon Iterators
Premium course icon Logical Operators
Premium course icon SWITCH
Premium course icon Text Functions
Show fewer lessons

Section 6

Task Four

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.

Premium course icon Part 1
Premium course icon Part 2
Premium course icon Part 3

Section 7

Creating Our First Data Visualization Report

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.

Premium course icon Report View
Premium course icon Slicers
Premium course icon Bar Chart
Premium course icon Bookmarks
Premium course icon Conditional Formatting
Premium course icon Field Formatting
Premium course icon Gauge Chart
Premium course icon Card Visuals
Show all lessons
Premium course icon Drillthrough
Premium course icon Filters
Premium course icon Map Vizuals
Premium course icon Custom Colors
Show fewer lessons

Section 8

Task Five

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.

Premium course icon Part 1
Premium course icon Part 2
Premium course icon Part 3
Premium course icon Part 4

Section 9

Task Six Final Project

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.

Premium course icon Part 1
Premium course icon Part 2
Premium course icon Part 3
Premium course icon Part 4
Premium course icon Part 5
Premium course icon Part 6
Premium course icon Part 7
Premium course icon Part 8
Show all lessons
Premium course icon Part 9
Premium course icon Part 10
Premium course icon Part 11
Premium course icon Part 12
Premium course icon Part 13
Premium course icon Part 14
Show fewer lessons

Section 10

Bonus - Power BI Service

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.

Premium course icon Power BI Service
Premium course icon Workspaces
MODULE 1

Data Science Fundamentals

This course is part of Module 1 of the 365 Data Science Program. The complete training consists of four modules, each building upon your knowledge from the previous one. Whereas the other three modules are designed to improve upon your technical skill set, Module 1 is designed to help you create a strong foundation for your data science career. You will understand the core principles of probability, statistics, and mathematics; you will also learn how to visualize your data.

See All Modules

Trust the other 450,000 students

Ready to start?
Sign up today for FREE!

Whether you want to scale your career or transition into a new field, data science is the number one skillset employers look for. Grow your analytics expertise and get hired as a data scientist!
×
Learn Data Science
this Summer!
Get 50% OFF