The Nifty 50 2023 Market Trend Analysis Dashboard is a comprehensive tool designed to provide a detailed analysis of the Nifty 50 index trends throughout the year 2023. This dashboard offers valuable insights into market movements on a monthly basis, enabling traders, investors, and analysts to make informed decisions based on historical data. By examining key metrics such as daily movements, opening gaps, absolute price changes, and turnover, users can identify patterns and trends that may influence future market behaviour.

Key Features:

• Daily Movement Analysis: A donut chart representing the distribution of daily market movements within specific ranges, allowing users to quickly assess market volatility and frequency of different price changes.

• Opening Gap Analysis: A visualization that shows the number of days the market opens with a gap (up or down), providing insights into market sentiment and pre-market activity.

• Range High-Low Analysis: A bar and line chart that displays the absolute range between the high and low prices each month, alongside the percentage range, offering a clear view of the monthly market volatility.

• Absolute Movement (Close - Open) Analysis: A combination chart highlighting the monthly absolute movement between closing and opening prices and the percentage moved, which helps in understanding intraday market behaviour.

• Turnover and % Movement Scatter Plot: A scatter plot visualizing the relationship between the turnover (₹ Cr) and percentage movement, helping identify trends and patterns in market activity.

• Turnover Trend Analysis: A dual-axis chart showing the monthly trend in turnover (₹ Cr) and shares traded, providing insights into market liquidity and trading volume over time.

Requirements:

• Power BI Desktop: The primary tool used for creating the dashboard and visualizations.

• Dataset: A detailed dataset containing daily Nifty 50 index data, including opening and closing prices, high and low prices, turnover, and volume of shares traded.

• Basic Knowledge of Power BI: Understanding how to use Power BI Desktop for data manipulation, creating visualizations, and dashboard design.

• Financial Market Understanding: Familiarity with market terms and concepts to interpret the data accurately.

This dashboard empowers users with the data-driven insights needed to anticipate market trends and develop informed trading strategies for the Nifty 50 index.