Financial Model with DCF (Power BI)

I created a Power BI report that involved the implementation of 98 DAX measures. To ensure the accuracy of the financial ratios, I utilized Excel to calculate the majority of them. Additionally, I set up Power Query Automation to prepare the data for Power BI, which streamlined the entire process.

To further enhance the data pipeline, I integrated it with Screener.in , a website that allows users to export financial data in Excel format.

However, the most complex part of the project was the development of the DCF (Discounted Cash Flow) calculation. I built this calculation using DAX as it required inputs of the growth rate %, discount rate %, and terminal growth rate %. The DCF calculation was critical to providing insights into the company's future growth and profitability potential.

Overall, this project showcases my proficiency in using Excel, Power Query, and DAX to create comprehensive and dynamic Power BI reports that provide valuable insights for financial analysis.