Human-AI synergy in Retail
Using Human-AI partnership for Improving customer experience and
business processes in the retail industry
Automated Data Ingestion Framework
US based multinational retail corporation, wanted to ingest data from multiple RDBMS sources. Abzooba developed a batch processing framework to ingest the data from different sources to a managed data lake which uses Hadoop for file processing.
Unified customer view by ingestion of customer and sales data
Data Ingestion & Transformation
A global retail conglomerates’ US arm wanted to fetch data from existing multivariate sources, perform transformations, and write it back to destination storage. Abzooba created data pipelines in Azure Data Factory to store source data, intermediate and destination data in ADLS Gen2. Azure Databricks was leveraged to create ETL pipelines.
Output files(CSV) on runtime (either once or multiple times a day)
Data Ingestion and Transformation from On Premise to Azure Cloud
US based flagship shopping channel and e-commerce retailer wanted to ingest and transform data for various markets from on-premise to Azure Cloud. Abzooba developed a metadata driven processing framework which dynamically handles multiple source files coming from various markets by fetching the configuration values from underlying metadata tables.
Scheduling and automation of pipeline runs with minimal configurations
Geospatial Data Ingestion
A global FMCG giant uses global positioning system fleet management and vehicle tracking software – Geotab.
Communicating with Geotab database through API has limitation of 50000 records per API-call. Abzooba developed a cloud based solution to ingest the data from Geotab databases to a managed data lake.
Managed data lake to provide complete dataset for analysis
Data Lake Creation & Reporting Services
A global retail conglomerates’ US arm wanted to create a strong foundational framework on Azure to support reporting, analytical and archival needs. Abzooba created a Data Lake in Azure Data Lake Storage and a Data Warehouse to store all final transformed data with Power BI connected to it for report generation.
Increase efficiency and effectiveness of reporting while supporting a monthly data volume of over 2TB
Multi-Source Data Ingestion To a Managed Data Lake
A global FMCG giant wanted to ingest data from various data sources into data lake
and serve the same among various teams for analytics and machine learning. Abzooba developed a cloud based solution to ingest data from multiple sources to a managed data lake.
Minimize cost and give insights for end users
Data Intelligence Management & Analytics
R&D team, Data Scientists, Product Developers, and other users of a Fortune 500 FMCG company need to search for projects/products based on contextual sentences. Abzooba’s solution allow users to cognitively search for projects/products, add selected items to a cart, check out the cart and prepare related files.
Reduced time to analyze data by ~75%
Reduced admin and infrastructure cost by ~50%
Data Lake Administration & Maintenance
A major global F&B corporation wanted support to manage and maintain data lake with real-time integration to marketing, shipping, logistics, sales and customer data. Abzooba supports maintenance activities for the data lake and manages downstream analytics tools.
Reduced admin and infrastructure cost by more than 50%
