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
This is an end-to-end analysis of S&P 500 stock prices from 2014–2017, covering 505 companies.
Getting here wasn’t a straight line. I hit MySQL connection errors, forgotten passwords, password mismatches, and slicers that refused to filter my charts. Every error message became a small lesson in how SQLAlchemy, MySQL services, and Power BI relationships actually work under the hood. I didn’t just copy steps — I troubleshot my way through each one until I understood why it worked.
The pipeline I built:
🔹 Python (Pandas + SQLAlchemy) to load 497K rows into MySQL
🔹 SQL for data cleaning, quality checks, and analysis
🔹 Power BI for an interactive dashboard with 5 visuals and 3 slicers
Here’s what the data revealed:
📌 The single highest trading volume day was August 24, 2015 — “Black Monday” — when a global market sell-off triggered 4.6 billion shares traded in one day, led by Bank of America and Apple.
📌 Wednesday consistently sees the highest trading volume, Monday the lowest — markets ramp up activity as the week goes on.
📌 Amazon’s most volatile day was June 9, 2017, with an $85.99 swing between its daily high and low.
📌 And the standout investment story: if you’d put money into Nvidia (NVDA) on January 2, 2014 and held until December 29, 2017, you’d have seen a +1,120% return.
This project pushed my SQL and Power BI skills further than any tutorial could — because real data (and real errors) force you to actually understand the tools, not just follow steps.
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 an end-to-end e-commerce BI solution using SQL and Power BI. Cleaned and modeled website session, pageview, order and refund data, developed business KPIs and interactive dashboards to analyze sales, customer behavior, conversion, and marketing performance.
great work💯
Intelligent AI agent platform that automates business workflows using LLM-powered agents, tool calling, task orchestration, and contextual decision-making. Designed to connect business processes, APIs, and data sources while reducing repetitive work and enabling reliable AI-assisted operations.
Great concept! Combining AI agents, tool calling, and workflow orchestration can make business automation much more powerful and scalable. 🚀
I created this Social Media Engagement Dashboard to analyze how different types of content perform across social media. It gives a quick overview of key metrics like likes, posts, and engagement rates, while also showing how engagement varies by post type, category, time of day, posting hour, and verified status. The goal is to help identify what content performs best and when audiences are most engaged.
