Lecture
Data Warehouses and Decision Support Systems
Related lectures (69)
ServiceNow: Creating Dashboards and Reports
Explores creating dashboards in ServiceNow, focusing on advantages, transition from homepages, and important concepts like tasks and incidents.
Data Wrangling with Hadoop
Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Data Warehousing: Overview and Challenges
Introduces data warehousing fundamentals, challenges, and the innovative concept of a 'lakehouse'.
River Hydraulics and Modeling: Semi-Distributed Approach
Explores river hydraulics, modeling, and calibration using a semi-distributed approach for accurate forecasting and water resource management.
Atomistic Machine Learning: Physics and Data
Explores Atomistic Machine Learning, integrating physical principles into models to predict molecular properties accurately.
OLAP Queries and Optimizations
Covers OLAP queries, examples of comparisons, ranking, and optimizations for query performance.
OLAP: Overview and Queries
Introduces OLAP concepts, schemas, queries, and optimizations for efficient data analysis.
Views: Simplifying SQL Queries
Explores views in SQL, covering creation, materialization, maintenance, cube building, and top-k queries optimizations.
Data Warehouses: Introduction and Challenges
Covers the introduction and challenges of data warehouses, including integrating data, managing metadata, and optimizing query performance.
Data formats and data wrangling with Hadoop
Explores Apache Hive for data warehousing, data formats, and partitioning, with practical exercises in querying and connecting to Hive.