How zahinsyukran/bursa-malaysia-esg-performance-analysis works
This repository is a Bursa Malaysia ESG-versus-KLCI analytics project: market data is acquired and prepared, then presented through a Power BI report backed by a semantic model. The README documents the acquisition, risk/return calculations, and three dashboard layers; the tree identifies the relevant notebooks, datasets, and Power BI files. Notebook internals and model wiring were not sampled, so the data-flow links reflect documented pipeline behavior rather than inspected implementation details.
Main entry points: clean_data.ipynb Clean and Engineer · report.json Report Layout · pull_data.ipynb Pull Market Data · model.bim DAX Model and Schema
Components 15
Data Pipeline
- Pull Market Data
scripts/pull_data.ipynb - Clean and Engineer
scripts/clean_data.ipynb
Analysis Data
- Historical Prices
data/raw/bursa_full_universe.csv - Sector and ESG Mapping
data/raw/mapping_table.csv - Processed Analysis Data
data/processed/bursa_analysis_final.csv
Semantic Model
- DAX Model and Schema
ESG_Bursa_Analytics.SemanticModel/model.bim
Power BI Report
- Report Model Link
ESG_Bursa_Analytics.Report/definition.pbir - Report Layout
ESG_Bursa_Analytics.Report/report.json - Performance Benchmarking
ESG_Bursa_Analytics.Report/report.json - Risk-Adjusted Efficiency
ESG_Bursa_Analytics.Report/report.json - Strategic Insights
ESG_Bursa_Analytics.Report/report.json
Other components
- Analyst
- Yahoo Finance
- Power BI Desktop
- Project Entry Point
ESG_Bursa_Analytics.pbip
Connections 13
- Pull Market Data → Yahoo Finance: fetches prices
- Pull Market Data → Historical Prices: writes data
- Clean and Engineer → Historical Prices: reads prices
- Clean and Engineer → Sector and ESG Mapping: uses metadata
- Clean and Engineer → Processed Analysis Data: writes analysis data
- DAX Model and Schema → Processed Analysis Data: uses dataset
- Report Model Link → DAX Model and Schema: links model
- Report Layout → Performance Benchmarking: presents
- Report Layout → Risk-Adjusted Efficiency: presents
- Report Layout → Strategic Insights: presents
- Analyst → Project Entry Point: opens
- Project Entry Point → Power BI Desktop: launches in
- Power BI Desktop → Report Model Link: loads report