How samyakkk11/indian-mutual-fund-intelligence works
This repository is a static mutual-fund analytics pipeline and Power BI dashboard. Its main workflow loads compiled NAV and scheme-master data into DuckDB, filters an active Direct-Growth universe, calculates daily returns, detects discontinuities, builds performance and risk analytics, validates and exports datasets, then presents them in Power BI. The graph preserves documented profiling and age-tier enrichment alongside the main path. Some pipeline ordering and the Power BI input relationship are documented in the README; unsampled implementation details are not inferred.
Main entry points: build_model.py Raw data model · run_analysis.py Analytics workflow · build_fund_analytics.py Performance and risk · add_fund_age_tier.py Fund age tiers
Components 15
Data inputs
- Path configuration
data/src/scripts/config.py - Source profiling
data/src/scripts/inspect_mf_data.py
DuckDB preparation
- Raw data model
data/src/scripts/build_model.py - DuckDB model
- Fund universe
data/src/scripts/create_fund_universe.py
Analytics and quality
- Daily returns
data/src/scripts/create_daily_returns.py - NAV discontinuities
data/src/scripts/flag_nav_discontinuities.py - Analytics workflow
data/src/scripts/run_analysis.py - Performance and risk
data/src/scripts/build_fund_analytics.py - Fund age tiers
data/src/scripts/add_fund_age_tier.py - Data validation
data/src/scripts/check_nesting.py - Parquet datasets
Dashboard
- Power BI report
Mf_Dashboard.pbix
Other components
- Compiled AMFI data
- Analyst
Connections 15
- Compiled AMFI data → Raw data model: supplies NAV and master
README.md - Path configuration → Raw data model: provides paths
data/src/scripts/build_model.py - Raw data model → DuckDB model: creates model
data/src/scripts/build_model.py - DuckDB model → Fund universe: reads scheme master
data/src/scripts/create_fund_universe.py - DuckDB model → Daily returns: reads NAV and universe
data/src/scripts/create_daily_returns.py - DuckDB model → NAV discontinuities: reads daily returns
data/src/scripts/flag_nav_discontinuities.py - DuckDB model → Analytics workflow: queries analytical tables
data/src/scripts/run_analysis.py - Analytics workflow → Performance and risk: builds analytics
README.md - Performance and risk → Parquet datasets: exports Parquet
- DuckDB model → Fund age tiers: joins scheme master
data/src/scripts/add_fund_age_tier.py - Parquet datasets → Fund age tiers: enriches dataset
data/src/scripts/add_fund_age_tier.py - Parquet datasets → Data validation: checks nesting
data/src/scripts/check_nesting.py - Parquet datasets → Power BI report: feeds dashboard
README.md - Analyst → Power BI report: explores fund metrics
README.md - Analyst → Source profiling: profiles source data