The Agenda
Agenda HomeSQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
Data Visualisation & Modelling
Financial Reporting with Power BI
Description
Learn how to build financial reports in Power BI (focused on Income Statement) with a complete end-to-end run through of designing a data model based on financial transactions, ingesting monthly system extracts (CSV), data modelling/DAX (including time intelligence) and data visualisation.
In this session you will learn how to:
• Capture report (and non-functional) requirements and design a corresponding data model to be built in Power BI
• Apply transformations to data in Power Query including how to automatically combine monthly CSV files, apply currency conversion and work with data at different grains/levels of detail (actual vs budget)
• Create basic calculations in DAX including key ratios such as Gross Profit % and Cost:Income Ratio
• Present data in the format of traditional financial statements in Power BI using the native matrix visual and custom visuals, including creating different views (e.g. monthly vs quarter/year to date) and with the ability to drill into individual transactions
• Perform variance analysis using waterfall charts, KPI cards and custom visuals which allow you to understand the drivers of financial performance
In this session you will learn how to:
• Capture report (and non-functional) requirements and design a corresponding data model to be built in Power BI
• Apply transformations to data in Power Query including how to automatically combine monthly CSV files, apply currency conversion and work with data at different grains/levels of detail (actual vs budget)
• Create basic calculations in DAX including key ratios such as Gross Profit % and Cost:Income Ratio
• Present data in the format of traditional financial statements in Power BI using the native matrix visual and custom visuals, including creating different views (e.g. monthly vs quarter/year to date) and with the ability to drill into individual transactions
• Perform variance analysis using waterfall charts, KPI cards and custom visuals which allow you to understand the drivers of financial performance
Learning Objectives
They will get the opportunity to understand the full end-to-end process involved in building a financial report – from requirements gathering, to build and then deployment. Whilst they will also get access to the e-learning course based on this material, by attending this full day training they will also get the opportunity to try many of the concepts hands-on and ask questions/learn directly from the author of the material.
Previous Experience
Delegates should be familiar with building reports in Power BI and aware of some of the key challenges/requirements from finance teams around financial statement reporting. A basic understanding of how financial transactions are captured (e.g. Debits/Credits) and the period-close processes required to report on the data will be useful though not essential.
Tech Covered
Azure, Power BI, Excel, Developing, Data Visualisation & Modelling