Money Excel - Personal Finance Blog

Menu
MENUMENU
MENUMENU
  • Home
  • Business Ideas
    • 225 Small Business Ideas
    • 40 Online Business Ideas
    • 20 Business Ideas for Beginners
    • 20 small manufacturing business
    • 30 Food Business Ideas
    • 100 Business Ideas low investment
  • Stock Market
    • Best Demat & Trading Accounts 2021
    • Best Virtual Trading Apps
    • Best Stock Screener
    • Best Discount Brokers in India
    • Multibagger Stocks of LockDown
    • Rakesh Jhunjhunwala Portfolio
  • Mutual Funds
    • Best Mutual Funds 2021-22
    • Best Direct Mutual Fund Platform
    • Best Mutual Fund Mobile Apps
  • Incometax
    • Income Tax Calculator FY 2020-21
    • Latest Income Tax Slab FY 2021-22
    • Income Tax Refund Request
    • Pay Advance Tax Online
    • Download New 15G -15 H Forms
  • Investment
    • Best Investment Options 2021
    • Long Term Investment Options
    • Best Investment Regular Income
    • Best Investment Options NRI
  • Credit Card
    • Best Credit Cards 2021-22
    • Best credit card for online shopping
    • Best Forex Card in India
    • Best Business Credit Cards
    • Credit Cards against Fixed Deposit
  • Insurance
    • Best Term Insurance Plans 2021
    • Best Health Insurance 2021
    • Best LIC Policy 2021
    • Best Car Insurance Companies
    • Best Mobile Insurance Companies
  • Downloads
Home
Mutual Funds
Mutual Fund Portfolio Analysis using Power BI

Mutual Fund Portfolio Analysis using Power BI

Shitanshu Kapadia March 22, 2019

Mutual Fund Portfolio Analysis is one of the prime requirement for the investor. To fulfill this demand there are several readymade tools available in the market. Most of them are online, paid or available with limited features. Today I will introduce you with a powerful tool that will empower you to conduct your own mutual fund portfolio tracking and analysis. It is free and easy to use tool. The name of the tool is Microsoft Power BI. Microsoft Power BI is a business intelligence and analytics tool that provides interactive visualization for decision making. Power Bi is available with various versions. For Mutual Fund Portfolio Analysis and Tracking, you will need Power BI Desktop. Power BI Desktop Free version can be downloaded from Microsoft site – https://powerbi.microsoft.com/en-us/pricing/

Once you download and install this tool, follow the steps given below to create your own dashboard and report for Mutual Fund Portfolio Analysis.

Also Read – How to use Power BI for Stock Market Analysis?

 Mutual Fund Portfolio Analysis using Power BI

The first step towards developing Mutual Fund Dashboard is providing data source of the portfolio. To provide data source you need to click on a button “Get Data” given in the top navigation bar. You will be prompted to provide a data source. You can provide data source as a website, SQL database, Excel file or any other compatible data source.

For simplicity and ease of understanding, we will use Excel as a data source input. I have use readymade excel file downloaded from my Demat Account. You can use a similar method or you may utilize excel file template used in this example.

Do not miss below posts -
  • Top Performing Mutual Funds for SIP – 2013
  • Top 20 Best Mutual Funds SIP to invest in India …
  • 15 Mutual Funds gives 40%+ Annual Return

The excel file contains various column such as Name of Mutual Fund Scheme, Last recorded NAV, Total Cost of Investment, Unrealized Profit/Loss etc.

You need to provide Excel file location after clicking on Get Data. Power BI will fetch data from all columns and you will be able to see various fields.

mutual fund portfolio

Total Mutual Fund Investment

The first visualization is Total Mutual Fund Investment. This visualization helps you in knowing total investment amount. For the creation of visualization “Total Mutual Fund Investment” click on “Table” under Visualization and select column where you have a total investment value of Mutual Fund. In my case it is Cost. After you get total value select “Card” visualization for proper visibility.  You can change the value in thousand, million and even billion. You can select font size and type. You can also apply the border.

Current Mutual Fund Value

To create visualization “Current Mutual Fund Value” click on “Table” under Visualization and select column where you have current NAV of Mutual Fund. In my case, it is Total value at NAV. After you get total value at NAV select “Card” visualization. For easy identification, you can provide text label.

Unrealized Profit or Loss

Unrealized Profit or Loss is next visualization. This visualization helps you in knowing profit or loss value of entire mutual fund portfolio or individual funds. To create this, first, click on “Table” visualization and select column where you have unrealized profit or loss. In my case, it is Unrealized Profit/Loss. After you get total value click on “Card” visualization.

Fund wise analysis

To know fund wise details in your mutual fund portfolio select “Table” visualization and select multiple column cost, scheme, and unrealized profit/loss. Once value gets reflected you can select “Line and Stacked Column Chart”. This will give you fund a wise analysis of your mutual fund portfolio. You can select a respective mutual fund to visualize Total MF investment, current value and unrealized profit and loss in that fund. You can also apply a scheme wise filter. I have also given the facility to visualize % profit and loss.

Conclusion

Power BI is a powerful tool that can be used for Mutual Fund Portfolio Analysis and Tracking. In the above example, excel based data source is used. You can also use an online website for getting real-time data updates.

If you find difficulty in generating your own dashboard, you can download PBIX file and EXCEL file given here. Provide your mutual fund data in excel file and press Refresh Button your portfolio will reflect on the screen.

Tweet
Share
Whatsapp
Pinterest
Prev Article
Next Article
Tags:Microsoft Power BI Mutual Fund Analysis Power BI Mutual Fund Dashboard Mutual Fund Portfolio Analysis Mutual Fund Portfolio Power BI Mutual Fund Tool Analysis Power BI

About The Author

Shitanshu Kapadia

Hi, I am Shitanshu. By Profession I am Engineer and working in the IT field. I am crazy about Finance and like to research on financial matters. I have written 80+ article on this blog. If you like my efforts kindly subscribe to this blog and also let your friends know about this website by sharing.

Leave a Reply Cancel Reply

Search

Top Posts & Pages

  • Income Tax Calculator FY 2020-21 (AY 2021-22) – Excel Download
  • Rakesh Jhunjhunwala Portfolio Holdings - March 2021
  • Download Income Tax Calculator FY 2021-22 (AY 2022-23)
  • 20 small manufacturing business ideas with low cost
  • Cash Deposit Machine Locator – How to find CDM Near You?
  • LIC Premium Paid Certificate Download For Income Tax Purpose - Online
  • How to check Property Records and Land Records online in India?
  • 235 Small Business Ideas with Low Investment in 2021-22
  • 30 Food Business Ideas with low investment
  • 10 Best Small Trading Business Ideas

Subscribe to Blog via Email

Join 5,476 other subscribers

Follow MoneyExcel

Money Excel – Personal Finance Blog

Personal Finance Blog
Copyright © 2021 Money Excel - Personal Finance Blog
| About |Downloads | Contact Us | Sitemap | Disclaimer | Privacy Policy |