Module 1 – Introduction to Data Analysis with Excel & Power BI (8 hours)
- Role of Excel & Power BI in data analytics and BI
- Latest trends in 2025: AI Copilot in Excel & Power BI, Real-time dashboards, Natural Language Queries
- Excel basics: Interface, workbook management, cell formatting
- Power BI overview: Desktop vs Service, data connectors
- Integrating Excel and Power BI
Hands-on:
- • Create your first dataset in Excel
- • Connect an Excel file to Power BI
Module 2 – Excel for Data Cleaning & Preparation (10 hours)
- Data import from CSV, databases, and web
- Data cleaning: removing duplicates, handling blanks, text-to-columns
- Data transformation: TRIM, PROPER, CONCAT, FIND, REPLACE
- Using Excel’s Power Query for ETL tasks
- Latest trend: AI-assisted data cleaning in Excel Copilot
Hands-on:
- • Clean a messy dataset in Excel using Power Query
- • Automate recurring cleaning steps
Module 3 – Excel for Data Analysis (12 hours)
- Sorting & filtering
- Conditional formatting for insights
- Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP
- Statistical functions: AVERAGE, MEDIAN, STDEV, COUNTIF
- What-If Analysis: Goal Seek, Scenario Manager
- Pivot Tables & Pivot Charts
- Latest trend: Dynamic arrays & advanced formulas (FILTER, SORT, UNIQUE)
Hands-on:
- • Create a sales performance analysis with PivotTables
- • Build a financial forecast with Goal Seek
Module 4 – Power BI for Visualization & Reporting (12 hours)
- Loading data from multiple sources
- Data modeling & relationships
- DAX basics: CALCULATE, SUMX, FILTER
- Designing effective dashboards: charts, KPIs, slicers
- Latest trend: Power BI AI visuals (Key Influencers, Smart Narratives)
Hands-on:
- • Build an interactive sales dashboard in Power BI
- • Use AI visuals to identify top performance drivers
Module 5 – Advanced Power BI & Integration (10 hours)
- Advanced DAX calculations
- Custom visuals from AppSource
- Power BI service: publishing, sharing, and scheduled refresh
- Row-level security for restricted access
- Latest trend: Natural Language Q&A and Copilot in Power BI
Hands-on:
- • Publish a dashboard to Power BI Service and share with stakeholders
- • Create role-based access for reports
Module 6 – Capstone Project (20 hours)
Project Theme:
- "Interactive Business Performance Dashboard" – Students will:
- 1. Import and clean a multi-sheet dataset in Excel
- 2. Analyse data with PivotTables, formulas, and charts
- 3. Load cleaned data into Power BI
- 4. Build an interactive dashboard with KPIs, filters, and AI insights
- 5. Publish and share the report online
Examples:
- • Retail sales dashboard with trends and forecasts
- • HR analytics dashboard (attrition, hiring, performance)
- • Financial performance monitoring tool
Final Deliverables:
- • Excel workbook with cleaned & analysed data
- • Published Power BI dashboard
- • Documentation + short demo video
Assessment & Certification
- • Weekly Quizzes: 20%
- • Assignments: 30%
- • Capstone Project: 50%
- • Minimum 60% score for certification
Reviews
There are no reviews yet.