Udemy

Platform

English

Language

Data Science

Category

PowerBI Zero to Hero

A practical guide to building Dashboards with Power BI

4.49 (364 reviews)

Students

2.5 hours

Content

Jun 2021

Last Update
Regular Price

BLUE HOST
Blue Host
Fast, easy, and secure WordPress hosting in minutes + 1 free domain name
65%OFF : $2.95/month

What you will learn

Power bi

Business Intelligence

Data Visualisation

Dashboarding

Powerbi

DAX

Power Query

Data Modeling

BI

Data vizualisation


Description

Hello & Welcome to this Microsoft Power BI course. If you're trying to quickly master the most suitable tool for connecting, transforming, visualising, and analysing your Data, you are in the right place. We will take you from zero to hero, through our practical learning approach, and will quickly get you up running & building analytical solutions for your organisation.

My name is Abdelkarim M. MAHMOUD, and I am a Power BI certified Consultant. I have spent the last years empowering different type of organizations by helping them gain performance and competitivity through their Data. I had the chance and the pleasure to train dozens of teams from simple Power BI users to Chief Data Officers. I am here today to put all my expertise at your disposal in a simple and practical way.

This in-depth training strikes the perfect balance between theory and practice, several PowerBI use cases are covered to allow you to get the most value from your data. Here's what we're gonna dive into :


Introduction - What is Power BI ?

  • More reasons to use Power BI ESPECIALLY if you use excel

  • Resources & Course Structure

  • Quick tour & Interface overview


Chapter 1 - Extract, Load, and Transform Data in Power Query

  • Power Query, Connecting to a Database and Data Types

  • Filtering

  • Removing & Ordering Columns

  • Conditional Columns

  • Connecting to a folder as a Data Source

  • Combining Data

  • Dealing with less structured data

  • Fixing Errors


Chapter 2 - Data Modeling ?

  • Tables and Relationships

  • BEST PRACTICE : Dimensional Modeling & Star Schemas

  • BEST PRACTICE : Optimising The model for Development Time


Chapter 3 - DAX for Data Analysis Expressions

  • DAX, the “POWER” in POWER BI

  • Using Measures to create Calculations and KPIs

  • Comparing this year’s Value to last year’s value

  • Year over Year Varience, and Waterfall Charts

  • Year to Date with DAX


Chapter 4 - Data Vizualisation

  • Why Data Visualisation Really Matters

  • Pie Chart and Treemap

  • Hierarchies

  • Filtering and TopN

  • Dual-Axis (Combo) Chart

  • Advances Visual Analytics Pane - Trends, Targets, Forecasts and more

  • Artificial Intelligence: Decomposition Tree, Q&A and Key Influencers

  • Slicers

  • MAPS and Dynamic Coloring !

  • Fancy Tables


Chapter 5 - Power BI Service

  • Sharing and Collaboration in Power BI

  • How to Publish a report to the Power BI service

  • Deep Dive into the Power BI service


Screenshots

PowerBI Zero to Hero
PowerBI Zero to Hero
PowerBI Zero to Hero
PowerBI Zero to Hero

Content

Chapter 0 (Introduction)

Welcome, Hero !

What is Power BI ?

More reasons to use Power BI ESPECIALLY if you use excel

Resources & Course Structure

Quick tour & Interface overview

Chapter 01 - Extract, Load and Transform Data in Power Query

Power Query, Connecting to a Database and Data Types

Filtering

Removing & Ordering Columns

Conditional Columns

Connecting to a folder as a Data Source

Combining Data

Dealing with less structured data

Fixing Errors

Exercises Scenario & Resources

Exercise 01 - Import Data from Access Data Base

Exercise 02 - Import Data from a folder containing CSV files

Exercise 03 - Import a less structured Data from an Excel file

Exercises Solutions

Chapter 02 - Data Modeling

Data Modeling ?

Tables and Relationships

BEST PRACTICE : Dimensional Modeling & Star Schemas

BEST PRACTICE : Optimising The model for Development Time

Exercise

Exercise Solution

Chapter 03 - DAX for Data Analysis eXpressions

DAX, the “POWER” in POWER BI

Using Measures to create Calculations and KPIs

Comparing this year’s Value to last year’s value

Year over Year Varience, and Waterfall Charts

Year to Date with DAX

Exercises Scenario & Resources

Exercise 1 - Last year comparison

Exercise 2 - Year to Date

Exercise 3 - Market Share

Exercise 4 - Best Practices : Optimize the Data Model

Exercises Solution

Chapter 04 - Data Vizualisation

Why Data Visualisation Really Matters

Pie Chart and Treemap

Hierarchies

Filtering and TopN

Dual-Axis (Combo) Chart

Advances Visual Analytics Pane - Trends, Targets, Forecasts and more

Artificial Intelligence: Decomposition Tree, Q&A and Key Influencers

Slicers

MAPS and Dynamic Coloring !

Fancy Tables

Custom Formatting & Design tips

App Like User Experience & Navigation

Exercises Scenario & Resources

Exercice 1 - Cross Tabular Report

Exercise 2- Part-to-Whole Report

Exercise 3- Relationship Report

Exercise 4- Trend Report

Exercise 5- Rank Report

Exercise 6- Customise your report & Navigation

Exercices Solutions

Chapter 05 - Power BI Service

Sharing and Collaboration in Power BI

How to Publish a report to the Power BI service

Deep Dive into the Power BI service

Congratulations Hero!

Why Power BI is going to be huge


Reviews

S
Sumathi5 July 2021

this course was absolutely designed for beginner like me to kick start career in power bi. Thanks a lot !

A
Amzath24 June 2021

It is very interessing learning course. the lecturer is going through the different section easily and it is also quite easy to follow him.

D
Dikra21 June 2021

a well designed content, super understandable ! I've enjoyed learning POWERBI and it helped me in my certification !

K
Khulkarkhon14 June 2021

I'm really impressed by the lecturer's the way how easily he explains everything. I wish the best of luck!!! Thanks a lot!

S
Sitharamaiah9 June 2021

This course is very helpful to grow my carrer in data analytics. I recommend this course for every one who want to become from zero to hero.

X
Xi7 June 2021

The teacher is really talkative to tell our student how to do data sciences. He is humble to offer his knowledge. No too much awkward knowledge, it's really something that you can be handy to analyze your data. I love it.

D
Damián7 June 2021

I really loved this course. The classes are short, but contain a lot of useful information. There is also some practice, so you're not just absorbing information. Looking forward to learning more about Power BI.

N
Nadjia6 June 2021

I needed to learn how to use power Bi for a school project ,this course helped me learn easily , in a short period of time all the basics and have a good overview of power Bi. The instructor , definitely knows how to break-down complex topics into smaller and consumable chunks , i thank him for his easy and smart way of teaching. This definitely is one of the best courses to go to. I'd highly recommend it.

W
Waqas5 June 2021

I am really loving this course. Thanks dear. I would specially appreciate that your video qualify and your way of teaching is marvelous. Please confirm, will i get the certificate after the completion of this course to share on linkedin profile?

A
Abdelkader4 June 2021

This is the best course on Power BI I have encountered! He makes it really easy to understand such complex topics and it trains you as you go along so that once you're finished with the course you are confident enough to work on your own. I totally recommend this course to anyone who is interested in Power BI or Business Inteligence.

M
Mohand23 May 2021

What I like most about this course is that it didn't waste my time, the intructor goes straight to the point, I always appreciate this in online courses, thanks. Other than that, I think the production is great.


Coupons

DateDiscountStatus
6/4/2021100% OFFExpired
6/11/2021100% OFFExpired
7/9/2021100% OFFExpired

4054442

Udemy ID

5/16/2021

Course created date

5/24/2021

Course Indexed date
ANUBHAVJAIN
Course Submitted by