When the project began, the front end reporting system included over 250 hard-coded SSRS reports and 100 Tableau dashboards. The user community was frustrated with issues regarding performance, reliability, and accuracy. The software limited APUS from implementing a strong governance and master data management process which led to an extensive change control log which had requests going back over one year. Our team partnered with the existing Data Warehouse resources to replace the failing data warehouse with MicroStrategy, SSIS, and SQL Server 2012.
We provided business analysis and technical resources to help support the APUS transition to a new BI platform. Services included all standard BI SDLC functions including: program management, data analysis, requirements, design, testing, and support of production deployments. We also provided guidance on BI best practices, organizational structure, and helped prioritize the work effort across the teams. Our experts helped APUS address widespread inconsistencies between KPIs across departments. Additionally, we worked with executive stakeholders to establish a BI Competency Center which included users from all departments and helped formulate enterprise data governance standards, which improved consistency across the organization.