PowerBI Zero to Hero
What you’ll learn
Power bi
Business Intelligence
Data Visualisation
Dashboarding
Powerbi
DAX
Power Query
Data Modeling
BI
Data vizualisation
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.31 GB
Created by: Abdelkarim MOHAMED MAHMOUD
You Can See More Courses in the Developer >> Greetings from CourseDown.com