Your CEO questions

Please produce BI reports that answer these questions:

1) Are we selling more backpacks in our traditional stores or in our modern ones?  Show formatted number sold by quarter. Sort by quarter and store layout. [Note: sum quantities from the stores with the same type]

2) Show the total revenue from all boots models by store and city. Sort by revenue. Top on top. [Note: aggregate all boots models]

3) Show the revenue per square foot in each of our stores and cities. Sort descending.

4) In which month does Richmond, Atlanta, and Charleston each make the most money?

5) What is the monthly revenue from our 'camping' product category? (order by month chronologically: e.g. Jan is first)
[You might need to do some research for the last ones. Google it. These are common problems and they are tricky!].