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. For more powerful, multidimensional OLAP-style reporting, however, it falls short. OLAP reporting has traditionally relied on a data warehouse.

Data Lake 98

Data Lake OLAP Data Warehouse Unstructured Data 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

erwin

AUGUST 15, 2022

For NoSQL, data lakes, and data lake houses—data modeling of both structured and unstructured data is somewhat novel and thorny. This blog is an introduction to some advanced NoSQL and data lake database design techniques (while avoiding common pitfalls) is noteworthy. Data Modeling.

Data Lake 52

Data Lake Modeling Unstructured Data Data Warehouse 52

erwin

JUNE 7, 2022

Designing databases for data warehouses or data marts is intrinsically much different than designing for traditional OLTP systems. Accordingly, data modelers must embrace some new tricks when designing data warehouses and data marts. Figure 1: Pricing for a 4 TB data warehouse in AWS.

Data Warehouse 52

Data Warehouse Modeling Sales Data Lake 52

AWS Big Data

MARCH 7, 2023

A data hub contains data at multiple levels of granularity and is often not integrated. It differs from a data lake by offering data that is pre-validated and standardized, allowing for simpler consumption by users. Data hubs and data lakes can coexist in an organization, complementing each other.

Analytics 71

Analytics Data Warehouse Data Lake Metadata 71

Jet Global

OCTOBER 7, 2020

Confusing matters further, Microsoft has also created something called the Data Entity Store, which serves a different purpose and functions independently of data entities. The Data Entity Store is an internal data warehouse that is only available to embedded Power BI reports (not the full version of Power BI).

Data Warehouse 90

Data Warehouse OLAP Reporting Finance 90

Jet Global

JANUARY 15, 2021

As Microsoft focuses its reporting strategy around Power BI and Azure Data Lake services, Dynamics partners should carefully consider the implications of starting down the path that Microsoft is recommending. A non-developer can build a custom data warehouse with Jet Analytics in as little as 30 minutes.

Cost-Benefit 72

Cost-Benefit Data Lake Reporting OLAP 72