Big Data Analytics & Visualization in Excel

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.

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.

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.

**Please ensure that you have at least any of these versions:

• Microsoft 365 - All versions that include Desktop versions of Excel for Windows
• Office Professional 2019
• Office Home & Business 2019
• Office Home & Student 2019
• Office 2016 Professional Plus (available via volume licensing only)
• Office 2013 Professional Plus
• Excel 2013 standalone
• Excel 2016 standalone
  Internet connection for participants required.
  
  

FOLLOWING VERSION DO NOT HAVE TOOLS TO RUN THIS BIG DATA ANALYTICS TRAINING. PLEASE MAKE SURE YOU HAVE ONE OF THE ABOVE EXCEL VERSION. 

• Office Professional 2016
• Office Home & Student 2013
• Office Home & Student 2016
• Office Home & Business 2013
• Office Home & Business 2016
• Office for Mac
• Office for Android
• Office RT 2013
• Office Standard 2013
• Office Professional 2013

Ts. Fahmie A. Hamid

Ts. Fahmie A. Hamid is an Islamic Financial Planning (IFP®) graduate and currently holds the Capital Markets Services Representative’s License (CMSRL) issued by the Securities Commission Malaysia under Financial Planning activities. He is also a Professional Technologist (Ts.) registered with the Malaysian Board of Technologists (MBOT).

Fahmie is a multi-skilled consultant, coder, and technology strategist with over 25 years of training and consulting experience. He has been actively involved in professional training since 1997, delivering impactful programs across industries, combining his strong background in technology, finance, and business strategy.

Throughout his career, Fahmie has conducted diverse training programs for government agencies, GLCs, NGOs, MNCs, educational institutions, F&B, M&E, and financial service organizations. His wide-ranging topics include Information Technology, Artificial Intelligence (AI), Internet of Things (IoT), Sales and Marketing, Business Strategy, Financial Management, Financial Planning, and Compliance.

He is well known among his network as a Personal Finance Strategist who brings a practical, technology-driven learning experience to his sessions. Fahmie’s training style integrates his unique KNOW-WHAT, KNOW-WHY, and KNOW-HOW methodology — emphasizing understanding, purpose, and real-world application.

Educational Background

• Islamic Financial Planner, Islamic Banking & Finance Institute Malaysia (2023–2024)

• B.Sc. in Computing Science with Honours, Staffordshire University, U.K. (1998–1999)

• Higher Diploma in Computer Systems, Asia Pacific Institute of IT (APIIT) (1997–1998)

• Diploma in Information Technology, Asia Pacific Institute of IT (APIIT) (1996–1997)

Professional Titles & Affiliations

• Professional Technologist (Ts.), MBOT (2025)

• CMSRL in Financial Planning, Securities Commission Malaysia (2024)

• HRDC TTT Accredited Trainer (2024)

• MPFC Professional Shariah Retirement Planning Advisor (PSRPA) (2024)

• MPFC Associate Shariah RFP (2024)

• FPAM Associate Member (2024)

• Capital Market Essentials Program (eFPMR) (2024)

• HRDF TTT Exempted Trainer

“Before attending the course, I felt ready to learn & improve my Excel skills. In the program I learned many methods to work on data in Excel. After the course, I feel I have improved some excel skills. The trainer went above & beyond and share a lot. His training is also easy to understand & very clear.” – Intan Diana, Science officer, ISTIC-UNESCO.

“I felt that I lacked the necessary skills to utilize Excel efficiently. During the course, I learned a lot of different excel functions that could help me in at work. After the 2 days training, I feel like an Excel master. The trainer was very engaging. He answered all my questions and explained them very well.”- Ahmad Safuan, Science officer, ISC ROAP.

“Before attending the course, I thought enough about Excel. On these 2 days course, I learned picked up many different Excel functions. I gained knowledge a lot from the training. The trainer well engaged and knowledgeable.’- Farah Atiqah, Science officer, ISC ROAP. 

“I didn’t have too much knowledge about Excel and its functions. By showing up in the 2 days Microsoft Excel course, I feel gained knowledge & discover many things in this application. The trainer was good at explaining.”- Zarmila Salmi, Admin & Finance officer, ISTIC-UNESCO.

“I am always curious what functions can excel do. In the course, I realise that there are many excel functions that can help me. After the course, I want to review all my files and see if the new skills that I picked up can be applied. Many thanks to the trainer, Mr Vincent Chin.”_ LUO XIAOHUI, Project Leader of Huntsman Global Shared services.

“I felt anxious before the program. During the course, I learned about Power query, short cut keys, useful functions.  After the course, I feel confident and boosted up because of the clear and better understanding. Great training and learnt a lot about excel. Shimin Guo, Global Shared services.

“Before attending the course, I feel enthusiastic, Open-Minded, Eager to Explore. During the course, I learned about Advance Formulas & Functions, Basic Power Query, Application of Excel Skills. After this training, I felt excited and eager to apply the technique and tips that have been taught in the session into my work. I think the session was a good one and I enjoyed the pace and flow of the session which was steady and reasonably easy to pick up. Thanks Vincent!.” Huntsman Global Shared services.

This course fee is applicable for online training

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

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

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

3. HRD Corp Claimable Courses Skim Bantuan Latihan Khas - Applicable to Malaysian Employer Only

We'd happy to help.
Feel free to talk to us today, however most suitable for you.
Mobile call/ whatsapp: +6012 6869 628 | +6018 2175 123
Office: +603 8074 9056
Email: info@itrainingexpert.com
Website: www.itrainingexpert.com