HOT

PowerBI Zero to Hero

Development

Rating4.5
Enroll Now

PowerBI Zero to Hero, available at $69.99, has an average rating of 4.45, with 59 lectures, based on 5848 reviews, and has 58676 subscribers.

You will learn about Power bi Business Intelligence Data Visualisation Dashboarding Powerbi DAX Power Query Data Modeling BI Data vizualisation This course is ideal for individuals who are Excel users wishing to switch to Power BI or interested by a more powerful tool or Business and data analysts or CXO or Young managers, future managers and MBA students or people looking to start or to switch to a data career It is particularly useful for Excel users wishing to switch to Power BI or interested by a more powerful tool or Business and data analysts or CXO or Young managers, future managers and MBA students or people looking to start or to switch to a data career.

Enroll now: PowerBI Zero to Hero

Summary

Title: PowerBI Zero to Hero

Price: $69.99

Average Rating: 4.45

Number of Lectures: 59

Number of Published Lectures: 59

Number of Curriculum Items: 59

Number of Published Curriculum Objects: 59

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

  • Power bi
  • Business Intelligence
  • Data Visualisation
  • Dashboarding
  • Powerbi
  • DAX
  • Power Query
  • Data Modeling
  • BI
  • Data vizualisation

Who Should Attend

  • Excel users wishing to switch to Power BI or interested by a more powerful tool
  • Business and data analysts
  • CXO
  • Young managers, future managers and MBA students
  • people looking to start or to switch to a data career

Target Audiences

  • Excel users wishing to switch to Power BI or interested by a more powerful tool
  • Business and data analysts
  • CXO
  • Young managers, future managers and MBA students
  • people looking to start or to switch to a data career

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

Course Curriculum

Chapter 1: Chapter 0 (Introduction)

Lecture 1: Welcome, Hero !

Lecture 2: What is Power BI ?

Lecture 3: More reasons to use Power BI ESPECIALLY if you use excel

Lecture 4: Resources & Course Structure

Lecture 5: Quick tour & Interface overview

Chapter 2: Chapter 01 – Extract, Load and Transform Data in Power Query

Lecture 1: Power Query, Connecting to a Database and Data Types

Lecture 2: Filtering

Lecture 3: Removing & Ordering Columns

Lecture 4: Conditional Columns

Lecture 5: Connecting to a folder as a Data Source

Lecture 6: Combining Data

Lecture 7: Dealing with less structured data

Lecture 8: Fixing Errors

Lecture 9: Exercises Scenario & Resources

Lecture 10: Exercise 01 – Import Data from Access Data Base

Lecture 11: Exercise 02 – Import Data from a folder containing CSV files

Lecture 12: Exercise 03 – Import a less structured Data from an Excel file

Lecture 13: Exercises Solutions

Chapter 3: Chapter 02 – Data Modeling

Lecture 1: Data Modeling ?

Lecture 2: Tables and Relationships

Lecture 3: BEST PRACTICE : Dimensional Modeling & Star Schemas

Lecture 4: BEST PRACTICE : Optimising The model for Development Time

Lecture 5: Exercise

Lecture 6: Exercise Solution

Chapter 4: Chapter 03 – DAX for Data Analysis eXpressions

Lecture 1: DAX, the “POWER” in POWER BI

Lecture 2: Using Measures to create Calculations and KPIs

Lecture 3: Comparing this year’s Value to last year’s value

Lecture 4: Year over Year Varience, and Waterfall Charts

Lecture 5: Year to Date with DAX

Lecture 6: Exercises Scenario & Resources

Lecture 7: Exercise 1 – Last year comparison

Lecture 8: Exercise 2 – Year to Date

Lecture 9: Exercise 3 – Market Share

Lecture 10: Exercise 4 – Best Practices : Optimize the Data Model

Lecture 11: Exercises Solution

Chapter 5: Chapter 04 – Data Vizualisation

Lecture 1: Why Data Visualisation Really Matters

Lecture 2: Pie Chart and Treemap

Lecture 3: Hierarchies

Lecture 4: Filtering and TopN

Lecture 5: Dual-Axis (Combo) Chart

Lecture 6: Advances Visual Analytics Pane – Trends, Targets, Forecasts and more

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

Lecture 8: Slicers

Lecture 9: MAPS and Dynamic Coloring !

Lecture 10: Fancy Tables

Lecture 11: Custom Formatting & Design tips

Lecture 12: App Like User Experience & Navigation

Lecture 13: Exercises Scenario & Resources

Lecture 14: Exercice 1 – Cross Tabular Report

Lecture 15: Exercise 2- Part-to-Whole Report

Lecture 16: Exercise 3- Relationship Report

Lecture 17: Exercise 4- Trend Report

Lecture 18: Exercise 5- Rank Report

Lecture 19: Exercise 6- Customise your report & Navigation

Lecture 20: Exercices Solutions

Chapter 6: Chapter 05 – Power BI Service

Lecture 1: Sharing and Collaboration in Power BI

Lecture 2: How to Publish a report to the Power BI service

Lecture 3: Deep Dive into the Power BI service

Chapter 7: Congratulations Hero!

Lecture 1: Why Power BI is going to be huge

Instructors

Rating Distribution

  • 1 stars: 40 votes
  • 2 stars: 76 votes
  • 3 stars: 595 votes
  • 4 stars: 2319 votes
  • 5 stars: 2840 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Content Creation with ChatGPT + AI Tools

Blogging For Beginners: Start, Grow and Monetize (Sinhala)

(NEW) The Complete Growth Hacking & Conversion Course