课程概述
本课程以商业数据业务为核心，帮助学员快速了解 Business 数据业务流程。通过 8 个涵盖不同 Business 业务部门的完整数据分析项目，让学员在短时间内掌握北美商业数据分析工作的核心技能，积累实际经验。同时，课程将介绍商业数据分析领域最常用的工具和技术，包括 Power BI、Tableau、SQL 和 Python。此外，课程还提供独家英语面试辅导，模拟真实面试场景，帮助学员掌握正确的回答技巧，直至顺利找到工作。
适合人群
- 零基础毕业生：希望进入数据分析领域的应届生
- 转行人士：希望转型到商业数据分析领域的职场人士
- 数据分析爱好者：对数据分析感兴趣，希望提升技能的学员
- 数据分析专业人士：希望在商业数据分析领域提升职业竞争力的从业者
工具基础课 - 简历面试常用 POWER BI
- Get data
- Prepare your data
- Model your data
- Write a measure in DAX
- Build your report
- Format the report
- Finished report
- Save your report
工具基础课 - 简历面试常用 TABLEAU
1: Connect to and Transform Data
- Connect to data sources
- Prepare data for analysis
- Customize fields
2: Explore and Analyze Data
- Create calculated fields
- Create quick table calculations
- Create custom table calculations
- Create and use filters
- Create parameters to enable interactivity
- Structure the data
- Map data geographically
- Summarize, model, and customize data by using the Analytics feature
3: Create Content
- Create charts
- Create dashboards and stories
- Add interactivity to dashboards
- Format dashboards
4: Publish and Manage Content on Tableau Server and Tableau Online
- Publish Content
- Schedule data updates
- Manage Published workbooks
工具基础课 - 简历面试常用 SQL
- SELECT Statement Practice
- WHERE Statement Practice
- JOIN Statement Practice
- INNER JOIN Statement Practice
- RIGHT & LEFT JOIN Statement Practice
- UNION Statement Practice
- UNION vs UNION ALL Statement Practice
- INTERSECT vs EXCEPT Statement Practice
- Aggregation Statement Practice
- SORT Statement Practice
- GROUP BY Statement Practice
- HAVING Statement Practice
- String Statement Practice
- Date Statement Practice
- NULL Statement Practice
- CAST Statement Practice
- Derived Statement Practice
- WITH Statement Practice
- CASE Statement Practice
- CREATE, INSERT, UPDATE, DELETE Statement Practice
工具基础课 - 简历面试常用 PYTHON
- Python Modules, Packages, Libraries
- Object creation
- Viewing data
- Selection
- Missing data
- Operations
- Merge
- Grouping
- Reshaping
- Time series
- Categoricals
- Plotting
- Getting data in/out
- Error handling
-
商务数据初级分析师课程 （初级BDA工具班）- 核心内容（24 hours）
-
工具基础课 - 简历面试常用 POWER BI
-
Get data
-
Prepare your data
-
Model your data
-
Write a measure in DAX
-
Build your report
-
Format the report
-
Finished report
-
Save your report
-
-
工具基础课 - 简历面试常用 TABLEAU
-
Connect to and Transform Data
-
Explore and Analyze Data
-
Create Content
-
Publish and Manage Content on Tableau Server and Tableau Online
-
-
工具基础课 - 简历面试常用 SQL
-
SELECT Statement Practice
-
WHERE Statement Practice
-
JOIN Statement Practice
-
INNER JOIN Statement Practice
-
RIGHT & LEFT JOIN Statement Practice
-
UNION Statement Practice
-
Union vs Union All Statement Practice
-
INTERSECT vs EXCEPT Statement Practice
-
Aggregation Statement Practice
-
SORT Statement Practice
-
GROUP BY Statement Practice
-
HAVING Statement Practice
-
String Statement Practice
-
Date Statement Practice
-
NULL Statement Practice
-
CAST Statement Practice
-
Derived Statement Practice
-
WITH Statement Practice
-
CASE Statement Practice
-
Create, Insert, Update, Delete Statement Practice
-
-
工具基础课 - 简历面试常用 PYTHON
-
Python Modules
-
Packages, Libraries
-
Object creation
-
Viewing data
-
Missing data
-
Operations
-
Merge
-
Subsection
-
Grouping
-
Reshaping
-
Time series
-
Categoricals
-
Plotting
-
Getting data in/out
-
Error handling
-
朱子宇
Related Courses
