Home > Geospatial Data Ingestion

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

Speak to AI expert