Excel Crazy

Sample Superstore Dashboard in Tableau

Let’s talk about tableau training in Gurgaon here. This dashboard helps you to analyze product wise sales and profit. You can use a drop-down control to analyze sales across regions by category, subcategory, and products.

we have designed sample super store dashboard using sample superstore dataset. This dashboard helps you to analyze product wise sales and profit. You can use a drop-down control to analyze sales across regions by category, subcategory, and products.

Section 1:

Let’s learn how to create Doughnut-Chart in Tableau for Category-wise Section.

Steps

  • Select Pie Chart on the mark card.
  • Drag product category over a color shelf.
  • Drag sales field oversize shelf.
  • Click Label, and then select Show mark labels.
  • Resize the pie chart as desired.
  • Drag number of records I the row shelf.
  • Drag number of records again in the row shelf.
  • In Rows shelf, right-click on both a number of records fields and select aggregate function (SUM) to Minimum.
  • Set the second number of records to a dual axis.
  • Now in mark cards, select the second number of records.
  • Change the chart type to circle.
  • Remove product category from the color shelf.
  • Remove Sales from the size shelf.
  • Now click color pallet and select the same color as the background color.
  • Click size shelf and reduce the size of the circle.
  • Drag Sales field over labels.
  • Right-click on each axis and uncheck show headers.
  • Drag order date as a year in column shelf.

 

Section 2: Region-wise sales (Map Chart)

  • Using State dimension create filled map chart.
  • Drag Sum of Sales over the color shelf.

Section 3: Products scattering (Quadrant Chart)

  • http://www.excelcrazy.in/quadrant-analysis-in-tableau/

Section 4: Sub-Category-wise Sales high to low (Funnel Chart)

  • Using Sub-category and Sales create stacked column chart.
  • Short output in descending order.
  • Drag Sum(Sales) oversize shelf.
  • Sub Category over detail I mark card.
  • Sum(Profit) over the color shelf.

We have created four sections in this dashboard.

  • Category-wise Sales in the form of doughnut chart
  • Region wise sales (Map Chart)
  • Products scattering (Quadrant Chart)
  • Sub-Category-wise Sales high to low (Funnel Chart)

In this visualization, we have used sample superstore dataset provided by tableau.

We have created four sections in this dashboard.

  • Category-wise Sales in the form of doughnut chart
  • Region wise sales (Map Chart)
  • Products scattering (Quadrant Chart)
  • Sub-Category-wise Sales high to low (Funnel Chart)

In this visualization, we have used sample superstore dataset provided by tableau.

We will talk more about tableau training in Gurgaon.

0 responses on "Sample Superstore Dashboard in Tableau"

Leave a Message

Your email address will not be published. Required fields are marked *

top
 

© LOKESH PALIWAL 1987 - 2018

LOKESH@EXCELCRAZY[DOT]COM | 8826547882

Reporting Solutions | Data Consulting | Analytics Training

CONTACT US
close slider

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Message for us...

Skip to toolbar