Data Science Podcast Collection

Welcome! This assignment is designed purely as a practice case, but it comes from a real company, so it reflects a real-world scenario you might encounter in a marketing analyst role. Think of it as a playground to explore your skills and creativity. Feel free to include your final report or dashboard in your portfolio or resume as a shining example of your work!

⚠️ Heads-up: Skillish.io won’t be grading this assignment. Please relax, experiment, and have fun with it.

💡 One hint for building effective visualizations: Consider the three T’s:

Time to See: How quickly a user can see the key visuals (content focus).
Time to Understand / Insight: How quickly a user can grasp the implications or patterns (make it easy to understand).
Time to Act: How quickly a user can take action based on the insight (problem-solving oriented).

If you’d like to explore some similar high-quality examples (with different datasets), here are some references:

Helpful technical resources:

Assignment Received: Time to Show Your Skills!

🎯 Objective

We’d like to understand how you approach data analysis, storytelling, and business problem-solving. You will work with the provided dataset to extract insights, answer key business questions, and present your findings in either a report (PDF/Word/Slides) or an interactive dashboard (Tableau/Power BI/Looker Studio/Excel).

📂 Dataset

Please use this dataset for your analysis: campaign_performance_2024.xlsx

📝 Task

Please complete the following steps:

1. Data Understanding & Cleaning

Briefly describe the dataset: what fields are included, what each column means, and any issues you noticed (e.g., missing values, outliers).
If you make assumptions (e.g., interpreting unclear columns), state them clearly.

2. Exploratory Analysis

Using the dataset, explore performance trends and answer business-oriented questions such as:

Which hotels, regions, or devices appear to perform best?
How do costs, clicks, and bookings relate to each other?
Are there patterns over time (by week)?
Where do you see inefficiencies (high spend, low return)?

(Feel free to propose your own angles of analysis, we’re interested in your thinking process.)

3. Visualization

Create charts/graphs/tables to support your analysis.
They should help a marketing manager quickly understand key trends and insights.
If delivering a dashboard: make sure it’s interactive and easy to navigate.
If delivering a report: make sure visualizations are clear and well-labeled.

4. Recommendations

Based on your findings, provide 3–5 actionable recommendations for the campaign managers and the marketing director.
Focus on business impact and practical next steps.

✅ Deliverables

Format:
- Report (PDF, Word, or Slides) OR
- Dashboard (Power BI, Tableau, Looker Studio, or Excel with pivot charts)
Length: Max 10 slides/pages, or a dashboard with supporting notes.
Deadline: Within 72 hours of receiving this assignment.

💡 Evaluation Criteria

Your potential marketing director will evaluate your work based on:

Problem-Solving: How well you translate data into business insights.
Clarity & Storytelling: Is the analysis easy to follow for a non-technical audience?
Data Visualization: Are charts/tables well-chosen, accurate, and insightful?
Actionability: Do your recommendations make sense and provide value?
Professionalism: Is the report/dashboard polished, structured, and within scope?

👉 Tip: Don’t over-engineer. Focus on the clarity of insights rather than complex modeling. Assume your audience is the marketing director who needs clear guidance for next quarter’s strategy.