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.
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...
Article
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...
Article
Measures like year-to-date (YTD) are great at tracking performance against an annual goal, but not so good at continuously tracking the...
Article
Hugh Johnson explains why data visualisation is important for your monthly board pack. The human brain struggles to hold more than about...
Article
Hugh Johnson explains how tools like Power BI can help you to transform an outdated budgeting process into something more dynamic and...
Article
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...
Article
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...
Article
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...
Article
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...
Article
Traditional accounting reporting is monthly, quarterly, annual and maybe a 30/60/90+ view for receivables. You can replicate this in Power...
Article
When I used to supervise the finance department in a small business, I constantly struggled with getting useful information about my...
Article
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...
Article
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...
Article
Power BI can produce some very powerful and insightful analysis of your Sage 50 sales data . There are however some important things to...
Article
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...
Article
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:...
Article
Ten tips for naming your tables, columns and measures in Power BI and otherwise documenting and organising your data model. Working with...
Article
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...
Article
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...