Download the templates (free): pages.ptarmy.com/download
Excel has always been the standard for pro forma financials and modelling, but PowerBI will overtake it in the near future. Watch this tutorial to level up your modelling skills, and give your customers the flexibility enabled by a web based income statement with sensitivity sliders. This is part one, next up is the balance sheet and cash flow statement.
🚀Who Should Watch This ChatGPT/Power BI Tutorial?
Beginners interested in how to model an income statement
Finance professionals who are excel masters, but curious about PowerBI
Data enthusiasts interested in new ways to work with data
🎯Timestamps:
[00:00] Opening
[01:20] Excel vs PowerBI Modelling
[02:23] 3 Reasons PowerBI is better
[03:37] Basic Data Inputs
[07:30] Concepts of PATH and hiearchy
[10:51] Custom Sorting
[12:17] Magic Income Statement Measure
[16:27] Pro Forma Forecast
[17:37] User Parameters for Sensitivities
[18:57] Measure #2 - adding forecast
Негізгі бет PowerBI Pro Forma Financials: Modelling Beyond Excel | Part 1
No video
Пікірлер: 19