How We Helped:

During an initial Discovery phase, Inspire11 identified inefficiencies in the core solution and business processes that caused increased costs for the client. Additionally, Inspire11 found inconsistencies in the implementation of business logic flows that increased the complexity of system support and maintenance as well as dependencies on obsolete, unsupported technologies.

  • Multiple instances of redundant or unnecessary transformations between data landing and reporting layers
  • Business logic was applied unevenly across these different processing steps making it difficult to identify and remediate issues. For example, sometimes business logic would be contained within a BI tool, while other times it was in a staging layer
  •  Pervasive use of manual, Excel-based business reporting
  • Use of obsolete technology that were no longer being supported by the vendor

Inspire11 designed the new Modern Data Architecture (“MDA”) platform to address key areas of inefficiency in the legacy system. The new MDA platform simplified the end-to-end processing and improved solution reliability while providing business users with automated reports to streamline internal processes. At its core, our solution was designed for scalability by utilizing a metadata driven Extract, Load, Transform (ELT) framework and methodology that prioritizes reusable code components configured at runtime with metadata.

Our team relied on the following framework guiding principles:

  • Flexible & Extensible: Think big but start small
  • Nimble: Fast to setup and easy to adapt to change
  • Thrifty: Cost effective to build and maintain
  • Resilient: Processes run without special care and attention; resolve simple issues automatically
  • Lean Design: The solution is no more complicated than it absolutely needs to be  

In three months, Inspire11 performed the following activities:

  • Onboarded data from 5+ sources and hundreds of tables into a cloud-based Microsoft Azure environment
  • Eliminated 40% of redundant “hops” between landing and reporting layers
  • Enhanced data processing with a variety of cloud-enabled features: change tracking, exception handling rules, parallel processing, and hundreds of business transformations of varying complexity
  • Migrated heavily utilized reports into a Microsoft Power BI solution to demonstrate the reliability and performance benefits of the new environment
  • Business UAT process to ensure that migrated functionality met the specifications
  • Developed new and advanced capabilities with improved granularity of operations transactions