fbpx

UOB Case Study

“Understanding and implementing SQL in day-to-day operation”

Date: 29 – 31 May 2018
Place: PT Bank UOB Indonesia office

Banks have always held vast amounts of data inside their organizations. Companies in the banking and financial industry are working towards establishing new business opportunities by identifying how customers consume and are made aware of products.

It is important for a bank to understand how to collect, clean, and analyze data from multiple sources in order to be able to optimize the gathered data into useful information. Having a proper knowledge on how to treat data and create a good database environment can be a competitive advantage that takes the business decision process to the whole new level.

Decisions can be made depending on which additional services can be offered to secure customer loyalty, along with understanding how banks should communicate specifically with individuals by applying more behavioural analytics to segmentation.

How to create value for customers through data becomes an important factor in the digital economy. It means establishing a more accurate understanding of customers and the context in which they consume services. Communicating with customers about products and services in an appropriate and timely manner and ultimately creating a more enhanced customer experience through the value of data.

Summary:

Using SQL to learn how to collect, clean and analyze data from multiple sources including the web, a local file, and a relational database.

Result:

  • Understanding the fundamentals of Databases and SQL
  • Querying Large Databases and Aggregating Data in SQL
  • Writing Efficient and Dynamic Queries
  • Create Local Database

Relevant Courses: SQL