課程資料
Master in Big Data Analytics with Excel and Power BI
MASTERBIGDATA
 
若想更了解以上資訊,歡迎致電 3106 8211 查詢。
 
課程費用: $4980

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

繳費方法:

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

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

 
退款安排: 本中心備有完善之退款政策及程序。學生將會於報讀課程前獲發有關之文件,學員亦可按此閱讀。
 
質素保證: 本中心備有完善之免費補堂,免費重讀及彈性上課安排,令學員更有保障。
 
   
理論: 0小時 實習: 18小時 示範: 0小時

合共: 18小時

 


課程內容:
Master in Big Data Analytics with Excel and Power BI

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
- Formatting Data
- Building a Pivot Table
- Adding pivot charts and a slicer

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

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

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

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

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

Module 7: Visualizing Data in Excel

This module describes how to visualize data in Excel.

Lessons
- Pivot Charts

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

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
- Using Power BI desktop

Module 9: Introduction to Self-Service BI Solutions  


Introduces business intelligence (BI) and how to self-serve with BI.

Lessons

- Introduction to business intelligence
- Introduction to data analysis
- Introduction to data visualization
- Overview of self-service B

- Considerations for self-service BI
- Microsoft tools for self-service BI


Lab : Exploring an Enterprise BI solution
- Viewing reports
- Creating a Power BI report
- Creating a Power BI dashboard


Module 10: Introducing Power BI

This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.

Lessons

- Power BI
- The Power BI service

Lab : Creating a Power BI dashboard
- Connecting to Power BI data
- Create a Power BI dashboard


Module 11: Power BI

At the end of this module students will be able to explain the rationale and advantages of using Power BI.

Lessons
- Using Excel as a data source for Power BI
- The Power BI data model

- Using databases as a data source for Power BI
- The Power BI service

Lab : Importing data into Power BI
- Importing Excel files into Power BI
- Viewing reports from Excel files


Module 12: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, buil-in tools. This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.

Lessons
- Power BI desktop queries
- Shaping datal

- Combining data

Lab : Shaping and combining data
- Shape power BI data
- Combine Power BI data


Module 13: Interactive Data Visualizations

This module describes how to create and manage interactive data visualizations.

Lessons
- Creating Power BI reports
- Managing a Power BI solution


Lab : Creating a Power BI report
- Connecting to Power BI data
- Building Power BI reports
- Creating a Power BI dashboard

 

 
 
如有任何有關課程之查詢,歡迎致電 3106 8211 與我們的客戶關係主任聯絡。
 
MASTERBIGDATA19080036M 
日期 30/8/2019~13/9/2019 (FRI)
時間 10:30~17:30 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 4980

 
MASTERBIGDATA1909001D 
日期 12/9/2019~24/10/2019 (THU)
時間 19:00~22:00 
合共 18 小時
上課地點 北角分校
課程費用 $ 4980

 
MASTERBIGDATA19090026 
日期 28/9/2019~2/11/2019 (SAT)
時間 10:30~13:30 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 4980

 
MASTERBIGDATA1910002B 
日期 2/10/2019~6/11/2019 (WED)
時間 19:00~22:00 
合共 18 小時
上課地點 北角分校
課程費用 $ 4980

 
MASTERBIGDATA19100015 
日期 29/10/2019~10/12/2019 (TUE)
時間 19:00~22:00 
合共 18 小時
上課地點 長沙灣分校
課程費用 $ 4980