Data Warehouse Implementation Project: Unclaimed Bank Accounts Dataset

This project focuses on the design and implementation of a data warehouse using MS Access 2007, utilizing an unclaimed bank accounts dataset from Edmonton, Canada. The project begins with an introduction to data warehousing and business intelligence, followed by a detailed description of the dataset, including its structure, columns, and domain information. The objectives of the project are clearly defined, encompassing dataset selection, data warehouse design, tool selection (MS Access), implementation, data population, querying, and result generation. The project's scope involves creating tables for customer, bank, and transaction data, interconnected through a dimension table. The implementation process includes creating tables, importing data, and establishing relationships. The results section answers research questions related to currency, address repetition, name repetition, and address visits, providing insights derived from the data analysis. The project also includes an entity relationship diagram (ERD), which demonstrates the logical structure of the database and the relationships between its components. The project concludes with a summary of findings, showcasing the successful implementation of a data warehouse and its ability to provide valuable insights from the dataset. The technology used is MS Access, chosen for its suitability in querying and analyzing large datasets.