XTIVIA worked with LLS to resolve the challenges presented. The teams discussed the best approach for LLS. Following an assessment and roadmap phase, in which XTIVIA team interviewed key business users and assessed LLS data environment needs. XTIVIA used its team to design a report architecture that was flexible and quick to implement. XTIVIA worked closely with LLS executives and IT teams to outline key milestones and timelines. Together, XTIVIA and LLS implemented a robust BI reporting architecture solution. The reports measured a strategically important program and would lay the foundation for responsiveness going forward. XTIVIA streamlined those reports, creating a single repository for all measures.
XTIVIA followed best practices in designing the Report Architecture to be Scalable & Extensible with a ‘User First’ design. The design allowed users to filter data and drill to the lowest grain. The internal system designed by XTIVIA allows LLS to be dynamic in their reporting. They can now make revisions more quickly, while also reducing complexity for the users and managers by providing quality reports that are easy to understand.
XTIVIA was asked to create a dynamic report architecture that would change how LLS would maintain and access data and manage the campaigns effectively. Since LLS is a non-profit organization, time and clarity were of the essence. XTIVIA team worked closely with LLS to walk them step by step through the process. They overcame obstacles related to report organization, Microsoft® Excel compatibility, formatting and analytic capabilities. The results of XTIVIA’s collaboration with LLS produced reports that are more streamlined and easier to access in an intuitive user interface that both users and management can utilize. LLS’s initial vision of clarity and better time management became a reality through XTIVIA’s technical expertise and ability to communicate the knowledge. The project involved the creation of a star-schema data mart and the ETL required to populate this target schema. End users had access to the data through simple reports with variety of input controls so that they could slice/dice the information to quickly get to the answers they needed. The same data mart was utilized to populate interactive dashboard for the executives. This meant the entire organization had access to the data visualization and capabilities to analyze the data. Finally, the reports were embedded in the operational systems. This meant users had access to the intelligence when and where they needed it most.
Microsoft® SQL Server®
Senior Data Architect
Senior Jaspersoft Developer
320 hours over 3 months
Download the Case Study PDF here