Data Warehouse and Business Intelligence | Project
Added on - 25 Sep 2019
Business Intelligence and Data WarehouseAssignment
CONTENTS1.Introduction2.1Dataset Description2.2Domain Information2.3Objectives2.4Project Scope2.Design3.1Technology Used3.2Implementation3.3Operation and Processing3.Results and Conclusion4.1Results4.2Conclusions4.3Future Work4.4Analysis of Results4.5Accomplishments
1.Introduction1.1Dataset DescriptionThe project uses unclaimed bank accounts dataset for generating data warehouse andBusiness Intelligence reports. This dataset contains the list of all the bank accounts thoseare unclaimed and abandoned at branches in the Edmonton area of Canada. The addressescontains in the dataset are all from the Edmonton area. Some important dates are enlistedbelow related to the dataset:Date Created:July 21, 2010Updated:June 27, 2014Data Last Updated:August 21, 2011Theedmontonjournalis the sole owner of this data. This data is freely available at the websiteand can be downloaded as required.Dataset contains 12.8K rows and7 columns. The column description is as shown below:Column NameTypeLast / Business NamePlain TextFirst NamePlain TextBalanceNumberAddressPlain TextCityPlain TextLast TransactionDate & Timebank_namePlain TextFollowing is the preview of dataset. Its first 10 rows are shown below.
Last / BusinessNameFirst NameBalanceAddressCityLastTransactionbank_nameKELLYJUSTIN R74.5UNKNOWN,UNKNOWN02/26/1983BANK OF NOVASCOTIA0.8806/04/1993TORONTO-DOMINIONBANKLCL 4011,246.8203/29/1988CANADIAN IMPERIALBANK OF COMMERCENEED NEWS787.5112055 -95 ST.Edmonton04/02/1980HSBC BANK CANADABIANCHIBERNARD357.98UNKNOWN AB03/29/1995HSBC BANK CANADACHANSUI PANG102.3404/17/1990BANK OF MONTREAL8203/18/1986TORONTO-DOMINIONBANKNEWLAURA24.03UNKNOWN,UNKNOWN11/20/1985BANK OF NOVASCOTIA19.7610/13/1990TORONTO-DOMINIONBANKWRIGHTK.2,195.1008/03/1983BANK OF MONTREAL1.2 Entity Relationship DiagramEntity relationship diagrams demonstrate the logical structure of database.ER modeling is atechnique to model data so as to generate a conceptual model of the database. ER Diagrams wereoriginally introduced by Dr. Peter Chen. ER Diagram uses rectangles to represents entities anddiamonds describes relationships between those entities.