PRACTICE QUESTIONS – GLOBAL SUPER STORE
1. As a part of the top management, I want to analyze our sales region-wise.
2. From the perspective of sales by region, which shipping mode is better?
3. I want to analyze the sales of various categories and sub-categories.
4. I want to analyze the sales of various sub-categories, segment-wise.
5. I want to analyze the sales according to the date on which the order was placed.
6. I want to analyze the trends in sales and profit.
7. I want to see the total profit across all categories from 2011, in a quarterwise /
monthly manner.
8. Based on my data, I want to predict how much sales and profit I am likely to have.
9. I want to see how much each segment contributes to the overall sales.
10. Does my profit increase along with increase in sales?
11. Will giving more discount lead to more sales?
12. Will giving more discount lead to more quantity being ordered by customers?
13. What is the typical order size (quantity)?
14. I want to see a view of profitable and non-profitable states, so that all non-profitable
states are shown in red, and profitable states are shown in green.
15. I want to see a view of the total deliveries to each state, as well as whether the
deliveries to those states were on time or not.
16. I want to see month-wise sales and also how sales trended across the year.
17. I want to understand how the sales for each sub-category trends across each month. I
want to know whether we sell more in July or August.
18. I want to understand category-wise sales based on year of order date, and also have
some reference value for helping my interpretation
