Back

Course Information PDF

Course Category:	Information Technology
Course Title:	Data Mining and Data Analysis with Excel PowerPivot

Course Code:

IT033

Medium of Instruction:

Cantonese

Duration:

24.0 hour(s)

Course Fee:

Macao Resident: MOP1,800

Non-Macao Resident: MOP1,800

Certificate:

Students who have obtained an overall passing grade of the course and met the attendance requirement will be issued a course certificate by UTM. The passing grade of the course is 50.

Course Code	Sub Code	Course Start Date	Course End Date	Class Schedule
IT033	2201	2022/03/07	2022/03/30	View

Objective:

PowerPivot is an add-in for Excel that greatly extends the pivot table. PowerPivot offers improved data summarization and cross-tabulation as well as expanded data capacity, and advanced calculations. Power View provides interactive data exploration and visualization of data.

Upon successful completion of this course, you will be able to use PowerPivot along with Excel 2013 to analyze data from a variety of sources, create reports, use DAX functions, define KPIs (Key Performance Indicators), and visualize PowerPivot data. Work with advanced functionality in PowerPivot for data mining.

Outline:

1. Understanding Power Pivot
2. Building Data Models
3. Create Pivot Tables and Pivot Charts
4. Using calculation in Power Pivot
5. Using Data Analysis Expression (DAX)
6. Understanding Power View
7. Comprehensive analysis of data using PowerPivot

Teacher:

Please refer to the schedule

Remarks:

English version of the software is used

Last Updated: 2023/05/31

Back