Power BI: Essentials for Accountants

by

New to Power BI? This practical course guides you through building your first report step by step using a downloadable workbook, helping accountants gain confidence with data modelling, DAX measures and interactive reporting.

£150 +VAT

4 CPD hours

365 days’ access

Use ACPD101 for 10% off any purchase.
Power BI Essentials for Accountants

Power BI: Essentials for Accountants

£150 +VAT

4 CPD Course

365 days’ access

Use ACPD101 for 10% off any purchase.
Power BI Essentials for Accountants

Power BI: Essentials for Accountants

This course is not currently available. To find out more, please get in touch.

This course will enable you to

  • Recognise why Power BI is useful for accountants
  • Understand the roles of Power BI Desktop and the Power BI Service
  • Create, edit, and manage relationships between tables in Power BI
  • Use measures to calculate revenue, cost, profit, and profit margins
  • Design a structured and professional report layout using backgrounds and clear positioning

About the course

Power BI can be a powerful reporting tool for accountants, but getting started can feel daunting. The software combines data preparation, modelling, calculations and visual reporting, and unfamiliar concepts such as Power Query and DAX can make it seem more technical than it needs to be. This course provides a practical introduction that helps you understand how Power BI fits into a typical reporting workflow and how it can support clearer, more insightful financial reporting.

Working through a downloadable workbook alongside the course, you’ll build your own Power BI report step by step. You’ll learn how to import and transform data, create a structured data model, manage relationships between fact and dimension tables, build measures for revenue, cost, profit and year-on-year analysis, and design professional reports using cards, charts, tables, conditional formatting, slicers and interactive visuals.

You’ll come away with a working understanding of how Power BI Desktop and the Power BI Service work together, along with practical experience of building and formatting your own report from start to finish. This course will give you the confidence to organise data effectively, create reliable calculations and produce clear, interactive reports that colleagues and stakeholders can explore and use.

Contents

The fundamentals

Getting started
What is Power BI?
Desktop and service
Power BI Desktop and Service
The reporting workflow
Combining data from multiple files
Transforming data
Getting more data
Managing your data connections
Documenting your steps

Building a data model

Getting started
Why relationships matter
Building table relationships
Managing relationships
Formatting and hiding columns
Date tables
Creating a date table
Adding reporting columns
Sorting columns

Creating measures

Getting started
Measures
First measures
Building more measures
Filter context
Year-on-year analysis
Organising measures

Building your report

Getting started
Designing the report layout
Card visuals
Comparison values
Conditional formatting
Adding a top N table
Using drill down
Slicers
Clear slicers
Configuring visuals

Author

Alan Murray

Alan Murray

Alan has over 20 years” experience as an Excel trainer and loves to help companies improve their business processes and learn how to harness the power of Excel.