NSE Data Analysis Dashboard (Power BI)

Project Overview

This Power BI dashboard provides a detailed analysis of stock market data from the National Stock Exchange (NSE) of India.
It allows tracking of price movements, volume trends, and short-term vs long-term performance, transforming raw stock data into actionable insights for market analysis and investment decisions.

---

Database Schema

The project uses a single table with the following columns:

NSE Stock Data Table

• Company
• Open
• High
• Low
• LTP
• Chng
• % Chng
• Volume (lacs)
• Turnover (crs.)
• 52w H
• 52w L
• 365 d % chng
• 30 d % chng

Relationships:
• Single flat table is used as the data source for all visuals and measures.

---

Power BI File / Code

• Only a Power BI report file is included: NSE_Data_Analysis.pbix (contains data model, DAX measures, calculated columns, and dashboards).

• To view the interactive report, download the .pbix file and open it in Power BI Desktop. (GitHub will only allow downloading the file; it cannot render .pbix in-browser.)

---

Key Queries / Analysis Points

The analysis was done inside Power BI using DAX measures and calculated columns. Key items created:

• Calculated Columns / Measures:

  • Avergae Daily Change %
  • Rank by % Chng (ranking stocks by daily % change)
  • Avg LTP, Total Turnover, Total Volume
  • Short-term vs long-term performance metrics (30 d % chng vs 365 d % chng)

• Dashboards:

  1. Overview Dashboard

     • Shows top gainers & losers, overall market movement, and volume/turnover summary.

  2. Deep-Dive Dashboard (4 charts)

     • Price movement chart: High vs Low vs LTP
     • Volume vs Turnover chart: Ranked
     • 52-week range overview
     • Short-term vs long-term % change comparison (30-day vs 365-day)

---

Insights & Findings

• Market is currently weak: Market strength is at -70.13, indicating a bearish trend.
• Average daily change negative: Avg Daily Change % is -2.93%, showing general downward movement in prices.
• High price volatility: Maximum LTP in the dataset is 25.90K while minimum LTP is 121.15, suggesting a wide spread of stock prices.
• Top movers: Companies like CIPLA, DIVISLAB, DRREDDY, and NESTLEIND show significant daily % changes and high turnover, making them key stocks to watch.
• Stock performance trends: Annual % change is consistently higher than monthly % change for most stocks, suggesting longer-term growth or decline is more pronounced than short-term fluctuations.
• Price vs 52-week range: Example stock HEROMOTOCO is trading near its 52-week low (LTP: 2,526.80 vs 52w L: 2,505.15), indicating potential undervaluation or recent decline.

---

Repository Structure

NSE_Data_Analysis/

├── NSE_Data_Analysis.pbix # Power BI report (download to view)

└── README.md # Project overview, schema, analysis, insights

---

AUTHOR

Sejal Jain – SQL & Data Analysis Enthusiast

• GitHub: https://github.com/sejaljain1601-ui

• LinkedIn: https://www.linkedin.com/in/sejal-jain-lko