28 Mar Using the tool of Data and Business ?Analysis as
Using the tool of Data and Business Analysis as your preference, apply what you learned in data Analysis program
- 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.
- To submit: a report that includes the analysis of the data, supported by visualizations
- Communicate your thoughts on each visualization you share in the report
- Provide insights/suggestions/observations on what you believe can help the business and how
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
