SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
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