This is an advanced Excel course, covering Excel tools Pivot Table, Power Pivot, Power Query, and 3DMap in detail.
You will be introduced to business intelligence, OLAP, flat files, relational databases, and big data.
By the end of the Excel Business Intelligence course, you will benefit by:
- Reducing your turnaround-time in data preparation at the workplace using the abovementioned tools compared to usage of conventional Excel methods.
- Visualize Data using 3DMap.
Who Must Attend
Data miners, data analysts, project managers, revenue managers, finance managers, journalists & 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 suite of Power tools- Power Query, Power Pivot and 3D Map.
This course is more suited to participants who are regular users of Excel already familiar with intermediate Excel functions and those who are already familiar with the Pivot Table.
Module 1: Excel Business Intelligence - Big Data
Big data components
Big data and small data
Sources of big data
Big data structure
Big data analysis
Tools and technology
The Microsoft Data Platform
Module 2: Using Pivot Tables
Pivot Table basics
Using Pivot Table Filters
Sorting, Formatting Pivot Tables
Calculations and Inserting Formulas
Pivot Table charts
The new Data Model functionality in Pivot Table
Module 3: Excel Power Query
What is Power Query?
Connecting to data source & importing data
Creating a new query
Merging & appending queries
Automating consolidation of files
Creating an index
Changing data types, data format & replacing values
Unpivoting & pivoting columns
Replacing values in columns
Module 4: Excel 3D Maps
Plotting geographical data
Creating & visualizing data in 3D Maps- column, bubble, heatmap & region charts
Adding layers & scenes
Visualize data over timelines
Playing & recording the map
Module 5: Excel Power Pivot
Getting started with Power Pivot
Importing data into Power Pivot
Understanding Power Pivot & Relationships
Creating Relationships between Tables
Data Analysis Expressions (DAX) language- SUM, SUMX, CALCULATE, RELATED, &&, FILTER
Visualizing data from Power Pivot
Intensive hands-on approach on real-life case-study data. You will be using big data and conventional Excel datasets. Completion of dashboard projects are required to complete this course successfully.
1. Required software (either one): Excel 2016 Professional Plus, Excel 2019, Excel 2021, Microsoft 365.
2.Ensure Power Query and Power Pivot are working in your installed versions of your Excel.
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified 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.
|Sign up 1 pax|
|Pay before course starts|
|MYR 2,990.00 per pax|
|Sign up 1 person|
|Pay 14 days before course starts|
|MYR 2,590.00 per pax|
|Sign up 3 pax or more|
|Pay 14 days before course starts|
|MYR 2,490.00 per pax|