PowerBI Zero to Hero

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