kisutsajack-ai/nairobi-stock-market-analysis-powerbi

NSE Market Intelligence Dashboard — Democratizing access to equity market data for retail investors in Kenya. Analyzes 40+ listed companies across valuation, dividend and growth metrics to reduce information asymmetry in an emerging market where professional data tools are cost-prohibitive for small-scale investors. 📊 Nairobi Securities Exchange (NSE) Market Performance Dashboard. 📌 Project Overview This project analyzes the performance of **40 companies listed on the Nairobi Securities Exchange (NSE)** using financial indicators such as market capitalization, valuation ratios, dividend yield, trading volume, and earnings growth. The objective of the dashboard is to provide **a clear view of market structure, company valuation, and investment opportunities** through interactive visualizations built in Power BI. --- 🎯 Business Problem Investors and analysts often struggle to quickly understand **which companies dominate the market, which sectors drive growth, and which stocks may be undervalued or overvalued**. Key Questions: - Which companies dominate the NSE by market capitalization? - Which sectors control the largest share of the market? - Which stocks provide the highest dividend returns? - Which companies show strong earnings growth relative to valuation? - Which stocks are most actively traded? --- 🧹 Data Preparation Prepared the dataset using Excel before importing into Power BI. - Cleaned financial data and removed inconsistent formats - Converted abbreviated values (K, M, B, T) into numeric values - Structured dataset into a flat table suitable for Power BI - Created calculated columns for market cap and trading volume - Validated missing values for financial ratios - Created four Power BI pages covering the market, companies, and valuation-growth relationships. - Used scatter analysis to identify observations for deeper investigation. --- 📐 Data Modeling Data model designed to support financial analysis and visualization. Fact Table: **NSE Companies Dataset** Key variables included: - Company Name - Sector - Market Capitalization - Trading Volume - P/E Ratio - EPS - EPS Growth % - Dividend Yield % Measures created using DAX: - Total Market Capitalization - Average P/E Ratio - Maximum Dividend Yield - Total Trading Volume --- 📊 Analytical Pages …