Instructions

Review the data set of the project. It includes a sample report (rows 1 to 4) a set of business rules (five) and six business questions.

Design a dimensional model that support the generation of the report and observe the business rules. In addition, the model should be able to be used to answer the business questions.

. B G A M Quarter Date 6/1/17 1/3/18 2/2/18 Year Trans Type Trans Amount Acct Type 2017 Deposit $100 Savings 2018 Withdrawal $12 Checking 2018 Loan pmt $1,010 Car Loan Teller Jones Lee Jones Branch Branch City Branch State Branch Supervisor Customer 456 Fullerton CA Smith Carter 500 Brea Garcia Reagan 10 Phoenix Pick Ford CA 1 AZ Business rules: 1. Tellers may work in different branches 2. Branch supervisors are assigned to only one branch 3. Account types are: Savings, Checking, Car Loan, Mortgage Loan, Home Equity Line of Credit, Certificate of Deposit 4. Transanction types are: Deposit, Withdrawal, Loan Pmt, Loan Origination, Open Account, Close Account 5. Transaction Dates span 2015-2018 Business questions: 1. How many transactions take place on weekends? 2. Which day is the busiest? 3. Which day is the busiest for deposits? 4. Which tellers work more? 5. Which customers are depleting their money? (withdrawals exceed deposits) 6. Which branches are growing their business? . B G A M Quarter Date 6/1/17 1/3/18 2/2/18 Year Trans Type Trans Amount Acct Type 2017 Deposit $100 Savings 2018 Withdrawal $12 Checking 2018 Loan pmt $1,010 Car Loan Teller Jones Lee Jones Branch Branch City Branch State Branch Supervisor Customer 456 Fullerton CA Smith Carter 500 Brea Garcia Reagan 10 Phoenix Pick Ford CA 1 AZ Business rules: 1. Tellers may work in different branches 2. Branch supervisors are assigned to only one branch 3. Account types are: Savings, Checking, Car Loan, Mortgage Loan, Home Equity Line of Credit, Certificate of Deposit 4. Transanction types are: Deposit, Withdrawal, Loan Pmt, Loan Origination, Open Account, Close Account 5. Transaction Dates span 2015-2018 Business questions: 1. How many transactions take place on weekends? 2. Which day is the busiest? 3. Which day is the busiest for deposits? 4. Which tellers work more? 5. Which customers are depleting their money? (withdrawals exceed deposits) 6. Which branches are growing their business