Problem statement 1 - Active records over time
In Dataset – Employee, Dataset record has a start and end date for each employee, you need to
create a chart to show Active employee by month.
Task 1– How can we determine the number of employees who were active in January 2023 and
March 2023?
Problem statement 2 – Use superstore dataset to get answers of below task.
Task 1 - Identify which product has the widest profit Range? (Hint: get min/max profit and check
range)
Task 2 - What is the number of customers who placed their first order in June 2021? (i.e They placed
an order for the first time during the period of June 1 to June 30, 2021.)
Task 3 - What is the count of products that appear in the top 20 for both 2021 and 2022.
Task 4 - The product that had the second highest sales in 2019, What was the rank of that product in
the year 2022?
Task 5 - Which of our most loyal customers has the highest sales volume with us?
(Note – loyal here means customer who purchase our products every year)
Note: Use the best features that you know of in Tableau that help build the best story from the
datasets.