- 参加本课程不需要任何特定要求。
数据分析是当今商业中的重要工具。我们将始终专注于培养实际数据分析的技能。该课程的目的是说明代表们对问题给出基于证据的答案：
发生了什么事？
- 处理和分析数据
- 生成资讯丰富的数据可视化
会发生什么？
- 预测未来性能
- 评估预测
会发生什么？
- 将数据转化为基于证据的业务决策
- 优化流程
该课程本身可以作为为期 6 天的课堂课程提供，也可以根据需要在几周内 远端 提供。 我们可以与您合作，提供最适合您需求的课程。
基本 Excel
- 导航
- 处理数据
- 使用公式和位址
- 图表
高级 Excel
- 逻辑函数
- 情景分析
- 求解
- 巨集
- 代码第一眼：VBA
VBA
- 数据类型
- 编写函数
- 控制程式：条件计算和回圈
- 调试技术
资料分析 Python
- 介绍 Python
- 变数和类型
- 使用 Pandas 在 Python 中进行数据操作
- 编写函数
- 使用 Matplotlib 和 Seaborn 进行数据可视化
- 与 Pandas 的数据争论
Machine Learning 和 Python 简介
- 使用 scikit-learn 进行线性回归
- 分类和回归树 Python
- 使用支援向量机和 Random Forests 进行分类
- 使用 scikit-learn 的聚类技术
United Arab Emirates - Data Analytics with Excel, VBA and Python - From the Ground Up
Qatar - Data Analytics with Excel, VBA and Python - From the Ground Up
Egypt - Data Analytics with Excel, VBA and Python - From the Ground Up
Saudi Arabia - Data Analytics with Excel, VBA and Python - From the Ground Up
South Africa - Data Analytics with Excel, VBA and Python - From the Ground Up
Brasil - Data Analytics with Excel, VBA and Python - From the Ground Up
Canada - Data Analytics with Excel, VBA and Python - From the Ground Up
中国 - Data Analytics with Excel, VBA and Python - From the Ground Up
香港 - Data Analytics with Excel, VBA and Python - From the Ground Up
澳門 - Data Analytics with Excel, VBA and Python - From the Ground Up
台灣 - Data Analytics with Excel, VBA and Python - From the Ground Up
USA - Data Analytics with Excel, VBA and Python - From the Ground Up
Österreich - Data Analytics with Excel, VBA and Python - From the Ground Up
Schweiz - Data Analytics with Excel, VBA and Python - From the Ground Up
Deutschland - Data Analytics with Excel, VBA and Python - From the Ground Up
Czech Republic - Data Analytics with Excel, VBA and Python - From the Ground Up
Denmark - Data Analytics with Excel, VBA and Python - From the Ground Up
Estonia - Data Analytics with Excel, VBA and Python - From the Ground Up
Finland - Data Analytics with Excel, VBA and Python - From the Ground Up
Greece - Data Analytics with Excel, VBA and Python - From the Ground Up
Magyarország - Data Analytics with Excel, VBA and Python - From the Ground Up
Ireland - Data Analytics with Excel, VBA and Python - From the Ground Up
Luxembourg - Data Analytics with Excel, VBA and Python - From the Ground Up
Latvia - Data Analytics with Excel, VBA and Python - From the Ground Up
España - Data Analytics with Excel, VBA and Python - From the Ground Up
Italia - Data Analytics with Excel, VBA and Python - From the Ground Up
Lithuania - Data Analytics with Excel, VBA and Python - From the Ground Up
Nederland - Data Analytics with Excel, VBA and Python - From the Ground Up
Norway - Data Analytics with Excel, VBA and Python - From the Ground Up
Portugal - Data Analytics with Excel, VBA and Python - From the Ground Up
România - Data Analytics with Excel, VBA and Python - From the Ground Up
Sverige - Data Analytics with Excel, VBA and Python - From the Ground Up
Türkiye - Data Analytics with Excel, VBA and Python - From the Ground Up
Malta - Data Analytics with Excel, VBA and Python - From the Ground Up
Belgique - Data Analytics with Excel, VBA and Python - From the Ground Up
France - Data Analytics with Excel, VBA and Python - From the Ground Up
日本 - Data Analytics with Excel, VBA and Python - From the Ground Up
Australia - Data Analytics with Excel, VBA and Python - From the Ground Up
Malaysia - Data Analytics with Excel, VBA and Python - From the Ground Up
New Zealand - Data Analytics with Excel, VBA and Python - From the Ground Up
Philippines - Data Analytics with Excel, VBA and Python - From the Ground Up
Singapore - Data Analytics with Excel, VBA and Python - From the Ground Up
Thailand - Data Analytics with Excel, VBA and Python - From the Ground Up
Vietnam - Data Analytics with Excel, VBA and Python - From the Ground Up
India - Data Analytics with Excel, VBA and Python - From the Ground Up
Argentina - Data Analytics with Excel, VBA and Python - From the Ground Up
Chile - Data Analytics with Excel, VBA and Python - From the Ground Up
Costa Rica - Data Analytics with Excel, VBA and Python - From the Ground Up
Ecuador - Data Analytics with Excel, VBA and Python - From the Ground Up
Guatemala - Data Analytics with Excel, VBA and Python - From the Ground Up
Colombia - Data Analytics with Excel, VBA and Python - From the Ground Up
México - Data Analytics with Excel, VBA and Python - From the Ground Up
Panama - Data Analytics with Excel, VBA and Python - From the Ground Up
Peru - Data Analytics with Excel, VBA and Python - From the Ground Up
Uruguay - Data Analytics with Excel, VBA and Python - From the Ground Up
Venezuela - Data Analytics with Excel, VBA and Python - From the Ground Up
Polska - Data Analytics with Excel, VBA and Python - From the Ground Up
United Kingdom - Data Analytics with Excel, VBA and Python - From the Ground Up
South Korea - Data Analytics with Excel, VBA and Python - From the Ground Up
Pakistan - Data Analytics with Excel, VBA and Python - From the Ground Up
Sri Lanka - Data Analytics with Excel, VBA and Python - From the Ground Up
Bulgaria - Data Analytics with Excel, VBA and Python - From the Ground Up
Bolivia - Data Analytics with Excel, VBA and Python - From the Ground Up
Indonesia - Data Analytics with Excel, VBA and Python - From the Ground Up
Kazakhstan - Data Analytics with Excel, VBA and Python - From the Ground Up
Moldova - Data Analytics with Excel, VBA and Python - From the Ground Up
Morocco - Data Analytics with Excel, VBA and Python - From the Ground Up
Tunisia - Data Analytics with Excel, VBA and Python - From the Ground Up
Kuwait - Data Analytics with Excel, VBA and Python - From the Ground Up
Oman - Data Analytics with Excel, VBA and Python - From the Ground Up
Slovakia - Data Analytics with Excel, VBA and Python - From the Ground Up
Kenya - Data Analytics with Excel, VBA and Python - From the Ground Up
Nigeria - Data Analytics with Excel, VBA and Python - From the Ground Up
Botswana - Data Analytics with Excel, VBA and Python - From the Ground Up
Slovenia - Data Analytics with Excel, VBA and Python - From the Ground Up
Croatia - Data Analytics with Excel, VBA and Python - From the Ground Up
Serbia - Data Analytics with Excel, VBA and Python - From the Ground Up
Bhutan - Data Analytics with Excel, VBA and Python - From the Ground Up
Nepal - Data Analytics with Excel, VBA and Python - From the Ground Up
Uzbekistan - Data Analytics with Excel, VBA and Python - From the Ground Up