Excel Data Analytics Projects

📊 Overview

These projects showcase a series of Excel-based data analytics exercises using a dataset of job listings in the field of Data Analytics and a coffee sales dataset.

🧩 Project Highlights

1. Interactive Dashboard

• Analyzes various jobs within the data analytics domain.

• Visualizes metrics by job title,countryandjob type.

• Displays:

  • Median salaries
  • Number of job listings per role and region
  • The best job platform

  

2. Skill & Salary Analysis

• Provides deeper insights into key skills required for different jobs
• Includes median salary comparisons by:

  • Country

  • Job title

    

3. Interactive Dashboard of Coffee Sales

• Tracks coffee sales performance across multiple countries:
  • Filters by roast type, size and loyalty card usage
  • Sales over time by coffee type (Arabica, Excelsa, Liberica)
  • Top 5 customers
  • Timeline filter

📁 Tools Used

• Microsoft Excel (Pivot Tables, Charts, Filters, Formulas, Power Query, Power Pivot, DAX)

💼 Dataset

• Job listings dataset focused on the Data Analytics job market around the world
• Coffee sales data from multiple countries based on roast type, size, and customer behavior