Geospatial Data Ingestion
Client
For a global FMCG giant
Business Problem
- Our client uses Geotab, a global positioning system
- Communicating with Geotab database through API has limitation of 50000 records per API-call
- It is difficult to analyze partial results received through each API call
Abzooba’s Solution:
- Reporting components (semantic layers & reports/ dashboards) for ~35 views
- Specialized data store/table structure and data refresh approach
- Extraction of actuals & forecast from Workday
- Ingestion of consolidated data back into Workday
- Data collation (Actuals – available entries in Workday + Current Year)
Business Benefits:
Managed data lake to provide complete dataset for analysis
Tech Stack
