Jet Global

SEPTEMBER 4, 2020

For more sophisticated multidimensional reporting functions, however, a more advanced approach to staging data is required. The Data Warehouse Approach. Data warehouses gained momentum back in the early 1990s as companies dealing with growing volumes of data were seeking ways to make analytics faster and more accessible.

Data Lake 88

Data Lake OLAP Data Warehouse Unstructured Data 88

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 68

Analytics Data Warehouse Data Lake Metadata 68

Jet Global

OCTOBER 22, 2020

The company is pointing customers to several other options, including “BYOD” (which stands for “bring your own database”) and Microsoft Azure data lakes. This leads to the second option, which is a data warehouse. In this scenario, data are periodically queried from the source transactional system.

Modeling 52

Modeling OLAP Reporting Sales 52

AWS Big Data

JUNE 21, 2023

Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query. These types of queries are suited for a data warehouse. Amazon Redshift is fully managed, scalable, cloud data warehouse. This is achieved by partitioning the data.

Data Warehouse 76

Data Warehouse Data Lake OLAP Cost-Benefit 76