I will merge multiple datasets, clean them and build dashboards

South Africa

I speak English

Turning raw data into clear and actionable insights

Hi, I’m Dillan — a data analyst who transforms raw data into clear, actionable insights. I specialize in data cleaning, analysis, and dashboard creation using Excel, Python, and Power BI. My portfoli...
About this Gig

Do you have data coming from different systems, branches, or departments all in different formats and you need everything merged, cleaned, analyzed, and turned into a clear business report?

You're in the right place.


What I provide:

Data Cleaning & Preparation

  • Fix inconsistent formats, dates, currencies, and duplicates
  • Standardize column names and structure
  • Convert messy text prices (e.g., $399.50 / 420.00) into numeric values
  • Handle missing or broken data

Data Merging

  • Combine multiple datasets (different sources, formats, or currencies)
  • Create unified tables for analysis
  • Apply exchange rates and normalization (USD/EUR/others)

KPI Analysis

  • Total sales
  • Monthly trends
  • Product performance
  • Customer breakdowns
  • Growth metrics

Power BI Dashboard

A clean, modern dashboard including:

  • Executive KPIs
  • Monthly revenue charts
  • Product comparisons
  • Interactive filters
  • Currency-converted insights

Automated Python Reports

  • PDF summary (KPI report)
  • Text report
  • Cleaned CSV outputs

Final Delivery Package

  • Clean datasets
  • Merged dataset
  • Python script used
  • Power BI report (.pbix)
  • PDF summary
  • README documentation for transparency

Send me your files and lets get started.

Analysis type:

Quantitative Analysis

Expertise:

Trends

Statistics

Technology:

Power BI

Programming language:

Python

DAX

My Portfolio

Other Data Analytics Services I Offer