Example weighted average receivables demo. Weighted average debt age, weighted average due days and weighted average overdue days. Interactive demo shows how you can slice by customer to see who you should be focusing on to drive down your debtor days. What does this tell you?
Details about the BICategories table in the Suntico BI data feed for Power BI. This is the list of all of your Sage 50 Accounts Nominal Categories. You can use Suntico BI to set up your Sage 50 Accounts system as one of your Power BI data sources. Why not try it now?
The BICharts table provides a list of all of your Sage 50 Accounts Charts of Accounts. Use this table if you want to perform profit & loss or balance sheet analysis at the nominal account (nominal code) category level for a given Chart of Accounts. Why not try it now?
Why and how to do a DAX running total calculation in Power BI. Two methods are presented: using the Quick Measure facility in Power BI, and writing your own DAX formula from scratch. Use variations to calculate running totals like YTD and rolling totals like sales last 52 weeks (example given).
Description of the BIPurchaseOrders table in the Suntico Sage 50 Accounts OData feed for Power BI. This table is the header information for all of your Sage 50 Accounts Purchase Orders in your POP module. Why not try it now?
Do you track your aged debtors in terms of weighted accounts receivable days? Using Power BI to track your receivables terms, age, and overdue days as weighted averages will help to give you a true picture of the cost of customer credit. Is it time that you took a look?
An estimate of relative Power BI adoption by country, based on Google search volume for the term "Power BI". It appears that interest in the UK is more than double that of the USA, and in New Zealand more than four times.