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.
23rd Sep 2021
Power BI basics: An introduction to the filter context
A basic difference between formulae in Excel and Power BI In the Excel cell A3 in the image below, you can determine the result of the...
Finance & strategy
14th Jan 2021
ABC of Power BI: F is for Forecast
For a limited few, 2020 was not all bad. The Irish economy is expected to close out with growth of around 3.5%. So despite all the business...
Excel
28th Oct 2020
ABC of Power BI: E is for exchange rate
Let’s say that you have three companies, each operating in different a different country and with different base currencies: GBP, EUR and...
Excel
12th Aug 2020
ABC of Power BI: ‘D’ is for Date
Unlike traditional financial reports that are tied to fixed periods, quarters and fiscal years, Power BI reports can analyse data over any...
Excel
12th May 2020
ABC of Power BI: ‘C’ is for CALCULATE
Alberto Ferrari, one of the world’s most famous experts on Power BI, compares CALCULATE in DAX to the queen on a chessboard; it is...
Excel
19th Mar 2020
ABC of Power BI: ‘B’ is for bar chart
1. Bar charts need little explanation Most people can understand a well-labelled bar chart. Take a look at the example below. We can see...
Excel
19th Feb 2020
ABC of Power BI: ‘A’ is for append
Power Query provides a very simple way to append two or more tables into a single “long” table that has all of the rows (and columns) of...
Financial reporting
17th Jan 2020
Power BI basics: How to use DAX Studio to reduce your model footprint
In very simple terms, the more memory that your Power BI model consumes when it is open (aka your model footprint), the slower it will be...
Excel
13th Dec 2019
Power BI basics: Two ways to remove old data and speed up your report
Out with the old and in with the new If you load transactional tables from your accounting software into Power BI then the chances are that...
Excel
30th Oct 2019
Do not be scared of Power BI
Unlike ourselves, Power BI is completely rational. An unexpected answer is simply a symptom that you need a better understanding of your...
Excel