Data Analysis with Power BI
Program Code: DAPBI
Short Course
8 weeks
Online
Microsoft
Program Overview
Transform raw data into actionable insights using Microsoft Power BI. Learn data visualization, DAX, and dashboard creation. This online course requires a strong internet connection and a laptop.
Curriculum & Modules
Week 1: Introduction to Data Analytics
- Data Types
- Data Lifecycle
- Analytics Tools
Week 2: Excel for Data Analysis
- Advanced Formulas
- PivotTables
- Power Pivot
Week 3: Power Query
- Data Transformation
- Merging Queries
- Data Cleaning
Week 4: Data Modelling
- Relationships
- DAX Basics
- Calculated Columns
Week 5: DAX Fundamentals
- CALCULATE
- FILTER
- Time Intelligence
Week 6: Dashboard Design
- Visualizations
- Bookmarks
- Drill-through
Week 7: Business Intelligence Reporting
- Row-Level Security
- Publish to Service
- Gateway
Week 8: Capstone Dashboard Project
- Executive Management Dashboard
- Project Presentation
Entry Requirements
Strong internet connection and a laptop are required as this is an online course.