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. 

0
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...
0
Traditional accounting reporting is monthly, quarterly, annual and maybe a 30/60/90+ view for receivables. You can replicate this in Power...
0
When I used to supervise the finance department in a small business, I constantly struggled with getting useful information about my...
0
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...
0
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...
0
Power BI can produce some very powerful and insightful analysis of your Sage 50 sales data . There are however some important things to...
0
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...