Information Technology and Digital Banking: Concepts and Practice · Part B: Systems and Design
Chapter 8: Data warehousing, BI and analytics
How a bank turns years of transactions into insight: data warehouses and marts, dimensional models and OLAP, data mining, BI and neural networks, and the analytics now built into banking.
Buyers of the e-book, or of the print copy, which includes it, read the whole chapter. Everyone can read the free sample, pages 1 to 24 of the e-book.
About this chapter
In the exam
Expect Inmon’s four traits, ETL, marts, star and snowflake, OLAP operations, mining techniques, support, confidence and lift, and data lakes.
At the desk: The cross-sell question, Bank N
Bank N’s marketing head wants to send an insurance offer to every customer. Mr Arvind Menon suggests a test first: the warehouse already holds who bought what.
Mr Rohit Deshpande is asked to mine it: how strongly home loans and insurance go together, whether that beats the average, and how the analysts should cut the data by region and quarter.
In this chapter
- 8.1The data warehousep. 101
- 8.2Dimensional models and OLAPp. 102
- 8.3Data miningp. 103
- 8.4BI, expert systems and neural networksp. 104
- 8.5Analytics in banksp. 105
- Exam traps and quick checksp. 106
- Practice: 16 questions in three roundsp. 107
- Answers, with every wrong option explainedp. 109
- Make it stickp. 111
- Chapter 8 on one pagep. 112
Corrections and updates
None for this chapter so far. Every correction to the book, and any rule that changes after its date, is listed on the errata page.