PowerBI Zero to Hero

A practical guide to building Dashboards with Power BI

Power bi

Business Intelligence

Data Visualisation

Dashboarding

Powerbi

DAX

Power Query

Data Modeling

BI

Data vizualisation

Familiarity with Microsoft Excel or Google Sheets

If you're trying to quickly master the most suitable tool for connecting, transfog, 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

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

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



DOWNLOAD
uploadgig


rapidgator


nitro