A professionally written report including 1 page or less (single space)/per team member with each page providing a single well-justified and valuable business recommendation different from the others in the report. Follow the example provided in class through the Intro to Pandas for Data Analytics Exercises and review the rubric carefully.

Do:

• Read the provided rubric, below, carefully. It will be used to grade both your report and your revised version. You can click on each criteria (in the left most column of the rubric) to see the expectations for each.
• Drill down in the data to investigate different angles and consider alternate explanations. If you discover a certain region has the highest art sales, that’s great! Now try to learn more about those sales. What customer type buys the most art supplies? Is there a seasonal effect on art supply sales? Is there a region where art supplies sell best? Use data insights to develop a compelling "story."
• Consider the flow of your writing…are you leading your reader to your conclusion (your recommendation).
• Pay attention to the quality of your writing. It should be professional, concise (pretend you have to pay for every word!), and grammatically correct with no spelling errors. Font and format matter too.
• Proof read carefully. Swap reports with a teammate and proof / grade each other's reports.
• Read the examples provided.

Do NOT:

• Include data insights that do not directly support your recommendation.
• Reference your coded project in your report. Natalie won't see it.

About Office Solutions

1. Natalie oversees Sales and Marketing. Includes online advertising, direct sales to corporate accounts, emails, customer relationship management etc.
2. Office Solutions is a low-cost leader, online only, pay for Google ad, cookie-based search on FB, etc. no physical mailings, 2 emails a month to customers. Some cold calls to corporations
3. Natalie is head of sales and marketing – logistics, inventory, and vendor management are run by others.
4. Goals:
   1. Increase overall sales by 20% this year
   2. Increase profits by 10% this year. (What product categories, subcategories, regions, segments have highest profits, year over year trends)
   3. Most of our customers are individual consumers. Increase corporate accounts by 50% over the next 3 years.
5. Some ideas Natalie has for the future that students could consider for their projects.
   1. Create a loyalty program for most valuable consumers
   2. Looking to test market a new line of high-end furniture that includes traditional and standing desks, tables, and bookcases (regional analysis strong sales of furniture, total cost per sale)
   3. What to know more about what sells and where. Are our discount strategies working?
   4. Several new art vendors have approached us: two framed art companies one offering prints and one offering original art and one offering 3D art. (Which vendor, what region
   5. We sell a lot of office supplies to our consumer accounts. Some of those are small orders. Understanding the types of products frequently bought together would help us better target our promotions and sales and improve cross-selling.
   6. We’d like to drop underperforming products or even subcategories, but we still want to provide all the products requested by top 50% most frequent and profitable accounts.
   7. We charge a premium handling charge for same day shipping. What proportion of our orders are same day? Are same day orders always the same customers? Are they individual or corporate? Regionally specific or postal code specific?
   8. We’d like to better tailor our marketing efforts and focus on those subcategories, or even individual products, with the highest profit.

/ segment to test market)