Glossary of Terms
Session 1 - Power BI Fundamentals and Reporting Workflow
Session 2 - Connecting and Preparing Data with Power Query
Session 3 - Building Data Models and Managing Relationships
Session 4 - Creating Effective Reports and Dashboards
Session 5 - Publishing and Sharing Reports with Power BI Service
Additional Videos
-
Session Video - Introduction to Microsoft Power BI (87:02)
-
Session Video - Power BI Desktop (101:49)
-
Session Video - Power BI Query Editor - Merge Query (110:13)
-
Session Video - Transform Data Set (105:37)
-
Session Video - Excel Visuals (95:09)
-
Session Video - Different Kinds of Charts (100:57)
-
Session Video - Build Visuals with Data in Power BI (100:01)
-
Session Video - Add Data to Your Report - Online Food Delivery (100:23)
-
Session Video - Create a Dashboard (116:09)
-
Session Video - Concept of Data Modelling (99:55)
-
Session Video - DAX Functions (91:53)
-
Session Video - Data Cleaning - Data Set (59:44)
-
Session Video - Data Set (106:56)
-
Session Video - DAX & Other Features (120:52)
-
Session Video - DAX Functional (87:51)
-
Session Video - Power BI Services (112:42)
-
Session Video - Functionalities of Power BI (109:01)
-
Session Video - DataSets (135:07)
-
Session Video - Dataverse (132:14)
Assessments
-
Assessment - 1. Power BI Foundations & Setup
-
Assessment - 2. Data Loading, Cleaning & Transformation (Power Query)
-
Assessment - 3. Data Modeling & Core DAX
-
Assessment - 4. Visualizations & Report Design
-
Assessment - 5. Publishing, Sharing & Power BI Service
-
Assessment - 6. Security, Performance & Best Practices + Capstone
Assignments
-
Assignment - 1. Power BI Foundations & Setup
-
Assignment - 2. Data Loading, Cleaning & Transformation (Power Query)
-
Assignment - 3. Data Modeling & Core DAX
-
Assignment - 4. Visualizations & Report Design
-
Assignment - 5. Publishing, Sharing & Power BI Service
-
Assignment - 6. Security, Performance & Best Practices + Capstone
Lab Activity
-
Lab Activity - 1. Get started with Power BI Desktop
-
Lab Activity - 2. Sample File Overview
-
Lab Activity - 3. Use Power Query to transform data
-
Lab Activity - 4. Overview of query evaluation and query folding in Power Query
-
Lab Activity - 5. Error handling
-
Lab Activity - 6. Time intelligence functions
-
Lab Activity - 7. Write DAX Formulas For Semantic Models
-
Lab Activity - 8. Create DAX calculations in semantic models
-
Lab Activity - 9. Use DAX time intelligence functions in Semantic models
-
Lab Activity - 10. Create Visual calculations in Power BI Desktop
-
Lab Activity - 11. Visualizations overview in Power BI
-
Lab Activity - 12. Create report bookmarks in Power BI to share insights and build stories
-
Lab Activity - 13. Power BI service basics
-
Lab Activity - 14. Publish semantic models and reports from Power BI Desktop
-
Lab Activity - 15. Row-level security (RLS) with Power BI
Additional Assessment
-
Assessment - Advanced Analytics in Power BI using R and Python
-
Assessment - Data Analysis Expressions (DAX)
-
Assessment - Data Visualization
-
Assessment - Direct Connectivity
-
Assessment - Introduction to Power BI Q_A and Data Insights
-
Assessment - Introduction to Power BI
-
Assessment - Power BI Desktop
-
Assessment - Power BI Report Servers
Additional Lab Activity
-
Lab Activity - Connect to Data Sources in Power BI Desktop
-
Lab Activity - Create a Calculated Column that uses an IF Function
-
Lab Activity - Create Calculated Columns in Power BI Desktop
-
Lab Activity - Create your own measures in Power BI Desktop
-
Lab Activity - Creating a Measure using Power BI DAX
-
Lab Activity - Creating R visuals in Power BI
-
Lab Activity - Creating visual using Python
-
Lab Activity - Dashboard vs. Reports
-
Lab Activity - Download Power BI Desktop directly
-
Lab Activity - Exploring live connections to data with Power BI
-
Lab Activity - Get data from Comma Separated Value (.CSV) files
-
Lab Activity - Get data from Power BI Desktop Files
-
Lab Activity - Import Power View and Power Pivot to Power BI
-
Lab Activity - Install as an App from the Microsoft Store
-
Lab Activity - Paginated Reports
-
Lab Activity - Power BI Publisher for Excel
-
Lab Activity - Programming Power BI datasets with the Tabular Object Model (TOM)
-
Lab Activity - Row-level Security
-
Lab Activity - Use your measure in another Measure
-
Lab Activity - Use your measure in the Report
-
Lab Activity - Use your measure with a Slicer
-
Lab Activity - Use your New Column in a Report
DataSets
Sample Data
Capstone Projects / Case Studies
-
Capstone Project - 1. Financial Reporting & Variance Analysis (P&L Dashboard)
-
Capstone Project - 2. Healthcare Patient & Operations Dashboard
-
Capstone Project - 3. HR Workforce Analytics & Attrition Dashboard
-
Capstone Project - 4. Retail Sales Performance & Profitability Dashboard
-
Capstone Project - 5. Supply Chain & Logistics Performance Dashboard
Sample Resumes
Interview Questions
Prepare your LinkedIn Profile
Prepare your Resume
Final Quiz
