1. Data Query and Processing
- SQL: Basic queries, multi-table joins, subqueries, window functions, performance optimization
- Excel: Pivot tables, VLOOKUP/XLOOKUP, conditional formatting, basic macro programming
2. Programming and Data Processing
- Python: Pandas data processing, NumPy numerical computation, Matplotlib/Seaborn visualization
3. Statistics Fundamentals
Descriptive statistics, probability distributions, hypothesis testing, confidence intervals, regression analysis
4. Business Intelligence and Visualization
Power BI: Interactive dashboards, data modeling, DAX formulas, report publishing
5. Machine Learning
Classification (logistic regression, decision trees, etc.), regression (linear regression, etc.), clustering (K-means, etc.), model evaluation and tuning
6. Deep Learning
Feedforward neural networks, CNN (image processing), RNN (sequence data), TensorFlow/PyTorch model building
7. Generative AI and Large Language Models
LLM working principles, Transformer architecture, text generation techniques, AI application scenarios
8. Prompt Engineering
Instruction design, context examples, output format control, avoiding prompt pitfalls