SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’

Online Microsoft Data Platform Lunch Sessions

SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’

2021-01-21 Past SQL Friday Sessions 0
Time:12:00 Central European Time (11:00AM UTC)
Accompanying material:https://prodata.ie/2020/10/02/financial-modelling-in-powerbi-downloads/
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’

Bob has been involved in taking Financial Models from paper based to highly dynamic analytics models in Microsoft BI for many large enterprises in Ireland.

Building Successful Financial Models based of a Chart of Accounts and General Ledger can be difficult for a number of reasons:
– Dynamic/Growing Chart of Accounts
– Many to Many Structure
– Parent Child
– Ragged Hierarchies on financial reports
– Unary Operators such as running sums
– Entity Attribute Value structures
– Forecasting and Budgeting
– Overhead Allocation
– Modelling Profit Variations like EDBITA

Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.

About Bob Duffy

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM and now Analysis Services “Maestro” certified.

Bob used to work for Microsoft Consulting Services a Senior Consult and subject matter expert for BI/data. He now works at the Prodata SQL Centre off Excellence in Dublin, Ireland where he helps enterprise customers with cloud architecture, design, performance tuning, benchmarking and pretty much anything to do with SQL Server or Business Intelligence.