DataCamp

📊 Guided Projects using Python

1. Investigating Netflix Movies and Guest Stars in The Office

🔑 Key Learnings

• Performed data manipulation and data visualisation using Pandas and Matplotlib libraries.
• Created dataframes and used filtering techniques.
• Built a line plot and scatter plot.

View my project here!

2. Generating Keywords for Google Ads

🔑 Key Learnings

• Created prototype set of keywords for search campaign for an online furniture retailer.
• Created dataframes.

View my project here!

3. Exploring the NYC Airbnb Market

View my project here!

4. Streamlining Employee Data

View my project here!

---

📊 Guided Projects using SQL

1. Analyze International Debt Statistics

🔑 Key Learnings

• Using aggregate functions such as SUM(), MAX()
• Filter techniques such as WHERE, GROUP BY
• Sorting using ORDER BY
• Limit results using LIMIT clause
• Subquery in WHERE clause

View my project here!

2. What and Where Are the World's Oldest Businesses?

🔑 Key Learnings

• Using aggregate functions such as MAX(), MIN(), COUNT()
• Filter techniques such as WHERE, GROUP BY and HAVING
• Sorting using ORDER BY
• Inner JOIN and LEFT JOIN

View my project here!