Our projects
Razan Dashboard
In this dashboard, we study the sales metrics in different timeframes and different countries. we can choose between multiple filters on the sides, we can know that the best selling time is at 12 pm, and most of money come from united kingdom so we can give them some offers. Orders decrease on January so we can Make discount to increase them and we can also decrease production at this time to save cost.
Marketing & sales
We wanted in this dashboard to know the best sales channels after using several channels, and the most sales time from 2010-2014, so we used the correlation metric to identify, and as we notice we can filter the days any years and quarters, as the correlation is the highest in social media, So it is the best channel for sales where we can invest money on it more than other channels.
Coca Cola Analysis
We made this analysis for Coca Cola company to see the best selling time and metrics for each brand. We can know info about each brand and if we can decrease cost, as we can see that the sales is Max in July and Dec, and min in April, so we can decrease the production in April to save time and cost. We can see that the best retailer is Sadoop so we can make some discount and offer for him. also for Dream we can show better quality for him to attract him to have more sales.
Amazon Analysis
This dashboard was created for an Amazon store, and we organized the assessments into three categories: bad, good, and super. We displayed the revenue by products, allowing us to identify the products generating the most revenue for potential optimization. Similarly, we highlighted the products with lower revenue to promote them more effectively and showcase their benefits. Additionally, we included other useful metrics in the dashboard. Furthermore, detailed information for each product is provided in the table.
What other conclusions can we make from this dashboard?