{"id":17,"date":"2025-12-14T20:58:10","date_gmt":"2025-12-15T04:58:10","guid":{"rendered":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/points\/os-inc-sales-analytics-executive-summary-data-driven-recommendation\/"},"modified":"2025-12-14T20:58:10","modified_gmt":"2025-12-15T04:58:10","slug":"os-inc-sales-analytics-executive-summary-data-driven-recommendation","status":"publish","type":"points","link":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/points\/os-inc-sales-analytics-executive-summary-data-driven-recommendation\/","title":{"rendered":"OS, Inc. Sales Analytics \u2013 Executive Summary &amp; Data-Driven Recommendation"},"content":{"rendered":"<h3 data-start=\"174\" data-end=\"257\"><strong data-start=\"178\" data-end=\"255\">OS, Inc. Sales Analytics \u2013 Executive Summary &amp; Data-Driven Recommendation<\/strong><\/h3>\n<p data-start=\"258\" data-end=\"1381\">For this project, I was contracted as a data consultant to support Natalie, the VP of Sales &amp; Marketing at OS, Inc., in achieving her aggressive goal of <strong data-start=\"411\" data-end=\"447\">increasing company profit by 10%<\/strong>. Using Python and Pandas, I conducted an in-depth analysis of multi-year sales data to uncover root causes of profit volatility\u2014most notably a <strong data-start=\"591\" data-end=\"624\">46.98% profit decline in 2017<\/strong>\u2014and identified clear performance disparities across regions, segments, and product sub-categories. My findings revealed over <strong data-start=\"750\" data-end=\"771\">$22,000 in losses<\/strong> from low-performing categories like Tables, Bookcases, and Supplies, while Technology products such as Copiers and Phones emerged as top profit drivers. The final recommendation centered on a two-part strategy: eliminating loss-making products and shifting targeted marketing toward high-profit categories and strong markets like the West Region and Consumer Segment. Through this project, I strengthened my skills in <strong data-start=\"1190\" data-end=\"1300\">Python-based data analytics, business intelligence, strategic decision-making, and executive communication<\/strong>.<br data-start=\"1301\" data-end=\"1304\" \/><strong data-start=\"1304\" data-end=\"1320\">Project URL: <a href=\"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-content\/uploads\/sites\/1393\/2025\/12\/OS-Inc.-Sales-Order-Data-Analysis-Executive-Summary-and-Recommendation.pdf\">OS, Inc. Sales Order Data Analysis- Executive Summary and Recommendation<\/a><\/strong><\/p>\n","protected":false},"author":2672,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-17","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/points\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/users\/2672"}],"replies":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":0,"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/points\/17\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/media?parent=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}