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
Converted structured data from a sample PDF/image-style source into a clean Excel workbook with organized rows, standardized formatting, and formula-based accuracy checks.
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
Cleaned and standardized messy Excel data by fixing names, emails, phone numbers, dates and values, while identifying duplicate records and adding validation checks for better data accuracy.
Supply Chain Data Cleaning - Supplier Inventory Fix
Project: Cleaned messy supplier file with 532 rows for a small business.
BEFORE: Data had duplicates, inconsistent names (safaricom LTD vs SAFARICOM LTD), missing quantities, NULL prices, extra spaces.
WHAT I DID:
✓ Removed 47 duplicate rows using Remove Duplicates
✓ Standardized 112 supplier names with TRIM & PROPER
✓ Fixed stock quantities: blank -> 0, "10 pcs" -> 10
✓ Cleaned price column: NULL removed, spaces trimmed
✓ Used VLOOKUP to add product categories
AFTER: 99.2% clean, ready for PivotTable reporting.
RESULT: Client saved 6 hours, now has accurate stock levels for reordering.
Tools: Excel, Google Sheets, VLOOKUP, PivotTable, Data Validation
Timeline: 24 hours delivery
I designed and developed a Spotify-inspired Music Analytics Dashboard in Microsoft Power BI, combining data modelling, DAX, interactive navigation, and custom dashboard design into a single analytical experience.
The dashboard allows users to explore music data from different perspectives — from overall performance and popularity to individual artists, songs, albums, and trends over time.
What I built
- Overview Dashboard — high-level KPIs and music performance trends
- Artist Analytics — artist rankings, song counts, popularity and catalogue analysis
- Song Analytics — song popularity, duration, year-wise analysis and album insights
- Interactive Navigation — seamless movement between dashboard sections
- Dynamic Visual Analysis — monthly trends, popularity patterns and category comparisons
- Detailed Data Tables — deeper exploration beyond summary-level KPIs
- Spotify-inspired UI — dark, modern interface designed around the visual identity of a music streaming platform
Key metrics explored
- 342 Artists
- 789 Distinct Songs
- 562 Albums
- Average Song Duration: 3.28 minutes
- Average Popularity: 90
Tools & Skills
Power BI · DAX · Data Modeling · Data Visualization · Interactive Dashboard Design · KPI Development · Business Intelligence
The goal wasn't simply to create another Power BI report — it was to make the data explorable, intuitive and visually engaging.
Interested in turning your own data into an interactive Power BI dashboard? Let's connect.
