Pimp my Spreadsheet; Power BI brings numbers to life
Track: Analytics and Visualization
Investment Sensitivity Analysis using Power BI over an Excel financial model.
Each of the 3 key steps are introduced and demonstrated.
1) Best practice financial model in Excel using the FAST standard and driver based scenarios;
2) A simple VBA macro script to integrate Excel and Power BI
3) Dashboards and reports in Power BI to inform investors with visual interactive storyboards.