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, Microsoft, Unity, H3C, Lenovo, PMI, 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.
 

 

課程時間表:

 
BIGDATA17090014 
日期 2017/09/19 - 2017/10/10
時間 19:00-22:00 (TUE)
合共 12小時
地點 長沙灣分校
費用 $ 2980