Microsoft income statement – FY18 Q4 financial results in Power BI

On July 19, 2018, Microsoft Corp. announced the financial results for the quarter ended June 30, 2018, as compared to the corresponding period of last fiscal year.

The results are impressive, for example:

  • Revenue was $30.1 billion and increased 17%
  • Operating income was $10.4 billion and increased 35%
  • Net income was $8.9 billion GAAP and $8.8 billion non-GAAP

But what caught my attention, was the fact the press release included only standard tables with additional downloadable Excel, PowerPoint, and Word documents.

So my immediate thought was, where's the Power BI presentation of these fabulous results???

So I tried to redesign the tables in an attempt to present the financial results in a clearest possible way, by leveraging the amazing Power BI capabilities, together with the advanced visualization capabilities of Zebra BI visuals for Power BI.

Alright, here we go:

 

View as PDF

 

What do you think? Please let me know in the comments!

 

Note: This is not an official presentation of Microsoft Corp. financial results. It's just a quick study of how financial data such as income statements can be visualized in a clear and understandable way in Power BI as an alternative to standard data tables.

Source: Microsoft Corp. Earnings Release FY18 Q4

Zebra BI visuals for Power BI can be downloaded at https://zebrabi.com/pbi

 

3 replies
  1. Ron
    Ron says:

    "Before" picture of original statements would be helpful for comparison.

    I like the dynamic option I noticed in one of the slides. It would be helpful if there was a note to inform users how to use the feature. I recognized it from a PivotTable slicer, but for anyone who was not familiar with slicers they could thing that it was just static text.

    Reply
  2. Andrej Lapajne
    Andrej Lapajne says:

    Hi Ron, here's the how-to article on how to set up the overlay charts (called 'Report Page Tooltips' in Power BI): https://zebrabi.com/pbi/use-report-page-tooltips-provide-details/

    Next, here you can download a PBIX example of monthly P&Ls that demonstrates all the features presented in the Microsoft makeover: https://zebrabi.com/pbi/beautiful-income-statements-power-bi/

    We have a step-by-step article on how to set up Income statements in Power BI with a downloadable sample file here: https://zebrabi.com/pbi/income-statement/

    Finally, you will find a 1-hour detailed webinar recording that covers this topic here: https://zebrabi.com/income-statements-power-bi-webinar/

    Hope this is helpful 🙂

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *