Next course: 25th JUNE 2019 – LONDON, UK

Power BI training in London for accountants

Learn the basic concepts of Power BI in this unique training course, aimed specifically at accountants. Understand how to work with dates to produce montly and year-to-date reporting. This course is for accountants who are accomplished users of Excel for reporting, but have limited or no prior exposure to Power BI.

Book Now
1 Day
Limited spots

By focusing on the typical needs of an accountant for financial analysis we can cut to some of the essential tips, tricks and techniques that will get you productive right away.

Connect, Share, Learn 

In this one-day hands-on introduction to Power BI, you will, in a single day, build an interactive Profit & Loss report using typical “raw” SME accounting data.  Through doing this, you will learn about:

  • Power BI Desktop

  • Tables & Relationships

  • Essential data for SME financial analysis

  • Importing data into Power BI

  • Drag & drop to create a simple report

  • Some of the more popular visualisation options

  • Calculated Columns and Measures in Power BI

  • Why and how to add a Dates table

  • Adding analysis periods to the Dates table

  • Handling your financial year vs calendar year

  • Date-based analysis like YTD, YoY, Period-on-Period

  • Mapping your transactions table to your P&L

  • Building a powerful, interactive one-page P&L Report

DAX (Data Analysis Expressions) functions that you will be introduced to will include:

  • Filter Functions
    • CALCULATE
    • ALL
    • FILTER
  • Logical Functions
    • IF
    • AND
    • OR
  • Math & Trig Functions
    • SUMX
    • DIVIDE
  • Date & Time Functions
    • CALENDAR
    • YEAR
    • MONTH
    • TODAY
  • Statistical Functions
    • MAX
  • Text Functions
    • FORMAT
  • Other Functions
    • VAR
Departmental Profit & Loss

The training everyone has been waiting for

At the end of the course, you will have a templated Profit & Loss report and an understanding of how it was created that you can take away and adapt to your own particular needs.

Reserve your seat

Instructor

Hugh Johnson, one of the founders of Accounting Insights, has been working full-time with Power BI since before it’s launch.

Hugh Johnson

Hugh’s focus has been exclusively on building Power BI reports from accounting data; profit & loss, balance sheet, sales, receivables, liquidity, actual vs budget variance and stock reporting.  In this time, he has learned 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.

Upcoming training:

Training
Hugh Johnson, VP Accounting Insights

No prior knowledge of Power BI is assumed, though a working knowledge of Excel (or equivalent), use of Excel functions and a good knowledge of accounting is. Prior exposure to working with tables (for example in Microsoft Access or Excel) or Pivot Tables would be beneficial, but not essential.

All equipment and software necessary for the course will be provided.

Tea, coffee, soft drinks and lunch will be provided.


Order Now
Where ?
InTuition House, 210 Borough High Street,
London, SE1 1JA, UK

10 metres from Borough Tube Station, 10 mins walk from London Bridge Rail & Tube Station.

Need Help ?
Email us at
[email protected]
if you have any questions.
Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Youtube
Consent to display content from Youtube
Vimeo
Consent to display content from Vimeo
Google Maps
Consent to display content from Google
Spotify
Consent to display content from Spotify
Sound Cloud
Consent to display content from Sound