Overview of the client
Our client is an American worldwide manufacturer, marketer and distributor of consumer and commercial products with a portfolio of various brands.
Business Challenges and Objectives
The client wanted to expand their decision making by using a lager set of external data along with enterprise data and was limited due to the existing Enterprise Data Warehouse’s capabilities and cost of storing large amounts of data.
- TekLink helped in defining the Architecture of new Data Platform with modern capabilities and lower cost using Microsoft Azure Synapse and Data Bricks.
- Designed a central framework and implemented our proposed solution for Modern Data Warehouse in a phased manner.
- Created an Azure Data Lake for the Storage of Raw and Refined Data for POS data received from various retailers and eCommerce sites. Point of Sale data from the various retail, eCommerce vendors is loaded, transformed and harmonized in Azure Synapse for Sales Analytics.
- Additionally, the sales data from the client’s US based distributor of consumer and commercial products from across the globe is pushed into the Analytics Model in Azure.
- The team then created a business-friendly semantic data layer using Azure Analysis Services. Dashboards and reports were created in Power BI for the business to use. In addition, Self-service was enabled for various User Groups using Power BI.
Key Project Benefits
- By leveraging our deep expertise, TekLink enabled our client to create a modern data platform to address their growing need for additional data and advanced analytics. The platform also empowered the business to use Self-Service Analytics and Reporting. This freed up valuable IT and finance resources towards other meaningful activities.
- Further, the platform enabled Business and IT teams to use the data for Advanced Analytics and building Machine Learning models such as analyzing product reviews, search terms from E-Commerce sites.
- The self-Service approach enables our Client’s decision-makers to react faster to business indicators and implement business decisions faster.