Posts

Showing posts with the label Bank ATM Analytics - SAP Hana

Featured Post

14 Top Data Pipeline Key Terms Explained

Image
 Here are some key terms commonly used in data pipelines 1. Data Sources Definition: Points where data originates (e.g., databases, APIs, files, IoT devices). Examples: Relational databases (PostgreSQL, MySQL), APIs, cloud storage (S3), streaming data (Kafka), and on-premise systems. 2. Data Ingestion Definition: The process of importing or collecting raw data from various sources into a system for processing or storage. Methods: Batch ingestion, real-time/streaming ingestion. 3. Data Transformation Definition: Modifying, cleaning, or enriching data to make it usable for analysis or storage. Examples: Data cleaning (removing duplicates, fixing missing values). Data enrichment (joining with other data sources). ETL (Extract, Transform, Load). ELT (Extract, Load, Transform). 4. Data Storage Definition: Locations where data is stored after ingestion and transformation. Types: Data Lakes: Store raw, unstructured, or semi-structured data (e.g., S3, Azure Data Lake). Data Warehous...

Bank ATM Analytics - SAP Hana

Image
Problem: ATM(Automated Teller Machine) has become an integral part of our society. Recent estimates developed by ATMIA place the number of ATMs in use currently at over 2.2 million, or 1 ATM per around over 3000 people in the world. If we think of very specific banks than a recent information in wikipedia states that SBI Group (State Bank Of India) has around 45000+ ATM. So we see the numbers are huge. But there is a very big problem and i would like to use a typical example from India to illustrate this. Here, many times the ATM runs out of currency notes of specific denomination as lets say Rs 100. The end consumer is left with the option of either accepting currency of higher denomination or seek a different ATM. Here we also have a charge applied by the bank if a consumer withdraws money from a ATM of a bank different from the one in which he holds his account. Now this is a major inconvenience for the end consumer and also a loss for the bank as their reputation is effecte...