2 Days | Class based & Online

This introductory/intermediate course provides a comprehensive, hands-on foundation in Microsoft Power BI, enabling participants to quickly build practical data analysis and reporting skills. Through guided exercises and expert instruction, learners will explore key features of Power BI, including data modelling, visualisation, and interactive reporting. The course is structured into clear, actionable modules that ensure all participants progress with confidence. By the end of the program, attendees will be proficient Power BI users able to create insightful, visually engaging dashboards that support data-driven decision-making.

Course Content:

1. Understanding Power BI and Its Business Applications
   Explore when and how Power BI supports data analysis, reporting, and corporate decision-making.
2. Power BI Desktop Installation, Licensing, and Version Options
   Gain clarity on setup requirements, licensing models, and feature differences.
3. Connecting to diverse data sources
   Import data from files, databases, online sources, and enterprise systems.
4. Managing and Repointing Data Sources
   Update and reconnect to moved or relocated data without rebuilding reports.
5. Data Cleaning and Preparation Techniques
   Remove unnecessary rows and columns to create clean, reliable datasets.
6. Transforming Data Types and Applying Essential Data Shaping Tools
   Correct data types and apply filters, grouping, splitting, and duplication tools to refine data.
7. Combining Data Using Append and Merge
   Integrate datasets to create unified, analysis-ready tables.
8. Pivoting and Unpivoting Data for Analysis
   Restructure datasets to support flexible reporting and modelling.
9. Creating Custom, Conditional, and Calculated Columns
   Build logic-driven columns, apply custom functions, and enhance dataset intelligence.
10. Using Indexing and Extraction Tools
    Add indexing fields and extract values to support advanced transformations.
11. Building a Robust Data Model with Relationships and Join Types
    Understand join kinds, manage relationships, and optimise model structure.
12. Creating Hierarchies and Working with Related Tables
    Build drill-down structures and leverage table relationships for richer reporting.
13. Introduction to DAX: Formulas, Measures, and Quick Measures
    Develop analytical calculations using foundational DAX functions.
14. Creating and Managing Date Tables
    Implement date table rules, configure internal versus external date tables, and optimise time intelligence.
15. Best Practices for Modelling, Performance, and Report Design
    Apply professional standards for building efficient, scalable, and reliable Power BI reports.

Learning objectives: