Data and Business Analysis

· 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.

· 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