Data Analysis using SQL and Advanced Excel                                                         >>Home

Data is central to the task of understanding customers, understanding products, and understanding markets. Data must be analyzed, and the results must be presented to the right audience. To fully exploit its value, we must transform data into stories and scenarios, charts and metrics, and insights.

This course focuses on three key technological areas used for transforming data into actionable information:

■■ Relational databases store the data. The basic language for  retrieving data is SQL.

■■ Excel spreadsheets are the most popular tool for presenting data. Perhaps the most powerful feature of       Excel is the charting capability, which turns columns of numbers into pictures.

■■ Statistics is the foundation of data analysis.These three technologies are presented together, because they are all interrelated.
SQL answers the question “how do we pull data from a database?” Statistics answers the question “how is it relevant”? And Excel makes it possible to convince other people of the veracity of what we find.

Target Audience
Credit, market and operational risk managers, Internal Audit, Business Intelligence analysts, Customer relationship mangers, Financial Control Officers. Etc

Duration: 3 days

Date:   Click to view the course schedule
         

Time:  9am to 5pm daily

Fee1 :  GHc 800 per participant (Ghana)
Fee 2:  N 90,000 per participant (Nigeria)

The course will expose participants to the following areas:

• Structure of the Data
• Entity-relationships
• Data Analysis using Dataflows
• Dataflows, SQL and Relational Algebra
• SQL Queries
• Joining tables
• Other Capabilities of SQL using subqueries
• Data Exploration
• Excel for charting
• Exploring string values
• Using SQL to generate summary code
• Basic Statistical Concepts
• How different are the averages
• Counting Possibilties
• Ratios and their statistics
• Chi- square
• SQL to calculate chi-square values

Using SQL (Structured Query Language)  for Auditing & Investigation

Most banking Applications have comprehensive audit capability and tracks all the activities of the users and stores the audit log as part of the database that can be viewed, reported and queried using the knowledge of SQL. The entire history of the transactions, along with all the messages, accounting entries are stored in data tables.  With the knowledge of SQL, auditors can easily extract, interrogate and analyze the information in these data tables. This course would expose auditors to the following areas.

1. Understanding DBMS (DataBase Mgt System)
2. Understanding Oracle SQL
3. Extracting & analyzing data with SQL
4. Interrogating data using SQL
5. Audit enquiries/queries to the databases
6. SQL continuous online near real time monitoring of customers transaction data and users inputs in the system.

 

Who should Attend: Inspectors, Internal control Officers,
                                    Auditors, IS Auditors, IS Security
                                    Officers, Accountants,  IT
                                    Professionals e.t.c.

About the Facilitator:

Michael Adesoji Adegunwa, CISA, CISSP-ISSEP, OCDBA, CFE

Michael Adesoji Adegunwa is a Certified Information Systems Security Professional and an Oracle Certified Database Administrator with 7 years Oracle experience. He  has also worked as a Software architect/programmer with programming experience in assembly language, C/C++, Java, Visual Basic, Oracle PL/SQL and others. He is currently with Rhythex Consulting as a Senior Technical consultant for Applications and Database Security, Audit and Control. His major research interests are buffer overflows, reverse engineering applications and Database hacking, cryptography, penetration testing and other security related research. He is a speaker at the Nigeria Oracle Users Group (NOUG) conference and writes for the NOUG magazine. He could be reached via email at soji.adegunwa@rhythexconsulting.com

ORACLE SQL (Structured Query Language) for Data Interrogation and Analysis

Most banking Applications have comprehensive audit capability and tracks all the activities of the users and stores that audit log as part of the database that can be viewed, reported and queried using the knowledge of SQL. The entire history of the transactions, along with all the messages, accounting entries are stored in data tables. This aspect would expose auditors to the following areas.

1. Understanding SQL
2. Extracting & analyzing data with SQL
3. Interrogating data using SQL
4. Audit enquiries/queries to the databases
5. SQL continuous online near real time monitoring of customers transaction  data and users inputs in the system.

Who should Attend: Inspectors, Internal control Officers,
                                    Auditors, IS Auditors, IS Security
                                    Officers, Accountants,  IT
                                    Professionals e.t.c.

Duration:                    3 days

Dates:                        Check our course schedule
                       
Time:                          9. am to 6pm daily

Fee 1:                          Ghc 650 per participant (Ghana)

ee 2:                           N 120,000 per participant(Nigeria)