Get in Touch
 Duration 14 hours

Course Outline

Introduction to Power BI

  • Exploring the Power BI ecosystem
  • Navigating the Power BI Desktop interface
  • Connecting to common data sources

Data Preparation and Transformation

  • Utilising Power Query for data cleaning
  • Shaping and transforming data
  • Managing and combining queries

Data Modelling Fundamentals

  • Establishing relationships between tables
  • Working with data types and hierarchies
  • Constructing star schemas

Building Visualisations

  • Selecting appropriate visuals for your data
  • Customising charts and visuals
  • Effective use of slicers and filters

DAX Essentials

  • Understanding calculated columns and measures
  • Applying common DAX functions
  • Implementing time intelligence concepts

Advanced Analytics and Reporting

  • Creating drill-through and tooltip pages
  • Enhancing dashboards with advanced visuals
  • Applying conditional formatting

Publishing and Sharing Insights

  • Publishing reports to Power BI Service
  • Managing workspaces and access rights
  • Sharing dashboards across teams

Optimising Performance and Governance

  • Improving data model performance
  • Adhering to governance and compliance practices
  • Implementing dataset refresh strategies

Summary and Next Steps

Requirements

  • A foundational understanding of data concepts
  • Experience working with spreadsheets or tabular data
  • Familiarity with basic reporting tasks

Target Audience

  • Business analysts
  • Corporate professionals working with data
  • Users requiring the creation of dashboards and reports

Testimonials (2)

Upcoming Courses

Related Categories