Assignment:
Prompt:
It's the end of 2021 and your Regional Sales Leader has asked you to provide a review of the business. She wants to know areas of strength and weakness in our revenue base, and what we should be investing in for the future. It's up to you to create a short deck (no more than 3 slides) reviewing the current state of the business using the data provided. Please also provide an excel backup of any analysis you conduct.1) What are the underlying trends in the business? Please visualize them and summarize with a few bullets.
2) What advertisers and/or products are driving those trends?
3) Which products would you invest in and why?
4) What advertisers would you focus on with the sales team and why?
5) How would you forecast future quarters, and what data would you request to do so?