Data Warehouse and Business Intelligence | Project

Added on -2019-09-25

| 14 pages
| 2678 words

Trusted by 2+ million users,
1000+ happy students everyday

Showing pages 1 to 4 of 14 pages

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, 2011The edmontonjournal is the sole owner of this data. This data is freely available at the websiteand can be downloaded as required.Dataset contains 12.8K rows and 7 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,UNKNOWN 02/26/1983BANK OF NOVASCOTIA 0.8806/04/1993TORONTO-DOMINIONBANK LCL 4011,246.8203/29/1988CANADIAN IMPERIALBANK OF COMMERCENEED NEWS787.5112055 -95 ST. Edmonton04/02/1980HSBC BANK CANADABIANCHIBERNARD357.98UNKNOWN AB 03/29/1995HSBC BANK CANADACHANSUI PANG102.3404/17/1990BANK OF MONTREAL8203/18/1986TORONTO-DOMINIONBANK NEWLAURA24.03UNKNOWN,UNKNOWN 11/20/1985BANK OF NOVASCOTIA 19.7610/13/1990TORONTO-DOMINIONBANK WRIGHTK. 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.

Found this document preview useful?

You are reading a preview
Upload your documents to download
Become a Desklib member to get accesss

Students who viewed this