Interested in attending? Have a suggestion about running this course near you?
Register your interest now
Description
For information regarding CCH Learning Events Covid-19 Health and Safety Practices, please click HERE.
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.
What you will learn
By the end of the workshop, you will :
- Learn how to work with Excel and external databases such as MS-Access using SQL
- Understand the use of structured tables and Excel data manipulation functions for business analysis and reporting
- Learn how to move datasets between MS-Access and MS-Excel
- Understand the strengths and weaknesses in MS-Access and MS-Excel
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 modeling
- 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
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 Asia-Pacific 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.
This is a 2-days face-to-face event, to be conducted on 12 - 13 October 2020.