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
Related Articles
Accion Labs
8
min read
Demystifying Big Data Technologies
You hear a lot about Big Data these days. Industries from pharmaceuticals to auto-makers are using Big Data solutions to ...
Start Reading
Accion Labs
13
min read
Document Repository - A Big Data Processing Engine
ABSTRACT This case study outlines the architecture that was implemented to address the requirements of a government department ...
Start Reading
Pooja Salot
7
min read
How to minimize challenges to develop notification engines for a successful user engagement
Notifications are highly important when it comes to user engagement and interaction. Imagine if you can send and track all ...
Start Reading