Updated v1.0 (Summer 2020)
This Microsoft Power BI Training helps you to get focus on the absolute most important thing, and that’s living the life you truly want.
You not only learn how to build powerful and insightful Microsoft Power BI dashboards, but you will also be guided into becoming a thriving Data Analytics Expert.
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. You will learn 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 want to take their first step into the world of Microsoft Power BI from home. You can start this course from where-ever you are in the world and you can even start it if you have never worked with data or analytics before!
Where does this take place?
This entire course and platform is available to you online at anytime anywhere. 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 team of Data Analytics Experts at anytime.
When does it start?
You 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 that every person is capable of buildinf powerful and insightful Microsoft Power BI dashboards independently of their background. We want to showcase how simple this can be.
Here's a quick summary of everything you get:
This is not your typical online course. We provide you with everything you need to not only to succeed with building dashboards Microsoft Power BI, but also everything you need to become a thriving Data Analytics Expert.
- Access to step-by-step training videos and worksheets that is available to you from any desktop or mobile device, anywhere in the world, anytime you like!
- Interactive data analytics community both there to support, inspire, and help you grow!
- Experts ready to help you whenever you need, with whatever you need! (The Stella Data Analytics Experts)
- How to become a thriving Data Analytics Expert that stands the test of time.
Course Curriculum
- How To Get Data From A Website (10:44)
- How To Get Data From A CSV File (5:55)
- How To Get Data From A TEXT File (3:58)
- How To Get Data From A Excel File (4:23)
- How To Add Additional Data And Rrefresh The Dataset (6:57)
- Recap: What did we learn in this module? (2:03)
- Module 2: Challenge and Solution (11:46)
- How To Create And Drop A Database (5:32)
- How To Create And Drop A Table (5:25)
- How To Populate a Table And Create A Select Statement (7:14)
- Creating A Database And Tables For A Dashboard (9:56)
- Connecting A MYSQL Dataset To Microsoft Power BI Desktop (5:03)
- How To Add Additional Data To A MYSQL Table (7:10)
- Editing The Connection Between MYSQL And Power BI Desktop (2:59)
- Recap: What did we learn in this module? (3:52)
- Module 3: Challenge and Solution (12:51)
- DO NOT SKIP THIS: Introduction (2:50)
- Promoting First Rows To Headers (2:15)
- How To Work With Columns (4:33)
- Editing Different Rows Of The Dataset (4:53)
- Assigning A Data Type To A Column (9:42)
- How To Replace Values In A Cell (5:07)
- Pivot and Unpivot Columns In A Table (13:08)
- How To Use The Format Function (8:59)
- How To Extract Values From A Specific Cell (8:18)
- Using The Statistics Functions (6:31)
- Rounding The Values Of A Column (4:54)
- Creating Custom Columns (6:22)
- How To Duplicate Columns, Add An Index And A Conditional Column (8:50)
- Introducing The View Tab In Power BI Desktop (4:57)
- How To Merge Tables (20:39)
- How To Append Tables (10:44)
- Creating Relationships Between Tables (10:38)
- Recap: What did we learn in this module? (4:28)
- Module 4: Challenge and solution
- Setting Up The Dataset For The DAX Foluma's (5:23)
- How To Use The COUNT functions (16:11)
- Dividing Columns (4:07)
- How To Use SUM And SUMX (10:56)
- Calculating With The Different AVERAGE Functions (2:42)
- Calculating The MIN And MAX In A DAX Function (3:21)
- Introduction To The CALCULATE Function In DAX (9:00)
- How To Use The ALL Function (12:06)
- Calculations With The RELATE Function (8:46)
- How To Use LOOKUPVALUE (3:11)
- Using IF Functions In Calculations (3:54)
- Recap: What did we learn in this module? (3:51)
- Creating Your First Visualisation (14:47)
- Adding A Bar Chart (16:55)
- How To Create A Line And Area Chart (12:21)
- Creating Column Charts (13:01)
- How To Create A Ribbon Chart (7:09)
- Creating A Waterfall Chart (3:20)
- How To Use The Scatter Chart (11:01)
- Designing A Funnel (6:02)
- How To Create A Pie And Donut Chart (13:25)
- Creating A Treemap (13:25)
- Using The Map Visualisations (14:12)
- How To Create A Gauge (9:22)
- Using Cards (11:04)
- Creating KPI's (Key Performance Indicators) (7:10)
- Adding A Filter To A Dashboard (13:12)
- How To Use Tables And The Matrix (10:06)
- Recap: What did we learn in this module? (3:46)
- Starting With The End Result (7:05)
- Getting The Data (7:26)
- Creating Relationships Between Tables (2:32)
- Creating The Measures For The Dashboard (12:35)
- Formatting The Measures (5:45)
- Creating The Pages And Add A Top Bar (10:22)
- How To create A KPI (Key Performance Indicators) Bar (9:14)
- Creating The Visualisations On Each Page (17:59)
- How To Create A Drill Through To Another Page (7:05)
- Fine Tuning The Dashboard (15:17)
- Recap: What did we learn in this module? (4:02)