You may add more courses here,
your list will be saved.

Home Malaysia Courses Data Analytics BIG DATA ANALYTICS VISUALIZATION EXCEL

BIG DATA ANALYTICS VISUALIZATION EXCEL iTraining Expert

BIG DATA ANALYTICS VISUALIZATION EXCEL Kuala Lumpur

iTraining Expert

Price: MYR 2,290

Duration: 2 Days

Course details

MODULE 1: Introduction
•Business Intelligence & Big Data today
•What is Story Telling & Data Visualization?
•Story Telling vs Data Visualization
•Data-driven narratives & Dashboards
•Components of a good Dashboard

MODULE 2: Using PivotTables
•Creating Excel Tables & operating them efficiently
•Building a PivotTable
•Sorting, Formatting & Filtering PivotTables
•Grouping records in PivotTables
•PivotTable calculations & formulas
•Slicers & Timelines

MODULE 3: Excel Power Query
•What is Power Query?
•Connecting to various data sources & importing data
•Using Power Query to replace the VLOOKUP
•Shaping & customizing a data model from multiple data sources
•Merging, appending & exporting queries

MODULE 4: Excel PowerMap
•Creating & visualizing data in PowerMap
•Integrating PowerMap into dashboards
•User interaction & form design

MODULE 5: Exploring & visualizing data in Power View
•Exploring data, creating charts & maps
•Slicing, filtering, highlighting & sorting data
•Power View dashboard design

MODULE 6: Excel Power Pivot
•Getting started with Power Pivot
•Importing data into Power Pivot
•Understanding Power Pivot & Relationships
•Creating Relationships between Tables
•KPIs
•Hierarchies
•Data Analysis Expressions (DAX) language overview
•Visualizing data from Power Pivot Updated on 11 May, 2020

Job roles this course is suitable for:

Project Manager , Finance Manager , Revenue Accounting Manager

Course Location

Show map Location Kuala Lumpur

About iTraining Expert

is the corporate training events arm of ITE INTERNATIONAL LTD with extensive training experience from both the government and corporate sector covering Malaysia, Singapore, Australia, China, Vietnam and Indonesia. We've been running the training business since 1999.

We've been running the human development and corporate training business since 1999. This year, we celebrate our 16th years in contributing to the advancement of Human Capital, Skills and Knowledge to enable Productivity, Efficiency and Effectiveness at Work and in Life.

Our Services: