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
Built a full Business Analytics & Reporting Platform designed to transform raw sales data into decision-ready insights.
The platform covers the complete analytics workflow — from data cleaning and KPI calculation to interactive filtering, profitability analysis, automated business insights, and downloadable CSV/Excel reporting.
The project is deployed as a live Streamlit web application, allowing users to interact with filters, explore business performance, and generate reports directly in the browser.
Key features include dynamic KPI tracking, revenue and profit trend analysis, product/category/regional performance breakdowns, data quality monitoring, and multi-sheet Excel reports with Executive Summary, KPIs, Product Performance, Regional Analysis, and Filtered Data.
Built with Python, Pandas, Streamlit, Plotly, and OpenPyXL using a modular project structure focused on maintainability and real-world reporting workflows.
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
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.
A data-driven quarterly business review dashboard built to track key performance metrics — monthly revenue trends, customer churn rate, and support response time. This project demonstrates data analysis, visualization, and business intelligence reporting skills using Python for data processing and chart generation.
BEFORE: Client had messy Excel inventory with 500 rows, duplicates (A12 / a12), blanks, wrong prices like "$ 2.5" and "N/A", and different warehouse names (KER / ker / Kericho).
AFTER: I did:
Removed 12 duplicate SKUs
Standardized item names to Title Case
Fixed QTY and Prices to 2 decimals
Unified Warehouse to Kericho
Made sheet ready for pivot dashboard
Result: Clean, ready-to-use inventory in 2 days using Excel.
Tools: Excel, Remove Duplicates, Text to Columns, TRIM, PROPER
