"The structure, the practice exams, the instructor — all top tier. Passed first try."
Course Outline
What the programme covers, module by module.
Module 1: Introduction to Power BI for Finance
- Power BI overview
- Finance applications
- Power BI ecosystem
- Business intelligence concepts
- Financial analytics
- Reporting workflow
Module 2: Power BI Interface
- Power BI Desktop
- Report view
- Data view
- Model view
- Navigation
- Report development workflow
Module 3: Importing Financial Data
- Excel data
- CSV files
- Database connections
- Financial datasets
- Data sources
- Data refresh concepts
Module 4: Power Query Fundamentals
- Power Query Editor
- Data transformation
- Data cleaning
- Column operations
- Data types
- Query management
Module 5: Cleaning Financial Data
- Missing values
- Duplicate records
- Data formatting
- Error handling
- Financial data validation
- Data quality checks
Module 6: Financial Data Modelling
- Data models
- Relationships
- Fact tables
- Dimension tables
- Star schema
- Finance model design
Module 7: Introduction to DAX
- DAX fundamentals
- Measures
- Calculated columns
- Aggregations
- Financial calculations
- DAX syntax
Module 8: DAX for Financial Analysis
- SUM
- CALCULATE
- DIVIDE
- FILTER
- Conditional calculations
- Financial measures
Module 9: Time Intelligence with DAX
- Year-to-date
- Month-to-date
- Quarter-to-date
- Previous period
- Year-over-year analysis
- Period comparisons
Module 10: Financial Statement Dashboards
- Income statement
- Balance sheet
- Cash flow statement
- Financial metrics
- Report layouts
- Interactive analysis
Module 11: Budget vs Actual Analysis
- Budget data
- Actual performance
- Variance calculations
- Variance percentages
- Performance indicators
- Management insights
Module 12: Revenue Analysis
- Revenue trends
- Product revenue
- Customer revenue
- Regional analysis
- Growth analysis
- Revenue dashboards
Module 13: Cost & Expense Analysis
- Cost categories
- Expense trends
- Department analysis
- Cost variance
- Expense monitoring
- Cost dashboards
Module 14: Profitability Analysis
- Gross profit
- Operating profit
- Net profit
- Profit margins
- Product profitability
- Customer profitability
Module 15: Cash Flow Analysis
- Cash inflows
- Cash outflows
- Operating cash flow
- Cash trends
- Liquidity monitoring
- Cash flow dashboards
Module 16: Financial KPI Dashboards
- Revenue KPIs
- Profitability KPIs
- Liquidity KPIs
- Efficiency KPIs
- KPI cards
- Performance tracking
Module 17: Forecasting & Trend Analysis
- Historical trends
- Financial forecasting
- Growth patterns
- Trend lines
- Scenario insights
- Forecast visualization
Module 18: Interactive Financial Reports
- Slicers
- Filters
- Drill-down
- Drill-through
- Tooltips
- Report navigation
Module 19: Dashboard Design & Visualization
- Finance dashboard layouts
- Chart selection
- Conditional formatting
- Executive visuals
- Data storytelling
- User experience
Module 20: AI Features in Power BI
- AI-assisted insights
- Smart narratives
- Key influencers
- Anomaly detection
- Automated insights
- Responsible AI usage
Module 21: Publishing & Sharing Reports
- Power BI Service
- Publishing reports
- Workspaces
- Dashboards
- Data refresh
- Report sharing concepts
Module 22: Practical Finance Dashboard Project
- Financial data preparation
- Data modelling
- DAX measures
- Budget variance analysis
- KPI dashboard creation
- Executive finance report
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device