Certificate in Big Data Analysis
課程編號: CBDA2001
Certificate in Big Data Analysis 課程簡介
在每日的商業世界中,我們需要處理大量的數據以及各式各樣的資料分析。因此MS Office 扮演着重要的角色,協助我們加速完成每天的工作。
多年以來各大企業一直不斷地努力鼓勵員工學習及提升 MS Office 應用技能,進而縮短工作時間亦能夠提升工作效率。
本課程融合了多年的實戰經驗,令各位學員能夠充分利用及了解 MS Office 各版本的特點。由1997年的紮實基礎到 Office 365 雲端版本的最新技術,都能夠靈活運用。
課程特色:適合高速及集中的你,快速學習全部技術,投入日常工作中提升效率 。
課程時數:共 1 堂 每堂 3 小時
課程材料:筆記一份,練習檔案一份。
上課模式:一人一機,真人導師教授課程。
公司培訓:本課程適用於公司團體培訓, 詳情可與我們職員聯絡。
報名資格:建議先完成 Excel Beginning, Intermediate 及 Advance 課程 或 對函數應用有深入認識的人士
報名方法:1)網上即時報名 2) 銀行入數報名
上課地點:銅鑼灣
立即報名:按此報名
證書認可 : 完成課程後可以申領證書一份。
課程內容:
Introduction to Data Management, Cloud Data and Databases
What is data Management, cloud data and databases
Where do we store the data?
What are the businesses and large corporates approach to big data
Why do we need a Server? What is the a local server, cloud server and web server
Why not saving our data in Local drive?
How to implement a Cloud server to home and business application?
Three common Data Types for statistical analysis in business environment
Handling Continuous Data
Handling Categorical Data
Handling Discrete Data
Data Formats to handle the three data types
Importing data from a Text file
Importing data from a Word
Importing data from a Excel
Importing data from a CSV
What is database?
Introduction to Common databases
SAS
Oracle
Access
SAP
Introduction to the relationship between Databases and Excel
Statistical Functions and business analysis
Average Function – Handling arithmetic mean
Calculation of geometric mean for financial data
STDEV.S Function – Handling data spreads
Calculation of standard deviation without using the function
Calculation of standard deviation without using the pivot table approach
NORM.S.DIST Function – Applying standard normal distribution to business data
Understand the pdf of normal distribution function
Understand the cdf of normal distribution function
NORM.DIST Function – Applying standard normal distribution to business data
Understand the pdf of normal distribution function
Understand the cdf of normal distribution function
NORM.INV Function – Applying the inverse normal distribution to business data
Marketing analysis with Norm.INV application
BINOM.DIST Function – Applying binomial distribution to retail business data
Business application to control risk for retail stores.
Financial Functions
PV Function – Calculate the Present value for standard cash flow
FV Function – Calculate the Future value for standard cash flow
NPV Function – Calculate the Net Present value for irregular cash flow
Add-in Function
How to turn on Add-in Functions?
What is Excel Add-in functions
Statistical Analysis tools for analyst
Applying the statistical tools for big data
Using the Solver Function
Business Maximum Profit analysis by using solver function
Using solver function general for other purposes
Requesting a Solver report
VBA/Macro Application
What is VBA/Macro and VBE
Installing the developer tab to Excel Ribbon
Understanding the Macro approach to daily work flow
Introduction to Macro application
The 3 steps approach to record a Macro
How to record a Macro?
How to run a recorded Macro?
How to Stop a Macro?
How to delete a Macro?
Adding a button for a Macro
Assigning a different Macro to a button
Change the name and size of the button
More business application for Macro
Introduction to VBA programming