Beatsy Solutions Beatsy Solutions
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.0
(0 ratings)
Category: Data & Business Technology
Created by James Mwangi Last updated 10/2026 English / Swahili

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.

2 Flexible Pathways
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 SEQUENCE
    50min
  • Advanced Lookups: XLOOKUP, Multi-Criteria Lookups, and Nested INDEX-MATCH
    50min
  • Complex Logical Functions: Nested IFS, SWITCH, LET, and LAMBDA Custom Formulas
    50min
  • Advanced Financial and Statistical Modeling Functions (NPV, IRR, XIRR, FORECAST.ETS)
    50min
  • Robust Error Handling, Formula Auditing, and Circular Reference Resolution
    50min

  • Power Query ETL Fundamentals: Importing Data from CSV, Folders, and SQL Databases
    50min
  • Transforming Messy Data: Splitting Columns, Unpivoting, and Replacing Values
    50min
  • Merging Queries (Joins: Left Outer, Anti-Join, Full) and Appending Data Tables
    50min
  • Working with Dates, Fiscal Calendars, and Custom M-Code Transformations
    50min
  • Automating Recurring Data Import Pipelines with Single-Click Refresh
    50min

  • Advanced Pivot Table Calculations: Calculated Fields, Items, and Grouping
    50min
  • Introducing the Excel Data Model: Creating Relationships Without VLOOKUP
    50min
  • Star Schema Architecture: Fact Tables vs Dimension Tables in Business Data
    50min
  • Introduction to DAX in Excel: Explicit Measures vs Implicit Measures
    50min
  • Designing Interactive Executive Excel Dashboards with Slicers and Timelines
    50min

  • Power BI Interface, Connecting to Sources, and DirectQuery vs Import Mode
    50min
  • Power BI Query Editor Best Practices and Query Folding
    50min
  • Advanced Relationship Management: 1-to-Many, Cross-Filter Direction, and Active/Inactive
    50min
  • Building a Standard Date Table (Calendar Dimension) in DAX
    50min
  • Star Schema Optimization for High-Performance Power BI Models
    50min

  • Evaluation Contexts: Row Context vs Filter Context Demystified
    50min
  • The Cornerstone Function: Mastering CALCULATE and Filter Overrides
    50min
  • Iterator Functions: SUMX, AVERAGEX, COUNTX, and Performance Considerations
    50min
  • Time Intelligence in DAX: YTD, QTD, SAMEPERIODLASTYEAR, and Moving Averages
    50min
  • Dynamic KPI Metrics: Disconnected Tables, What-If Parameters, and Ranking (RANKX)
    50min

  • Cognitive Design Principles for Dashboards: Visual Hierarchy and Color Theory
    50min
  • Advanced Visuals: Matrix with Conditional Formatting, Waterfall, and Scatter Plots
    50min
  • Interactive Storytelling: Drill-Down, Drill-Through, Tooltips, and Bookmarks
    50min
  • Power BI Service: Workspaces, Publishing, Dashboards, and Scheduled Refresh
    50min
  • Row-Level Security (RLS), Sharing Reports, and Exporting to PowerPoint/PDF
    50min

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!

Chat with us on WhatsApp