💹 Analysis of Coca-Cola (KO) Stock Performance from 1962 to 2022.

Analysis of Coca-Cola Inc. (KO) daily OHLCV data highlights a robust 60-year growth path (1962 to 2022) that evolved from sparse trading volumes to elevated monthly averages. It narrows down the trends to show steady performance over decades. Power BI visuals use optimized charts to track price and volume growth by month, quarter, and year, and KPI cards to highlight win rates and returns.

📂 Repository Layout

• 🗄️ dataset – Raw dataset and cleaned CSV files

• 📈 analysis charts – Final analysis visuals (PNG)

• ⚙️ process charts – Technical work steps visual (PNG)

• 💡 insights.md – All insights from analysis

• 📖 README.md – Project overview

  🛠️ Tools Used

• Excel – Initial dataset validation (rows/columns)

• Power Query - Data cleaning and transformation

• Power BI – Interactive visualizations

• GitHub – Hosting documented projects

• Markdown – Documentation (.md files)

🧠 Skills Demonstrated

• Power BI dashboard design for 60+ years of KO stock data trends
• DAX measure creation (AVERAGE, SUM, DIVIDE) for accurate aggregations
• Data transformation from raw to cleaned datasets
• Financial visualization of historical stock performance
• Problem-solving to match and analyse aggregation trends

📊 Business Questions Answered

Q	Business Question	Visualizations Used
Q1	Average KO volume by year	Clustered Column Chart
Q2	Average KO volume by month	Clustered Column Chart
Q3	Average KO close price by year	Area Chart
Q4	Average KO close price by quarter	Clustered Column Chart
Q5	Average KO close price by month	Clustered Column Chart

💡 Key Insights

Coca-Cola (KO) offers unmatched reliability: ~48% daily wins, 1.74% low volatility, 152,050% growth (0.04 to 60.86), and ±5% steady volume driven by recession-proof beverage demand, pricing power, and globally accepted brand. See Insights Here

📉 Analysis Findings

key data points and metrics extracted from the KO analysis. See Findings Here

⚙️ Process Charts

Work-in-progress charts showing screenshots of analysis steps. See Process Charts Here

📈 Analysis Charts

This folder holds all the final charts and visualizations created from this analysis. These include resistance trends over time, comparisons by gender, age group, and bacterial species. View charts here: See Analysis Charts Here

🗄️ Dataset

Raw Dataset – Original KO stock data (1962-2022): open, high, low, close prices + daily volume (~15K trading days).
Cleaned Dataset – Processed CSVs with optimized data types for Power BI analysis. See Datasets Here

🔗 Data Source

Coca-Cola Stock Dataset (1962–2022) by Kalilur Rahman (Kaggle). Dataset Source