Advanced Simulations in Power BI

Power BI

What was built?

Monte Carlo Simulation dashboard for valuation optimisation.

Why was IT built?

For education purposes and showing the power of dynamic arrays.

How the client now uses it for decisions/business?

Educate the client on evolving innovation in Dynamic Arrays and the merging of analytics and modelling.

I’ve worked with Lance on Data Analytics and highly value his skills. His models have been crucial in detailed RFPs with the government. Lance’s understanding of our business enables him to add significant value both in deliverables and thought leadership.

National Australia Bank

Business Leaders and Social Impact

Case Studies

Explore Other Case Studies

Shop Ready-Made Models

Views
0 K
Downloads
0 K
Reviews
0 +

This best practice resource is designed for finance professionals, accountants, and analysts seeking to leverage AI and automation, along with applying Modern Excel functions and features in their modelling workflows. Based on the “Friday’s Future of Finance Lab” session, this package provides a comprehensive overview of the skills, tools, and mindset required to thrive as an AI-powered accountant

Excel with structured table export from 3-way model to PowerBI already transformed. Google Analytics Data included too

USD 399.00

Newly released Dynamic Arrays functionality by Microsoft means models are now more powerful than ever!

USD 299.00

This is essential for all businesses that sail very close to the wind as they say. Cash is tight and you have to monitor it on a rolling 13-week basis

USD 299.00

Yield Curve Simulation Model (automated commentary) showing global impacts of yield curves on bond valuations

USD 25.00

A full Monte Carlo Excel Simulation 3-way Financial Model with dashboards and Xero accounting data source with scenarios and dashboards

USD 299.00