About the Course
The Data Analysis course equips students with essential skills in
statistical foundations, data wrangling, visualization, exploratory
data analysis, and the basics of machine learning. Learners gain hands-on
experience using tools such as Python, R, SQL, Excel, Tableau, and
libraries like Pandas and NumPy. The course emphasizes ethical data
handling and real-world problem solving, culminating in a capstone
project that prepares students for data-driven roles across industries.
Learning Methodology
The course combines theoretical instruction with practical, hands-on
learning. Students begin with foundational concepts in statistics and
data handling, then progress to data wrangling, visualization, and
exploratory analysis using Python and R. Learning is reinforced through
exercises, case studies, real-world projects, continuous feedback, and
assessments, with strong emphasis on ethical considerations in data use.
Course Outline (8 Weeks)
Weeks 1–2: Foundations of Data Analysis
- Introduction to data analysis concepts
- SQL basics (SELECT, WHERE)
- Data manipulation using SQL
- Excel data importing and cleaning
- Formulas and functions for data manipulation
- Pivot tables and charts
- Practical exercises with SQL and Excel
Weeks 3–4: Advanced SQL and Excel Techniques
- Subqueries and nested queries
- Aggregation and grouping
- SQL case studies
- Advanced Excel functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
- Data validation and conditional formatting
- Excel automation with macros
- Advanced SQL and Excel projects
Weeks 5–6: Introduction to Python for Data Analysis
- Basics of Python programming
- NumPy and Pandas for data analysis
- Data manipulation using Python
- Data visualization with Matplotlib and Seaborn
- Practical exercises in Python data analysis
Weeks 7–8: Tableau for Data Visualization
- Introduction to Tableau and interface overview
- Connecting Tableau to data sources
- Building interactive dashboards
- Storytelling with data
- Final project using SQL, Excel, Python, and Tableau
Possible Career Opportunities
- Data Analyst
- Business Analyst
- Data Scientist
- Machine Learning Engineer
- Data Engineer
- Financial Analyst
- Marketing Analyst
- Healthcare Data Analyst
- Operations Analyst
- Research Analyst
