Interactive Mentor-Led Cohorts

(02) 8902 0900contact@aumtrend.comWhatsApp / Viber
AUM Training
HomeCourses
Who We Serve
About UsContact
LMS Portal
PYTHON ANALYTICS
30 Hours (15 Days × 2 Hours)
View Full Curriculum

Data Analyst - Advanced with Python

Clean, group, merge and reshape real datasets with Pandas, run statistical hypothesis tests with SciPy, and automate formatted monthly Excel reports from MySQL.

Live Interactive Syllabus
30 Hours (15 Days × 2 Hours)
•
Instructor-Led Online
•
15 Hands-on Coding Labs
What you'll master in Level 2
Target Competency Outcome

Clean, group, merge and reshape real datasets with Pandas, run statistical hypothesis tests with SciPy, and automate formatted monthly Excel reports from MySQL.

Training Objectives & Core Deliverables

Write Python scripts with variables, loops, functions, error handling and file handling from the basics

Clean messy data with Pandas: missing values, duplicates, wrong data types, text and dates

Group, summarise, merge and reshape datasets, including combining many files into one

Create clear charts with Matplotlib and Seaborn, and write findings as business insights

Run correlation, t-tests, chi-square tests and A/B test analysis in Python with SciPy

Pull data from MySQL into Pandas with SQLAlchemy, and write summary tables back

Automate a monthly report: read files, process data and produce a formatted Excel workbook with one run

Deliver and present a complete Python-based business analytics capstone project

Day-by-Day Training Schedule & Live Labs
15 Live Sessions • 100% Hands-on
Day 1
Setup and Python basics
Live Session
Topics Explored:
Google Colab and Jupyter notebooks
Variables, numbers and strings
Lists, tuples, dictionaries and sets
Reading and writing simple code, comments and common errors
Hands-on Lab Exercise

Set up the environment. Write small programs, for example a loan EMI calculator and a name-cleaning exercise.

Day 2
Control flow and functions
Live Session
Topics Explored:
if and else conditions
for and while loops, list comprehensions
Functions and arguments
Error handling with try and except, and importing modules
Hands-on Lab Exercise

Write functions that categorise customers and summarise a list of transactions.

Day 3
Files, dates and NumPy
Live Session
Topics Explored:
Reading and writing text, CSV and JSON files
Working with dates using datetime
NumPy arrays and vectorised calculations
Basic statistics with NumPy
Hands-on Lab Exercise

Read a CSV with plain Python, then repeat the same calculations with NumPy.

Day 4
Pandas basics
Live Session
Topics Explored:
Series and DataFrame
Reading CSV, Excel and SQL data
head, info and describe
Selecting and filtering with loc and iloc, sorting, new columns and apply
Hands-on Lab Exercise

Load a sales dataset and answer 10 business questions you could also answer in Excel or SQL, then compare the methods.

Day 5
Data cleaning
Live Session
Topics Explored:
Missing values: drop, fill and impute
Duplicates and wrong data types
Text cleaning with str methods
Dates with to_datetime, and outliers with IQR
Hands-on Lab Exercise

Clean a messy loan or customer dataset step by step.

Day 6
Grouping, summarising and time-based analysis
Live Session
Topics Explored:
groupby and agg, pivot_table, crosstab, value_counts
Datetime index, resample and rolling windows
Month-on-month and year-on-year change
Hands-on Lab Exercise

Rebuild an Excel pivot and a monthly trend table in Pandas.

Day 7
Combining and reshaping data
Live Session
Topics Explored:
merge, join and concat
melt and pivot to reshape data
Reading and combining many files from a folder
Checking merges for missing or duplicated rows
Hands-on Lab Exercise

Combine 12 monthly files with a product lookup table into one clean dataset.

Day 8
Charts with Matplotlib and Seaborn
Live Session
Topics Explored:
Bar, line, histogram, box, scatter and heatmap
Titles, labels, colours and subplots
Choosing the right chart, and saving charts
Hands-on Lab Exercise

Create 6 charts from the combined dataset and improve them for a business reader.

Day 9
Exploratory data analysis and storytelling
Live Session
Topics Explored:
An EDA checklist: distributions, relationships, segments and outliers
Turning charts into written insights
Structuring a notebook as a report
Hands-on Lab Exercise

Mini Project 1: an EDA notebook on a business dataset with charts and written insights.

Day 10
Statistics and hypothesis testing with SciPy
Live Session
Topics Explored:
Descriptive statistics and correlation in Pandas
Confidence intervals (intuition)
t-test and chi-square test with SciPy
Reading p-values, correlation vs causation, and A/B test analysis
Hands-on Lab Exercise

Test whether two branches or campaign groups differ significantly, and write the conclusion in plain language.

Day 11
Python and SQL together
Live Session
Topics Explored:
Connecting to MySQL with SQLAlchemy
Running queries into DataFrames
Writing results back to the database
When to use SQL and when to use Pandas
Hands-on Lab Exercise

Pull data with a SQL join, analyse it in Pandas and write a summary table back to MySQL.

Day 12
Automating reports
Live Session
Topics Explored:
Looping over many files
Writing formatted Excel workbooks with openpyxl or XlsxWriter: sheets, formats and charts
Reusable functions and scripts
Scheduling a script (overview)
Hands-on Lab Exercise

Mini Project 2: one script that reads monthly files and produces a formatted Excel summary report.

Day 13
Capstone kick-off and data preparation
Live Session
Topics Explored:
Project brief with several raw files or a SQL source, shared by the instructor
Define the business questions
Clean and combine the data in Pandas
Hands-on Lab Exercise

Learners prepare the dataset and write their question list with mentor support.

Day 14
Capstone: analysis, charts and automation
Live Session
Topics Explored:
Analysis, charts and a statistical test
An automated Excel summary report
Write 5 to 7 key insights and recommendations
Hands-on Lab Exercise

Learners complete the analysis and report with mentor support. Remaining work is completed as practice.

Day 15
Presentations, portfolio and career prep
Live Session
Topics Explored:
Capstone presentations and feedback
Portfolio: notebooks shared as HTML or PDF, and resume points
Interview questions: Python, Pandas, SQL and scenario-based
Next learning paths: Data Science and Data Engineering
Hands-on Lab Exercise

Present the capstone and receive feedback.

Detailed Module-wise Curriculum
15 Modules

Google Colab and Jupyter notebooks

Variables, numbers and strings

Lists, tuples, dictionaries and sets

Reading and writing simple code, comments and common errors

Lab Practical: Set up the environment. Write small programs, for example a loan EMI calculator and a name-cleaning exercise.

if and else conditions

for and while loops, list comprehensions

Functions and arguments

Error handling with try and except, and importing modules

Lab Practical: Write functions that categorise customers and summarise a list of transactions.

Reading and writing text, CSV and JSON files

Working with dates using datetime

NumPy arrays and vectorised calculations

Basic statistics with NumPy

Lab Practical: Read a CSV with plain Python, then repeat the same calculations with NumPy.

Series and DataFrame

Reading CSV, Excel and SQL data

head, info and describe

Selecting and filtering with loc and iloc, sorting, new columns and apply

Lab Practical: Load a sales dataset and answer 10 business questions you could also answer in Excel or SQL, then compare the methods.

Missing values: drop, fill and impute

Duplicates and wrong data types

Text cleaning with str methods

Dates with to_datetime, and outliers with IQR

Lab Practical: Clean a messy loan or customer dataset step by step.

groupby and agg, pivot_table, crosstab, value_counts

Datetime index, resample and rolling windows

Month-on-month and year-on-year change

Lab Practical: Rebuild an Excel pivot and a monthly trend table in Pandas.

merge, join and concat

melt and pivot to reshape data

Reading and combining many files from a folder

Checking merges for missing or duplicated rows

Lab Practical: Combine 12 monthly files with a product lookup table into one clean dataset.

Bar, line, histogram, box, scatter and heatmap

Titles, labels, colours and subplots

Choosing the right chart, and saving charts

Lab Practical: Create 6 charts from the combined dataset and improve them for a business reader.

An EDA checklist: distributions, relationships, segments and outliers

Turning charts into written insights

Structuring a notebook as a report

Lab Practical: Mini Project 1: an EDA notebook on a business dataset with charts and written insights.

Descriptive statistics and correlation in Pandas

Confidence intervals (intuition)

t-test and chi-square test with SciPy

Reading p-values, correlation vs causation, and A/B test analysis

Lab Practical: Test whether two branches or campaign groups differ significantly, and write the conclusion in plain language.

Connecting to MySQL with SQLAlchemy

Running queries into DataFrames

Writing results back to the database

When to use SQL and when to use Pandas

Lab Practical: Pull data with a SQL join, analyse it in Pandas and write a summary table back to MySQL.

Looping over many files

Writing formatted Excel workbooks with openpyxl or XlsxWriter: sheets, formats and charts

Reusable functions and scripts

Scheduling a script (overview)

Lab Practical: Mini Project 2: one script that reads monthly files and produces a formatted Excel summary report.

Project brief with several raw files or a SQL source, shared by the instructor

Define the business questions

Clean and combine the data in Pandas

Lab Practical: Learners prepare the dataset and write their question list with mentor support.

Analysis, charts and a statistical test

An automated Excel summary report

Write 5 to 7 key insights and recommendations

Lab Practical: Learners complete the analysis and report with mentor support. Remaining work is completed as practice.

Capstone presentations and feedback

Portfolio: notebooks shared as HTML or PDF, and resume points

Interview questions: Python, Pandas, SQL and scenario-based

Next learning paths: Data Science and Data Engineering

Lab Practical: Present the capstone and receive feedback.
PYTHON ANALYTICS COMPETENCY BADGE
Certificate of Technical Competency — Data Analyst - Advanced with Python

Complete all live hands-on labs to earn this verifiable competency badge. This credential unlocks progression to Data Analyst - Job Ready.

LIVE ONLINE COHORT
Admissions Open
Enroll in Data Analyst - Advanced with Python
Reserve your seat for upcoming live batches, syllabus consultation & fee structure.
Selected Course Program *
100% Privacy. Official Admissions Desk.

Frequently Asked Questions

Frequently Asked Questions: Data Engineering Course

Find clear answers to common questions about our live interactive classes, cohort schedules, project mentoring, and career assistance.

The program offers 3 comprehensive, career-focused courses: (1) Data Engineering Course (50 Hours), (2) Data Analyst - Advanced with Python (30 Hours), and (3) Data Analyst - Job Ready (30 Hours). Learners can enroll in individual courses or the complete data career master pathway.

Beginners should start with 'Data Analyst - Job Ready' to master business metrics, foundational SQL queries, and Power BI dashboards. Next, advance to 'Data Analyst - Advanced with Python' for automated analytics, and finally graduate to the 50-hour 'Data Engineering Course'.

No. Cloud basics are taught from the ground up starting with AWS IAM and S3, with step-by-step mentor guidance in every live session.

Most tasks use the AWS free tier. We configure budget alerts, and every cloud lab ends with a clean-up step to avoid unexpected bills. Learners should expect minimal or zero extra cost if instructions are followed.

Yes. All tools work on Windows, macOS, and Linux. Windows users will install WSL2 (Windows Subsystem for Linux) with mentor support, which makes the developer experience identical to Linux.

Every session is recorded in HD and shared within 24 hours, along with code repositories and daily lab tasks. You can catch up and ask questions in the next session or on the batch discussion channel.

You will finish with production-grade portfolio projects documented and pushed to your personal GitHub repository, verifiable certificates of completion, a professionally reviewed resume, and rigorous technical interview preparation.

Still have questions? We're here to help!

Speak directly with our technical advisors to discuss cohorts, curriculum, and career assistance.

FREE 1-ON-1 ACADEMIC GUIDANCE

Ready to Start Your Tech Journey?

Connect with our academic training counsellors. We analyze your background, career goals, and recommend the best live online track for your success.

Call Helpline: (02) 8902 0900WhatsApp or Viber Support