Capstone Project and Assignment

An Excel file has been provided which is a real-world comprehensive dataset with details regarding Canada’s Freight Analysis Framework. Study the dataset (the Excel file) and answer to the following questions. You can create charts as part of your answers to some questions.

Submit your solution file (Word file) on Moodle by December 4 2024.

Analysis Questions

What are the top five product categories exported from Atlantic provinces in Canada to the rest of Canada, US, and Mexico?

Analyze the shipment from rest of Canada to the province of Nova Scotia in terms of transportation mode and product type? For example, what percentage of the total shipments from rest of Canada to the province of Nova Scotia are via rail, air, truck?

Analyze the shipment from rest of Canada to the province of New Brunswick in terms of transportation mode and product type? For example, what percentage of the total shipments from rest of Canada to the province of Nova Scotia are via rail, air, truck?

Analyze the shipment from rest of Canada to the province of New found land in terms of transportation mode and product type? For example, what percentage of the total shipments from rest of Canada to the province of Nova Scotia are via rail, air, truck?

Analyze the shipment from rest of Canada to the province of Prince Edward Island in terms of transportation mode and product type? For example, what percentage of the total shipments from rest of Canada to the province of Nova Scotia are via rail, air, truck?

What are the most popular products being shipped to Canadian provinces from outside Canada?

What product category not only accounts for the highest volume of shipments from the Atlantic provinces to the rest of Canada but also generated the highest aggregate value in shipments?