DataSelf Analytics for Sage 100
The following is a summary of the BI, report, and dashboard templates available. Please contact DataSelf to discuss how these templates and information could apply to your specific business and needs.
Data Warehouse Solution
Click the following links to learn about:
Deployment for Sage 100 with Providex or Sage 100 with MS SQL Server.
Power BI Templates for Sage 100
Click here to learn more: DataSelf Analytics for Sage 100 with Power BI.
Tableau Templates for Sage 100
Click here to learn more: DataSelf Analytics for Sage 100 with Tableau.
Microsoft Excel Templates
These templates include Excel workbooks with pre-configured data feeds from your MS SQL Server data warehouse and/or ETL+ CSV exports. Most MS Excel workbooks will require some level of adjustment before they provide value. The data feeds will easily bring the latest data warehouse data into Excel, from where users can slice and dice their data and build new reports.
Available data warehouse data feeds for MS Excel:
- AP Aging Today
- AR Aging Today
- Budgeting/Forecasting
- GL Transactions
- GL Financials (P&L, B/S, Budget, Trial Balance)
- Inventory On Hand Today
- Inventory Transactions
- Manufacturing: BOM Bill of Materials
- Manufacturing: Work Order (Production Order)
- Open PO Today
- Open SO Today
- Sales Invoice
Keywords: out-of-the-box templates, mappings, ETL+, data warehouse, ERP, CRM, reports, dashboards, KPIs.