AUTOMATED FINANCIAL STATEMENTS ANALYSIS


Profit and Loss statement analysis:
This is very good for financial analysis of the different business units, here we can see the current month financial vs. same month last year with the %change. I am also covering here Year to date (YTD) financial with same period last year. The picture is showing a very simple ERD which i used among the tables.

Please see the table given below, this is based on embed code. All the visuals are interactive, you just need to select the business unit and the month, all the visuals will update accordingly.
CAGR i.e. compound annual growth rate is also worked on which vary with changes in the year. 
You can also check profitability trend and cost trend.

Comments

Post a Comment

Popular posts from this blog

Dynamically Embed a Web Page in a Power BI Report

Today I learnt a new thing from BI Elite which I am sharing with you. Now in a one window, one can study different blogs. I am using power bi for compiling different blogs from where you can learn a lot of things regarding Microsoft Power BI. You can also see my blog named “Power BI Lover”, which I used for analyzing and presenting different sort of information. 
Read more

Performance Analysis- with using Multi task visual

Great for displaying multiple KPIs in a single visual. The custom visual is published by Microsoft. In the visual multiple areas can be analyzed. Here I am analyzing total sales, total cost, total profit, average rate and quantity of my company in a particular date. Month Slicer can be used to see the behavior of your variables in different time scales. Moreover, the Product Slicer will also help to see the trend behavior of all the products or can see a single product. The important thing is that the chart has two areas one is Main Chart the other is Sparkline Chart. In our example the Main Chart by default will show the sold product quantity trend on the different date, whereas Sparkline Chart by default will show the trend behavior of sales, cost, profit and average rate. If you are interested in to see the trend of sales in Main chart you just need 1 st hover on the sales in sparkline area and then move to Main chart, you will see the sales trend over there. Th same ca
Read more

Ad Revenue Prediction

This is the post regaring the ad revenue projection based on different features. I have thaken a data of ad revenue , ratinh and channels where my target column is ad revene which I estimated based on the rating. The rating has a coefficien of determaion of 94% showing a high dependednce on each other. Please click on the link and project the revenue based on your desired rating. Please first click Read More and then click this link.  Click_here
Read more