Overview

This case study explores Tesla’s stock performance over a six-year period (2020–2025), with a focus on early-year trends (January–April) and the impact of key leadership and policy changes — particularly the appointment of Elon Musk to the Department of Government Efficiency (DOGE) in 2025.

Through Power BI visualizations and year-over-year comparisons, the project investigates whether Tesla's Q1 2025 performance reflects a unique market shift or mirrors patterns from prior years.

Objectives

• Identify early-year trends in Tesla's stock closing price and volatility (Jan–Apr each year)
• Compare pre-DOGE, DOGE-era, and earlier performance patterns
• Assess whether 2025 volatility and growth are outliers or part of a larger trend
• Evaluate Tesla’s stock resilience after historical dips
• Explore potential use of past trends to forecast future performance

Tools Used

• Power BI: Data cleaning, dashboard creation, and trend visualizations
• Python: Date formatting and conditional logic for period labels
• DAX: Measures for average close, volatility, and percent change
• Yahoo Finance: Source of historical Tesla stock data

Key Visuals

Average Close Price by Year (Jan–Apr)

A bar chart showing Tesla’s average close from 2020 to 2025.

Daily Close Price Trends Across Years