📊 Amazon Stock Price Dashboard (1997–2025)
A Power BI Dashboard Project for Data Analyst Internship – Task 4
🌐 Project Overview
This project presents an interactive Power BI dashboard built using Amazon (AMZN) historical stock price data from 1997 to 2025. The dashboard highlights long-term trends, key performance indicators (KPIs), and trading patterns to support financial analysis and insights.
This submission is part of the Data Analyst Internship – Task 4: Dashboard Design, where the goal was to apply visualization skills and build a stakeholder-friendly dashboard.
📁 Dataset Description
File: AMZN_1997-05-15_2025-02-21.csv
The dataset contains Amazon’s stock market performance over a span of 28 years. It includes:
Column Name Description
Date Trading date Open Opening stock price High Highest price of the day Low Lowest price of the day Close Closing stock price Adj Close Adjusted closing price Volume Number of shares traded
🎯 Dashboard Objectives
Visualize Amazon’s stock price trends over time
Track important stock KPIs
Provide interactivity using slicers
Create meaningful visualizations for business decisions
Apply Power BI skills learned during the internship
📌 Key Features of the Dashboard
⭐ KPIs Included
Latest Closing Price
Highest Price Ever
Lowest Price Ever
Average Trading Volume
📈 Visuals Used
Line Chart: Closing price trend (1997–2025)
Column Chart: Daily trading volume
Date Slicer: Filter data by any time range
🎨 Design Elements
Clean and minimal layout
Consistent color palette
Well-organized KPI section
Easy-to-read labels and tooltips
📝 Key Insights
Amazon’s stock grew significantly over decades
Large jumps in price correspond to major business milestones
Trading volume increased as the company scaled
The dashboard makes it easy to identify spikes, dips, and patterns
🛠 Tools Used
Power BI Desktop
Microsoft Excel/CSV
DAX (for KPI calculations)
GitHub