MEF Academy

Vision & Mission

Upcoming Events

MEFA Monthly Calendar

Training Programs

Industrial Relations

HR Management
& Development

Occupational Safety
& Health

Business Management

ICT

Certification &
Academic Courses

SWINBURNE
Certified Programs

UNIMAS
Certified Programs

In-house Courses

PSMB Scheme

Academy Staff


Training Directory 2024

MEF ACADEMY
3A06-3A07, Block A,
Phileo Damansara II,
No. 15 Jalan 16/11, Seksyen 16,
46350 Petaling Jaya,
Selangor Darul Ehsan,
Malaysia

Tel: 603-7498 7200

Information & Communication Technology

PowerPivot: Powerful Data Analysis and Data Modeling in Microsoft Excel

Objectives

With PowerPivot, Microsoft brings the dynamism of Business Intelligence tools to Excel, transforming enormous number of data/records into meaningful information. It is a Big Data tool that helps to generate rich and interactive analytics solutions.

Topics Covered

Module 1: Introduction to PowerPivot
Module 2: Getting Data into PowerPivot
Module 3: Table Relationships
Module 4: PowerPivot Windows
Module 5: Calculated Column
Module 6: PivotTables
Module 7: PowerPivot and Dashboards
Module 8: Create simple Data Analysis Expression (DAX) and Key Performance Indicators (KPI)
Module 9: Create a Hierarchy in a Table
Module 10: Create and Manage Data with Perspectives

*For more information, please click and refer to the brochure.

Target Audience

This course is relevant to data analysts, business analysts, financial analysts and anyone who wants to better manage their data. Knowledge and experience in using Excel PivotTable is assumed. Participants are required to have the Microsoft Excel version 2010 and above.

Methodology

Scheme	SBL	Fee	RM 1, 400
Duration	14 Hours	Members Less