Home
Solutions
Data Integration
Training
Why Zizia
Blog
Contact
Linkedin
X-twitter
Home
Solutions
Data Integration
Training
Why Zizia
Blog
Contact
Linkedin
X-twitter
Home
Solutions
Data Integration
Training
Why ZIZIA
Blog
Contact
Home
Solutions
Data Integration
Training
Why ZIZIA
Blog
Contact
Home
Courses
powerbi
Microsoft Power BI Training: Introduction Course
Microsoft Power BI Training: Introduction Course
Curriculum
9 Sections
84 Lessons
4 Weeks
Expand all sections
Collapse all sections
Module 1 - Welcome To Microsoft Power BI Training 1.0
2
2.1
Get Acces To The Stella Data Analytics Private Student Community
4 Minutes
2.2
Prepare Power Bi Desktop For The Course
3 Minutes
Module 2 - Connecting A Dataset To Microsoft Power BI Desktop
7
3.1
How To Get Data From A Website
10 Minutes
3.2
How To Get Data From A CSV File
5 Minutes
3.3
How To Get Data From A TEXT File
4 Minutes
3.4
How To Get Data From A Excel File
4 Minutes
3.5
How To Add Additional Data And Rrefresh The Dataset
7 Minutes
3.6
Recap: What did we learn in this module?
2 Minutes
3.7
Module 2: Challenge and Solution
12 Minutes
Module 3 - Introduction to MYSQL
9
4.1
How To Create And Drop A Database
5 Minutes
4.2
How To Create And Drop A Table
5 Minutes
4.3
How To Populate a Table And Create A Select Statement
7 Minutes
4.4
Creating A Database And Tables For A Dashboard
10 Minutes
4.5
Connecting A MYSQL Dataset To Microsoft Power BI Desktop
5 Minutes
4.6
How To Add Additional Data To A MYSQL Table
7 Minutes
4.7
Editing The Connection Between MYSQL And Power BI Desktop
2 Minutes
4.8
Recap: What did we learn in this module?
2 Minutes
4.9
Module 3: Challenge and Solution
12 Minutes
Module 4 - Preparing And Transforming The Dataset In The Power Query Editor
19
5.1
DO NOT SKIP THIS: Introduction
2 Minutes
5.2
Promoting First Rows To Headers
2 Minutes
5.3
How To Work With Columns
4 Minutes
5.4
Editing Different Rows Of The Dataset
4 Minutes
5.5
Assigning A Data Type To A Column
10 Minutes
5.6
How To Replace Values In A Cell
5 Minutes
5.7
Pivot and Unpivot Columns In A Table
13 Minutes
5.8
How To Use The Format Function
10 Minutes
5.9
How To Extract Values From A Specific Cell
8 Minutes
5.10
Using The Statistics Functions
6 Minutes
5.11
Rounding The Values Of A Column
5 Minutes
5.12
Creating Custom Columns
6 Minutes
5.13
How To Duplicate Columns, Add An Index And A Conditional Column
8 Minutes
5.14
Introducing The View Tab In Power BI Desktop
4 Minutes
5.15
How To Merge Tables
20 Minutes
5.16
How To Append Tables
7 Minutes
5.17
Creating Relationships Between Tables
10 Minutes
5.18
Recap: What did we learn in this module?
4 Minutes
5.19
Module 4: Challenge and solution
Module 5 - Creating Measures And Calculations With DAX Formula's
12
6.1
Setting Up The Dataset For The DAX Foluma’s
6 Minutes
6.2
How To Use The COUNT functions
16 Minutes
6.3
Dividing Columns
4 Minutes
6.4
How To Use SUM And SUMX
10 Minutes
6.5
Calculating With The Different AVERAGE Functions
3 Minutes
6.6
Calculating The MIN And MAX In A DAX Function
3 Minutes
6.7
Introduction To The CALCULATE Function In DAX
6 Minutes
6.8
How To Use The ALL Function
12 Minutes
6.9
Calculations With The RELATE Function
8 Minutes
6.10
How To Use LOOKUPVALUE
3 Minutes
6.11
Using IF Functions In Calculations
4 Minutes
6.12
Recap: What did we learn in this module?
4 Minutes
Module 6 - Creating Visualisations In Power BI Desktop
17
7.1
Creating Your First Visualisation
14 Minutes
7.2
Adding A Bar Chart
19 Minutes
7.3
How To Create A Line And Area Chart
12 Minutes
7.4
Creating Column Charts
12 Minutes
7.5
How To Create A Ribbon Chart
7 Minutes
7.6
Creating A Waterfall Chart
3 Minutes
7.7
How To Use The Scatter Chart
11 Minutes
7.8
Designing A Funnel
6 Minutes
7.9
How To Create A Pie And Donut Chart
13 Minutes
7.10
Creating A Treemap
13 Minutes
7.11
Using The Map Visualisations
14 Minutes
7.12
How To Create A Gauge
9 Minutes
7.13
Using Cards
11 Minutes
7.14
Creating KPI’s (Key Performance Indicators)
7 Minutes
7.15
Adding A Filter To A Dashboard
13 Minutes
7.16
How To Use Tables And The Matrix
10 Minutes
7.17
Recap: What did we learn in this module?
4 Minutes
Module 7 - How To Style A Dashboard
4
8.1
How to add a theme
9 Minutes
8.2
Adding More Flexible Titles To The Visualisation
4 Minutes
8.3
Creating Buttons, Images and Text Boxes
17 Minutes
8.4
Recap: What did we learn in this module?
4 Minutes
Module 8 - How To Publish And Share A Dashboard
3
9.1
How To Publish A Report To The Workspace
4 Minutes
9.2
Pushing Your Report To The Power BI App
8 Minutes
9.3
Recap: What did we learn in this module?
1 Minute
Module 9 - Building A Dashboard From Scratch
11
10.1
Starting With The End Result
7 Minutes
10.2
Getting The Data
7 Minutes
10.3
Creating Relationships Between Tables
10 Minutes
10.4
Creating The Measures For The Dashboard
12 Minutes
10.5
Formatting The Measures
5 Minutes
10.6
Creating The Pages And Add A Top Bar
10 Minutes
10.7
How To create A KPI (Key Performance Indicators) Bar
9 Minutes
10.8
Creating The Visualisations On Each Page
17 Minutes
10.9
How To Create A Drill Through To Another Page
7 Minutes
10.10
Fine Tuning The Dashboard
15 Minutes
10.11
Recap: What did we learn in this module?
1 Minute
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content
