Tableau Practice Problems with Solutions

Tableau Practice Problems with Solutions – Sales Performance Analysis

Tableau Practice Problems with Solutions – As a Data analyst you come across many different problems to find solutions. Or as new learner data analytics tools like Tableau you would come across a problem where you stuck upon. But don’t worry, in this short blog we have come up with a Tableau Practice Problems with Solutions for you. You can take inspiration and reverse engineer this solution to your actual problem. This short blog will help you save time and drive result fast so let’s get into one of the Tableau Practice Problems with Solutions

Tableau Practice Problems with Solutions

Problem: Sales Analysis by Month and Region Dataset: A sales dataset with columns like month, region, sales amount, and quantity sold.

Objective: Analyze sales performance by month and region and identify the top-selling regions.

Solution:

  1. Connect Tableau to the sales dataset.
  2. Drag the “Month” field to the Columns shelf and the “Sales Amount” field to the Rows shelf.
  3. Drag the “Region” field to the Color shelf to differentiate the regions.
  4. Change the chart type to a line chart to visualize the sales trend over months.
  5. Add a filter or parameter to focus on a specific time period or region.
  6. Sort the regions based on sales amount to identify the top-selling regions.
MonthRegionSales AmountQuantity Sold
Jan-21North$10,000100
Jan-21South$8,00080
Feb-21North$12,000120
Feb-21South$9,50095
Mar-21North$9,50095
Mar-21South$11,000110
Tableau Practice Problems with Solutions – Profit Analysis by Product Category and Region

By following the steps mentioned above and using the provided dummy dataset, you can analyze the sales performance by month and region and identify the top-selling regions in Tableau.

Superstore dataset analysis Tableau

Here is one more example to enhance your data analytical skill Superstore dataset analysis Tableau

Problem: Profit Analysis by Product Category and Region 

Dataset: Superstore dataset with columns like Order ID, Order Date, Region, Product Category, Sales, Profit. 

Objective: Analyze the profit by product category and region to identify the most profitable categories and regions. 

Order IDOrder DateRegionProduct CategorySalesProfit
12023-01-01NorthElectronics$1,000$200
22023-01-05SouthFurniture$2,500$400
32023-02-03EastOffice Supplies$800$100
42023-02-10WestElectronics$1,200$300
52023-03-15NorthFurniture$3,000$500
62023-03-20SouthElectronics$1,500$250
Superstore dataset analysis Tableau – Superstore dataset analysis Tableau

Solution: 

  1. Connect Tableau to the Superstore dataset. 
  2. Drag the “Product Category” field to the Columns shelf and the “Profit” field to the Rows shelf. Drag the “Region” field to the Color shelf to differentiate the regions. 
  3. Change the chart type to a stacked bar chart to compare the profit contributions of each product category within each region. 
  1. Add filters or parameters to focus on specific time periods, product categories, or regions. Sort the bars based on profit to identify the most profitable categories and regions.

Useful tag

Tableau Practice Problems with Solutions, Tableau practice questions on Sample Superstore, Superstore dataset analysis Tableau

Scroll to Top