SQLBits 2020

Financial Modelling with Power BI

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

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.

Come along to see the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.

Challenges Include:

- 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

Speaker

Bob Duffy is a SQL Server MVP, currently working as Database and Solution Architect in Dublin, Ireland. He has over 28 years experience in the database sector, with MCA, MCM and Maestro certification.

Bob Duffy's Sessions

From SSIS to Synapse to Fabric - A Data Architects Case Study

Financial Statements with Power BI - Part 1 P&L/BS

EDW Automation in Synapse SQL Pools

SQL Storage Fundamentals for Azure VMs

Financial Modelling with Power BI

The European Economic Crisis and the Euro-A Data Tale

Scaling the DVD Store from 100 to a million TPM

When good SQL design goes bad

Migrating to the Cloud

Optimising Cube Processing

The Irish Economic Crisis, Visualised with Power BI

SQL 2012 Always on Deep Dive

Windows Azure For SQL folk

SQL 2012 Always On-Deep Dive

Load Testing Analysis Services

SQL Consolidation Planning

SQL tuning from the dot.net perspective