I will clean your raw dataset and build a structured database

United Kingdom

I speak English, Hindi

Data Cleaning and Analysis

Hi I am a recent Computer Science graduate with a strong interest in data analytics and technology-driven problem-solving. I have experience working with Python, SQL, and data visualisation tools to...
About this Gig

Raw data in, clean organised database out.

Exports and spreadsheets from different systems are rarely consistent: duplicates, missing values, mixed formats and categories that don't match. I clean and check your data, then load it into a properly structured database that is ready to search, report on or connect to Power BI.

What I do:

Clean and validate raw data (duplicates, errors, outliers, inconsistent labels)

Combine several files or sources into one consistent dataset

Design and build the database (PostgreSQL or MySQL), with a schema diagram on Standard and Premium

Document every change I make, so you can trust the result

Experience: I built a pipeline that cleans and loads 13 years of TfL data (millions of rows), and combined 5+ differently recorded sources into one database for a startup. I check sources before using them and fix problems before they reach a report.

Tools: Python (Pandas), SQL, PostgreSQL, MySQL, Excel

To start: send me your file and tell me what you need to do with the data. Questions are welcome before you order.

Database type:

Relational database

Platform:

MySQL

•

PostgreSQL

•

SQLite

•

SQL Server

Expertise:

ERD

•

SQL

•

Performance