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 Oct 2019
How to add a YTD drill-through to your Power BI P&L report
This is a question that came up from a client of mine. She had built out a P&L report and had added a drill-through page to show the...
Financial reporting
2nd Oct 2019
Can you learn Power BI in a day?
Like most questions to do with Power BI, the answer is “it depends”. It depends on what you mean by “learn”. If all that you want to do is...
Excel
22nd Aug 2019
Power BI basics: How to create a simple, dynamic and flexible dates table
I say more or less, because every so often I come across a minor tweak that I need to do for a particular report. The structure that I will...
Finance & strategy
7th Aug 2019
Your Power BI P&L report: How to handle expenses as positive numbers
If you view expenses as a negative number, then creating a P&L statement in Power BI is simple. But for many businesses it's not that...
Finance & strategy
23rd Jul 2019
Power BI basics: Query Editor or DAX?
In his latest article on Power BI, Hugh Johnson weighs up Query Editor and DAX and asks: which is the better option for preparing your data...
Management accounting
17th Apr 2019
Power BI: Rolling 12 months and YTD
Measures like year-to-date (YTD) are great at tracking performance against an annual goal, but not so good at continuously tracking the...
Finance & strategy
4th Apr 2019
Power BI: Why would you, when you already have Excel?
Back to basics: Why would you bother investing the time to learn Power BI when you already have Excel? Interest in Power BI is growing...
Excel
30th Jan 2019
Power BI: 1, 2, 3, 4, big data
Hugh Johnson explains why data visualisation is important for your monthly board pack. The human brain struggles to hold more than about...
Finance & strategy
28th Nov 2018
Power BI: Working with Excel budgets or forecasts
Hugh Johnson explains how to pivot and unpivot Power BI and Excel data and get the best of both worlds. It should be no surprise to you...
Excel
21st Nov 2018
Power BI: Agile reporting of actual vs forecast, target or budget
Hugh Johnson explains how tools like Power BI can help you to transform an outdated budgeting process into something more dynamic and...
Finance & strategy