Using SQL to Retrieve and Analyze Data Quickly and Efficiently
Learn SQL
Training Overview
This course is designed for people who want to answer business questions with data. We will be using Bigquery and SQL (Structured Query Language) as our primary data warehouse to access and analyze the data stored in the database.
SQL is a powerful tool and is easy to get started with. It also helps you generate compelling reports. It is used by big and small companies alike to tackle challenging analytics problems and answer questions to improve business processes, operations and sales ROI.
Understand various data models used in analytics and Bigquery data warehouse.
Understand why relational databases are useful and what you can do with them.
Use SQL effectively to create customer analytic records (CARS) analyses on customer profile and transactional data from e-commerce settings.
Training Objectives
Get a solid introduction to analytics and data-driven decision making.
Learn to retrieve large amounts of records from a database quickly and efficiently.
Gain a good understanding and practical experience using SQL to analyze data.
Have experience analyzing big data sets that traditionally would be difficult to analyze using MS Excel and other similar tools.
Benefits of Attending
You should also attend if you are asking these questions:
How do I easily explore and extract insights from my data?
I have too many rows and columns in my Excel sheets, causing it to crash on me.
How can I work more effectively?
How do I make my data analysis reproducible?
How do I use data-driven presentations to convince stakeholders?
Who Should Attend This Training
People who need to conduct basic data analysis and presentation from these departments:
IT, Marketing, Product Marketing, Product Development, Digital Marketing, CRM, Finance, HR, Business Development, Data Analyst, Sales, etc.
Training Module
3 Hours per Session
Session 1
-
Introduction to relational databases
-
Introduction to BigQuery
-
Introduction to SQL
-
Data importing to GBQ
Session 2
-
Basic SELECT statement, ORDER BY, LIMIT
-
Table Variables and Set Operators
-
WHERE clause
-
Subqueries in WHERE clause
-
Practical Exercises
Session 3
-
The JOIN Family of Operators
-
NULL values
-
GROUP BY and analytics functions
-
WINDOW, NITLE function
-
Practical Exercises
Session 4
-
SQL Project - Build Customer Analytics Records showing customer profiles used in Customer Segmentation and Predictive Modelling (eg: demographics, purchasing behavior and custom segmentation).
-
Example dataset includes basic customer profiles, point-of-sale data, & inventory data from an e-commerce store.
This online training will be conducted over Zoom video conferencing.
This training consists of lectures and hands-on exercises.
Participants are required to actively engage with the hands-on component.
Training Methodology
Kwan Huey Yin has 10 years of experience in Google Analytics, Google Tag Manager and data analysis with clients spanning various industries. Clients she has worked with include MSIG, Tune Hotels, L’Oreal, Hermo, L’Occitane, FashionValet, UNIQLO, Club21, Kakitangan.com, BonusLink, Zurich, DoctorOnCall, UNICEF Children4Change, The Body Shop and TheRakyatPost. The scope of work includes but is not limited to Google Analytics auditing, Google Analytics advanced implementation, Google Analytics training, digital media buying campaign insights, reporting & recommendations.
Huey Yin graduated with a Degree in Computer Science and Statistics and is a Google Analytics and Google Ads Certified Individual. She is skilled technically in coding, troubleshooting and analysis including driving SQL analysis on marketing datasets. She currently leads a team of JavaScript developers and marketing data analysts that cover Web Tracking Audits, Advanced Tracking Implementations and Advanced Custom Reports with Analysis, Dashboarding and Automation.
Kwan Huey Yin
Trainer's Profile
Terms & Conditions
-
Full payment is required before participating in this program. Fill up this form to receive an invoice via email from Persuasion Technologies Sdn Bhd within 2 working days.
-
Cancellation MUST be made in writing 7 days before program date, otherwise full course fee will be charged. Substitution of a participant is encouraged but kindly inform us 5 days in advance.
-
Persuasion Technologies Sdn Bhd reserves the rights to cancel or postpone the program due to unforeseen circumstances and payment will be refunded if that happens.
-
Persuasion Technologies Sdn Bhd reserves the rights to modify or alter the advertised topics if necessary.
-
The class needs a minimum of 10 persons to commence. Maximum 20 persons per class.
-
Important: You will receive an email with a link to the conference call 1 day before the online training. The email you provide at the time of registration will be the only email address that can access the link for the online training.
Register For This Course
