Your gateway to data extraction, wrangling, and analytics expertise.
Level Up as a Data Analyst
Training Overview
Data analysts are being held back by traditional data analysis tools and techniques. Data is growing at an unprecedented rate and traditional tools like MS Excel struggle when it comes to manipulating and analyzing all but the most basic of datasets. Also, because most data is only available in a raw, unstructured form, and using traditional tools to massage these data for analysis is cumbersome, data analysts are unable to extract value out of such data or even apply modern data analytics on it.
Modern data analytics benefits greatly from a multi-tool approach. It’s about choosing the right tools for the job, automating repetitive tasks by writing reusable scripts, and treating data analysis as an iterative process. We believe that all data analysts should be fluent in SQL, and a scripting language like R or Python. Tools like MS Excel, Tableau and other similar offerings can also be added to the mix if and when required.
The goal is to initiate you to modern data analytics workflow and tools, and set you up for success. The big ideas in this course are data extraction and wrangling, automation and scripting, the analytics workflows.
We will bring these ideas to life by developing real-world data analytics projects using tools and techniques (SQL, R, data wrangling, modeling, etc.) that will be covered during the course.
Training Objectives
Clean and manipulate data, and combine multiple sources of data to unlock new analytics use cases.
Use modern data analytics and leverage big data for deeper analysis of data.
Expand the repertoire of tools available to data analysts.
Benefits of Attending
Understand the full data analytics pipeline, and be familiar with programming tools to accomplish the different portions
Be able to collect data from unstructured sources and store it appropriately using relational databases, graphs, etc
Know how to explore and visualize your data
Use predictive analytics to get even more mileage out of your data
Learn SQL & R to extract insights from your database and visualize your reporting data. Complete 1 project in 2 weeks and level up.
Who Should Attend This Training
People engaged in some form of data analysis and who are from these departments: Marketing, Digital, Finance, Human Resources, R&D, Traffic Analysis, Business Analysis, Risk Analysis, etc.
You should attend if you are asking these questions:
How do I reliably collect and manage my data?
How do I manipulate and transform my data into an analysis-ready form?
What is a good way to structure my data and reason about it?
How do I start exploring and visualizing my data?
What big data technologies do I need to take my data analysis to the next level?
Training Module
3 Hours per Session
Session 1:
Relational Databases and SQL
-
Relational Databases and SQL
-
Introduction to SQL
-
Working with multiple data tables
-
SQL for analytics
-
Take-home Exercises
Session 2
Data Science with R
-
Introduction to Data Science with R
-
The R Language
-
Lists and Data Frames
-
Subsetting
-
R Packages
-
Logical Tests
-
Take-home Exercises
Session 3
Visualizing and Manipulating Data
-
Describing and Building Graphs Using ggplot2
-
Data Transformation Using dplyr
-
Combining Datasets
-
Grouped Aggregates
-
Derived Data
-
Take-home Exercises
Session 4
Predictive Analytics
-
Introduction
-
Supervised vs. Unsupervised Learning
-
Linear Regression
-
Clustering OR Text Mining
-
Take-home Exercises
Athar Hameed is the Chief Data Scientist at Persuasion Technologies Sdn Bhd, a regional Google Analytics Partner and Data Science company. He’s a highly accomplished software engineer, data science practitioner, and trainer.
Athar is one of the foremost Python experts in Malaysia and has been programming in Python since 2004. He has developed and taught Python-based curriculum to over 500 industry professionals and students. He also taught the first ever Python MOOC in Malaysia. He was previously a Python and Data Science mentor at Thinkful Inc. and also had the good fortune of working directly with Alex Martelli (a Python Core Developer and author of Python in a Nutshell).
Clients he has trained include Maxis, Celcom, Axiata, Citibank, Petronas, Asia Pacific University and Telekom Malaysia, among others.
Athar Hameed
Trainer's Profile
Training Methodology
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.
Register For This Course
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.
