A 3.4.2 Activity Worksheet
A Data Warehouse (OLAP) is different from a standard transactional database (OLTP). While operational databases are designed for fast daily transactions (like buying a ticket), data warehouses are designed for analysis, reporting, and decision-making. Although DB Browser for SQLite is a transactional database tool, we will use it to simulate the 6 key characteristics of a Data Warehouse. Concept: In a Data Warehouse,...