Financial Storytelling and Data Storytelling in #PowerBI

money-1604921_1920

As a consultant, I think it’s important to understand the numbers that make up a business. It means I can provide better advice to my customers since I can read their balance sheets, understand their financial statements, and translate these numbers into effective data visualization in tools such as Tableau and Power BI.

There are a number of accounting ratios which can be used to help determine the success – or otherwise – of a business. There is no ‘magic silver bullet’ that can help to determine definitively, but it is possible to put the ratios together to make a story that will help us to understand the business better. We can tell the story better through data visualization. So we move from data storytelling to finance storytelling.

Once we have the ‘story’ behind the accounting ratios, we can start to use these as a basis for storytelling in Power BI. In this blog series, we will start to look at the accounting ratios and how they are calculated. Then, we will look at how we can visualize this information in Power BI.

Accounting Ratios

Click here to see a bigger version.

Since we are looking at accounting ratios and how we can visualize them, let’s use this flow chart as a starting point. In the next topics, we will look at what these accounting ratios mean in more detail. We will also look at some of the McKinsey modelling, such as ROIC and the calculation of value.

One thought on “Financial Storytelling and Data Storytelling in #PowerBI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s