Industry
Retail
Challenges
Solution
Challenge
- Disparate data sources which are utilised by different functions for manual analysis and campaigns
- Broken reporting, siloed within functions
- No single source of truth and a common definition and documentation of KPIs and Reports
- Manual Data collation and aggregation with little or no historical trace
Solution
- Create a single source of truth for all departments
- Ingest and Integrate from different data sources
- Augment with 3rd party data sources
- Define and Consolidate the KPIs across different departments
- Data Democratisation - Enabled access using RBAC to various business teams along with the Data Catalogue and Lineage to help them discover the data as per their needs
Business value delivered
- Data consolidation of not only 1st party data sources but 2nd and 3rd party as well
- Single source of truth with a standardised definition of the KPIs across departments
- Multi-tiered Processing and AI/ML support
- Centralised access and usage control
- Reduction of time to implement other use cases
- Data Accessibility at the most granular level - right from the senior stakeholders to the on-ground sales team
Technology deployed
- Snowflake
- Databricks + PySpark
- S3
- AWS Data Migration Service
- Tableau