PowerBI Zero to Hero

A practical guide to building Dashboards with Power BI
PowerBI Zero to Hero
File Size :
2.57 GB
Total length :
2h 29m

Category

Instructor

Abdelkarim MOHAMED MAHMOUD

Language

Last update

11/2021

Ratings

4.3/5

PowerBI Zero to Hero

What you’ll learn

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

PowerBI Zero to Hero

Requirements

Familiarity with Microsoft Excel or Google Sheets

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 excelResources & Course StructureQuick tour & Interface overviewChapter 1 – Extract, Load, and Transform Data in Power QueryPower Query, Connecting to a Database and Data TypesFilteringRemoving & Ordering ColumnsConditional ColumnsConnecting to a folder as a Data SourceCombining DataDealing with less structured dataFixing ErrorsChapter 2 – Data Modeling ?Tables and RelationshipsBEST PRACTICE : Dimensional Modeling & Star SchemasBEST PRACTICE : Optimising The model for Development TimeChapter 3 – DAX for Data Analysis ExpressionsDAX, the “POWER” in POWER BIUsing Measures to create Calculations and KPIsComparing this year’s Value to last year’s valueYear over Year Varience, and Waterfall ChartsYear to Date with DAXChapter 4 – Data VizualisationWhy Data Visualisation Really MattersPie Chart and TreemapHierarchiesFiltering and TopNDual-Axis (Combo) ChartAdvances Visual Analytics Pane – Trends, Targets, Forecasts and moreArtificial Intelligence: Decomposition Tree, Q&A and Key InfluencersSlicersMAPS and Dynamic Coloring !Fancy TablesChapter 5 – Power BI ServiceSharing and Collaboration in Power BIHow to Publish a report to the Power BI serviceDeep Dive into the Power BI service

Overview

Section 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

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

Lecture 6 Power Query, Connecting to a Database and Data Types

Lecture 7 Filtering

Lecture 8 Removing & Ordering Columns

Lecture 9 Conditional Columns

Lecture 10 Connecting to a folder as a Data Source

Lecture 11 Combining Data

Lecture 12 Dealing with less structured data

Lecture 13 Fixing Errors

Lecture 14 Exercises Scenario & Resources

Lecture 15 Exercise 01 – Import Data from Access Data Base

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

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

Lecture 18 Exercises Solutions

Section 3: Chapter 02 – Data Modeling

Lecture 19 Data Modeling ?

Lecture 20 Tables and Relationships

Lecture 21 BEST PRACTICE : Dimensional Modeling & Star Schemas

Lecture 22 BEST PRACTICE : Optimising The model for Development Time

Lecture 23 Exercise

Lecture 24 Exercise Solution

Section 4: Chapter 03 – DAX for Data Analysis eXpressions

Lecture 25 DAX, the “POWER” in POWER BI

Lecture 26 Using Measures to create Calculations and KPIs

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

Lecture 28 Year over Year Varience, and Waterfall Charts

Lecture 29 Year to Date with DAX

Lecture 30 Exercises Scenario & Resources

Lecture 31 Exercise 1 – Last year comparison

Lecture 32 Exercise 2 – Year to Date

Lecture 33 Exercise 3 – Market Share

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

Lecture 35 Exercises Solution

Section 5: Chapter 04 – Data Vizualisation

Lecture 36 Why Data Visualisation Really Matters

Lecture 37 Pie Chart and Treemap

Lecture 38 Hierarchies

Lecture 39 Filtering and TopN

Lecture 40 Dual-Axis (Combo) Chart

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

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

Lecture 43 Slicers

Lecture 44 MAPS and Dynamic Coloring !

Lecture 45 Fancy Tables

Lecture 46 Custom Formatting & Design tips

Lecture 47 App Like User Experience & Navigation

Lecture 48 Exercises Scenario & Resources

Lecture 49 Exercice 1 – Cross Tabular Report

Lecture 50 Exercise 2- Part-to-Whole Report

Lecture 51 Exercise 3- Relationship Report

Lecture 52 Exercise 4- Trend Report

Lecture 53 Exercise 5- Rank Report

Lecture 54 Exercise 6- Customise your report & Navigation

Lecture 55 Exercices Solutions

Section 6: Chapter 05 – Power BI Service

Lecture 56 Sharing and Collaboration in Power BI

Lecture 57 How to Publish a report to the Power BI service

Lecture 58 Deep Dive into the Power BI service

Section 7: Congratulations Hero!

Lecture 59 Why Power BI is going to be huge

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

Course Information:

Udemy | English | 2h 29m | 2.57 GB
Created by: Abdelkarim MOHAMED MAHMOUD

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top