I have built something extremely similar using PowerPivot and Excel to create balanced scorecards with drill down KPIs and metrics. I have over fifteen years experience utilising Excel, VBA, SQL, Access, and (more recently) PowerPivot to build custom reporting suites and would love to work with you on your project!