DataSelf Analytics for Acumatica

The following is a summary of the available BI, report, and dashboard templates. Please contact DataSelf to discuss how these templates and information could apply to your business and needs.

Data Warehouse Solution

• Data warehouse templates for Acumatica

• DataSelf ETL+ Overview

Power BI Templates for Acumatica

DataSelf Analytics for Acumatica with Power BI.

Tableau Templates for Acumatica

DataSelf Analytics for Acumatica 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.

DataSelf Analytics Deployment

• Acumatica Cloud

• Acumatica On-premise/Private Cloud

DFT+ Data Modeling

Data Models gather and transform raw data into fast and ready-to-be-reported information. They work as the single version of the truth defined in the DataSelf Server-side components (ETL+, data warehouse, Power BI models, and/or Tableau data sources). All reports, dashboards, and KPIs derive information from their data models. Changing the data model will automatically reflect the new rule across all reports and dashboards. For instance, a simple change to the Gross Profit data model calculation to absorb freight, and next time, reports and dashboards will automatically show GP with freight absorbed.

What’s more, our DFT+ modeling is source agnostic! Click here to learn more.

DFT+ Star Schema Example

The following exemplifies how the Sales Invoice DFT+ tables are linked in DataSelf’s out-of-the-box templates in a star schema arrangement. This model works in reporting tools such as Power BI, Tableau, and Excel.

DFT+ Galaxy Schema Example

The following exemplifies how DFT+ tables are linked in DataSelf’s out-of-the-box templates in a galaxy schema arrangement. This model works in reporting tools such as Power BI, Tableau, and Excel.

A key benefit of a galaxy schema is easy reporting across multiple fact tables in a single report. Click the image to zoom in.

Keywords: out-of-the-box templates, mappings, ETL+, data warehouse, ERP, CRM, reports, dashboards, KPIs., MS Excel.