Data Analytics for Banker/Banking

Certificate of completion (supplied by PasarTrainer)

Training Material

* Thinking about Analytical Problems
* Conceptual Business Models
* The information-Action Value Chain
* Real World Events and Characteristics
* Data Capture by Source Systems

This module introduces how to think about analytical problems and examine the process by which data enables analysis & decision-making.

Module 1: Data and Analysis in the Real World

* Data Storage and Databases
* Big Data & the Cloud
* Virtualization, Federation, and In-Memory Computing
* The Relational Database
* Data Tools Landscape
* The Tools of the Data Analyst

This module explains how Big Data can bring value to the company and the world.

Module 2: Analytical Tools

* Introduction to SQL
* Aggregating and Sorting Data in SQL
* Extracting Data from Multiple Tables
* Stacking Data with UNION Command
* Extending SQL Queries Using Operators
* Using SQL Subqueries

This module introduces big data concepts and fundamentals.

Module 3: Data Extraction Using SQL

* Analytical Organizations – Roles
* Analytical Organizations – Structures
* Data Governance
* Data Privacy
* Data Quality

Module 4: Real World Analytical Organizations

A multiple-choice test to assess the participants' proficiency level in the real-world analytical organization.


10 Questions - Closed Book

A multiple-choice test to assess the participants' proficiency level regarding data analysis in the real world.

Exercise (case study) where participants are asked to extract data using SQL based on real-world scenarios.

Case Study

A multiple-choice test to assess the participants' proficiency level regarding analytical tools.

Introduce you to the data analytics practices executed in the business world. Explore such key areas as the analytical process, how data is created, stored, accessed, and how the organization works with data and creates the environment in which analytics can flourish.

After completion of this program, participants will be better able to:
* Strong foundation in all the areas that support analytics and will help you to better position yourself for success within your organization
* Develop skills and a perspective that will make you more productive faster and allow you to become a valuable asset to your organization.
* Provides a basis for going deeper into advanced investigative and computational methods.