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

Its solution was to replicate data from the production database, using data entities, into a traditional relational database. Microsoft referred to this approach as “bring your own database” (BYOD). There is an established body of practice around creating, managing, and accessing OLAP data (known as “cubes”).

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

AWS Big Data

MARCH 7, 2023

Flexible and easy to use – The solutions should provide less restrictive, easy-to-access, and ready-to-use data. 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.

Analytics 68

Analytics Data Warehouse Data Lake Metadata 68

Jet Global

OCTOBER 7, 2020

They can sit inside your D365 F&SCM instance or in a separate Azure space, referred to as Bring Your Own Database (BYOD), which stores the data entities in Azure but in an SQL format that is accessible to reporting. Reference (e.g., It helps simplify and speed up data management and analytics efforts in D365 F&SCM.

Data Warehouse 90

Data Warehouse OLAP Reporting Finance 90

Jet Global

JANUARY 15, 2021

In this respect, we often hear references to “switching costs” and “stickiness.” 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.

Cost-Benefit 72

Cost-Benefit Data Lake Reporting OLAP 72

Jet Global

DECEMBER 3, 2021

The term “ business intelligence ” (BI) has been in common use for several decades now, referring initially to the OLAP systems that drew largely upon pre-processed information stored in data warehouses. As technology has evolved, BI has grown steadily more powerful, affordable, and accessible.

Business Intelligence 52

Business Intelligence Sales OLAP Data Warehouse 52