Data Lake, Data Warehouse and OLAP

How OLAP and AI can enable better business

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

OLAP Slice and Dice Cost-Benefit Data Warehouse

Complexity Drives Costs: A Look Inside BYOD and Azure Data Lakes

Jet Global

NOVEMBER 5, 2020

For more powerful, multidimensional OLAP-style reporting, however, it falls short. OLAP reporting has traditionally relied on a data warehouse. OLAP reporting based on a data warehouse model is a well-proven solution for companies with robust reporting requirements. Option 3: Azure Data Lakes.

Data Lake

Data Lake OLAP Data Warehouse Unstructured Data

Navigating Data Entities, BYOD, and Data Lakes in Microsoft Dynamics

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

Data Lake OLAP Data Warehouse Unstructured Data

Webinars

Prepare Now: 2025s Must-Know Trends For Product And Data Leaders

Marketing Operations in 2025: A New Framework for Success

Apache Airflow®: The Ultimate Guide to DAG Writing

MORE WEBINARS

Build an Amazon Redshift data warehouse using an Amazon DynamoDB single-table design

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

Data Warehouse Data Lake OLAP Cost-Benefit

Unlocking Data Storage: The Traditional Data Warehouse vs. Cloud Data Warehouse

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

Data Warehouse Data Lake OLAP Data-driven

Data Modeling 301 for the cloud: data lake and NoSQL data modeling and design

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 basics.

Data Lake

Data Lake Modeling Unstructured Data Data Warehouse

Data Modeling 201 for the cloud: designing databases for data warehouses

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

Data Warehouse Modeling Sales Data Lake

Unlock scalability, cost-efficiency, and faster insights with large-scale data migration to Amazon Redshift

AWS Big Data

AUGUST 1, 2024

Large-scale data warehouse migration to the cloud is a complex and challenging endeavor that many organizations undertake to modernize their data infrastructure, enhance data management capabilities, and unlock new business opportunities. This makes sure the new data platform can meet current and future business goals.

Data Warehouse

Data Warehouse KPI Optimization Cost-Benefit

How Aura from Unity revolutionized their big data pipeline with Amazon Redshift Serverless

AWS Big Data

APRIL 4, 2024

Amazon Redshift is a recommended service for online analytical processing (OLAP) workloads such as cloud data warehouses, data marts, and other analytical data stores. Redshift Serverless measures data warehouse capacity in Redshift Processing Units (RPUs).

Big Data

Big Data Data Warehouse Advertising OLAP

TIBCO JasperSoft for BI and Reporting

BizAcuity

AUGUST 1, 2022

TIBCO Jaspersoft offers a complete BI suite that includes reporting, online analytical processing (OLAP), visual analytics , and data integration. The web-scale platform enables users to share interactive dashboards and data from a single page with individuals across the enterprise. Online Analytical Processing (OLAP).

Reporting

Reporting OLAP Online Analytical Processing Dashboards

How gaming companies can use Amazon Redshift Serverless to build scalable analytical applications faster and easier

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

Analytics Data Warehouse Data Lake Metadata

Understanding Data Entities in Microsoft Dynamics 365

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

Data Warehouse OLAP Reporting Finance

What is Business Intelligence Consulting

BizAcuity

APRIL 1, 2023

Thanks to the recent technological innovations and circumstances to their rapid adoption, having a data warehouse has become quite common in various enterprises across sectors. This also applies to businesses that may not have a data warehouse and operate with the help of a backend database system.

Business Intelligence

Business Intelligence Consulting KPI Data Warehouse

What is Business Intelligence Consulting

BizAcuity

JANUARY 31, 2023

Thanks to the recent technological innovations and circumstances to their rapid adoption, having a data warehouse has become quite common in various enterprises across sectors. This also applies to businesses that may not have a data warehouse and operate with the help of a backend database system.

Business Intelligence

Business Intelligence Consulting KPI Data Warehouse

Master Your Power BI Environment with Tabular Models

Jet Global

OCTOBER 22, 2020

OLAP Cubes vs. Tabular Models. Let’s begin with an overview of how data analytics works for most business applications. The company is pointing customers to several other options, including “BYOD” (which stands for “bring your own database”) and Microsoft Azure data lakes. The first is an OLAP model.

Modeling

Modeling OLAP Reporting Sales

Prevent Customer Churn: Customer Retention in the Transition to Microsoft D365 F&SCM

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

Cost-Benefit Data Lake Reporting OLAP

Why Business Intelligence is Top of Mind for CFOs for 2022

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

Business Intelligence OLAP Sales Data Warehouse

Unleashing the power of Presto: The Uber case study

IBM Big Data Hub

SEPTEMBER 25, 2023

Uber understood that digital superiority required the capture of all their transactional data, not just a sampling. They stood up a file-based data lake alongside their analytical database. Because much of the work done on their data lake is exploratory in nature, many users want to execute untested queries on petabytes of data.

OLAP

OLAP Data Lake Data-driven Snapshot

Data Leaders Brief

How OLAP and AI can enable better business

Complexity Drives Costs: A Look Inside BYOD and Azure Data Lakes

Webinars

Trending Sources

Navigating Data Entities, BYOD, and Data Lakes in Microsoft Dynamics

Webinars

Build an Amazon Redshift data warehouse using an Amazon DynamoDB single-table design

Unlocking Data Storage: The Traditional Data Warehouse vs. Cloud Data Warehouse

Data Modeling 301 for the cloud: data lake and NoSQL data modeling and design

Data Modeling 201 for the cloud: designing databases for data warehouses

Unlock scalability, cost-efficiency, and faster insights with large-scale data migration to Amazon Redshift

How Aura from Unity revolutionized their big data pipeline with Amazon Redshift Serverless

TIBCO JasperSoft for BI and Reporting

How gaming companies can use Amazon Redshift Serverless to build scalable analytical applications faster and easier

Understanding Data Entities in Microsoft Dynamics 365

What is Business Intelligence Consulting

What is Business Intelligence Consulting

Master Your Power BI Environment with Tabular Models

Prevent Customer Churn: Customer Retention in the Transition to Microsoft D365 F&SCM

Why Business Intelligence is Top of Mind for CFOs for 2022

Unleashing the power of Presto: The Uber case study

Stay Connected