BUSINESS INTELLIGENCE IT Management paper writing service

Imagine you work as a BI expert in Bank XYZ. You are given an spreadsheet file (Excel) which contains a subset of data from the log file of the Bank’s operational (transactional) system that manages and authorizes the transactions performed at the ATMs of the Bank (by customers of the bank or by customers of other banks) or at the ATMs of other banks by customers (cardholders) of Bank XYZ.

 

As part of a BI solution implementation your main task is to design a dimensional model which will primarily be based on the above data. After  a series  of  requirements  sessions  with relevant business stakeholders, you have identified that such a BI solution should be able to support the following:

 

 

 

1. Number and Total Amount of Daily and Monthly Transactions performed per “us” terminals (i.e. the ATM terminals of Bank XYZ).

 

 

 

2. Daily and Monthly Number of Withdrawal Transactions and total amounts of such transactions per terminal.

 

3. Number and Total Daily and Monthly Amount of Transactions in other FIID terminals (i.e. transactions performed in the ATMs of other Banks by customers of Bank XYZ).

 

 

 

4.Number of Daily and Monthly Captured (Retained) Cards per

 

 

Manufacturer of Terminals in the ATM network of Bank XYZ.

 

 

 

 

 

5.Number of Daily and Monthly Credit card transactions performed by cardholders of Bank XYZ outside its network of ATMs (i.e. performed in other banks ATMs).

 

 

 

6.Number and Total Amounts of Daily and Monthly Transactions per

 

 

Credit Card Network type (e.g. Visa, Mastercard).

 

 

 

 

 

7.Daily and Monthly Number of Transactions, per card type (credit/debit), per transaction type, per city on Bank XYZ (“us”) terminals (ATMs).

 

 

 

8.Number and Total amounts of Daily and Monthly Transactions per Transaction type performed on “us” terminals (i.e. the ATM terminals of Bank XYZ).

 

Study carefully the subset of data given to you as well as the above business needs. Then perform the following tasks.

 

 

 

1.Design an appropriate dimensional schema (in a graphical form) that can be used to implement such a BI solution. Explicitly state the grain  of  your  schema and include  as  many  details  as  possible concerning the schema attributes. You may use whatever tool you wish (e.g. Word, PowerPoint, Visio, a UML tool) in order to design such schema.

[50% of marks]

 

 

 

 

 

2.Provide a suitable set of sample rows of the fact(s) tables of the proposed schema illustrating the respective data interrelationships. The rows you provide should use/include data from the operational data subset given to you.

[20%]

 

 

 

 

 

3.Design two suitable Cubes that show data corresponding to the following:

• Daily number of Transactions, per card type (credit/debit), per transaction type (withdrawal, deposit, etc.).
• Total amounts of Daily Transactions per transaction type, per city

 

on Bank XYZ (“us”) terminals.

 

 

The cubes you design should also illustrate in their visible parts some corresponding data from the subset given to you (i.e. data for one day).[10%]

 

 

 

Additionally, in the second cube above, perform the following OLAP

 

operations and design the results of these operations.

 

§	Roll up on location (from cities to regions)	[5%]
§	Slice, for transaction type = “withdrawal”	[5%]

 

 

 

 

4.Answer the following question: Apart from the identification of facts/measures, in order to be comprehensive on the proposed dimensional model, it is necessary to discuss and agree with the business stakeholders on an additional important aspect of the model. Explain the aforementioned important aspect which has not been analysed.[10%]

 

 

 

Notes: (i) In the facts part of the dimensional schema you design, some measures/facts may be derived facts. (iii) the dimensional schema may have more than one fact tables (iii) ignore the need for currency conversions as part of your model. (iv) if you wish, you may design on paper your model and/or cubes and include them as

 

scanned images in your answer.

Is this the question you were looking for? If so, place your order here to get started!