| Date | Quarter | Year | Trans Type | Trans Amount | Acct Type | Teller | Branch | Branch City | Branch State | Branch Supervisor | Customer |
| 6/1/17 | 2 | 2017 | Deposit | $100 | Savings | Jones | 456 | Fullerton | CA | Smith | Carter |
| 1/3/18 | 1 | 2018 | Withdrawal | $12 | Checking | Lee | 500 | Brea | CA | Garcia | Reagan |
| 2/2/18 | 1 | 2018 | Loan pmt | $1,010 | Car Loan | Jones | 10 | Phoenix | AZ | Pick | Ford |
| 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? |
jackal
CopyofDimensionalModelingExercise-Final.xlsx
