Financial Modelling in Power BI

How do you build three-way integrated financial statements into business intelligence suite?  Simple!  Use Power Query, Power Pivot and Power BI to consolidate historical, actual and forecast data which may be presented in Power BI dashboards with what-if? analysis capabilities.

End users will see how Power Query cleans up the data, Power Pivot links the data and uses its in-built language (DAX) to create Key Performance Indicators that generate the financial statements. Power BI then wraps it all up in a nice little bow with graphical representations and an interactive dashboard.

Tricks shown include how to move Excel data models into Power BI in seconds the right way and the wrong way.

Data Modelling & Formulas