CS5504: Bank XYZ ATM/POS Transaction Dimensional Modeling Project

This assignment solution addresses the design of dimensional models for a Business Intelligence (BI) system within the context of Bank XYZ. The project focuses on analyzing ATM and POS transaction data to create effective dimensional schemas. The solution explores different architectural paradigms, emphasizing the differences between BI and OLTP systems, and delves into dimensional modeling techniques, including star and snowflake schemas, and OLAP cubes. The response provides detailed answers to questions related to schema design, including the identification of dimensions, fact tables, and the concept of granularity, using sample data to illustrate the application of the schemas. The assignment also considers stakeholder requirements and the importance of data details. The solution includes references to key concepts and relevant resources.