Data Warehouse and Analytics

Technologies used
Azure data factory
Snowflake
PowerBI
Azure functions
Python
Challenges
Separate data across different source system
Time consuming data access/ fetching process
No central data warehouse and scattered data not aligned at company level
Time to access data was affecting crucial & timely decision making
Solutions
Detailed understanding of existing source system and designing data warehouse accordingly
Quick and efficient data warehouse implementation using Inferenz framework
Single source of truth for all the reports, dashboard and ad-hoc reporting
Integrated view of data from different acquisitions and tuck in single warehouse
Benefits
Reflect Sales, Revenue and Payroll in timely manner for executive business decisions
Increased in power and speed of data analytics
Consolidated company wide view in mist of all the ongoing acquisition in very less time frame
Cutting edge technology