- 參加本課程不需要任何特定要求。
數據分析是當今商業中的重要工具。我們將始終專注於培養實際數據分析的技能。該課程的目的是説明代表們對問題給出基於證據的答案：
發生了什麼事？
- 處理和分析數據
- 生成資訊豐富的數據可視化
會發生什麼？
- 預測未來性能
- 評估預測
會發生什麼？
- 將數據轉化為基於證據的業務決策
- 優化流程
該課程本身可以作為為期 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