A Tennessee, USA based Healthcare technology company that builds software, analytics, network solutions, and technology-enabled services was looking to build data visualization tool to create actionable insights for product optimization.
Accion Labs developed a Business Intelligence application using Tableau to help the customer consolidate KPIs across the company and optimize products they offered.
CHALLENGES
- Inability to collect, visualize and consolidate KPIs from clients’ various Business Units
- Data integrity issues due to fragmentation of data across different systems as a result of M&As, rapid growth and increase in number of products offered
- Difficulty in collating all data from diverse on-premise source systems and flat files to ingest into a cloud-based AWS Redshift Data Warehouse
SOLUTION
- Transform staging data and place it into Product Analytics Data Mart database
- Build and deliver a logical and physical data model for the Data store
- Developed automated data ingestion routines to source data from various business units
- Design and execute functional and regression test cases for data ingestion routines
- Use AWS S3 buckets to handle huge data volumes
- Assist Operations team in rollout activities and creating handover artifacts
TECHNOLOGY STACK
App Services and Integration: Tableau, Talend Data Integration
Databases and Indexing Engines: Amazon Redshift, MS SQL Server, Oracle, Salesforce, SBP, Essbase
Cloud Infrastructure: Amazon Web Services
DevOps: Jenkins, GitLab, Jira
ACHIEVEMENTS/RESULTS
- Ready availability of actionable data for improved decision making and analysis
- Data accumulated over time to be utilized to lead change by enabling smarter healthcare
- Enable consistent KPI metrics across business units
- Reduce wastage and improve process efficiency to simplify administration and enhance payment processing for the client’s customers