Financial Reporting with Power BI Course
The syllabus is organised into a series of modules, each presented as a series of “challenges” – a specific requirement from your stakeholders or a task that you need to complete as part of your reporting solution. Through each challenge, you will have the opportunity to not just learn the features of Power BI, but will also be able to practice with interactive “try it out” exercises, quiz questions and downloadable templates In MS Word/Excel.
Each challenge consists of a number of micro-learning lessons and is expected to take circa 1-2 hours to complete You can come back and complete lessons over time though please ensure you allocate sufficient time to complete the exercises and activities in each lesson.
Click/Scroll across for the content in each module
Introduction
In the Introduction module we will look at the current situation (building Financial Statements with Excel), the Actuals/Budget dataset and the example solution we will end up with at the end of the course.
Content
Requirements and Data Model Design
Before you just load the data into Power BI, you need to think, somewhat obsessively, about the audience for it.
A report which is aimed at technical analysts who need to drill into details should be quite different to that aimed at an executive audience who perhaps just want high level numbers.
Once you know the audience, start with identifying the user stories/problem statements and the business questions that they need the report to answer.
Then define the calculations that you will need in order to answer them and design the data model – the tables of data behind the Power BI report – accordingly.
Lastly, you will need to consider how your audience will consume the report and what features, within both the report itself and the Power BI platform more generally, they will be expected to use.
