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
Cleaned a 1,000-row messy HR dataset using PostgreSQL, handling inconsistent missing values, whitespace, mixed numeric/text data, and five different date formats. Built a reproducible SQL pipeline using CASE, regex, TRIM, type casting, and TO_DATE(), followed by validation checks to ensure the cleaned data remained accurate and analysis-ready.
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
It’s been a minute since my last post here on Contra.
While my main focus usually lives in photo editing and digital design, I was digging through the archive recently and thought it’d be fun to share a couple of branding projects from the past:
Slide 1: Seart Visuals apparel & merchandise branding (1 year ago)
Slide 2: Choku Ladies Boutique identity and mockups (2 years ago)
Brand identity isn't my everyday lane, but tackling projects like these taught me a lot about visual consistency across different mediums. I’d love to hear your thoughts or see any feedback from fellow designers. Great to connect with the community again.
That's really great typography logo design❤️❤️
Exploring how complex financial data can feel simple, structured, and easy to navigate.
Vault One is a crypto portfolio dashboard concept that brings together asset performance, portfolio allocation, transaction history, and key financial metrics in one workspace.
I focused on visual hierarchy, information density, and data visualization, using a neutral color palette, subtle UI details, and selective accent colors to keep the interface clean without compromising functionality.
The goal was to make the data easier to understand, not just nicer to look at.
Would love to hear your thoughts on the visual direction and layout!
#ProductDesign #UIDesign #Fintech #DashboardDesign #UXDesign
How I Built an End-to-End Sales Analytics Dashboard in Excel for an E-commerce Company
I recently completed an end-to-end sales analytics project using Microsoft Excel, transforming raw e-commerce sales data into an interactive dashboard that provides meaningful business insights.
In this project, I explored the data, performed analysis, identified key sales trends, and built an interactive dashboard to help businesses make data-driven decisions.
I documented the entire process, including the approach, tools, analysis, and dashboard development.
Read the full project walkthrough on Medium: https://medium.com/@Refino/how-i-built-an-end-to-end-sales-analytics-dashboard-in-excel-for-an-e-commerce-company-e8692d81f354
Excellent work! Turning raw data into actionable business insights is a valuable skill.