Data Analytics and Visualization Using Tableau: Histogram

 The objective of this Tableau project is to create a histogram exactly similar below:

The PROBLEM: The Manufacturing Engineer and the Finance Manager would like to know and understand the pattern of customer waiting time. The company’s waiting time (in minutes) of 100 customers was randomly collected as data from October 1- Dec.1, 2021.

The collected data of the 100 customers waiting times are as follows:

34	16	18	26	11	36	47	54	28	44
30	16	14	35	25	25	33	46	33	66
16	51	49	33	19	55	33	46	33	47
33	46	66	36	54	48	24	56	28	27
40	4	47	58	2	41	45	44	28	6
5	22	42	21	31	21	10	33	49	38
44	33	36	31	26	50	26	54	36	38
41	23	14	32	36	31	42	46	4	57
40	12	53	21	26	39	55	39	47	42
60	36	38	37	34	14	47	37	28	50

Step 1. Drag the “Hospital Wait Times” to the Columns shelf.

Step 2. Click “ Show Me” on the toolbar. Select the histogram chart type.

Step 3. On the “Hospital Wait Times (bin), “ select “edit”.

Step 4. Change the size of bins to “7” to have ten bins.

Step 5. Drag “Hospital Wit Times” to “Color” in the Marks card.

Step 6. Drag “Sheet 1(count)” onto the “label” mark.

This is now the final Histogram showing the customer’s  waiting time which is commonly ranged between 35 and 42 minutes. More than 60% of customer’s waiting time occur between 20 and 55 minutes. Customers who wait less than 15 minutes and 55 minutes are rare.

Since shortening customers waiting time is important to maintain loyalty, improvement methods are needed to reduce waiting time.

Arnel Lopez Cadeliña