Description

This is a 2-day workshop to be conducted on 22nd - 23rd November 2023.

There are many approaches to data analysis, and SQL is often regarded as one of the best languages for big data.

This hands-on workshop will show you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to perform sophisticated data analysis without the need for complex and expensive data mining tools. The Trainer will also share on how you can extract useful business information from relational databases. You will learn the fundamental techniques before moving into the "where" and "why" of each analysis, and then learn how to design and perform these analyses using SQL and Excel.

With professional guidance from the trainer, the hands-on exercise will show you how to best use the tools you already know to achieve expert results.

Programme Outline

Data Analysis

• Understanding Data
• Fundamentals of Data Analysis & Synthesis
• Types of data
• Developing a Data Analysis Strategy
• Basic Data Analysis Techniques

Databases

• What are databases?
• Understanding database design basics
• Introduction to data modelling
• Organizing and manipulating the data in databases
• Relational Database Basics

SQL and Relational Databases

• Brief history of SQL
• Acquiring & Exporting Data
• Methods of accessing data
• Connect from Excel to a database
• Export: query data into Excel
• Excel database communication features, commands, etc.
• SQL Basics
• Terminology
• Basic Select Statements
• Select list
• FROM clause
• WHERE clause
• ORDER BY clause
• GROUP BY and HAVING clause
• Subqueries
• Joins

This workshop qualifies for 14.0 CPE hours in Information Technology (Category 5).

What you will learn

• Understand the use of structured tables and Excel data manipulation functions for business analysis and reporting
• Understand the strengths and weaknesses in relational databases like MS-Access and spreadsheets like MS-Excel
• Learn how to work with Excel and external databases such as MS-Access using SQL

Prerequisites

Participants should ideally have fundamental knowledge of Excel.

Laptop Requirements

This is a 2-day intensive programme where participants will get to apply their knowledge with hands-on exercises, guided by the Trainer. Participants are required to bring along their laptops, equipped with full installation of Access and Excel 2010 and above.

Target Audience

Professionals, Managers and Executives who work with external relational databases and would like to familiarize themselves with SQL to enhance their skills in data analysis, synthesis and reporting in EXCEL.

Expert Speaker

Dr Lim Thou Tin

Dr. Lim is a business graduate from the NUS. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctorate in business administration from Southern Cross University with research interests in information systems and business modelling. He is also a certified business intelligence professional with specialisation in business analytics.

Dr Lim’s work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives / projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia and Thailand.

Dr Lim continues to be involved in senior management education at local tertiary institutions, teaching information and accounting topics at degree and postgraduate level with research and publishing interests in knowledge management and business intelligence.