Address
8-9 Marino Mart, Fairview, Dublin 3, D03 EK81, Ireland
Contact
[email protected]
Intermediate
Power BI Training
for accountants
Online instructor-led Power BI training
Master Power BI for Amazing Financial Reports
Designed for Accountants/Finance professionals
Aimed at individuals with some proficiency in Power BI
An opportunity to acquire the building blocks for great financial reporting
Intermediate-level, instructor-led training
Conducted in small groups, limited to a maximum of 8 students, providing you the chance to raise specific questions and learn from others in the cohort.
- Learn how to create interactive financial reports like this.
5 x 1/2-day course
Limited spots
Online Training
18th March 2024 – Using Power BI Desktop to create financial reports
Explore the complexities of financial reporting, mastering the art of structuring your data model efficiently, managing fiscal periods with precision, seamlessly integrating budgeting and forecasting, and creating tailored presentations of your financial statements.
Connect and learn
In this intimate, 5 x half-day hands-on introduction to Power BI, you will learn about:
- The Power BI Evaluation Context
- Measures & Calculated Columns
- Working with Dates
- Avoiding the problems of DAX time intelligence
- Challenges with dates & financial reporting
- Handling periods 0 and 13
- Creating a date table for your financial reports
- The challenges behind financial statements
- A data model for financial reporting
- Incorporating Budgets and Forecasts
- Financial statement rows
- Custom aggregations
- Dynamic columns
- Multiple charts of accounts
- Fine-tuning your statement(s) presentation
- Mixing % & number formats
The course comprises five half-day modules
Evaluation context
- Power BI vs Excel
- Filter Context
- Row Context & Context Transition
- Manipulating the Filter Context
- Drag & Drop Excercises
- Basic revision of CALCULATE
- Measures & Calculated Columns
The Financial Statement
- Worked example using P&L
- Creating a base P&L measure
- Organising your measures
- Actual vs Previous vs Budget
- Income Statement Rows
- Dynamic columns
- Balance Sheets & Cash Flow
Dates
- Challenges for financial reporting
- Problems with time intelligence
- A Power Query Dates table
- Using Dates Measures
Layout customisation
- Blank spacing rows
- Expenses or Liabilities as positive
- Custom formatting
- Include / exclude null rows
- Including a % row
Data Model
- A look at financial statements
- Implications for a data model
- A flexible model for finance reports
- Incorporating Budgets & Forecasts
Instructor
Hugh Johnson
Hugh is one of the founders of Accounting Insights and he has been working full-time with Power BI since before its launch.
Hugh’s focus has been exclusively on building Power BI reports from accounting data; profit & loss, balance sheet, cash flow, sales, receivables, liquidity, actual vs budget variance and stock reporting. In this time, he has learned/developed many techniques to achieve great financial reports and believes that the best person to build your financial reports is someone with accounting knowledge rather than a specialist data scientist. It is easier to train an accountant in Power BI than to train a data scientist in accounting.
“Creating great financial reports in Power BI is straightforward, but not obvious!”
Power BI training for the specific challenges of financial reporting
In our Power BI training courses you can learn how to handle some of the particular nuances around financial reporting in Power BI.
- How to handle different fiscal year ends
- Handling a 52-53 week, or 4-4-5 calendar
- Simple “three-click” selection of date ranges (e.g. Year > Month > YTD)
- Dynamic dates axis based on period selection
- Income Statement as a % of Sales
- Incorporating budgets, forecasts and other comparison scenarios
- Handing multi-level budgets
- Multiple charts of accounts and user-focused presentation of financial statements
- Formatting negative numbers
- Displaying expenses and liabilities as positive values
- Income Statement, Balance Sheet and Cash Flow layouts
- Including irregular subtotals in your financial statements
- Mixing aggregations and percentages or ratios in your financial statement rows
- “7 + 5” type reporting for YTD actual with remainder as budget / forecast
- Dynamic “project-based” date ranges
- Including date ranges that span year-end transitions
Income Statement example
Get the Power BI training that will give you the foundations to tackle this example income statement.
- This template is provided as part of the training, along with the sample data shown
- Try out this report here
- For your own bespoke Power BI training or coaching, contact us
