hands-on experience with Tableau and become familiar with the interface and tools, practicing various drill-down and filtering techniques to generate insight into data. Use the “Sample – Superstore Subset” Example Data Set in Tableau

 “Sample – Superstore Subset” Example Data Set in Tableau.

·       Project Objective: Gain hands-on experience with Tableau and become familiar with the interface and tools, practicing various drill-down and filtering techniques to generate insight into data. Use the “Sample – Superstore Subset” Example Data Set in Tableau.

·        For each question, use the hints/listed components to create a visualization which will provide the information needed to answer the question. Each question should be on visualization.

·        Make sure you include all listed components in order to receive full credit for the question.

·       Provide a screen shot of the completed visualization (including any filters) from which you got your answer(s).

Example Question & Answer:

·         Are there any states that have lost money? Which ones and how much have they lost?

·         Required Components:

o   1.) U.S. Map, 2.) A color scale for each state indicating profitable or not profitable, 3.) Each state labeled with name, 4.) Each state labeled with profit amount

Answer:

o        Texas ($25,729) and other states are losing money.

 Screen Shot:

Question #1:

o        What is the percent of total Sales for the ‘Home Office’ Customer Segment in May of 2021?

Answer:

The percent total sales in May of 2021 for the home office is 11.16%

  Screen Shot:

Question #2:

o   Find the top 10 Product Names by Sales within each region. Which product is ranked #2 and #3 in both the Central & West regions in 2019?

Answer:

In central the ranked #2 is GBC Ibimaster 500 Manual ProClick Binding System and #3 is High Speed Automatic Electric Letter Opener

In west the ranked #2 is HON 5400 Series Task Chairs for Big and Tall and #3 is Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind

Screen Shot:

Question #3:

o        In the Technology Product Category, which unprofitable state is surrounded by only profitable     states?

Answer:

The name of the state is Colorado by profit of (3,472$)

 Screen Shot:

Question #4:

o        In which Region do all Product Categories fall beneath the overall average profit?

 Answer:

South region the all product is fall beneath the overall average profit Screen Shot:

Screen Shot:

Question #5:

o          Which Product Sub-Category has both “Days to Ship Actual” and “Days to Ship Scheduled” above 4,000 in 2020?

Answer:

There is no sub category has days to ship actual and days to ship scheduled above 4,000 The highest is Binders but its below 4,000

Screen Shot:

Question #6:

o   Find the customer with the lowest overall profit. What is his/her profit ratio?

The customer name is Sean Miller and his profit ratio is -7.9% Screen Shot:

Screen Shot:

Question #7:

o       Look at the sum of profits for each Product Sub-Category. Which sub-category is - 30,000 USD below the average profit across all categories? Please create a table calculating looking as the sum of profit and subtracting from the window average (SUM([Profit]) – WINDOW_AVG(SUM([Proft])))

Answer:

The sub category below -30,000usd is tables by -34,572

Screen Shot:

Question #8:

o   What percent of total profits do the top 10 customers by Sales represent?

 

Here is the visualization of profit of total 10 customers by sakes represents.

Screen Shot: