Data And Business Analysis - Sales and Marketing

Data And Business Analysis

Using the tool of Data and Business  Analysis as your preference, apply what you learned in data Analysis  program

Final Project

Sales and Marketing

Business Case

· You are working at CampWithMe, a store that sells tools, clothing, and equipment for camping and traveling.

· CampWithMe always struggled with having good visibility on how its different branches are performing, so you suggest creating a dashboard that monitors the performance of the store at all times, and gives better visibility to the decision makers.

· Using the dashboard, let’s understand how the different product lines are performing and contribute to the revenue, and brainstorm ideas on how to improve it.

Data Information

· Year: year of order

· Product line: product line name

· Product type: product type

· Product brand: product brand

· Product name: product name

· Region: region of retailer

· Retailer country

· Retailer name

· City (multiscript)

· Campaign name

· Promotion name

· Order method type

· Revenue

· Planned revenue

· Product cost

· Quantity

· Unit cost

· Unit price

· Unit sale price

· Profit margin

· Gross profit

· Quantity

· Promotion plan revenue