Center for Medicare/Medicaid Studies: Business Intelligence Projects Dashboard
The Center for Medicare/Medicaid Studies is tasked with implementing numerous projects related to the Affordable Care Act. They use Microsoft Project to manage these projects. However, other important sources of data on their projects – including their funding status and their position in a multidimensional priority matrix – came from data outside MS Project, making it impossible to use MS Project's native reporting capabilities to generate the detailed reports they needed to see. They commissioned a pilot project to explore the capabilities of Microsoft's SharePoint 2010 and SQL Server based business intelligence stack.
Performance Period | May 2012 – July 2012 | CMS Pilot Dashboard, main page Projects In Progress Scorecard and KPI Endangered Projects Dashboard |
Number of Users | 18,000 Agency-wide | |
Technical Accomplishments | We designed an interactive dashboard, built on top of a cube made from their data, to enable them to view their projects by status and from multiple perspectives.
| |
Results Achieved |
| |
Contact | Keith Belk, Day1Solutions |
/cms-capms%20bi%202012-2.png?ctag=230531)
/cms-capms%20bi%202012-3.png?ctag=230531)
