The Complete Power Bi Practical Course 2023

Power BI: Jump start your career as Power BI developer

What you'll learn

How to create data models inside Power BI

Get a good solid understanding of DAX

How to build beautiful and interactive dashboards that can be presented to clients

How to shape your data to meet the needs of the business

Get a full exposure of the dashboard creation and sharing process

Learn how to manipulate data using Power Query

Understand the fundamentals of dashboard design, no more boring dashboards

Students will learn how to work with Power BI independently

How to translate complex business logic into DAX expressions

Clear and easy to follow, step by step approach in each lesson

1 to 1 support using the Q&A feature

Create, style and format popular visuals such as Pie chart, Table chart, Trend line

Requirements

A computer, both Windows and Mac users are welcome

Description

Course content FULLY UPDATED JUNE 2022!Do you want to learn how to work with Microsoft Power BI?Are you a beginner looking to become а proficient Power BI user?If so, congratulations, as you have come to the right place!This is a complete course that consists of four parts building on each other:1. Power Query2. Data modeling3. DAX expressions4. Building visually-pleasing and practical reports in Power BIIn the process, you will learn how to apply a number of best practices the course author has learned on the job while working for some of the largest companies in the world.Everyone wants to create a beautiful dashboard. But only few people are able to do so because it isn't an easy task.By taking this course, you will learn how to:Manipulate data with Power QueryTranslate complex business logic into DAX expressionsCreate data models inside Power BIUnderstand the fundamentals of dashboard designBuild beautiful and interactive dashboards that can be presented to clientsAll of this is shown step-by-step in a beginner-friendly manner.This course is designed for students who like to learn by doing. It contains over 15 hours of content, packed with real-life business scenarios along with quizzes and projects that allow you to apply what you have learned in practice. By completing the course you will acquire a solid understanding and will be able to jumpstart your career as Power BI developer. We will not only teach you how to create stunning dashboards, but we will also introduce you to data modelling, data transformations, teach you 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 analyse your data for free. And, although Power BI desktop may not be available for Mac, this course will show you an easy solution that allows you to use Power BI desktop on your Mac for free for the next 12 months! This course is suitable for complete beginners, intermediate and advanced users, as we’ll guide you every step of your journey with easy to understand explanations.So, what are you waiting for?Click 'Buy now' and start your Power BI journey today!

Overview

Section 1: What Does the Course Cover?

Lecture 1 What Does the Course Cover?

Lecture 2 How to Use This Course

Section 2: Power BI Overview

Lecture 3 Introduction to Power BI

Lecture 4 Power BI Desktop vs Power BI Pro

Lecture 5 Power BI Data Sources

Section 3: Power BI Setup

Lecture 6 Power BI for MAC

Lecture 7 Power BI for Mac Part 2

Lecture 8 How to Install Power BI

Section 4: Course Resources

Lecture 9 Download Course V2 Files

Section 5: Power Query

Lecture 10 What is Power Query?

Lecture 11 Importing Data

Lecture 12 Data Types

Lecture 13 Replacing Values

Lecture 14 Merge Columns

Lecture 15 Extract Values

Lecture 16 Remove Duplicates

Lecture 17 Remove Columns

Lecture 18 Filters

Lecture 19 Date Functions

Lecture 20 Conditional Columns

Lecture 21 Unpivot

Lecture 22 Merge Queries

Lecture 23 Parameters

Lecture 24 Query Properties

Lecture 25 Data Profiling

Lecture 26 Web Scraping

Lecture 27 Mathematical Functions

Section 6: Test your knowledge - Power Query

Section 7: Data Modeling

Lecture 28 Data Modeling

Lecture 29 Relationships

Lecture 30 Role Level Security

Section 8: Practical Task One

Lecture 31 Lecture One

Section 9: DAX Expressions

Lecture 32 What is DAX?

Lecture 33 Calculated Columns

Lecture 34 Calendar Table

Lecture 35 Building a Measure

Lecture 36 Measures Table

Lecture 37 CALCULATE

Lecture 38 FILTER vs KEEPFILTERS

Lecture 39 Iterators

Lecture 40 RELATED vs RELATEDTABLE

Lecture 41 SELECTEDVALUE

Lecture 42 DIVIDE

Lecture 43 Logical Operators

Lecture 44 Variables

Lecture 45 TREATAS

Lecture 46 SWITCH

Lecture 47 Text Functions

Lecture 48 CONCATENATEX

Lecture 49 Time Intelligence

Lecture 50 Expression Based Titles

Lecture 51 Tabular Editor

Lecture 52 Calculation Groups

Section 10: Test your knowledge - DAX

Section 11: Practical Task Two

Lecture 53 Practical Task Two - DAX

Section 12: Building Reports

Lecture 54 Building Reports Intro

Lecture 55 Power BI Canvas

Lecture 56 Drawing Shapes

Lecture 57 Slicers

Lecture 58 Filled Map

Lecture 59 Matrix Table

Lecture 60 Donut Chart

Lecture 61 Interactive Tooltip

Lecture 62 Gauge Visual

Lecture 63 KPI Visual

Lecture 64 Card Visual

Lecture 65 Area Chart

Lecture 66 Bookmarks

Lecture 67 Format Painter

Lecture 68 Stacked Column Chart

Section 13: Test your knowledge - Building Reports

Section 14: Practical Task Three

Lecture 69 Practical Task Three - Building Reports

Section 15: Power BI Service

Lecture 70 Power BI Licensing

Lecture 71 Power BI Service

Lecture 72 Azure Sign Up

Lecture 73 Power BI Service Sign Up

Lecture 74 Power BI Service Walkthrough

Lecture 75 Upload Power BI Reports

Lecture 76 Scheduled Refresh

Lecture 77 Creating a SQL Database

Lecture 78 Connecting to a SQL Database

Lecture 79 Connecting to a Live Dataset

Lecture 80 ALM Toolkit

Section 16: 2020 Course Version

Lecture 81 Section info & Download Resources

Section 17: Connecting to Data Sources

Lecture 82 Introduction to Data Sources

Lecture 83 The Query Editor

Lecture 84 Import vs DirectQuery

Lecture 85 Importing Data from Excel Files

Lecture 86 Importing Data from Excel Files - Continued

Lecture 87 Data Modeling Explained & Key Concepts

Lecture 88 First Data Model

Lecture 89 Active vs Inactive Relationships

Lecture 90 Entering Data Manually

Lecture 91 Roles

Lecture 92 Refreshing Data

Lecture 93 Hierarchies

Lecture 94 Ask a Question

Section 18: Practical Task Three

Lecture 95 Task Three

Lecture 96 Task Three, Part 1

Lecture 97 Task Three, Part 2

Section 19: Data Modelling

Lecture 98 Introduction to Data Modelling

Lecture 99 DAX

Lecture 100 Calculated Columns

Lecture 101 Measures

Lecture 102 The Star Schema

Lecture 103 The Snowflake Schema

Lecture 104 Investigating the Filter Flow

Lecture 105 Related vs Relatedtable

Lecture 106 Bi-directional Cross-filtering

Lecture 107 Calculate

Lecture 108 Time Intelligence, Part 1

Lecture 109 Time Intelligence, Part 2

Lecture 110 All

Lecture 111 Filter

Lecture 112 Iterators

Lecture 113 Logical operators

Lecture 114 Switch

Lecture 115 Text Functions

Lecture 116 CONCATENATEX

Lecture 117 Expression Based Titles

Section 20: Practical Task Four

Lecture 118 Task Four

Lecture 119 Task Four, Part 1

Lecture 120 Task Four, Part 2

Lecture 121 Task Four, Part 3

Section 21: Creating Our First Data Visualization Report

Lecture 122 Introduction

Lecture 123 Report View

Lecture 124 Slicers

Lecture 125 Bar Chart

Lecture 126 Bookmarks

Lecture 127 Conditional Formatting

Lecture 128 Field Formatting

Lecture 129 Gauge Chart

Lecture 130 Card Visuals Part 1

Lecture 131 Card Visuals Part 2

Lecture 132 Drillthrough

Lecture 133 Filters

Lecture 134 Map Vizuals

Lecture 135 Custom Colors

Section 22: Practical Task Five

Lecture 136 Task Five

Lecture 137 Task Five, Part 1

Lecture 138 Task Five, Part 2

Lecture 139 Task Five, Part 3

Lecture 140 Task Five, Part 4

Section 23: Practical Task Six, Final Project

Lecture 141 Task Six

Lecture 142 Final Project, Part 1

Lecture 143 Final Project, Part 2

Lecture 144 Final Project, Part 3

Lecture 145 Final Project, Part 4

Lecture 146 Final Project, Part 5

Lecture 147 Final Project, Part 6

Lecture 148 Final Project, Part 7

Lecture 149 Final Project, Part 8

Lecture 150 Final Project, Part 9

Lecture 151 Final Project, Part 10

Lecture 152 Final Project, Part 11

Lecture 153 Final Project, Part 12

Lecture 154 Final Project, Part 13

Lecture 155 Final Project, Part 14

Section 24: Bonus Lectures: Power BI Service

Lecture 156 Important Announcement for students without access to work or school email

Lecture 157 Power BI Service

Lecture 158 Workspaces

Power BI beginners,Power BI advanced users,People interested in a career in business intelligence,Business organisations transitioning from other BI tools into Power BI