Certification Course
THE ALPHA PROGRAM
₦50k
FEATURES:
Excel
PowerBI
4 Interview Preparation Sessions
Week 1
Week 2
Overview of Data Modelling Concepts
Key Excel Functions: VLOOKUP, XLOOKUP, INDEX-MATCH
Data Organization: Horizontal and Vertical Stacking (VSTACK, HSTACK)
Introduction to Data Visualization in Excel
Principles of Effective Data Visualization
Creating and Customizing Charts and Graphs: Bar Charts, Line Graphs, Pie Charts
Advanced Visualization Techniques: Pivot Tables, Sparklines
Week 3
Fundamentals of Data Storytelling
Structuring a Compelling Data Narrative
Tools and Techniques for Presenting Data Stories
Power BI Basics and Interface Overview
Understanding BI Concepts: Primary Keys, Foreign Keys, Fact & Dimension Tables, getting started with Data Importation in Power BI
Week 4
Module 7 – Data Manipulation and Modelling in Power BI
Basics of the Power BI Query Editor
Developing Data Models: Relationships, Hierarchies, Calculated Columns
Building Fact and Dimensional Tables
Module 8 – Advanced Data Analysis with Power BI
Introduction to DAX (Data Analysis Expressions)
Advanced DAX Functions: CALCULATE, FILTER, RELATEDTABLE
Techniques for Advanced Data Analysis in Power BI
Week 5
Module 9 – Project Work and Presentation Skills
Applying Skills to a Real-World Dataset
Crafting a Data Story Around Project Findings
Effective Communication and Presentation Techniques
Understanding Roles and Responsibilities in Data Analytics
Building a Targeted Resume
Preparation for Job Interviews: Tips and Practice
Final Week
End-to-End real-life case study Excel
End-to-End real-life case study Power Bi
Add On
4 Interview Preparation Sessions
