Daehar
Daehar (name is representational) is a multinational cosmetic and beauty product company that has been in business for over 110 years.
The company wanted to design a Predictive dashboard based on scenario-based sales prediction model that helps sales manager make better decisions about pricing, marketing, and other aspects of their business. It's uses different types of data such as historical data and applies an array of statistical techniques to predict sales. This would help them to achieve their sales goals, stay ahead of the competition, and grow their business. The real time change in prediction model through edits and filters allowed them to get the right insight into each product and category, allowing them to make better informed decisions.
Challenges
Short timeline to deliver quick click through prototypes, test & iterate
Visualize complex structure of data to deliver best insights
To design a well defined filter system to help user find their insights
My Role
I conducted workshops and surveys to understand user needs, then worked with product owners and developers to align my solution with brand guidelines and technical limitations.
Date & Duration:
/ Feb'2023 / 4weeks
Project Tags
/ Sales Dashboard
/ Data Visualization
/ Predictive Analysis
Solution
/ The target and actual sales for the previous year were added to help sales managers better understand the market trends.
/ The cards provide a quick overview of sales performance against target.
The Dashboard
/ They can filter the scenarios and the level of detail to narrow down to their specific area of concern.
/ Users can choose from multiple market scenarios to see how their total sales could turn out.
Filter Settings
Scenario Models
/ Users can edit sales scenarios in two ways: top-down or bottom-up.
Top-down allows users to edit the total sales value or number of units,
while bottom-up allows users to edit each parameter individually.
/ This helps sales managers understand each scenario and align their sales strategy accordingly.
Edit Scenario
/ Sales managers can edit sales scenarios with their own values, either by selecting specific rows or the whole table in bulk.
/ The outcome in predicted sales changes will be shown to the user in the graph upon saving giving him the information needed to make better marketing decision.
Outcomes
The Sales Dashboard and Predictive tool helped 200+ Daehar sales managers.
Benefits of using the dashboard and predictive tool:
Maintained Daehar's position as a leader in the e-comm market.
Improved decision-making and chances of achieving target.
Use scenarios to edit and align strategies to achieve targets.
Quickly understand their sales performance against targets.
Increased visibility into sales performance.