Logo

Big Data Analytics & Visualization in Excel

Overview

HRDF Claimable
 
This Big Data Analytics & Visualization in Excel course teaches participants how to manage their data using conventional methods and the latest Excel Power tools. Participants then use the art of story-telling to visualize their data on effective dashboards.

Learning Outcomes

Participants will learn to shape and model data; visualize data in using Excel’s range of Power tools- Power Pivot, Power Query, Power View and Power Map to create complex dashboards.

Who Must Attend

Participants who are data analysts, project managers, revenue managers, finance managers, journalists and those who are performing roles related to Business Intelligence (BI) in Excel. Also suited to individuals who wish to improve their knowledge on visualizing data using Excel’s new suite of Power tools- Power Query, Power Pivot, Power Map & Power View.

This course is more suited to participants who are regular users of Excel already familiar with basic Excel functions.

Course Details

2 Days Training

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

 

Methodology

Intensive hands-on approach on real-life case-study data. Participants will be using complex Big Data and conventional Excel datasets. Completion of dashboard projects are required to complete this course successfully.
 
SETUP REQUIREMENTS
Required software: Excel 2013 and above. For Excel 2013, Power View requires Microsoft Silverlight 5.
Required add-in to be set up in Excel: Power Map, Power View, Power Query, Power Pivot
Internet connection for participants required.

Course Leader

VINCENT CHIN
Chartered Accountant, ACCA (UK)
Sig Sigma Black Belt (ASQ)
 
Vincent has held financial, continuous improvement and I.T. positions in the banking, shared services and hospitality industry. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Office Specialist and a PSMB-accredited trainer. His previous roles include being an internal change consultant of a global team, a financial shared-services local head and a finance regional head. 
 
Vincent’s experience in the continuous improvement sphere of the financial industry includes projects in process automation & robotics, productivity management, end-to-end reviews and streamlining. He also trained yellow belts and green belts in DMAIC (the acronym for Define, Measure, Analyse, Improve & Control; a problem-solving methodology in Six Sigma) for other various companies. Vincent codes in VBA and has developed complex bespoke Excel applications in the companies he worked for.
 
He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA and process improvement. Vincent also assist companies in automating Excel tasks, end-to-end process reviews, developing process target operating models and other areas of process continuous improvement.
  
Vincent has trained employees from Genting Group, Dell, Motorola, Technip, CIMB, Malakoff, Digi, IBM, Starwood Hotels & Resorts, Petronas ICT, HSBC.
 
Vincent adapts a highly practical approach in his training and relates topics he conducts to real life scenarios. Because he is a no-nonsense person, his solid background in financial operations and process re-engineering experience aid him to create a unique training methodology that mimic closely the solutions that are needed in his participants’ organizations.

Testimonies


Investment

Normal fee
Sign up 1 pax
Pay before course starts
MYR 2,590.00 per pax
USD 760.00
Early Bird
Sign up 1 person
Pay 14 days before course starts
MYR 1,990.00 per pax
USD 580.00
Group Fee
Sign up 3 pax or more
Pay 14 days before course starts
MYR 1,790.00 per pax
USD 520.00

Certificate
Upon successful completion of this program, you will receive a Certificate of Achievement. 

Payment mode:

1. ONLINE PAYMENT  by Credit card:  You can opt to register and pay online with our latest payment integration system through our website.

2. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.

Contact us: ITRAININGEXPERT GLOBAL PLT
Tel:+603 8074 9056 | +603 8082 3707
Mobile: +6012 6869 628 | +6018 2175 123
Email: info@itrainingexpert.com
Website: www.iTrainingExpert.com

 

Registration Details

Select Course

Select Registration Type



IN HOUSE ENQUIRY

Related Courses

  • Financial Modelling For Forecasting, Budgeting & Financial Statements In Excel

    This 2 day financial modeling course offers you a sound understanding of both the principles of financial modeling and the practical application of these to real-world situations by using Excel to build financial models. Through this course, your w

    Read More

  • Top 10 Excel Skills for Business Professionals

    Do you have some co-workers who are always ahead with their data analysis while you are still struggling? The answer is simple. They are simply more efficient at using the Excel functions and formulas. And you too can achieve that in

    Read More

  • Microsoft Excel- Intermediate

    In today's fast- paced, technical business environment world, numbers meant everything. So it is of utmost importance that we the users, are able to manage the data - statistics, planning, reporting efficiently.

    Read More

  • Strategic Performance Management

    The Strategic Performance Management Training program provides participants with the key understanding and skill application in managing performance as well as the use of coaching as an approach to maximize the potential of their people.

    Read More