Industry: Technology

TechVariable creates solution that speeds up data collection, improves accuracy and generates real-time reports of trends

0 Engineers
0 Months
0% Increase in Tech Efficiency

Services

Product Engineering, Application Modernization, ETL as a Service

Technology

AWS, Node.js, Python, React.js, Mongo DB, Tableau, Kibana

Location

Malaysia

Interested?

Estimate a project

Overview

We developed a one-stop module for a Malaysian client that provides an interface between multiple, disparate data sources for generating business KPIs.

The client is an HR tech giant that provides its customers with Key Performance Indicators (KPIs).

The customers can now pull data from multiple, disjointed data sources to generate meaningful, holistic insights and KPIs. And the automation through schedulers and data push to BI systems increases the efficiency of the KPI generation

Challenges

A Malaysian news agency wanted to automate insight-mining from enormous amounts of data collected from various disparate sources, so they could speed up generation of useful reports on key societal trends. Their reports were often used by the government to understand trends such as drug usage. Currently, data was being captured from social media, newspapers and physical scanning of documents, before being manually stored in spreadsheets and analysed for trends.

The current process was labor-intensive, time consuming and inefficient. It was also prone to errors and was not very scalable.

Technical challenges in existing solution

Manual data entry: Data from different sources was manually entered into spreadsheets.

No standardization: Data came in different formats, sizes and languages, and needed to be harmonized.

Limitations on number of requests handled: Current AWS Lambda services had limitations on the number of requests processed at any given time.

Lack of customization: No access control through role management.

Reports lacked insights: No visualization of data to report high level trends.

Solutions

TechVariable built a platform that automated data collection and segregation, harmonized different file types into a cohesive set of data files, and enabled the generation of reports with data visualization in real-time. With an easy-to-use, interactive and customized user interface solution, we created three automated data pipelines:

We created three automated data pipelines:

Pipeline 1: A custom scraping engine collects data from all online sources, extracts data from hardcopy formats, PDFs and jpegs using Optical Character Recognition (OCR), and summarizes lengthy articles according to identified keywords.
Pipeline 2: Video transcription using Google APIs to process video and audio files from YouTube or otherwise.
Pipeline 3: : A custom-built mechanism for online sources that segregates hashtags, keywords, stories, etc. for further processing.

Need a custom software application for your business?

We at TechVarible do acknowledge that one size will not fit all. Hence, we work in collaboration with you to identidy, analyze & then develop a solution that fulfils your needs.

Either we will define the functional scope of your project to estimate the timeline and budget or you can create your own agile team from among our recources.

Book a Call

High Level Design Architecture

The Result

  1. The new platform leverages next-generation technologies to perform data collection, processing and analysis in real time.
  2. Improved efficiency, accuracy and scalability as a result of automated data collection.
  3. Ability to conduct sentiments analysis on more than 100,000-150,000 posts a month on various parameters.
  4. Reduced the number of resources/man-hours required.
  5. Improved the ability to handle spikes in data generation and volumes of requests.
  6. Enabled customization with user access control, advanced filters and search capabilities.
  7. Enabled auto-visualization and reporting in real-time.

Modules Implemented

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.

Help us understand your requirement

Staff Augmentation

"*" indicates required fields

Which developer are you looking to hire?*
How many years of experience do you need?*
How soon are you looking to fill this position?*
Upload your JD
Max. file size: 25 MB.
Or