Do not be scared of Power BI
Article
30th Oct 2019
Unlike ourselves, Power BI is completely rational. An unexpected answer is simply a symptom that you need a better understanding of your...
Data
Article
4th Apr 2019
3
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...
17th Apr 2019
Measures like year-to-date (YTD) are great at tracking performance against an annual goal, but not so good at continuously tracking the...
30th Jan 2019
1
Hugh Johnson explains why data visualisation is important for your monthly board pack. The human brain struggles to hold more than about...
21st Nov 2018
Hugh Johnson explains how tools like Power BI can help you to transform an outdated budgeting process into something more dynamic and...
14th Feb 2018
Hugh Johnson explains how to get your months in Power BI to sort according to your financial year, as defined by Sage 50 Accounts. A common...
Forecast
Article
28th Nov 2018
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...
Financial chart
Article
18th Oct 2017
6
Once you have got your Sage 50 data into Power BI Desktop, setting up a good date table is probably the next and most useful thing you need...
9th Apr 2018
2
There is a lot of talk about Power BI, but is it right for small to medium sized businesses (SMBs)? Getting a Power BI solution to work...
Analytics
Article
25th Oct 2017
Traditional accounting reporting is monthly, quarterly, annual and maybe a 30/60/90+ view for receivables. You can replicate this in Power...
1st Nov 2017
When I used to supervise the finance department in a small business, I constantly struggled with getting useful information about my...
8th Nov 2017
1
If you think that your customer addresses in your accounting software are too poor to show on a map, you can think again. If they're good...
15th Nov 2017
1
The way that you would use Power BI to analyse departments in Sage 50 depends on how you have set up your Sage 50 departments module. There...
28th Nov 2017
Power BI can produce some very powerful and insightful analysis of your Sage 50 sales data . There are however some important things to...
11th Dec 2017
Once you have a dataset in your Power BI desktop, one of the first things that you will want to do is to perform some calculations on your...
9th Jan 2018
If today you were to stop a student in the street and ask “What year are you in?” you could get many different, yet valid answers such as:...
1st Feb 2018
Ten tips for naming your tables, columns and measures in Power BI and otherwise documenting and organising your data model. Working with...
8th Jun 2018
This article is a summary of talk that I gave last month at Accountex , identifying situations where you may want to reach beyond Excel and...
Messenger delivering information
Article
18th Jul 2018
How can you support your collections team better with the data you already have? One of the things that tools like Power BI can do really...