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.
What you'll master in Level 2
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
Setup and Python basics
Set up the environment. Write small programs, for example a loan EMI calculator and a name-cleaning exercise.
Control flow and functions
Write functions that categorise customers and summarise a list of transactions.
Files, dates and NumPy
Read a CSV with plain Python, then repeat the same calculations with NumPy.
Pandas basics
Load a sales dataset and answer 10 business questions you could also answer in Excel or SQL, then compare the methods.
Data cleaning
Clean a messy loan or customer dataset step by step.
Grouping, summarising and time-based analysis
Rebuild an Excel pivot and a monthly trend table in Pandas.
Combining and reshaping data
Combine 12 monthly files with a product lookup table into one clean dataset.
Charts with Matplotlib and Seaborn
Create 6 charts from the combined dataset and improve them for a business reader.
Exploratory data analysis and storytelling
Mini Project 1: an EDA notebook on a business dataset with charts and written insights.
Statistics and hypothesis testing with SciPy
Test whether two branches or campaign groups differ significantly, and write the conclusion in plain language.
Python and SQL together
Pull data with a SQL join, analyse it in Pandas and write a summary table back to MySQL.
Automating reports
Mini Project 2: one script that reads monthly files and produces a formatted Excel summary report.
Capstone kick-off and data preparation
Learners prepare the dataset and write their question list with mentor support.
Capstone: analysis, charts and automation
Learners complete the analysis and report with mentor support. Remaining work is completed as practice.
Presentations, portfolio and career prep
Present the capstone and receive feedback.
Detailed Module-wise Curriculum
if and else conditions
for and while loops, list comprehensions
Functions and arguments
Error handling with try and except, and importing modules
Reading and writing text, CSV and JSON files
Working with dates using datetime
NumPy arrays and vectorised calculations
Basic statistics 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
Missing values: drop, fill and impute
Duplicates and wrong data types
Text cleaning with str methods
Dates with to_datetime, and outliers with IQR
groupby and agg, pivot_table, crosstab, value_counts
Datetime index, resample and rolling windows
Month-on-month and year-on-year change
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
Bar, line, histogram, box, scatter and heatmap
Titles, labels, colours and subplots
Choosing the right chart, and saving charts
An EDA checklist: distributions, relationships, segments and outliers
Turning charts into written insights
Structuring a notebook as a report
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
Connecting to MySQL with SQLAlchemy
Running queries into DataFrames
Writing results back to the database
When to use SQL and when to use Pandas
Looping over many files
Writing formatted Excel workbooks with openpyxl or XlsxWriter: sheets, formats and charts
Reusable functions and scripts
Scheduling a script (overview)
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
Analysis, charts and a statistical test
An automated Excel summary report
Write 5 to 7 key insights and recommendations
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
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.
Enroll in Data Analyst - Advanced with Python
Reserve your seat for upcoming live batches, syllabus consultation & fee structure.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.
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.
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.
