Internship - Data Analyst


If you’re reading this, then you’ve  been shortlisted for a 2 months internship at Business Quant.

We hope you’ve read the internship posting in full. 

Please complete and submit the assignment below, by 4pm Tuesday, 18.2.2020, for us to take this forward.

Here’s the source file.

The supporting definitions can be found here. These will help you in understand financial terms. 

Now, please create a balance sheet out of this data in Power BI.  Tableau also works but it doesn’t have an in built ETL, so you’ll only be making it harder for yourself by going with Tableau.

Anyway, a balance sheet looks like this –

Please create a similarly laid out balance sheet, with user selectable filters for:

  • Period range
  • Company, currently there are three in the data file.


PS: Solution shared below. 

Feel free to reach out if you have any doubts.

Good Luck!
Piyush Arora