Vision Classes - Data Analyst Syllabus
1. Fundamentals of Data Analysis
- Introduction to Data Analysis
- Types of Data: Structured vs. Unstructured
- Data Lifecycle
- Business Intelligence vs. Data Analysis
- Analytical Thinking
2. Excel for Data Analysis
- Data Cleaning
- Data Sorting, Filtering
- Pivot Tables & Charts
- Conditional Formatting
- VLOOKUP, HLOOKUP, INDEX, MATCH
3. Statistics & Probability
- Mean, Median, Mode, Range
- Standard Deviation & Variance
- Probability Distributions
- Hypothesis Testing
- Confidence Intervals
- Correlation & Regression Analysis
4. SQL (Structured Query Language)
- Basics of Databases & Tables
- CRUD Operations (Create, Read, Update, Delete)
- Joins (INNER, OUTER, LEFT, RIGHT)
- Aggregations (COUNT, SUM, AVG)
- Group By & Having Clauses
- Subqueries & Window Functions
5. Python/R for Data Analysis
- Data Types, Loops, and Functions
- Numpy & Pandas (for Python)
- Data Cleaning & Transformation
- Matplotlib/Seaborn (Data Visualization)
- Working with APIs & JSON
- Exploratory Data Analysis (EDA)
6. Data Visualization Tools
- Tableau or Power BI
- Dashboards & Reports
- Charts: Bar, Line, Pie, Scatter, Heatmaps
- Data Blending and Joins
- Filters and Parameters
7. Data Cleaning & Wrangling
- Handling Missing Data
- Outliers Detection
- Data Transformation
- Parsing Dates & Strings
- Data Normalization
8. Advanced Topics (Optional but Recommended)
- Time Series Analysis
- A/B Testing
- Web Scraping
- Introduction to Machine Learning (e.g., Linear Regression)
- Big Data Basics (Hadoop, Spark)
9. Capstone Projects
- Real-world business problem solving
- Data gathering, cleaning, analyzing, and presenting insights
- Tools used: Excel, SQL, Python, Tableau/Power BI