Introduction
In the ever-evolving tech industry, understanding stock trends and performance is vital for data-driven decision-making. This project analyzes the stock data of top tech giants—Apple, Microsoft and Google—providing actionable insights into their volume trends, moving averages and performance comparisons using SQL for data preparation and Tableau for visualization.
Overview
The project focuses on extracting and preparing stock data using SQL and visualizing the results in Tableau.
Key objectives include:
Analyzing historical stock data from 2020 to 2023.
Visualizing key metrics like volume, stock prices and moving averages.
Comparing performance across the three companies for actionable insights.
This comprehensive approach highlights the importance of clean data preparation and impactful visual storytelling.
Tools Used
Python: Data extraction with yfinance Library
SQL: Data Preparation & transformation.
Tableau: Interactive dashboard design and visualization.
Skills Demonstrated
Data Extraction with Yahoo Finance API
Advanced SQL query writing and optimization.
Data cleaning and transformation using SQL.
Building dynamic and interactive Tableau dashboard.
Designing KPIs and incorporating advanced visualizations.
Integration of multiple datasets for storytelling.
Here are some highlights from the analysis:
Apple's Strong Performance: Apple showed consistent growth, achieving the highest average closing price among the three companies during the analysis period.
Google's Volatility: Google exhibited more price volatility, reflected in significant peaks and troughs in its moving averages.
Microsoft's Stability: Microsoft displayed a steady upward trend, driven by consistent growth in stock prices and volume.
Volume Trends: A clear spike in trading activity was observed during significant market events, reflecting investor sentiment.
These insights demonstrate how financial data analysis can uncover trends that help make better investment decisions.
Role in the Project
As an independent Data Analyst, I designed and executed this project from start to finish.
This included:
Extraction of Data using Python
Preparing, Cleaning & Transforming stock data using SQL.
Designing advanced visualizations in Tableau to convey insights.
Creating an intuitive and interactive dashboard for effective storytelling.
Call to Action
Curious to see the full analysis in action?
👉 Explore the Interactive Dashboard
Want to dive into the technical details and source code?
👉 Check Out the GitHub Repository