Financial Reporting with Dashboards in Power BI

This book is the result of many years of experience in financial reporting as a professional accountant. It starts with a short presentation of Power BI, which is a free software that has to be installed on your computer. If you do not have it yet, the first chapter will show you how to download and install Power BI.

In order to show how to create financial reports, this book uses financial data from a fictional company. The reader can download all the files necessary to follow the process of financial reporting.

The book is showing screenshots to indicate where to click in Power BI in order to create the reports I am using as examples. It also has short videos to show how to follow these examples in Power BI. This is not a theoretical book about financial reporting; it is a step-by-step approach in creating reliable financial reports with examples.

It starts by showing you how to create the Income Statement and the Balance Sheet of an organization. Then, it continues with reports suitable for financial analysis. The reader is introduced to dashboards to be used in management discussion and analysis.

After following the examples in this book, the reader will know how to use most of the Power BI visuals. Some of the visuals like slicers, tables, matrices, charts, gauge and tachometer for financial reporting are discussed in detail and presented with formatting options.

The book explains how to use these visuals for variance analysis so that the financial reports users can instantly understand the progress in operations.

The last 2 chapters of the book explain how to use these reports as templates even when there is a change in reporting requirements. When new data become available at the end of a period, you only need to click a refresh button in Power BI in order to have updated reports.

The examples in this book are explained in such a detail that you will know how to upload your own data to create financial reports for your own needs.

The book provides a link to a feedback page where you can ask technical questions about the methods presented.

I will promptly answer any concerns related to the book.

Thank you for considering Financial Reporting with Dashboards in Power BI.