Jet Global

NOVEMBER 5, 2020

That stands for “bring your own database,” and it refers to a model in which core ERP data are replicated to a separate standalone database used exclusively for reporting. That works reasonably well for traditional reporting functions. For more powerful, multidimensional OLAP-style reporting, however, it falls short.

Data Lake 98

Data Lake OLAP Data Warehouse Unstructured Data 98

Jet Global

OCTOBER 26, 2021

Broadly speaking, these kinds of reports fall under the heading of “operational reporting”, because you use them as part of routine operations rather than as a financial management tool. In contrast with financial reporting, analytics tends to cast a much wider net in terms of its overall purpose and objectives.

Reporting 98

Reporting Slice and Dice OLAP Analytics 98

Jet Global

SEPTEMBER 4, 2020

Consultants and developers familiar with the AX data model could query the database using any number of different tools, including a myriad of different report writers. Data entities are more secure and arguably easier to master than the relational database model, but one downside is there are lots of them! Data Lakes.

Data Lake 88

Data Lake OLAP Data Warehouse Unstructured Data 88

Jet Global

FEBRUARY 8, 2021

This change also complicates matters considerably whenever you make changes to the underlying database, such as when your company builds custom extensions or installs third-party products alongside Microsoft D365 BC, or when Microsoft adds new features to the product that result in changes to the underlying data model.

Reporting 98

Reporting Dashboards Cost-Benefit OLAP 98

Jet Global

MAY 1, 2023

These licensing terms are critical: Perpetual license vs subscription: Subscription is a pay-as-you-go model that provides flexibility as you evaluate a vendor. Pricing model: The pricing scale is dependent on several factors. It is organized to create a top-down model that is used for analysis and reporting.

Analytics 52

Analytics Cost-Benefit Visualization Dashboards 52

Jet Global

SEPTEMBER 22, 2023

Jet Analytics from insightsoftware helps bridge the gap between reporting and data visualization. Designed to work with Microsoft Dynamics ERPs, Jet Analytics is a cost-effective data preparation, automation, and modeling solution that extends the Microsoft framework to speed-up and de-risk the delivery of a modern data warehouse.

Visualization 52

Visualization Reporting Data Warehouse OLAP 52

Jet Global

MAY 6, 2022

Hitting a Reporting Wall. If you use Power BI alone to generate reports, the complexity of the Microsoft Dynamics data model can be an obstacle as it requires knowledge of its proprietary DAX scripting language. Other challenges include: No automatic, real-time reporting. Enabling you to build self-serve custom reports.

Data Warehouse 52

Data Warehouse Visualization Finance Reporting 52