The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Excel Data Cleaning & Research Database
I cleaned and structured a research database in Excel, including duplicate removal, missing-field checks, data normalization and validation.
The workflow included a raw-data layer, cleaned dataset, validation log and summary to make the final database easier to review and use.
Portfolio case using demo/synthetic data.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
One quarterly number almost got double-counted across two reports.
Two dashboards were quietly tracking overlapping data. Caught before it went out now there's one source of truth the reports pull from, not two that can disagree.
→ A good number is only as good as the one place it actually comes from
Great catch before it shipped. I like the “one source of truth” framing - pulling reports from one validated source makes it much harder for a duplicate dashboard to quietly skew the number again.
DataFlow is a self-initiated Python automation tool designed to clean, analyze, and transform messy Excel and CSV files into structured, usable reports.
It detects duplicates, missing values, empty rows and columns, and common formatting issues while preserving the original source file. The project includes a Windows desktop application, automated Excel report generation, and an interactive browser-based CSV cleaning demo.
Excel Data Cleaning & Dashboard Project — cleaned and organized sales data, removed duplicates, created summaries, PivotTables and professional charts.
