Data Analysis with Python, SQL and Tableau ( 12 weeks )
Prerequisite: Basic Computer Knowledge, Working Computer, Good Internet
This course provides a comprehensive pathway into data analysis using Python, SQL, and Tableau. Learners will gain hands-on experience in data cleaning, transformation, visualization, and reporting. Starting from Python fundamentals, students progress into NumPy, Pandas, exploratory data analysis (EDA), SQL querying, and interactive dashboards with Tableau. By the end of the program, participants will be equipped with practical skills required for roles such as Data Analyst, Business Intelligence Analyst, and Junior Data Scientist.
For Students Who Are Unable To Join The Live Sessions Due To Conflicting Schedules, The Recording Of Any Live Class You Miss Will Be Sent To You 3-5 Hours After The Class Ends
Why you should join this Bootcamp
live-classes
Participate in interactive instructor-led live classes for practical and real-world data analysis training.
hands-on-projects
Work on real datasets to build practical data analysis and visualization skills.
python-programming
Develop strong Python programming skills tailored for data analysis.
data-cleaning
Learn how to clean, preprocess, and transform messy datasets.
data-visualization
Create compelling visualizations using Matplotlib, Seaborn, and Tableau.
sql-mastery
Master SQL queries including joins, grouping, filtering, and aggregation.
exploratory-data-analysis
Perform EDA to uncover patterns, trends, and insights from data.
dashboard-development
Design interactive dashboards and reports using Tableau.
version-control
Use Git for version control and collaborative workflow.
final-project
Complete a capstone project showcasing your end-to-end data analysis skills.
certificate
Earn a certificate upon successful completion of the Data Analysis with Python, SQL and Tableau course.
Curiculum
Introduction to Tableau
Overview of Tableau interface,Connecting to datasets,Creating basic dashboards
Advanced Tableau and Storytelling
Advanced dashboards,Data analysis with Tableau,Data visualization best practices,Building storyboards
Python Introduction
IDE setup,Primitive data types,Variables and basic syntax,Control flow (if statements and loops)
Python Data Structures and Git
Lists, tuples, and sets,Dictionaries in Python,Functions in Python,Introduction to Git and version control,Advanced Git workflow
NumPy and Pandas Fundamentals
Introduction to NumPy arrays,Data handling with Pandas,Reading CSV and JSON files,Understanding DataFrames and Series
Data Cleaning and Transformation
Handling missing data,Data cleaning techniques,Aggregation and grouping with Pandas,Feature transformation
Data Visualization with Python
Matplotlib basics,Advanced Matplotlib customization,Introduction to Seaborn,Creating statistical visualizations
Exploratory Data Analysis (EDA)
Introduction to EDA,Using Anaconda environment,Working with Jupyter Notebook,Generating EDA reports with visualizations
SQL Fundamentals
Introduction to databases,Basic SQL syntax,SELECT statements,Filtering and sorting data,COUNT queries
Advanced SQL Queries
SQL joins,GROUP BY clause,Aggregate functions,Combining multiple tables
Capstone Project
Selecting a real-world dataset,Performing data cleaning and EDA,Writing SQL queries for analysis,Building interactive Tableau dashboards,Final presentation and review