Retail Dashboard

EuroMart Dashboard


  • The dashboard is created on Google Data Studio platform.
  • This is completely interactive dashboard, where in on selecting specific field or filter in the dashboard, all the dashboard visualizations will update accordingly.
  • The dashboard is made by using a retail store dataset of Europe.


Dashboard Image : 



Dashboard Video : 

Sharing the glimpse of interactive dashboard through a short video as well, by playing around with some of the controls and visualizations present in it.        

   


Google Data Studio Dashboard : 

Also find my interactive dashboard from the below mentioned link  - 


Few Insights / Analysis from this dashboard : 

  • By looking from the 1st - Map visualization, we can infer that France is making the most of the sales whereas profit wise United Kingdom is doing the best.
  • From the Bar chart which is 2nd visualization, we can conclude that Bookcases sub-category is doing the best amount of sales whereas Tables category is making the least of the sales. But when we talk about profit making, Bookcases are still on the top but the least amount of profit is made by Furnishings sub-category.
  • From 3rd visualization which is Combo chart, we can conclude that the most amount of sales till now was done in Q3 of year 2014 whereas the highest amount of profit was made in Q3 of year 2012.
  • From 4th visualization which is a Donut chart, we can conclude that percent wise the most sales contribution is coming from Consumer segment. We can also see from the optional metrics option that, the most amount of profit percentage as well as profit margin percentage contribution is  also from Consumer segment.
  • From 5th visualization which is a Tree map, we can infer that the sales is most in umber when the shipping mode used is Economy type.
  • From 6th visualization which is a Pie chart, we can infer that the max percentage amount of sales is coming from Central region.
  • And the last visualization which is a table shows us the top 5 customer names who have performed well by doing the max amount of sales and managing to show up in top 5 sales wise.

These were the few insights that can be drawn from the data which is shown in dashboard. We can go ahead and play around with different controls and filters inside it to get even more deeper insights of data by applying various desired filters and obtain the result accordingly.




Comments

Post a Comment

Popular posts from this blog

Exploratory Data Analysis - Retail_Store

Image
Exploratory Data Analysis - Retail Task :  Performing  Exploratory Data Analysis on a Retail Company's  'Sample Superstore' dataset. The tool used is Tableau . Creating  different visualizations to analyze  the dataset, its trends and statistics and further   creating  Dashboard to showcase and compare the sales and profit depending on various different aspects. Using this insights from the data, creating  a Storyboard  to showcase the areas for improvement in order  to increase the   company's  Sales and Profit. Tableau Workbook Link :  The tableau workbook is uploaded on Tableau Public and below is the link to view the same. https://public.tableau.com/views/ExploratoryDataAnalysis_Task3/Storyline?:language=en-US&:display_count=n&:origin=viz_share_link Tableau Dashboard/Storyboard Image :  Dashboard - Storyboard Video : Sharing a glimpse of my dashboard / storyboard through a small video to showcase some of t...
Read more

HR Dashboard

Image
  JS Academy HR Dashboard  The dashboard is created on Google Data Studio platform. This is completely interactive dashboard, where in on selecting specific field or filter in the dashboard, all the dashboard visualizations will update accordingly. The dashboard is made up by using a HR dataset of a company. Dashboard Image : Dashboard Video :  Sharing the glimpse of interactive dashboard through a short video as well, by playing around with some of the controls and visualizations present in it.         Google Data Studio Dashboard :  Also find my interactive dashboard from the below mentioned link  -  HR Dashboard Few Insights / Analysis from this dashboard :  By looking from the 1st - Table visualization, it displays us the pay rate per hour of every employee in descending manner. From the Bar chart which is 2nd visualization, we can conclude that most of the employees are hired for or belong to Production Technician position...
Read more