Score a company using BRSR and sustainability disclosures
A clean analytics dashboard or notebook with business question, dataset, metrics, insights, and decision recommendation.
Build
Model, memo, dashboard, notebook, or deck.
Explain
Clear assumptions, insight, and recommendation.
Show
Resume bullet and interview story.
What you are doing
You are working as a Investment Banking. Your manager asks you to use ESG analysis to answer a real business or investment question and present a decision-ready output.
Show that you can apply ESG analysis in a practical analyst workflow, not only explain the theory.
What to make
A clean analytics dashboard or notebook with business question, dataset, metrics, insights, and decision recommendation.
Deliverables
- Brief
- Model or notebook
- Charts or dashboard
- Resume bullet
- Source and assumption log
- One-page executive summary
- Final output file
How to start
- Define the business question and stakeholder.
- Create or source a dataset with a data dictionary.
- Choose 5-8 metrics that answer the question.
Step-by-step execution
- Clean data and document assumptions.
- Create SQL queries or Python transformations.
- Build visualizations for trend, mix, cohort, funnel, and exception analysis.
- Write insights and recommended actions.
- Package the final output so someone can read it without your explanation.
Data and sources
- Public Kaggle-style dataset
- Synthetic transaction dataset
- Company metrics from filings
- RBI/NPCI public statistics
- Open government data
Tools to use
- BRSR
- annual report
- Python or Google Colab
- CSV dataset
- Charts
Quality rubric
- Metric definitions are clear.
- Charts answer real business questions.
- Data quality issues are documented.
- Insights lead to decisions.
- Dashboard avoids clutter and vanity metrics.
Resume bullet
Built a a clean analytics dashboard or notebook with business question, dataset, metrics, insights, and decision recommendation. for ESG analysis, using BRSR, annual report to convert raw information into a decision-ready finance output.
Interview talk track
- Problem: explain the business question and why it matters for Investment Banking.
- Method: describe the data collected, assumptions made, and analysis performed.
- Decision: state the recommendation, key risk, and what would change your view.