Empowering BI with a Transformative Data Analysis Dashboard for a Top Online Jewelry Retailer

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