SQL, Python & Power BI Learning Roadmap
For Risk Analysis & Stress Testing Project
Deadline: Aug 29 (Rough Draft) | Final Submission: Mid-September
OVERVIEW
Total Duration: 20 weeks (4 months)
Weekly Commitment: 12-15 hours/week
Total Hours Required: ~160-200 hours
Project Deadline: August 29, 2026 (Rough Draft)
Final Submission: Mid-September 2026
PROJECT TOPIC
"Risk Analysis & Stress Testing of Nifty 50: A Comparative Study Using VaR and GARCH
Models"
Deliverable: 70-80 page report with SQL queries, Python code, and Power BI dashboard
DETAILED WEEK-BY-WEEK ROADMAP
WEEKS 1-2: SQL BASICS
What to Learn:
SELECT, WHERE, ORDER BY
JOIN, GROUP BY, HAVING
Aggregate functions (SUM, AVG, COUNT)
CREATE TABLE, INSERT
Resources (FREE):
1. Mode Analytics SQL Tutorial
URL: [Link]
Type: Interactive, learn by doing
Duration: 6-8 hours
Best for: Complete beginners
2. HackerRank SQL
URL: [Link]
Type: Practice problems
Duration: 5-6 hours
Best for: Hands-on practice
3. YouTube: Alex The Analyst SQL
URL: [Link]
Type: Video tutorials
Duration: 4 hours
Best for: Visual learners
Time Commitment:
3-4 hours/week
Deliverables by Week 2:
✓ Complete Mode Analytics tutorial
✓ Solve 10+ HackerRank problems
✓ Understand basic SQL queries
WEEKS 3-4: DATA DOWNLOAD & SETUP
What to Do:
Download Nifty 50 historical data
Create SQL database
Practice querying real data
Data Sources (FREE):
1. NSE Website
URL: [Link]
Format: CSV download
Data: Historical Nifty 50 prices
2. Yahoo Finance API
Use: Python library (learn later)
Format: API access
Benefit: Automated data download
3. Kaggle Datasets
URL: [Link]
Search: "Nifty 50"
Format: CSV files
Tools:
DB Browser for SQLite (already on your computer)
OR SQLiteOnline: [Link]
Time Commitment:
3-4 hours/week
Deliverables by Week 4:
✓ Nifty 50 data downloaded
✓ SQL database created
✓ 5-10 SQL queries working
✓ Can extract daily returns, volatility, etc.
WEEKS 5-6: PYTHON BASICS
What to Learn:
Variables, loops, functions
Libraries: Pandas (data manipulation), NumPy (math)
Basic file handling
Installing libraries
Resources (FREE):
1. Codecademy Python (Free Tier)
URL: [Link]
Type: Interactive
Duration: 8-10 hours
Best for: Hands-on learners
2. YouTube: Corey Schafer Python
URL: [Link]
osiE80TeTt2d9bfVyTiXJA-UTHn6WwU
Type: Video series
Watch: First 10 videos (~8 hours)
Best for: Comprehensive understanding
3. DataCamp (Free Tier)
URL: [Link]
Type: Interactive courses
Duration: 4-5 hours
Best for: Data science focus
Installation:
Download Python: [Link]
IDE: Visual Studio Code (free) or PyCharm (free tier)
Time Commitment:
4-5 hours/week
Deliverables by Week 6:
✓ Python installed and working
✓ Can load CSV data
✓ Can manipulate data with Pandas
✓ Write 3-5 simple Python scripts
WEEKS 7-8: PYTHON - VaR CALCULATION
What to Learn:
Load Nifty data into Python
Calculate daily returns
Calculate VaR (3 methods):
Historical VaR
Parametric VaR (normal distribution)
Monte Carlo VaR
Resources (FREE):
1. YouTube: Risk Models Explained
Search: "VaR calculation Python"
Duration: 5-6 hours
Best for: Conceptual understanding
2. Medium Articles
Search: "VaR Python tutorial"
Duration: 3-4 hours
Best for: Code examples
3. Python Libraries (FREE):
Pandas (data manipulation)
NumPy (mathematics)
SciPy (statistics)
Code Template:
python
import pandas as pd
import numpy as np
# Load data
data = pd.read_csv('[Link]')
returns = data['Close'].pct_change()
# VaR calculation
var_95 = [Link](0.05)
print(f"VaR at 95% confidence: {var_95}")
Time Commitment:
4-5 hours/week
Deliverables by Week 8:
✓ VaR code working
✓ 3 VaR methods implemented
✓ VaR values calculated for Nifty 50
✓ Results saved/exported
WEEKS 9-10: PYTHON - GARCH MODEL
What to Learn:
GARCH(1,1) model theory
Fit GARCH to Nifty data
Forecast volatility
Backtest forecasts
Resources (FREE):
1. YouTube: GARCH Models
Search: "GARCH Python tutorial"
Duration: 5-6 hours
Best for: Step-by-step learning
2. GitHub/Medium Tutorials
Search: "GARCH implementation Python"
Duration: 3-4 hours
Best for: Real examples
3. Python Library: arch
Install: pip install arch
Docs: [Link]
Duration: 2-3 hours learning
Code Template:
python
from arch import arch_model
import pandas as pd
# Load returns
returns = pd.read_csv('nifty50_returns.csv')
# Fit GARCH
model = arch_model(returns, vol='Garch', p=1, q=1)
result = [Link]()
# Forecast
forecast = [Link](horizon=5)
print(forecast)
Time Commitment:
4-5 hours/week
Deliverables by Week 10:
✓ GARCH model fitted
✓ Volatility forecasts generated
✓ Backtest results (actual vs. forecast)
✓ All data ready for Power BI
WEEKS 11-12: POWER BI BASICS
What to Learn:
Connect data sources
Create visualizations (charts, graphs)
Build interactive dashboard
DAX basics (formulas)
Resources (FREE):
1. Microsoft Learn (Official)
URL: [Link]
Type: Official documentation
Duration: 8-10 hours
Best for: Comprehensive learning
2. YouTube: Guy in a Cube
URL: [Link]
Type: Video tutorials
Watch: First 15 videos (~10 hours)
Best for: Best Power BI tutorials
3. Udemy Free Courses
Search: "Power BI beginner free"
Duration: 6-8 hours
Best for: Structured courses
Download:
Power BI Desktop (FREE): [Link]
Time Commitment:
4-5 hours/week
Deliverables by Week 12:
✓ Power BI installed
✓ Can connect to data sources
✓ Created 3-5 sample visualizations
✓ Built basic dashboard
WEEKS 13-14: BUILD PROJECT DASHBOARD
What to Build:
Import VaR + GARCH results into Power BI
Create dashboard showing:
Daily VaR trend (line chart)
GARCH volatility forecast (comparison chart)
Stress test scenarios (scenario impact)
Key metrics (KPI cards)
Dashboard Components:
Time Commitment:
5-6 hours/week
Deliverables by Week 14:
✓ Complete Power BI dashboard
✓ All metrics visualized
✓ Dashboard looks professional
✓ Export for report
WEEKS 15-16: STRESS TESTING & ANALYSIS
What to Do:
Design 3-4 stress scenarios
Scenario 1: 2008 financial crisis (-20% market drop)
Scenario 2: COVID crash (-30% drop)
Scenario 3: RBI interest rate hike (+200 bps)
Scenario 4: Geopolitical event (-15% drop)
Calculate impact on Nifty 50
Interpret results
Analysis Focus:
Portfolio loss in each scenario
VaR adequacy
Risk mitigation strategies
Time Commitment:
4-5 hours/week
Deliverables by Week 16:
✓ Stress test scenarios completed
✓ Impact analysis done
✓ Results visualized
✓ All data for report ready
WEEKS 17-20: WRITE ROUGH DRAFT (BY AUG 29)
Report Structure: 50 Pages
1. Title Page & Abstract (2 pages)
2. Introduction (5 pages)
Why risk management matters
Nifty 50 overview
Project objectives
3. Literature Review (8-10 pages)
Risk management concepts
VaR methodology
GARCH theory
Stress testing framework
4. Methodology (8-10 pages)
Data sources (with SQL queries shown)
VaR calculation methods
GARCH(1,1) model setup
Stress test scenarios
5. Implementation (8-10 pages)
Python code (with explanations)
Calculations performed
Results summary
6. Results & Analysis (10-12 pages)
VaR findings
GARCH forecasts
Stress test results
Visualizations (Power BI screenshots)
Writing Tools (FREE):
Google Docs: [Link]
Microsoft Word (if you have it)
Overleaf (LaTeX): [Link]
Time Commitment:
5-7 hours/week (writing intensive)
Deliverables by Aug 29:
✓ 50-page rough draft
✓ All sections drafted
✓ SQL queries, Python code, Power BI dashboard included
✓ Visualizations embedded
WEEKS 21-24: FINAL POLISH (SEPT 29 FINAL SUBMISSION)
Final Report Structure: 70-80 Pages
Add to Rough Draft:
Expand stress testing section (5-10 pages)
Add case studies:
2008 financial crisis impact
COVID-19 market crash analysis
Historical data comparison
Policy recommendations (3-5 pages)
Polish writing and formatting
Add comprehensive appendix:
All SQL queries
Complete Python code
Power BI dashboard screenshots
Data tables and calculations
References
Deliverables by Sept 30:
✓ 70-80 page final report
✓ Professional formatting
✓ All code and visualizations included
✓ Ready for submission
WEEKLY TIME COMMITMENT SUMMARY
Weeks Focus Hours/Week Total Hours
1-2 SQL Basics 3-4 7-8
3-4 Data Setup 3-4 7-8
5-6 Python Basics 4-5 9-10
7-8 VaR Calculation 4-5 9-10
9-10 GARCH Model 4-5 9-10
11-12 Power BI 4-5 9-10
13-14 Build Dashboard 5-6 11-12
15-16 Stress Testing 4-5 9-10
17-20 Write Rough Draft 5-7 22-28
21-24 Final Polish 4-6 18-24
TOTAL ~14 hrs/week ~120-140 hours
ACTION ITEMS - START THIS WEEK
TODAY:
1. ☐ Bookmark Mode Analytics SQL Tutorial
2. ☐ Create free accounts:
HackerRank: [Link]
Codecademy: [Link]
Kaggle: [Link]
3. ☐ Open DB Browser for SQLite (already on your computer)
By Tomorrow:
1. ☐ Start Mode Analytics SQL (Lesson 1)
2. ☐ Complete first 3 SQL lessons
3. ☐ Do 3 HackerRank SQL problems
By End of Week:
1. ☐ Finish Mode Analytics SQL tutorial (6-8 hours)
2. ☐ Do 10 HackerRank SQL problems
3. ☐ Download Nifty 50 data from NSE
KEY RESOURCES SUMMARY
SQL Learning:
Mode Analytics: [Link]
HackerRank: [Link]
YouTube (Alex): [Link]
Python Learning:
Codecademy: [Link]
YouTube (Corey): [Link]
osiE80TeTt2d9bfVyTiXJA-UTHn6WwU
DataCamp: [Link]
Python Libraries:
Pandas: Data manipulation
NumPy: Mathematical operations
SciPy: Statistical functions
ARCH: GARCH modeling
Power BI Learning:
Microsoft Learn: [Link]
YouTube (Guy in a Cube): [Link]
Udemy: Free Power BI courses
Data Sources:
NSE: [Link]
Yahoo Finance: Via Python API
Kaggle: [Link]
Tools (All FREE):
DB Browser for SQLite (already installed)
Python: [Link]
VS Code: [Link]
Power BI Desktop: [Link]
Google Docs: [Link]
FINAL NOTES
✓ You have a clear path forward ✓ All resources are FREE ✓ Timeline is realistic (14
hrs/week) ✓ You can do this by Aug 29
Start TODAY. Don't delay.
Good luck! 🚀
Document Version: 1.0 Last Updated: June 9, 2026 Total Duration: 20 weeks (4 months)