Computer Academy

DATA ANALYSIS WITH POWER PIVOT FOR EXCEL

Enquire Now

Course Information

Schedules
  • 12 May 2025 (Mon) 10:00 AM - 5:00 PM
Registration period
5 Mar 2025 (Wed) - 14 Apr 2025 (Mon)
Price
HKD 1,780
Course Level
Study Mode
Duration
1 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
1 views

Course Overview

PowerPivot is an add-in for Microsoft Excel that allows users to work with millions of rows of data across different data sources. In view of the speed and ability to manage data between heterogeneous data. PowerPivot is becoming an indispensable tool for data mining in the era of big data.

The PowerPivot course will teach users how to construct their data models using various data sources (e.g. Excel tables , Access tables or SQL tables), and performing analysis with the Data Analysis Expression ( DAX ) functions and Pivottables.

The easy to follow exercises and small class size teaching approach can ensure the best learning result. It is an ideal course for people working in the accounting, financial analysis and data processing areas. Students can choose the daytime, evening and weekends classes to suit their learning needs.

 

What You’ll Learn


  • Understanding Power Pivot
  • Different Data Sources
  • What is a data model?
  • Creating data models
  • Introduction to Data Analysis Expression Language (DAX)
  • Data Analysis with PivotTables

 



Start FollowingSee all

Learning Insight

Jobs related to this course

  • Business Technology Analyst ( Open Platform )

    Bank of China (Hong Kong) Limited
  • Senior Finance Analyst/Assistant Finance Manager/Finance Manager (Business Analysis) (1-year Contract)

    DFI Retail Group
  • Assistant Systems Manager

    VOCATIONAL TRAINING COUNCIL

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed