Course Content
Introduction to Power BI – Week 1
-
Course Structure and Outline
00:00 -
Downloading Power BI
00:00 -
IMPORTANT: Adjusting Settings
00:00 -
Power Bi Desktop Interface & Workflow
00:00 -
DOWNLOAD: Course Resources
00:00 -
Connect to the Discord Community
-
QUIZ: Introducing Power BI Desktop
-
Week One – Workshop – cohort 3
Connecting And Shaping Data – Week 2
-
Power Bi Front End and Back End
00:00 -
Type of Data Connector
00:00 -
The Power Query Editor
00:00 -
Basic Table Transformations
00:00 -
Storage and Connection Mode
00:00 -
Connecting to Database
00:00 -
Extracting Data from the Web
00:00 -
Data QA and Profiling Tools
00:00 -
Mastering Text Tool in Power Query
00:00 -
Mastering Number Tool in Power Query
00:00 -
Mastering Date and Time Tool in Power Query
00:00 -
Change Type with Locale
00:00 -
Dynamic time calculation (Rolling Calendar)
00:00 -
Index & Conditional Columns
00:00 -
Calculated Column best Practices
00:00 -
Grouping & Aggregating
-
Pivoting and Unpivoting
-
Merging Queries
-
Appending Queries
-
How to Append File from a Folder
-
Data Source Settings
-
Data Source Parameters
-
Refreshing Queries
-
Power Query Best Practices
-
QUIZ: Connecting & Shaping Data
-
Week Two – Workshop – cohort 3
Data Model in Power BI – Week 3
-
Introduction to Data Modelling
-
Database Normalization
-
Fact & Dimension Tables
-
Primary & Foreign Keys
-
Relationships vs. Merged Tables
-
Creating Table Relationship
-
Managing & Editing Relationships
-
Star & Snowflake Schemas
-
Active & Inactive Relationships
-
Relationship Cardinality
-
Connecting Multiple Fact Tables
-
Filter Context & Filter Flow
-
Bi-Directional Filters & Ambiguity
-
Hiding Fields from Report View
-
Model Layouts
-
Data Formats & Categories
-
Creating Hierarchies
-
Data Model Best Practices
-
QUIZ: Creating a Data Model
Data Analysis Expression (DAX) – Week 4
-
Introduction to Data Analysis Expression
-
DAX vs. M Languages
-
Intro to DAX Calculated Columns
-
Intro to DAX Measures
-
Implicit vs. Explicit Measures
-
Quick Measures
-
Calculated Columns vs. Measures
-
Dedicated Measure Tables
-
Understanding Filter Context
-
DAX Syntax & Operators
-
Common DAX Function Categories
-
Basic Math & Stats Functions
-
Counting Functions
-
Conditional & Logical Functions
-
The SWITCH Function
-
Common Text Functions
-
Basic Date & Time Functions
-
Joining Data with RELATED
-
The CALCULATE Function
-
DAX Measure Totals
-
The ALL Function
-
The FILTER Function
-
Iterator (X) Functions
-
Time Intelligence Patterns
-
DAX Best Practices
-
QUIZ: Calculated Fields with DAX
Data Visualization with Power – Week 5
-
Introduction to Data Visualisation in Power Bi
-
The 3 Key Questions
-
Dashboard Design Framework
-
Sketching the dashboard layout
-
Adding Report Pages & Objects
-
Naming & Grouping Objects
-
Cards & Multi-Row Cards
-
Building & Formatting Charts
-
Line Charts
-
Trend Lines & Forecasts
-
KPI Cards
-
Basic Filtering Options
-
Table & Matrix Visuals
-
Conditional formatting
-
Top N Filtering
-
Top N Text Cards
-
Map Visuals
-
Report Slicers
-
HASONEVALUE
-
Gauge Charts
-
Advanced Conditional Formatting
-
Area Charts
-
Drill Up & Drill Down
-
Drill through Filters
-
Editing Report Interactions
-
Adding Bookmarks
-
Custom Navigation Buttons
-
Slicer Panels
-
Numeric Range Parameters
-
Fields Parameters
-
Custom Tool Tips
-
Importing Custom Visuals
-
Managing & Viewing Roles
Artificial Intelligence in Power BI – Week 6
Power BI Optimization Tool Week 6
Capstone Project -Week 7
Student Ratings & Reviews
No Review Yet