Power BI Course: Monthly Financial Reporting
Learn Power BI to automate financial reporting and engage your audience.
This course is for:
Accounting & Finance and Analysts

Target Audience
Accounting & Finance professionals or those with regular financial or commercial reporting duties.

Existing Ability Level
Beginner/Intermediate - no prior knowledge required. Those with existing experience can benefit from a range of techniques.

Objective
Automate your monthly financial reporting duties and significantly increase the value your reporting provides your audience.
What is Power BI Monthly Financial Reporting?
Accounting & Finance professionals, with no prior knowledge of Power BI, learn to use the application to automate and transform their monthly reporting duties.
Learning Power BI is framed in the context of the challenges accountants face each month in their reporting and the solutions that the application provides. Aside from learning to create a range of relevant, compelling reports and dynamic commentaries, the user learns how this saves time, increases the accuracy and trustworthiness of reporting, and empowers the business to utilise the reports to find information themselves.
The learning is set in the context of a fictional gym equipment wholesaler, Workout Warehouse, and is underpinned by realistic budgetary, forecast and actuals financial data, as well as customer, staff and company data.
The Power BI course is taught through:
> Short video lectures explaining the theory,
> Report building video walkthroughs to put the learning into practice,
> Challenging exercises to utilise the reports you create,
> Regular quizzes to test your knowledge,
> Comprehensive course slide deck to support your learning.
For further information see the Course Content and Course Overview sections below.
The course provided me with the essential foundations in data structure, mapping, and reporting, enabling me to create impactful dashboards from scratch.
It not only saved me time and streamlined processes but also empowered me to deliver innovative solutions that added significant value to our business.
Pieria, Finance Business Partner
Inspire Payments
Course Content
Course Aim, Structure & Fundamentals
Import & Transform Data
Creating the Data Model
Data Analysis Expressions (DAX)
Creating Reports & Visualisations
Sharing Reports
Course Overview
Automate your month-end reporting to save you time, reduce risk and deliver more value to the business.
About
This Power BI course has two aims: to teach you Power BI from scratch and to transform your monthly financial reporting. It’s developed by accountants for accountants. Comprehensive and realistic accounts data has been produced to allow for the creation of reports relevant to Finance professionals. And throughout, the learning is framed in the context of what the traditional month-end problems are and how Power BI can solve them.
Result
You'll be an intermediate in Power BI, full of ideas to apply to your work. You’ll be able to automate your month-end – saving you time; reduce errors and subsequent rework – increasing accuracy and trust and saving you time; and shift towards self-service reporting – empowering the business to find answers themselves in the reports you provide…saving you time!
Format
The course consists of short video lectures covering the theory, followed by practical demonstrations in Power BI of how it is applied in the creation of reports. Participants are invited to follow along in the report build, test their knowledge with regular quizzes, and utilise the reports to answer a range of month-end inspired questions.
Requirements
No previous experience in Power BI is required.
Power BI Course Contributor: Oliver Deacon
Microsoft Finance Director, Finance Leadership Coach
This Power BI course has been built in collaboration with Oliver Deacon, who spent several years as a Finance Director at Microsoft in Seattle, where he worked at the cutting edge of leveraging technology and data in financial and commercial reporting.
He experienced firsthand the value generated by using these technologies to redesign processes, raise the quality of output while reducing the time spent doing so, and extract more value and insight from the organisation’s data.
Oliver now coaches senior finance leaders on navigating the changing finance environment, building high-performing, motivated teams, and embracing the next generation of technologies.

"As a former Microsoft Finance Director, I know how crucial effective month-end reporting to drive action is. We spend so long building manual reports, only for the business to ask us for a different cut or more data – if they even look at them at all!
We built this Power BI course to provide finance teams with everything they need to create insightful and actionable commercial month-end reports. It focuses exclusively on finance reporting, helping you generate more engaging reports and scale your impact by enabling the business to self-serve.
Join this course to turbocharge your reporting process, produce valuable insights, and empower your organisation with reporting that leads to insight and action."
Why is Power BI the solution?
> Microsoft is the leader in Business Intelligence (Gartner). Its size and dominance suggests its BI solutions will become standard and business will invest in training.
> Power BI is built into the Microsoft ecosystem and shares similarities with Excel (e.g. interface, DAX language), making it easier to adopt by accountants.
> Data (financial and non-financial) can be taken, combined and utilised from a wide range of sources.
> It offers a complete solution: transforming data, performing advanced, standardised calculations, and then creating an array of powerful visualisations in a relatively intuitive way.
> Power BI reports and visualisations, once created, are quick to update - freeing time for analysis and insights.
> Finance can share reporting with a wide-range of stakeholders and define access by user - raising security.
> Users can self-serve on reporting to further explore insights themselves, freeing up Finance time.

Automating & Adding Value to Monthly Reporting

> Power BI drives a flywheel - it can free up time to reinvest in productivity initiatives and more automation, in turn freeing up more time whilst raising quality of work.
> An upfront investment of time, learning and creating month end reporting in Power BI will save time in perpetuity by automating manual processes, reducing errors and removing unnecessary elements of business partnering.
> The month-end process is therefore an excellent gateway to learning Power BI as there is such a high ROI on the time invested to learn and then create the process.
> Time can subsequently be redeployed into the application of Power BI and automation in other tasks, and general adoption of big data and business intelligence by Finance.

Superb way to learn Power BI! Clearly geared to accountants and the financial reporting process.
Khilan, Head of Strategic Planning
David Lloyd Leisure
Pricing
Invest in Yourself... Today!