Commercial Digital Literacy
Curriculum Verified
Advanced Excel, Power BI & Business Intelligence
Transform raw business data into actionable executive insights with advanced Excel formulas, Power Query data cleaning pipelines, star schema data modeling, and enterprise Power BI dashboards with DAX...
(0 ratings)
Category: Data & Business Technology
What you'll learn
["Master dynamic array formulas (XLOOKUP, FILTER, LET, LAMBDA) in Excel","Build automated ETL data pipelines with Power Query","Design robust relational data models with star schema architectures","Author advanced DAX measures utilizing CALCULATE, time intelligence, and iterator functions","Publish interactive executive dashboards with Power BI Service."]
Learning Tracks & Pricing Options
Designed for self-paced independent study, with optional 1-on-1 instructor support when needed.
| Curriculum & Support Feature | Option A: Self-Study Ksh 12,500.00 | Option B: Assisted Learning Ksh 27,500.00 |
|---|---|---|
| All 6 Structured Modules | ||
| Downloadable PDF Manuals & Starter Code | ||
| Hands-on Practical Exercises & Capstone Labs | ||
| Verified Certificate of Completion | ||
| Dedicated 1-on-1 Instructor Mentorship | Add on demand | Included |
| Live Debugging & Screen-Share Support | Add on demand | Included |
| Milestone Portfolio Code Reviews | Add on demand | Included |
| Enroll Self-Study • Ksh 12,500.00 | Enroll Assisted • Ksh 27,500.00 |
Self-Study Flexibility: If you choose Self-Study, you can request instructor assistance for any specific module whenever you need help without altering your self-study access.
Course Content
6 sections • 684 lessons • 30h total length
Expand all sections
-
Modern Dynamic Array Formulas: FILTER, UNIQUE, SORT, and SEQUENCE50min
-
Advanced Lookups: XLOOKUP, Multi-Criteria Lookups, and Nested INDEX-MATCH50min
-
Complex Logical Functions: Nested IFS, SWITCH, LET, and LAMBDA Custom Formulas50min
-
Advanced Financial and Statistical Modeling Functions (NPV, IRR, XIRR, FORECAST.ETS)50min
-
Robust Error Handling, Formula Auditing, and Circular Reference Resolution50min
-
Power Query ETL Fundamentals: Importing Data from CSV, Folders, and SQL Databases50min
-
Transforming Messy Data: Splitting Columns, Unpivoting, and Replacing Values50min
-
Merging Queries (Joins: Left Outer, Anti-Join, Full) and Appending Data Tables50min
-
Working with Dates, Fiscal Calendars, and Custom M-Code Transformations50min
-
Automating Recurring Data Import Pipelines with Single-Click Refresh50min
-
Advanced Pivot Table Calculations: Calculated Fields, Items, and Grouping50min
-
Introducing the Excel Data Model: Creating Relationships Without VLOOKUP50min
-
Star Schema Architecture: Fact Tables vs Dimension Tables in Business Data50min
-
Introduction to DAX in Excel: Explicit Measures vs Implicit Measures50min
-
Designing Interactive Executive Excel Dashboards with Slicers and Timelines50min
-
Power BI Interface, Connecting to Sources, and DirectQuery vs Import Mode50min
-
Power BI Query Editor Best Practices and Query Folding50min
-
Advanced Relationship Management: 1-to-Many, Cross-Filter Direction, and Active/Inactive50min
-
Building a Standard Date Table (Calendar Dimension) in DAX50min
-
Star Schema Optimization for High-Performance Power BI Models50min
-
Evaluation Contexts: Row Context vs Filter Context Demystified50min
-
The Cornerstone Function: Mastering CALCULATE and Filter Overrides50min
-
Iterator Functions: SUMX, AVERAGEX, COUNTX, and Performance Considerations50min
-
Time Intelligence in DAX: YTD, QTD, SAMEPERIODLASTYEAR, and Moving Averages50min
-
Dynamic KPI Metrics: Disconnected Tables, What-If Parameters, and Ranking (RANKX)50min
-
Cognitive Design Principles for Dashboards: Visual Hierarchy and Color Theory50min
-
Advanced Visuals: Matrix with Conditional Formatting, Waterfall, and Scatter Plots50min
-
Interactive Storytelling: Drill-Down, Drill-Through, Tooltips, and Bookmarks50min
-
Power BI Service: Workspaces, Publishing, Dashboards, and Scheduled Refresh50min
-
Row-Level Security (RLS), Sharing Reports, and Exporting to PowerPoint/PDF50min
Description
Transform raw business data into actionable executive insights with advanced Excel formulas, Power Query data cleaning pipelines, star schema data modeling, and enterprise Power BI dashboards with DAX. Learn real-world business intelligence workflows used by corporate analysts and financial controllers.
Recommended Learning Pathway
Prerequisites / Prior Knowledge:
Familiarity with basic Microsoft Excel formulas (SUM, AVERAGE, IF) and data entry.
Student Reviews & Feedback
Verified ratings from students enrolled in this course.
No reviews yet for this course. Be the first enrolled student to share feedback!