Unleash the Power BI

"It's an absolute time sink". That's probably the best way we've heard someone describe Power BI. Microsoft's analytics tool is defined by just how damn deep it is.

In that spirit, Hugh Johnson has created a library of detailed articles on how to deepen your use of Sage 50 Accounts using Power BI. Each article zooms in on a particular facet.

Given the amount of valuable content, we've helpfully collated it all into this content series. We hope that you'll find it as much of a "time sink" as Power BI itself. 

Financial chart
Article
18th Oct 2017
4
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
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
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
1
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...