π NIFTY 50 Stock Market Analysis Dashboard π Project Overview
This project is an interactive Stock Market Analysis Dashboard developed using Power BI to analyze NIFTY 50 stock data (2000β2021).
The dashboard provides insights into:
Stock price trends Company-wise returns Market volatility Trading activity Top gainers and losers πΌοΈ Dashboard Screens πΉ Introduction Page Overview of the project Highlights purpose: return, volatility, and trend analysis πΉ KPI & Trend Dashboard Maximum Price β 32.86K Minimum Price β 9.15 Overall Return β 78.56% Volatility β 3.54% Turnover β 161.01T Visuals: π Price Trend (multi-stock time series) π Volume of Company (bar chart) πΉ Return & Price Analysis π Treemap: Overall return by company Example: SHREECEM shows highest return π Price Comparison Chart Multi-company price movement from 2000β2021 π― Company Filter (Slicer) Enables individual stock analysis πΉ Top Gainers & Losers π Top Gainers SHREECEM BAJFINANCE EICHERMOT MARUTI π Top Losers INFY ZEEL WIPRO ITC IOC
π Date filter for dynamic analysis π Dataset Details Index: NIFTY 50 Time Period: 2000 β 2021 Features: Date Company Name Open Price High Price Low Price Close Price Volume
βοΈ Tools & Technologies Power BI β Dashboard creation DAX β Calculated measures Excel / CSV β Data source
π§ Insights from Dashboard Identified high-growth stocks over long-term Compared company-wise performance Observed market trends and fluctuations Highlighted top gainers and worst performers Analyzed trading volume distribution
π How to Use Open the .pbix file in Power BI Navigate between dashboard pages Use: Company slicer Date filter Explore trends, returns, and comparisons
π Future Enhancements Real-time stock data integration AI/ML-based stock prediction Sector-wise breakdown Advanced indicators (RSI, MACD)
π¨βπ» Author --Sandesh Futane π Data Analytics Project
β Project Highlights Real-world financial data analysis Strong Power BI + DAX implementation Interactive and visually rich dashboard Clear business insights and storytelling