Interactive Mentor-Led Cohorts

(02) 8902 0900contact@aumtrend.comWhatsApp / Viber
AUM Training
HomeCourses
Who We Serve
About UsContact
LMS Portal
LEVEL 1 — FOUNDATIONS
10 Hours (5 Days × 2 Hours)
View Full Curriculum

Python Foundations & Data Analysis

By the end of Level 1, participants will be able to write and run Python programs, manipulate data using NumPy and Pandas, perform data cleaning and exploratory data analysis (EDA), create visualizations, and prepare datasets for real-world projects.

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

By the end of Level 1, participants will be able to write and run Python programs, manipulate data using NumPy and Pandas, perform data cleaning and exploratory data analysis (EDA), create visualizations, and prepare datasets for real-world projects.

Training Objectives & Core Deliverables

Write Python programs using control flow, functions and built-in data structures.

Read and manipulate CSV, JSON, and text datasets.

Perform Exploratory Data Analysis (EDA) on real-world business datasets.

Create visualizations to identify patterns, distributions, and outliers.

Prepare clean datasets for downstream Machine Learning and data science.

Day-by-Day Training Schedule & Live Labs
5 Live Sessions • 100% Hands-on
Day 1
Python Fundamentals
Live Session
Topics Explored:
Python in AI and Data Science
Python workflow and use cases
Jupyter Notebook interface, cells, execution order and Markdown
Variables and naming rules
Numeric, string, Boolean and None types
Type conversion & operators
input(), print() & f-strings
Conditional statements (if/elif/else)
Loops (for, while) & range()
Basic debugging and coding conventions
Hands-on Lab Exercise

Create a sales discount calculator; build an eligibility checker; write a menu-driven order total program; debug common syntax, indentation and type errors.

Assignment / Deliverable

Mini-assignment: employee bonus eligibility and invoice calculator.

Learning Outcome: Write and run simple Python scripts/notebooks; use variables, conditions and loops to solve small business problems.

Day 2
Python Data Structures & Functions
Live Session
Topics Explored:
String indexing, slicing and methods
Lists and list operations
Tuples and immutability
Dictionaries and key-value access
Sets and set operations
Nested data structures
List comprehensions
Defining and calling functions
Parameters, return values and defaults
Lambda basics
Importing modules and using built-in libraries
Hands-on Lab Exercise

Analyze customer feedback text; normalize names and product codes; remove duplicate values; calculate order totals with functions; transform lists of sales records using comprehensions.

Assignment / Deliverable

Mini-assignment: customer contact cleanup and product-price transformation.

Learning Outcome: Select suitable data structures; manipulate text and collections; write reusable functions and import modules.

Day 3
File Handling, NumPy & Pandas Basics
Live Session
Topics Explored:
File paths and file modes
Reading and writing text files
CSV and JSON handling
with statement context management
Exceptions and try/except/finally
NumPy arrays, shape, dtype, indexing and arithmetic
Pandas Series and DataFrames
read_csv() and read_json()
Selecting columns and rows
Basic data types and dataset import checks
Hands-on Lab Exercise

Load customer and employee CSV files; parse a JSON order file; handle missing or invalid files safely; use NumPy for simple numerical calculations; inspect DataFrames.

Assignment / Deliverable

Mini-assignment: import two business datasets and produce a basic data-quality summary.

Learning Outcome: Read and write common data formats; handle errors safely; load structured data into NumPy and Pandas.

Day 4
Exploratory Data Analysis (EDA)
Live Session
Topics Explored:
Dataset shape and schema
head(), tail(), info(), describe()
Column types and missing-value analysis
fillna() and dropna() strategies
Duplicate detection and removal
Filtering with conditions and sorting
value_counts(), GroupBy and aggregations
Derived columns and feature creation
Data validation and sanity checks
Hands-on Lab Exercise

Clean a retail sales dataset; investigate missing customer and sales values; remove duplicates; compare revenue by region/category; create profit and order-value columns.

Assignment / Deliverable

Mini-assignment: submit a cleaned dataset plus a short findings report.

Learning Outcome: Profile, clean, filter and summarize tabular data; explain data-quality decisions and derive business metrics.

Day 5
Visualization & Preparing Data for AI
Live Session
Topics Explored:
Matplotlib and Seaborn basics
Line, bar, histogram, scatter and box plots
Category and distribution analysis
Correlation and heatmaps
Identifying trends, skew and outliers
Choosing suitable charts for business presentations
Exporting clean data
Reproducible EDA workflow
Preparing features and target columns for later ML work
Hands-on Lab Exercise

End-to-end retail/customer EDA: load data, clean it, create derived fields, generate at least five visualizations, interpret findings and export a clean CSV.

Assignment / Deliverable

Level 1 project: Retail/customer exploratory analysis and business recommendations.

Learning Outcome: Communicate insights visually; identify trends and potential data issues; prepare a clean dataset for downstream machine learning.

Track Portfolio Capstone Project

Level 1 Project — Retail/Customer EDA: A notebook that loads a dataset, documents data-quality checks, cleans missing and duplicate values, derives business metrics, creates visualizations and exports a clean dataset with business insights.

Detailed Module-wise Curriculum
5 Modules

Python in AI and Data Science

Python workflow and use cases

Jupyter Notebook interface, cells, execution order and Markdown

Variables and naming rules

Numeric, string, Boolean and None types

Type conversion & operators

input(), print() & f-strings

Conditional statements (if/elif/else)

Loops (for, while) & range()

Basic debugging and coding conventions

Lab Practical: Create a sales discount calculator; build an eligibility checker; write a menu-driven order total program; debug common syntax, indentation and type errors.

String indexing, slicing and methods

Lists and list operations

Tuples and immutability

Dictionaries and key-value access

Sets and set operations

Nested data structures

List comprehensions

Defining and calling functions

Parameters, return values and defaults

Lambda basics

Importing modules and using built-in libraries

Lab Practical: Analyze customer feedback text; normalize names and product codes; remove duplicate values; calculate order totals with functions; transform lists of sales records using comprehensions.

File paths and file modes

Reading and writing text files

CSV and JSON handling

with statement context management

Exceptions and try/except/finally

NumPy arrays, shape, dtype, indexing and arithmetic

Pandas Series and DataFrames

read_csv() and read_json()

Selecting columns and rows

Basic data types and dataset import checks

Lab Practical: Load customer and employee CSV files; parse a JSON order file; handle missing or invalid files safely; use NumPy for simple numerical calculations; inspect DataFrames.

Dataset shape and schema

head(), tail(), info(), describe()

Column types and missing-value analysis

fillna() and dropna() strategies

Duplicate detection and removal

Filtering with conditions and sorting

value_counts(), GroupBy and aggregations

Derived columns and feature creation

Data validation and sanity checks

Lab Practical: Clean a retail sales dataset; investigate missing customer and sales values; remove duplicates; compare revenue by region/category; create profit and order-value columns.

Matplotlib and Seaborn basics

Line, bar, histogram, scatter and box plots

Category and distribution analysis

Correlation and heatmaps

Identifying trends, skew and outliers

Choosing suitable charts for business presentations

Exporting clean data

Reproducible EDA workflow

Preparing features and target columns for later ML work

Lab Practical: End-to-end retail/customer EDA: load data, clean it, create derived fields, generate at least five visualizations, interpret findings and export a clean CSV.
LEVEL 1 — FOUNDATIONS COMPETENCY BADGE
Certificate of Technical Competency — Python Foundations & Data Analysis

Complete all live hands-on labs to earn this verifiable competency badge. This credential unlocks progression to Intermediate Python & Business Applications.

LIVE ONLINE COHORT
Admissions Open
Enroll in Python Foundations & Data Analysis
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: Python Programming

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

Yes. Level 1 begins with core Python syntax, basic logic, variables, and data structures. It requires zero prior programming knowledge.

You will build 3 complete portfolio projects: 1) Level 1 Retail/Customer EDA project with visualizations, 2) Level 2 API-to-Report automation tool with SQL database storage, and 3) Level 3 containerized FastAPI production microservice with Docker and PyTest.

Yes. You will learn relational database connectivity (CRUD and transactions), consume external REST APIs, build typed REST APIs with FastAPI, and package applications using Docker.

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