What is it?
Microsoft Power BI Training: Introduction Course is a 4-week online course with detailed over-the-shoulder videos, in-depth worksheets, and an ambitious community of Data Analytics Experts. We show you how to leverage all the features of the Power BI platform to create powerful and super insightful Power BI dashboards. Yes, even if you don’t have any experience in data or analytics.
Who is it for?
Microsoft Power BI Training: Introduction Course is for anyone who is looking to get an introduction to Microsoft Power BI and start their carreer as an Data Analytics Expert from home. We have worked with thousands of people from across the world, even those who have never worked with data and analytics before.
Where does this take place?
Our entire course and platform is available to you online at anytime. You may access all the video content, worksheets, and community from your desktop, laptop, phone, or iPad, on your time.
How does it work?
All you have to do is complete the videos, take notes, take action, and get results. It’s that simple. Use the community group for support, questions, or to share your progress. You may also get one-on-one support from our Stella Data Analytics Experts at anytime.
When does it start?
We start the moment you enroll! No fluff, no delay. You can complete the course in your own time and work through it as fast or slow as you wish. You get lifetime access to all the material and are grandfathered in for future updates.
Why do we exist?
We have created this course because we believe every person is capable of becomming a Data Analytics Expert and build powerful and insightful Microsoft Power BI dashboards independently of their background. We want to showcase how simple this can be.
Curriculum
- 9 Sections
- 84 Lessons
- 4 Weeks
- Module 1 - Welcome To Microsoft Power BI Training 1.02
- Module 2 - Connecting A Dataset To Microsoft Power BI Desktop7
- 3.1How To Get Data From A Website10 Minutes
- 3.2How To Get Data From A CSV File5 Minutes
- 3.3How To Get Data From A TEXT File4 Minutes
- 3.4How To Get Data From A Excel File4 Minutes
- 3.5How To Add Additional Data And Rrefresh The Dataset7 Minutes
- 3.6Recap: What did we learn in this module?2 Minutes
- 3.7Module 2: Challenge and Solution12 Minutes
- Module 3 - Introduction to MYSQL9
- 4.1How To Create And Drop A Database5 Minutes
- 4.2How To Create And Drop A Table5 Minutes
- 4.3How To Populate a Table And Create A Select Statement7 Minutes
- 4.4Creating A Database And Tables For A Dashboard10 Minutes
- 4.5Connecting A MYSQL Dataset To Microsoft Power BI Desktop5 Minutes
- 4.6How To Add Additional Data To A MYSQL Table7 Minutes
- 4.7Editing The Connection Between MYSQL And Power BI Desktop2 Minutes
- 4.8Recap: What did we learn in this module?2 Minutes
- 4.9Module 3: Challenge and Solution12 Minutes
- Module 4 - Preparing And Transforming The Dataset In The Power Query Editor19
- 5.1DO NOT SKIP THIS: Introduction2 Minutes
- 5.2Promoting First Rows To Headers2 Minutes
- 5.3How To Work With Columns4 Minutes
- 5.4Editing Different Rows Of The Dataset4 Minutes
- 5.5Assigning A Data Type To A Column10 Minutes
- 5.6How To Replace Values In A Cell5 Minutes
- 5.7Pivot and Unpivot Columns In A Table13 Minutes
- 5.8How To Use The Format Function10 Minutes
- 5.9How To Extract Values From A Specific Cell8 Minutes
- 5.10Using The Statistics Functions6 Minutes
- 5.11Rounding The Values Of A Column5 Minutes
- 5.12Creating Custom Columns6 Minutes
- 5.13How To Duplicate Columns, Add An Index And A Conditional Column8 Minutes
- 5.14Introducing The View Tab In Power BI Desktop4 Minutes
- 5.15How To Merge Tables20 Minutes
- 5.16How To Append Tables7 Minutes
- 5.17Creating Relationships Between Tables10 Minutes
- 5.18Recap: What did we learn in this module?4 Minutes
- 5.19Module 4: Challenge and solution
- Module 5 - Creating Measures And Calculations With DAX Formula's12
- 6.1Setting Up The Dataset For The DAX Foluma’s6 Minutes
- 6.2How To Use The COUNT functions16 Minutes
- 6.3Dividing Columns4 Minutes
- 6.4How To Use SUM And SUMX10 Minutes
- 6.5Calculating With The Different AVERAGE Functions3 Minutes
- 6.6Calculating The MIN And MAX In A DAX Function3 Minutes
- 6.7Introduction To The CALCULATE Function In DAX6 Minutes
- 6.8How To Use The ALL Function12 Minutes
- 6.9Calculations With The RELATE Function8 Minutes
- 6.10How To Use LOOKUPVALUE3 Minutes
- 6.11Using IF Functions In Calculations4 Minutes
- 6.12Recap: What did we learn in this module?4 Minutes
- Module 6 - Creating Visualisations In Power BI Desktop17
- 7.1Creating Your First Visualisation14 Minutes
- 7.2Adding A Bar Chart19 Minutes
- 7.3How To Create A Line And Area Chart12 Minutes
- 7.4Creating Column Charts12 Minutes
- 7.5How To Create A Ribbon Chart7 Minutes
- 7.6Creating A Waterfall Chart3 Minutes
- 7.7How To Use The Scatter Chart11 Minutes
- 7.8Designing A Funnel6 Minutes
- 7.9How To Create A Pie And Donut Chart13 Minutes
- 7.10Creating A Treemap13 Minutes
- 7.11Using The Map Visualisations14 Minutes
- 7.12How To Create A Gauge9 Minutes
- 7.13Using Cards11 Minutes
- 7.14Creating KPI’s (Key Performance Indicators)7 Minutes
- 7.15Adding A Filter To A Dashboard13 Minutes
- 7.16How To Use Tables And The Matrix10 Minutes
- 7.17Recap: What did we learn in this module?4 Minutes
- Module 7 - How To Style A Dashboard4
- Module 8 - How To Publish And Share A Dashboard3
- Module 9 - Building A Dashboard From Scratch11
- 10.1Starting With The End Result7 Minutes
- 10.2Getting The Data7 Minutes
- 10.3Creating Relationships Between Tables10 Minutes
- 10.4Creating The Measures For The Dashboard12 Minutes
- 10.5Formatting The Measures5 Minutes
- 10.6Creating The Pages And Add A Top Bar10 Minutes
- 10.7How To create A KPI (Key Performance Indicators) Bar9 Minutes
- 10.8Creating The Visualisations On Each Page17 Minutes
- 10.9How To Create A Drill Through To Another Page7 Minutes
- 10.10Fine Tuning The Dashboard15 Minutes
- 10.11Recap: What did we learn in this module?1 Minute