Sisense

NOVEMBER 12, 2020

Data warehouse vs. databases Traditional vs. Cloud Explained Cloud data warehouses in your data stack A data-driven future powered by the cloud. We live in a world of data: There’s more of it than ever before, in a ceaselessly expanding array of forms and locations. Data warehouse vs. databases.

Data Warehouse 52

Data Warehouse Data Lake OLAP Data-driven 52

erwin

JUNE 7, 2022

This blog is based upon webcast which can be watched here. 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.

Data Warehouse 52

Data Warehouse Modeling Sales Data Lake 52

Sisense

SEPTEMBER 3, 2019

This blog is intended to give an overview of the considerations you’ll want to make as you build your Redshift data warehouse to ensure you are getting the optimal performance. OLTP vs OLAP. First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing).

Data Warehouse 78

Data Warehouse OLAP Statistics Cost-Benefit 78

erwin

AUGUST 15, 2022

This blog is based upon a recent webcast that can be viewed here. For NoSQL, data lakes, and data lake houses—data modeling of both structured and unstructured data is somewhat novel and thorny. Moreover, this blog will provide readers with a firm foundation for NoSQL and data lakes as they move to the cloud.

Data Lake 52

Data Lake Modeling Unstructured Data Data Warehouse 52

Sisense

FEBRUARY 16, 2021

Every aspect of analytics is powered by a data model. A data model presents a “single source of truth” that all analytics queries are based on, from internal reports and insights embedded into applications to the data underlying AI algorithms and much more. OLTP does not hold historical data, only current data.

Modeling 52

Modeling OLAP Data Warehouse Cost-Benefit 52

IBM Big Data Hub

DECEMBER 7, 2023

Online analytical processing (OLAP) database systems and artificial intelligence (AI) complement each other and can help enhance data analysis and decision-making when used in tandem. As AI techniques continue to evolve, innovative applications in the OLAP domain are anticipated.

OLAP 60

OLAP Slice and Dice Cost-Benefit Data Warehouse 60

Jen Stirrup

OCTOBER 30, 2022

There are lots of definitions out there, but I like the Gartner one best: “ A broad category of applications and technologies for gathering, storing, analysing, sharing and providing access to data to help enterprise users make better business decisions.” Customer insight is a cornerstone of the activity of any business.

Data mining 52

Data mining Predictive Analytics Cost-Benefit OLAP 52