Apple Stock Market Analysis

What this project explores.

An end-to-end data engineering and analytics project analyzing historical Apple Inc. (AAPL) stock market data up to the present day, to extract actionable business insights and investment strategies.

Follow the implementation.

1. 01

   Developed a Python-based data extraction script to ingest daily historical stock metrics using the Yahoo Finance API.

2. 02

   Preprocessed raw stock data in Pandas, handling missing data points and calculating rolling averages, volatility, and trading volumes.

3. 03

   Built a data model in Power BI, implementing DAX measures for year-over-year growth, CAGR, and cumulative returns.

4. 04

   Designed an interactive financial dashboard utilizing storytelling techniques to guide users from executive performance down to daily trading trends.

See the work. Inspect the details.

A historical AAPL analysis connecting Python, market data, MySQL, and Power BI.

Enlarge screenshot ↗

Published Power BI home view · Captured from the published Power BI report. Select to enlarge.

INTERACTIVE / POWER BI

Go beyond
the screenshot.

Load the public Power BI report to explore its pages and filters. The interactive view connects to Microsoft Power BI when you choose to load it.

Load interactive report

If the embedded view is unavailable, open the report in Power BI . Published report availability is managed in Power BI.

Choose where to look deeper.

Search the linked source inventory or narrow it to the kind of artifact you want to inspect. Files open at their original source.