🚢 Boat Sales - Datacamp

📚 Table of Contents

• 💼 Business Case

• 📑Example Datasets

• 🚩 The Requirement

• 🚩 Task List - Oral Presentation

• A. Data Exploration and Cleansing

• B. Analysis

• 📃 What can you practice with this case study?

---

💼 Business Case

Nearly New Nautical is a website that allows users to advertise their used boats for sale. The marketing team is preparing a weekly newsletter for boat owners.

The newsletter is designed to help sellers to get more views of their boat, as well as stay on top of market trends.

The Head of Marketing has laid out an ambitious goal of increasing the number of readers by 75% this year.

---

📑Example Datasets

You can download the data from here. You can use any tools that you wish to analyze the data and create your presentation.

The dataset has the following columns:

Table : boat_data

Price	Boat Type	Manufacturer	Type	Year Built	Length	Width	Material	Location	Number of views last 7 days
CHF 3337	Motor Yacht	Rigiflex power boats	new boat from stock	2017	4	1.9		Switzerland	226
EUR 3490	Center console boat	Terhi power boats	new boat from stock	2020	4	1.5	Thermoplastic	Germany	75
CHF 3770	Sport Boat	Marine power boats	new boat from stock	0	3.69	1.42	Aluminium	Switzerland	124
DKK 25900	Sport Boat	Pioner power boats	new boat from stock	2020	3	1		Denmark	64
EUR 3399	Fishing Boat	Linder power boats	new boat from stock	2019	3.55	1.46	Aluminium	Germany	58
CHF 3650	Sport Boat	Linder power boats	new boat from stock	0	4.03	1.56	Aluminium	Switzerland	132
CHF 3600	Catamaran		Used boat,Unleaded	1999	6.2	2.38	Aluminium	Switzerland	474
DKK 24800	Sport Boat		Used boat	0	3			Denmark	134
EUR 3333	Fishing Boat	Crescent power boats	new boat from stock	2019	3.64	1.37		Germany	45
EUR 3300	Pontoon Boat	Whaly power boats	new boat from stock	2018	4.35	1.73		Italy	180

---

🚩 The Final Test Requirements

1. Introduce about your choosen dataset
2. Introduce the technical tools and steps to explore, discover unclear data before analyzing.
3. Show steps how to use power bi to import, modelling, analyze and visualize the final clean data (if candidates use power bi to explore and discover data, show it in this part too)
4. Present the information that the candidate discovered from the dataset
5. If possible, give some follow-up recommendations.

🚩 Task List - Oral Presentation

Your presentation must be no longer than 8 slides plus a title slide. You should not present for longer than 10 minutes.

Your presentation should be targetted at the non-technical customer who requested the work you have completed.

The presentation should include:

• An overview of the project and business goals
• Your key findings including visualizations to support those findings
• An overview of how your findings answer the customer questions
• Your recommendations to the business for future work

A. Data Exploration and Cleansing

B. Analysis

---

What can you practice with this case study?

• Python
  • numpy, pandas, currencyconverter, dataprep.clean Library
  • Cleaning, Transforming, Grouping, Spliting, Converting.
  • Import and Save CSV File
• POWER BI
  • Visualize
  • Analyze
  • Import CSV File and Transform data