Get in Touch
 Duration 14 hours

Course Outline

Introduction to Power BI

  • Exploring the Power BI ecosystem
  • Mastering the Power BI Desktop interface
  • Establishing connections to standard data sources

Data Preparation and Transformation

  • Utilising Power Query for data cleansing
  • Structuring and reshaping data
  • Overseeing and merging queries

Core Principles of Data Modelling

  • Establishing relationships between tables
  • Managing data types and hierarchical structures
  • Constructing star schema models

Creating Visualisations

  • Choosing appropriate visuals for specific data sets
  • Refining and customising charts and visuals
  • Implementing slicers and filters strategically

Essential DAX Concepts

  • Grasping calculated columns and measures
  • Employing standard DAX functions
  • Applying time intelligence principles

Advanced Analytics and Reporting

  • Developing drill-through and tooltip pages
  • Elevating dashboards with advanced visual elements
  • Applying conditional formatting rules

Publishing and Disseminating Insights

  • Deploying reports to the Power BI Service
  • Administering workspaces and access controls
  • Distributing dashboards across team structures

Performance Optimisation and Governance

  • Enhancing the performance of data models
  • Adhering to governance and compliance standards
  • Setting up dataset refresh strategies

Summary and Future Directions

Requirements

  • A foundational understanding of data concepts
  • Practical experience with spreadsheets or tabular data structures
  • Awareness of basic reporting processes

Target Audience

  • Business analysts
  • Corporate professionals engaged in data-centric roles
  • Individuals responsible for creating dashboards and reports

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from £3200 + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (2)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories