Jet Global

SEPTEMBER 4, 2020

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. Online analytical processing (OLAP), which enabled users to quickly and easily view data along different dimensions, was coming of age.

Data Lake 88

Data Lake OLAP Data Warehouse Unstructured Data 88

AWS Big Data

JUNE 21, 2023

A key pillar of AWS’s modern data strategy is the use of purpose-built data stores for specific use cases to achieve performance, cost, and scale. Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query.

Data Warehouse 78

Data Warehouse Data Lake OLAP Cost-Benefit 78

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 70

Analytics Data Warehouse Data Lake Metadata 70

Jet Global

OCTOBER 22, 2020

As a security measure, Microsoft is closing off direct database access to live Microsoft Dynamics ERP data. 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.

Modeling 52

Modeling OLAP Reporting Sales 52