Skip to main content
Skip table of contents

DataSelf Analytics for MS Dynamics BC / NAV

etl_plus_diagram_2605_fabric_power_bi_tableau_ms_dynamics.jpg

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

Data Warehouse Templates

The data warehouse templates include DataSelf ETL+ and MS SQL Server preconfigured mappings for tables that are popular for reporting and data analysis. It’s easy to customize your data warehouse solution. Adjustments and customizations can help to tailor the solution to your needs and maximize the templates' value. Click here to learn more: data warehouse templates for MS Dynamics BC / NAV.

Tableau Templates

These templates include Tableau data sources, workbooks, and Tableau Server preconfigured mappings. They work in conjunction with the data warehouse templates. These templates usually require some level of custom setup before they provide value.

Click here to download a list of the Tableau templates.

Template

Advanced

Pro

Enterprise

Pre-configured reports & dashboards

20+

300+

3,000+

AR Aging Today

CRM Activity *

Add-on

Add-on

Add-on

CRM Marketing Email *

Add-on

Add-on

Add-on

CRM Opportunity *

Add-on

Add-on

Add-on

Sales Invoice

Sales Order

** Add-ons require other applications. Ex.: Salesforce.com, Sage CRM, MS Dynamics CRM, or HubSpot.

Power BI Templates (data sets and workbooks)

These templates include Power BI data sources and workbooks. They work in conjunction with the data warehouse templates.

Click here to download a list of the Power BI templates.

Template

Advanced

Pro

Enterprise

Pre-configured reports & dashboards *

Dozens

Hundreds

Thousands

AR Aging Today *

Sales Invoice *

Sales Order *

* All Power BI templates require adjustments and customizations before providing value.

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 vs Other Reporting Tools

dataself_vs_mid_market_bi_matrix_microsoft_dynamics_2605.jpg
DataSelf Data Warehousing

DataSelf vs DIY Data Engineering Platforms

Data engineering and data warehouse/data lake platforms offer flexibility and scale, but can require technical teams, custom development, and ongoing maintenance.

DataSelf helps mid-market organizations accelerate such platforms and analytics with prebuilt connectors, automated governed modeling, KPI templates, and BI & AI-ready data structures.

Capabilities

Snowflake, MS Fabric, Databricks, Fivetran

DataSelf

SMB & mid-market focused

Not typical

Yes

Requires dedicated data engineers

Often

Often unnecessary

ETL/ELT (extract, transform, load)

Large enterprise focus

ETL+ (SMB focus)

Prebuilt ERP pipelines

Limited

Extensive mid-market connectors

Automated governed modeling

Custom initiative

DFT+ (Customizable)

KPI templates

Minimal

KPI+ (industry-specific, best practice 8,000+ KPI library)

Single version of the truth

Custom initiative

DFT+ (Customizable)

Star & galaxy schemas

Custom initiative

DFT+ (Customizable)

AI-assisted modeling & governance

Large enterprise focus

SMB focus

Fabric Power BI / Tableau / AI ready

Custom initiative

Pre-configured

Time to deploy

Minutes to hours

Minutes to hours

Time to value

Months

Hours to days

Architecture options

Primarily cloud-centric

Flexible

Business model

Platform (DIY)

Turnkey & customizable

Pricing model

Unpredictable

Predictable

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.