Clean, Analyze, and Visualize Dataset Using Excel or Python

Vista Analytics Hub - Startup

Posted at: 30-04-2025
We’re hiring a junior freelance data analyst to clean, organize, and visualize a dataset. The dataset will be provided (e.g., HR, Marketing, or Retail data), and the task is to generate basic insights and simple visualizations using Excel (preferred) or Python (Pandas + Matplotlib). - Requirements: Basic Excel skills (Pivot Tables, Charts, VLOOKUP) Or basic Python skills (Pandas, simple plotting) Ability to clean missing or wrong values Clear visual formatting (labeled charts, neat tables) - To Apply : Please send proposals
Milestones
  • Project delivery
    - Deliverables: Cleaned dataset (Excel or CSV) 2–3 basic visualizations (charts/graphs) Short written summary of findings (Word or PDF, ~150–200 words) Optional: Pivot Tables or Basic Formulas (Excel) - Dataset Theme: HR Employee Data Fields: Employee ID, Department, Age, Salary, Gender, Joining Date, Status (Active/Left) - Example Objectives: Find the average salary by department Visualize the gender distribution Track number of employees joined per year Show employee attrition rate (how many left vs. stayed)
Required skills
Data Analysis Python Excel Time Management Analytics Business Analysis
Deadline
10-05-2025
Client budget
11 - 12 USD