Empowering BI with a Transformative Data Analysis Dashboard for a Top Online Jewelry Retailer
BI and Data Analytics
Read Complete story
Synopsis
Technology Stack
SQL Server
Power BI
Python
Client Overview
The client is a multi-national electronic retailer, wholesaler and manufacturer of fashion jewelry and lifestyle accessories.
Challenge
The client wanted to consolidate different heterogeneous sources of data altogether at one place enabling business users to get insights across regions & in variant time.
Solution
Using the customer purchase data, customers are segmented based on the frequency of their orders, amount spent & the number of orders placed by them.
A tabular model was developed to directly connect Power BI with Live data warehouse and a dashboard was created to help identify products performance & their allocation.
Integrated the Weather API to further enhance the purchase pattern of the customers.
Some features of the portal helps in:
Identifying customer segment to be focused for promotions & to increase business.
Identifying purchase pattern of the customers with the help of detailed weather information, hence increasing/decreasing the products accordingly.
Outcome
Future analysis with reports of current & past data
Better purchase analysis leading to increased sales
I’m Q. How can I help?