Hugh Johnson
Member Since: 5th Aug 2011
Likes: 0
Thanks: 11
I am a founder director of Accounting Insights Ltd, a specialist provider of Power BI reporting solutions to accountants in practice and in industry. I help accountants to use Power BI to create intuitive, engaging reports from their accounting data. I deliver management packs, sales reports & forecasts, liquidity & cash flow reports, stock reports, and accounts receivable analysis from Sage, Xero, Exchequer, Microsoft Business Central, Iris, and CCH.
I hold a Master of Engineering from City University London (awarded with commendation and the highest marks in my year) and a Post Graduate Diploma in International Selling from Dublin Institute of Technology (awarded with distinction and the highest marks in my year).
My personal passions are high-performance Fireball dinghy racing and food.
Director Accounting Insights Ltd.
10th Jan 2024
ABC of Power BI: ‘P’ is for percentage of sales
Tracking how the various lines of your income statement and how they are moving in relation to sales is one of the simplest and most useful...
Excel
15th Aug 2023
ABC of Power BI: ‘O’ is for ODBC
One of the most common Power-BI-related questions I get is how to connect Power BI to Sage 50 Accounts. The answer, most definitively, is...
Excel
19th Apr 2023
ABC of Power BI: ‘N’ is for Negative Numbers
I have always thought that the way accountants treat negative numbers is weirdly inconsistent. A profession that takes pride in precision...
Excel
2nd Nov 2022
ABC of Power BI: ‘M’ is for Model
An important thing to get right for your Power BI financials report is your data model, or “model”. This is the set of tables that make up...
Excel
5th Oct 2022
ABC of Power BI: ‘L’ is for lifetime learning
If you enjoy learning new things and working with numbers, then you will never get bored with Power BI. Just when you think you have it...
Excel
17th Aug 2022
ABC of Power BI: ‘K’ is for KPI rethink
Power BI provides extremely flexible ways to aggregate and summarise your accounting data and therefore new ways to calculate your key...
Excel
3rd Aug 2022
ABC of Power BI: ‘J’ is for Journals
Creating a single table of “journals” in your Power BI model to hold all your transactions, actual or otherwise, is a great starting point...
Excel
29th Jun 2022
ABC of Power BI: ‘I’ is for Iterate
Let’s say that you have a sales table, with three columns for Customer, USD_Amount, Exchange_Rate (USD/GBP) and you want to compute the...
Excel
3rd Nov 2021
ABC of Power BI: H is for historic balance
Consider the simple visual from a Power BI report below: On the face of it, this could be an extract straight from your accounting software...
Excel
24th Sep 2021
ABC of Power BI: G is for gross profit (and other summary totals and ratios)
Consider the simple Profit & Loss statement below: The P&L statement is on two levels: a main grouping, such as sales, purchases,...
Excel