LEUKEMIA & LYMPHOMA SOCIETY®: BUSINESS INTELLIGENCE
Our client, The Leukemia & Lymphoma Society®, is a non-profit that funds lifesaving cancer research around the world. The organization is the largest voluntary health organization for blood cancer research in the world. LLS wanted to move from a cumbersome reporting system using an industry leading but expensive tool to an internally supported flexible reporting system built around Jasperserver. Creating this system required knowledge and skills regarding best practices around data management, team support for BI development and documentation, and expert project management. The client also needed a trusted partner who could not only build the new reporting capabilities rapidly but also transfer the knowledge.
The Leukemia & Lymphoma Society is a non-profit organization that funds life-saving cancer research around the world. LLS wanted to move from a cumbersome reporting system using an industry-leading (but expensive) tool to an internally supported flexible reporting system built around Jasperserver. Creating this system required knowledge and skills regarding best practices around data management, team support for BI development and documentation, and expert project management.
The first challenge presented was identifying Report architecture not suited to business processes and operational needs. Additionally, a lack of resources made it difficult for LLS to implement data management best practices to leverage the best outcome. The existing reporting sub-system was difficult to navigate (e.g. reports that ran multiple pages horizontally as well as vertically.) The reports could not be exported to excel and shared with team members. The formatting of the reports while somewhat useful, was not built with visual cues for easier access. The reports had limited analytical capabilities (parameters, filters etc.) yet execution time was longer.
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