Power BI isn’t just about trends and patterns - you can also enter parameters which feed into your model and drive outputs under different scenarios. In this session Rishi will use 2.4 billion rows of NYC taxi data for scenario modelling with potential taxi drivers being able to model revenue/profits under trips with different locations, weather conditions and journey durations in order to work out the optimal taxi driving strategy!

We will build this model using a simple Power Apps form embedded into Power BI, supported by a basic workflow. This solution is made even more seamless by combining a Direct Query connection to the parameter table with an imported data model on the full dataset, utilising the Composite Model feature of Power BI.

The scenario modelling techniques you learn here can be applied to your own data and optimisation strategies and you will see how easy it is to take Power BI beyond just reporting!