Scalable Modelling; using MS Fabric to dislodge OLAP cubes (Future of Financial Modelling Part 3)
Join us for an enlightening meetup as we continue our journey into the Future of Financial Modelling, powered by cutting-edge technology and AI. Hosted by Danielle Stein Fairhurst, Part 3 in this series culminates with an in-depth exploration of Microsoft Fabric, presented by technology and financial modelling expert, Lance Rubin. He delves into its potential to disrupt traditional OLAP Cube modelling systems that will revolutionise traditional accounting, (more…)
As AI technology evolves rapidly through advances such as ChatGPT, let’s consider how this will impact the financial modelling industry. Join industry leaders Jeff Robson, Lance Rubin and Craig Hatmaker and host Danielle Stein Fairhurst for a virtual meetup to discuss how these technological advancements might impact the process of building a model along with the role and skills of a financial modeller both today and in the future. 
Welcome to a 5-part video series on the “Must-have Excel Functions for Financial Modelling”. If your financial model is showing some returns, growth rates or any outputs that are fluctuating quite a bit over time, it’s useful to see what the compound annual growth rate is for this. In part 4 of this series, we take a look at a couple of different ways to calculate the compound annual growth rate (CAGR) using simple Excel functions. 
A Monte Carlo simulation is a numerical method that uses random draws to perform calculations and complex problems. Contrary to what many people think, you don’t need programming knowledge or a fancy software to start using the power of Monte Carlo Simulations in your Excel models. Watch to see the Hybrid meetup replay of the Sydney financial Modelling meetup group with visiting Associate Professor of Finance, David Brown during his trip to Sydney. 
If you’ve had any experience building financial models for others to use, you’re probably familiar with the ways users can use and misuse your model. In fact, one of the key sources of financial model error occurs when a model is not used for its intended purpose or users enter invalid inputs which cause incorrect calculations and inadvertent output error. 
It is well-documented that up to 90% of spreadsheets contain errors and although any individual mistake may be small, they can quickly add up. Checking for errors is an important part of the financial model build and there are many native Excel tools that can be used for this purpose. 
Excel today is not the Excel of yesterday. Dynamic Array Functions and Custom Data Types are just two of the relatively new must-know game-changing features. In this session, Microsoft trainer Mike Thomas gives us a tour of the most useful techniques, incorporating practical use cases that can help take your productivity in Excel to the next level.
At the recent Financial Modelling Summit, 
