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
🎵 Spotify Music Analytics Dashboard | Power BI & SQL
Transforming music streaming data into actionable insights using SQL, Power BI, Python, and Excel.
Spotify Music Analytics is an end-to-end Business Intelligence solution designed to analyze streaming trends, artist performance, track popularity, and listener engagement through interactive dashboards and data-driven visualizations.
🔹 What I Did
• Collected, cleaned, and transformed Spotify streaming data using SQL and Python
• Built an optimized data model in Power BI
• Created interactive dashboards with drill-down and cross-filtering capabilities
• Developed DAX measures for key music streaming KPIs
• Designed dashboards to analyze artists, albums, tracks, genres, and streaming trends
📊 Dashboard Features
• Executive Summary Dashboard
• Streaming Performance Analysis
• Top Artists & Top Tracks
• Album & Genre Performance
• Monthly & Yearly Streaming Trends
• Popularity Score Analysis
• Listening Behavior Insights
• Track & Artist Comparison
• Interactive Filters & Drill-through Navigation
🛠 Tools & Technologies
• Power BI
• SQL
• Python
• Pandas
• Microsoft Excel
• DAX
• Power Query
📈 Project Impact
• Analyzed 100K+ Spotify streaming records
• Built interactive dashboards for music analytics
• Identified top-performing artists, albums, and tracks
• Analyzed streaming trends and listener engagement
• Improved reporting through automated visual analytics
• Delivered actionable insights for data-driven decision-making
💻 GitHub Repository
https://github.com/Sandeep-crtl/Spotify-Insights
📝 LinkedIn Project Post
https://www.linkedin.com/feed/update/urn:li:activity:7414892040796229632/
#PowerBI #SQL #Python #Spotify #MusicAnalytics #DataAnalytics #BusinessIntelligence #Dashboard #DataVisualization #DAX #PowerQuery #Pandas #DataScience
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
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
Built a fully interactive executive project dashboard in Microsoft Excel for tracking enterprise implementation projects. This solution combines project timelines, milestone tracking, budget monitoring, task status, project priorities, and pending decisions into a single executive view. Designed to improve stakeholder visibility, streamline project reporting, and provide real-time insights for project managers and leadership teams.
A sustainable energy platform designed to empower the shift toward renewable power and smart energy solutions with Quantum. Our focus was on combining clean data visuals, strong branding, and a frictionless experience to present green tech at its best.
Check out the full breakdown on our page and drop your feedback below!
📩 Collaborate with Us? Contra Odama Studio
Amazing work👏🔥🔥
Mandum Rimba Project.
Mandum Rimba is an open-source geospatial platform, I designed and developed to make environmental and conservation data more accessible, interactive, and easier to understand.
The platform brings together dozens of spatial datasets, including protected areas, endangered wildlife, deforestation, peatlands, mangroves, concessions, wildfire hotspots, and biodiversity records, into a single WebGIS experience.
Beyond visualization, I built features that help users explore complex environmental issues through interactive maps, story-driven content, spatial analysis, and automatically generated reports.
The project was built from the ground up using a modern full-stack architecture, with a strong focus on performance, usability, and scalability.
What I worked on
- Full-stack architecture and development
- Interactive WebGIS and map visualization
- Spatial data processing and optimization
- Backend API and database design
- UI/UX design
- Data integration from multiple environmental sources
- Performance optimization for large geospatial datasets
Tech Stack:
Laravel, Next.js, TypeScript, MongoDB, MapLibre GL JS, PMTiles, Cloudflare R2, Tailwind CSS.
github repository:
https://github.com/ammar-rasyidi/mandum-rimba
