Power BI

Five reasons to use Power BI for your management report

Power BI Desktop, Power BI Pro

Hugh Johnson @2/25/2019 8:57:18 AM

Five reasons to use Power BI for your management report


For an Excel-savvy financial controller, Power BI is a natural choice to pack more power, automation and better visualisations into your monthly management report.


Financial reporting is one area where Power BI really comes into its own.  If you are struggling to get your management report done, apart from really good visualizations, here are five reasons why you should take a look at Microsoft Power BI.   The image below is an example profit & loss report done in Power BI.


Power BI

BIDates - Power BI Dates Table for Sage 50 Accounts

ODBC, Power BI Desktop, OData

Hugh Johnson @7/28/2018 3:22:00 PM

BIDates - Power BI Dates Table for Sage 50 Accounts


Description of the BIDates table in the Suntico Sage 50 Accounts OData feed for Power BI. This is a preconfigured Power BI Dates Table for Sage 50 Accounts that provides the link between date-driven transactions and has built-in intelligence relating to the accounting year . Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BIDates table in the Suntico Sage 50 Accounts OData feed that you have set to as one of your Power BI data sources.  

This table is essential if you want to analyse your various Sage 50 Accounts data tables by date or period.


Power BI

BIMetaData - Sage 50 Accounts - data about your data

Power BI Desktop, OData, metadata, Sage 50 Accounts

Hugh Johnson @4/19/2018 4:41:44 PM

BIMetaData - Sage 50 Accounts - data about your data


Details about the BIMetadata table in the Suntico BI data feed for Power BI. Use this table to see in an instant how fresh your Sage 50 Accounts data is on Power BI. 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?


Sage 50 Accounts OData feed for Power BI

The BIMetaData table is part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides data about your Sage 50 dataset and your Suntico subscription.  Use this table to determine how up-to-date your Sage 50 dataset is in Power BI.


Power BI

BINominalBudgets - Sage 50 Accounts Nominal Budgets

Power BI Desktop, OData, nominal records, Sage 50 Accounts, nominal budgets

Hugh Johnson @4/19/2018 3:44:22 PM

BINominalBudgets - Sage 50 Accounts Nominal Budgets


Details about the BINominalBudgets table in the Suntico BI data feed for Power BI. Use this table to track your performance against budget for each nominal code. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BINominalBudgets table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides a list of all of the nominal budgets for each of the nominal accounts and for each accounting period 1 thru 12.  Note that these periods refer to the months of the currently open financial year in Sage 50 and may not necessarily be the same as the periods of the current financial year if the company (for example it the previous year has not yet been closed off in Sage 50 Accounts).

This table is essential if you want to compare actual vs budgeted performance by nominal code.  This table does not hold the breakdown on nominal code budgets by department.


Power BI

BICharts - Sage 50 Accounts Charts of Accounts

Sage 50, Power BI Desktop, OData, chart of accounts

Hugh Johnson @4/19/2018 3:20:58 PM

BICharts - Sage 50 Accounts Charts of Accounts


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?


Sage 50 Accounts OData feed for Power BI

This article describes the BICharts table in the Suntico Sage 50 Accounts OData feed in the Suntico Power BI Sage 50 integration.  This table provides a list of all of your Sage 50 Charts of Accounts.

This table is essential if you want to perform profit & loss or balance sheet analysis at the nominal account (nominal code) category level for a given specified Chart of Accounts.


Power BI

BISupplierCurrencies - Sage 50 Accounts Supplier Currencies table

Power BI Desktop, OData, currencies, suppliers, Sage 50 Accounts

Hugh Johnson @4/19/2018 10:34:35 AM

BISupplierCurrencies - Sage 50 Accounts Supplier Currencies table


Details of the BISupplierCurrencies table in the Suntico Sage 50 Accounts OData feed for Power BI. This table provides the currency information for all of your Suppliers accounts in Sage 50 Accounts. Use this table if you want to analyse purchases by currency. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BISupplierCurrencies table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.    This table is a duplicate of the BICurrencies table and included to avoid relational ambiguity between BISuppliers, BICustomers and BITransSplits.

This table is essential if you want to analyse your Sage 50 purchases by currency.


Power BI

BISalesOrderLines - Sage 50 Accounts Sales Order Lines table

ODBC, Power BI Desktop, OData, sales orders

Hugh Johnson @4/18/2018 9:29:25 PM

BISalesOrderLines - Sage 50 Accounts Sales Order Lines table


Here are the BISalesOrderLines table details in the Suntico Sage 50 Accounts OData feed for Power BI. This table contains the Sage 50 Accounts Sales Order Lines - is the line item information for all of your Sales Orders and Quotes in your Sage 50 SOP module. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BISalesOrderLines table in the Suntico Sage 50 Accounts OData feed for the Power BI Sage 50 Accounts integration.  This table is derived from the underlying Sage 50 Accounts SOP_ITEM ODBC table. 

This table is essential if you want to analyse your Sage 50 Sales Orders at the product line item level.


Power BI

BISalesOrders - Sage 50 Accounts Sales Orders table

ODBC, Power BI Desktop, OData, sales orders, Sage 50 Accounts

Hugh Johnson @4/18/2018 9:11:17 PM

BISalesOrders - Sage 50 Accounts Sales Orders table


Details of the BISalesOrders 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 Sales Orders and Quotes from your Sage 50 SOP module. Why not try it now?


Sage 50 Accounts OData feed for Power BI

The Suntico BI OData feed turns your Sage 50 Accounts system into an online business intelligence data source for tools like Microsoft Power BI.  This article describes the BISalesOrders table.  This table is derived from a number of underlying Sage 50 Accounts SALES_ORDER ODBC table. 

This table is essential if you want to analyse your Sage 50 Sales Orders.


Power BI

BIStocks - Sage 50 Accounts Stocks (Products) table

Power BI Desktop, OData, stock, Sage 50 Accounts

Hugh Johnson @4/18/2018 7:19:07 PM

BIStocks - Sage 50 Accounts Stocks (Products) table


The BIStocks table in the Suntico Sage 50 Accounts OData feed for Power BI provides stock (product) information inlcluding costs, selling prices and stock levels. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BIStocks table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table is derived from the Sage 50 Accounts "STOCK" ODBC table.

This table is essential if you want to analyse sales and margin by stock category or to analyse stock levels.


Power BI

BIProductSales - Sage 50 Accounts Sales Invoices table

ODBC, Power BI Desktop, OData, sales invoices, product sales, sales orders

Hugh Johnson @4/18/2018 5:28:56 PM

BIProductSales - Sage 50 Accounts Sales Invoices table


Sage 50 Accounts Sales Invoices data with the sales invoice headers, line item details, historic line item margin, delivery address. Everything you need to analyse your product sales in Power BI. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BIProductSales table in the Suntico Sage 50 Accounts OData feed in the Suntico Power BI Sage 50 Accounts integration.  This table is derived from a number of underlying Sage 50 Accounts ODBC tables and provides details of all of the sales transactions created through the Sales Orders or Invoices & Credits modules in Sage 50.  It is essentially Sage 50 Accounts Sales Invoices with all the line item information and some further enrichments, for example to include gross margin of a transaction line item.

This table is essential if you want to analyse sales and margin by product code over time.


Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,
Dublin,
Ireland

+353 1 567 4069