niravtrivedi23/mutual-fund-analysis-Dashboard-Python-PowerBI — reverse-engineered prompt

Build me a mutual fund analysis project that helps a normal investor find the best low risk funds with strong returns. I want to start from a dataset of mutual fund schemes, clean it in Python, fix missing values and messy number formats, then score each fund based on things like 3 year return, 1 year return, expense ratio, risk level, fund age, AMC, category, SIP amount, and lump sum amount.

Please create an output file with the top 30 mutual funds ranked clearly, plus a professional dashboard that explains the results in a simple way. The dashboard should let me filter by fund type, category, AMC, risk level, rating, and sub category. Show cards and charts for total AUM, SIP vs lump sum, expense ratio comparison, 3 year returns, top AMCs, fund manager AUM, and short plain English insight cards.

Make it clean enough to use as a portfolio project. Look up current docs online if needed.