Overview
In this course, we take you through an in-depth overview of how Big Data visualization using Excel tools can result in an accurate predictive analysis of market trends ahead and how to adapt to them.
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
This course is more suited to participants who are regular users of Excel already familiar with basic Excel functions.
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.
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
For Excel 2013, Power View requires Microsoft Silverlight 5.
**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
Course Leader
VINCENT CHIN
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer
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 Certified Trainer, Microsoft Office Specialist and HRD Corp 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. 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 brings to you his 20 years’ of work and training experience in multiple industries where he was in charge of financial and business reengineering functions. He also develops complex VBA applications regularly in process improvement projects which requires his expertise.
One of his highest achievements in the role of a Financial Controller for several multinational conglomerates, he was being able to turn a loss making company into a profitable one within the year. Vincent has also managed a portfolio of business improvement projects with realized benefits of USD2 million in the prior year in an international bank.
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.
Or
We have a faculty of specialist and can cater to your organisation's different levels and specific needs.
For training and advisory services, feel free to contact us at info@itrainingexpert.com or call us at +603 8082 3707 | +603 8074 9056 | +6012 6869 628 | +6018 2175 123
Testimonies
“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.
Investment
| Normal fee |
| Sign up 1 pax |
| Pay before course starts |
| MYR 2,790.00 per pax |
| USD 820.00 |
| Early Bird |
| Sign up 1 person |
| Pay 14 days before course starts |
| MYR 2,090.00 per pax |
| USD 610.00 |
| Group Fee |
| Sign up 3 pax or more |
| Pay 14 days before course starts |
| MYR 1,990.00 per pax |
| USD 580.00 |
6% SST is chargeable, excluded in the quoted fee above
E-Certificate
Upon successful completion of this program, you will receive an E-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
