DataSelf Analytics for Sage X3

Data Warehouse Solution

Click the following links to learn about:

• Data warehouse templates for Sage X3.

• DataSelf ETL+ Overview.

• Deployment for Sage X3.

Power BI Templates for Sage X3

Click here to learn more: DataSelf Analytics for Sage X3 with Power BI.

Tableau Templates for Sage X3

Click here to learn more: DataSelf Analytics for Sage X3 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.

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.