Master in Big Data Analytics with Excel 高級證書課程 - Feva Works IT Education Centre

Master in Big Data Analytics with Excel 高級證書課程 BIGDATA

全民大數據行動正式開始!

隨著互聯網的急速發展與普及,網路上的數據每年將增長超過 50%,每兩年便將翻一番,而目前世界上90%以上的數據是最近 2 年才產生的,這就是我們當前所處的「大數據」時代!

「大數據」這個科技名詞在各種媒體上頻繁出現,毫無疑問已經成為當今科技界的熱點了。

其實業界提出的「大數據」概念,不僅告訴我們的是它的數量,更重要的是數據的分析利用,如何讓這樣海量的數據轉換為對企業更有價值的業務分析信息。


利用熟悉的 Excel 對數據進行分析



說到數據分析和商業智能,人們更多的會想到專業的數據平台和業界幾大軟體廠商,覺得這是專業人員的工作。

其實 Excel 就是一個強大的「自助式商業智能」解決方案工具,他可以更加輕鬆、簡單的完成數據的整合、分析和展示。

掌握 Excel 數據分析應用,就能讓全民大數據行動正式開始!

本課程為微軟原裝課程,由微軟認可導師 (Microsoft Certified Trainer) 教授。全個課程均為一人一機實習,理論與實戰並重。

課程附送全套 Digital Microsoft 原裝教材 (價值 $1,000)
 

 



課程全面教授學員有關 Big Data Analytics with Excel 技術。


免費課程首堂試讀體驗,立即報名 

 



 

理論: 0小時
實習: 12小時
示範: 0小時
合共: 12小時
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
課程費用: $2980

課程費用無須申請任何政府基金資助。

繳費方法:

一般課程:按月等額收取列明的課程費用。本中心將不早於課程開始的一個月前收取第一期費用。除第一期的費用外,每期的費用會在課程進行期間每月的首個上學日或之後收取。

組合課程:若該課程為組合課程,本中心將按該組合課程分科收費,直至所收學費為該組合課程的等額費用為止。

退款安排:
本中心備有完善之退款政策及程序。學生將會於報讀課程前獲發有關之文件,學員亦可按此閱讀。
質素保證:
本中心備有完善之免費補堂,免費重讀及彈性上課安排 (攝影課程除外),令學員更有保障。
自訂課程:
本中心歡迎各公司、機構或團體包團報讀課程,安排公司活動或同事培訓。想進一步查詢詳情,可致電熱線 3748 9826。
卓越成就:

本中心榮獲各大國際機構 (Adobe, Autodesk, Microsoft, Unity, H3C, Lenovo, Corel, Prometric, VUE, Certiport, Wacom 等等) 邀請成為香港區指定的認可教育中心及連續10 年榮獲香港社會服務聯會嘉許為「商界展關懷」公司,以表揚 Feva Works 對社會的貢獻。

除此之外,Feva Works 更連續 10 年獲 Microsoft 頒發全港最佳 Microsoft 授權培訓中心 (Best Microsoft Certified Partner for Learning Solutions of the Year) 及被 Adobe 選定為 Adobe CS4 & CS5 & CS6 & Creative Cloud 指定認可培訓中心。最近,Feva Works 更連續 10 年獲e-zone 電腦雜誌頒發最佳IT培訓中心。

課程內容:

MOC 20779 - Analyzing Data with Excel
Module 1: Data Analysis in Excel

This module looks at the classic Excel dashboard and at ways to extend it.

Lessons
- Classic Data Analysis with Excel
- Excel Pivot Tables
- Limitations of Classic Data Analysis

Lab : Building a Classic Excel Dashboard
- Filtering and Formatting Data
- Building a Pivot Table
- Building a Pivot Chart
- Building a Dashboard

After completing this module, students will be able to:

- Describe classic data analysis with Excel
- Describe Excel pivot tables
- Describe the limitations of classic data analysis with Excel

Module 2: The Excel Data Model

This module looks at the classic Excel data model and at ways to extend it.

Lessons
- Using an Excel Data Model
- DAX

Lab : Explore an Excel Data Model
- Create Calculated Columns
- Format Data Model Data
- Create Measures
- Analyze the Data

After completing this module, students will be able to:

- Describe an Excel data model
- View data within an Excel data table
- Describe DAX

Module 3: Importing Data from Files

This module looks at pre-formatting and importing CSV files.

Lessons
- Importing Data into Excel
- Shaping and Transforming Data
- Loading Data

Lab : Importing Data from a CSV File
- Import and Transform Data from a CSV File
- Add Data from a Folder

After completing this module, students will be able to:

- Import data into excel.
- Shape and transform data.
- Load data.

Module 4: Importing Data from Databases

This module looks at how to import data into Excel from a SQL Server database.

Lessons
- Available Data Sources
- Previewing, Shaping, and Transforming Data
- Table Relationships and Hierarchies
- Loading Data

Lab : Import Data from Multiple Sources
- Import Data from SQL Server
- Import Data from a CSV File
- Create a Data Table


After completing this module, students will be able to:

- Identify available data sources.
- Preview, shape, and transform data.
- Explain table relationships and hierarchies.
- Load data from various sources.

Module 5: Importing Data from Excel Reports

This module describes how to import data from a report.

Lessons
- Importing Data from Excel Reports
- Transforming Excel report Data

Lab : Importing Data from a Report
- Import Data from Excel
- Transform the Excel Data
- Load the Data into an Excel Data Model

After completing this module, students will be able to:

- Import data from Excel reports.
- Transform Excel report data.


Module 6: Creating and Formatting Measures

This module describes how to create and format measures.

Lessons
- DAX
- Measures
- Advanced DAX Functions

Lab : Creating Measures using Advanced DAX Functions
- Last year comparison
- Year to date
- Market Share


After completing this module, students will be able to:

- Explain what DAX is and when to use it.
- Describe a measure.
- Use some of the advanced functions within DAX.


Module 7: Visualizing Data in Excel

This module describes how to visualize data in Excel.

Lessons
- Pivot Charts
- Cube Functions
- Charts for Cube Functions

Lab : Data Visualization in Excel
- Create a Tabular Report
- Create a Pivot Chart
- Add Slicers to Charts


After completing this module, students will be able to:

- Create and refine a pivot chart.
- Describe cube functions and when to use them.
- Describe a number of charts for use with cube functions.


Module 8: Using Excel with Power BI

This module describes how to use Excel with Power BI.

Lessons
- Power BI
- Uploading Excel Data to Power BI
- Power BI Mobile App

Lab : Creating a Power BI Dashboard with Excel
- Uploading Excel Data
- Creating a Power BI Dashboard

After completing this module, students will be able to:

- Describe Power Bi and the various versions available.
- Upload Excel data to Power BI.
- Describe the Power BI App.
 

 

課程時間表:

 
BIGDATA17120014 
日期 2017/12/06 - 2017/12/27
時間 19:00-22:00 (WED)
合共 12小時
地點 長沙灣分校
費用 $ 2980


 
BIGDATA1801001E 
日期 2018/01/02 - 2018/02/06
時間 19:00-22:00 (TUE)
合共 12小時
地點 灣仔分校
費用 $ 2980