DataSelf Analytics for JAMIS Prime
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 popular for reporting and data analysis. Customizing your data warehouse solution is easy. Adjustments and customizations can help tailor the solution to your needs and maximize the templates' value.
Click here to learn more: data warehouse templates for JAMIS Prime.
Tableau Templates
These templates include Tableau data sources, workbooks, and Tableau Server preconfigured mappings. They work in conjunction with the data warehouse templates.
On average, templates cover 50% to 100% of their focused reporting needs (e.g., the AP & AR Aging Today templates often cover 100% of today’s aging reporting).
Click here to download a list of the Tableau templates.
Template - Code | Essentials | Pro | Enterprise |
|---|---|---|---|
Pre-configured reports & dashboards | 50+ | 800+ | 8,000+ |
AP Aging Today - AP | ✅ | ✅ | ✅ |
AR Aging Today - AR | ✅ | ✅ | ✅ |
Budgeting/Forecasting * - BD | NA | ✅ | ✅ |
Cash Flow Projection * - CF | ✅ | ✅ | ✅ |
CRM Activity * - CA | ✅ | ✅ | ✅ |
CRM Marketing Email ** - CM | ✅ | ✅ | ✅ |
CRM Opportunity * - CO | ✅ | ✅ | ✅ |
Field Service * - FS | ✅ | ✅ | ✅ |
GL Transactions * - GT | ✅ | ✅ | ✅ |
GL Financials (P&L, B/S, Trial Balance) * - GF | ✅ | ✅ | ✅ |
Inventory On Hand Today - IO | ✅ | ✅ | ✅ |
Inventory On Hand Monthly * - IH | ✅ | ✅ | ✅ |
Inventory Planning * - IP | NA | ✅ | ✅ |
Inventory Transactions * - IT | ✅ | ✅ | ✅ |
JAMIS - Organization P&L * - JDW | ✅ | ✅ | ✅ |
JAMIS Program Management * - JDW | ✅ | ✅ | ✅ |
Manufacturing: BOM (Bill of Materials) * - MB | NA | ✅ | ✅ |
Manufacturing: Work Order * - MW | NA | ✅ | ✅ |
Project Accounting * - PM | ✅ | ✅ | ✅ |
Purchase Order - PO | ✅ | ✅ | ✅ |
Sales Invoice - SI | ✅ | ✅ | ✅ |
Sales Order - SO | ✅ | ✅ | ✅ |
Non * marked templates should provide value right-of-the-box. Adjustments and customizations might be needed to maximize their value.
* These templates usually require adjustments and customizations before providing value. Until properly connected to a source system, they often have sample data.
** Add-ons might require other applications. E.g.: HubSpot for CRM Marketing Email.
Please check out your SOW (scope of work) for specific templates included.
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 - Code | Essentials | Pro | Enterprise |
|---|---|---|---|
Pre-configured reports & dashboards * | NA | 450+ | 4,500+ |
AP Aging Today * - AP | ✅ | ✅ | ✅ |
AR Aging Today * - AR | ✅ | ✅ | ✅ |
Inventory On Hand Today * - IO | ✅ | ✅ | ✅ |
Inventory Transactions * - IT | ✅ | ✅ | ✅ |
Purchase Order * - PO | ✅ | ✅ | ✅ |
Sales Invoice * - SI | ✅ | ✅ | ✅ |
Sales Order * - SO | ✅ | ✅ | ✅ |
* 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 require some adjustment before they provide value. The data feeds will easily bring the latest data warehouse data into Excel, where users can slice and dice their data and build new reports.
DataSelf vs Other Reporting Tools
DataSelf vs DIY Data Engineering Platforms
DIY data engineering and data warehouse/data lake platforms can provide flexibility and scale, but they often require dedicated technical teams, custom development, and ongoing maintenance. DataSelf helps SMB and mid-market organizations accelerate this process with prebuilt connectors, automated governed modeling, KPI templates, and BI-ready data structures.
The following comparison shows how DataSelf reduces complexity and speeds time to trusted analytics compared with fully DIY data engineering platforms.
Capabilities | Snowflake, MS Fabric, Databricks, Fivetran | DataSelf |
|---|---|---|
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 | 8,000+ (KPI+) |
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 |
SMB & mid-market focused | Not typical | Yes |
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, data lake, DFT+, KPI+, AI+,ERP, CRM, reports, dashboards, KPIs, Claude, ChatGPT, MCP Server, Microsoft Fabric, One Lake, Tangerine Software, ZAP, Phocas, Solver BI 360, Domo, Conversight.