I will clean your raw dataset and build a structured database
Data Cleaning and Analysis
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

