A solution to last week’s challenge can be found here.
The results of last week's exercise were again well received by the International Bank of Awesome Data (IBAD) leadership team - well done, Secret Assistants to the Regional Manager! There was one objection though, from those troublemakers in the Antarctica branch... apparently those guys like to see their data in a prettier format than just a data table in a file. Guess we can't blame them - everyone loves a good visualization!
So the final task on your mission to make the IBAD's awesome data even more awesome is to make it pretty!! This week's challenge is a lot more flexible - there are a few key elements we'd like to make sure are included in the final reports, but the overall format is up to you! The main goal is to make sure the final report has, at a minimum, the following key metrics displayed for the bank overall:
REQUIRED ELEMENTS:
- Appropriate headers/footers/subheaders showing Report Title, today's date, Assistant to the Regional Manager's name (if applicable), etc.
- A section highlighting key total metrics:
- Avg Daily Balance
- Overall % change (should be red font if negative, green font if positive)
- Count of Customers
- Ending Balance
- A chart showing the % of overall total debits & credits for the month by branch
- A chart showing the count of customers by branch
Beyond these required elements, the rest is up to you! Formatting, charts, batched reports... be creative!
SOME IDEAS:
- A section highlighting "best branch of the month", i.e. the bank with the largest percentage increase in bank balance over the course of the month
- A "naughty list" for the lowest performing banks (largest percentage decrease in bank balance)
- A recap of totals by transaction type across all branches
- A graph showing overall daily balance, with differentiation for cleared vs uncleared balances
- Any other metrics, trends, etc. that you find interesting!!
- Make it an app, so the Assistants to the Regional Manager can select their name from a dropdown to get a customized output!
The IBAD leadership team can't wait to see what you come up with... You can have this on their desks by end of day, right?
