case study#1

.docx

School

Humber College *

*We aren’t endorsed by this school

Course

3000

Subject

Finance

Date

Feb 20, 2024

Type

docx

Pages

6

Uploaded by UltraFireGoose38

Report
Group 10 Drashti Dhameliya (N01463037) Riya Joshi (N01533370) Arshdeep Banga (N01462005) Erin Allison-Yoshida(N01368754) Jonathan Amar (N01456295) FIN 4503 Data Analytics & Fintech – WINTER 2023 Case Study #1 (5%) FORMAT : · This assignment is to be completed in groups. · Assignment to be completed by midnight February 19 th . · Use MLA or APA format · The solutions must be submitted via Blackboard. INTRODUCTION: The overall goal is to use data visualisation to demonstrate a nonobvious insight gleaned from the data, or to make a particular point. You may use multiple displays that together tell a story using Python and Power BI. CASE STUDY: Product demand is one important task in finance management. It allows to find the optimal order quantity for businesses to minimise logistics costs, warehousing space, stockouts, and overstock costs. The Product Demand dataset contains historical product demand for a manufacturing company. The company provides thousands of products within dozens of product categories. There are four central warehouses to ship products within the region it is responsible for. Since the products are manufactured in different locations all over the world, it normally takes more than one month to ship products via ocean to different central warehouses. If forecasts for each product in different central with reasonable accuracy for the monthly demand for month after next can be achieved, it would be beneficial to the company in multiple ways.
REQUIREMENTS : 1. Plot the categories demand. -- Code for this graph will be found in the appendix. 2. Visually, demonstrate if the categories demand changed over the years.
Graph above demonstrate how different categories demand changed over years 3. Observe the top 5 products in 2014 and track their demand over the years. We have a high demand for Category_019 , Category_ 005, Category_001, Category_007, and Category_021 In the year 2014. And this graph shows different trends in future years. Appendix :
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help