We’ll look at some examples of data modelling challenges in Power BI that crop up often in finance. For example, calculate the risk associated with open trades, sum peak exposure values over several days, estimate the future revenues of a subscription business taking churn into account. For each example, we’ll look the problem, and demo some approaches using Power BI and DAX.

Mark is an independent consultant and trainer. He specialises in data analysis, visualisation and reporting using Power BI and the Microsoft Data Platform. He has received Microsoft's Most Valuable Professional (MVP) award for the last three years. He has a MA in Natural Sciences from Cambridge and an MBA from Imperial College, London.

Mark is the organiser of London Business Analytics Group, a very popular community meetup group. It has held over 100 free events in the last four years on subjects such as machine learning, data visualisation, ethics of big data, p-values, build data maps and visualising survey data.