Data Warehouses and Decision Support Systems

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (32)

Page 1 of 4

Data Warehousing: Overview and Challenges

Introduces data warehousing fundamentals, challenges, and the innovative concept of a 'lakehouse'.

Data Wrangling with Hive: Managing Big Data Efficiently

Covers data wrangling techniques using Apache Hive for efficient big data management.

Data Warehouses: Introduction and Challenges

Covers the introduction and challenges of data warehouses, including integrating data, managing metadata, and optimizing query performance.

OLAP: Overview and Queries

Introduces OLAP concepts, schemas, queries, and optimizations for efficient data analysis.

OLAP Queries and Optimizations

Covers OLAP queries, examples of comparisons, ranking, and optimizations for query performance.

OLAP Queries: Aggregations, Cube Operator, and Optimizations

Explores OLAP queries, cube operator, super-aggregates, and optimization techniques.

Data Warehouses and Data Lakes

Covers data warehouses, data lakes, OLTP vs. OLAP, data quality, and the Data Lakehouse concept.

Data Wrangling with Hadoop: Storage Formats and Hive

Explores data wrangling with Hadoop, emphasizing storage formats and Hive for big data processing.

Data Virtualization Demo: SmartDataLake

Showcases a demo on adaptive data virtualization in SmartDataLake, focusing on assembling company profiles and executing join queries across datasets.

OLAP Data Model: Multidimensional and Relational Approaches

Explains OLAP data models, focusing on multidimensional and relational approaches.