"Business Intelligence with Power BI (2-days) also known as Power BI Desktop"
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:
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.
DAY 1: 9:00 AM – 5:00 PM
9.00AM - 10.30AM
Module 1: Excel Business Intelligence - Big Data
10.30AM - 10.45AM Break
10.45AM - 1.00PM
Module 2: Excel Business Intelligence - Big Data (Continuation from Module 1.)
1.00PM - 2.00PM Lunch
2.00PM - 3.30PM
Module 3: Using Pivot Tables
3.30PM - 3.45PM Break
3.45PM - 5.00PM
Module 4: Using Pivot Tables (Continuation from Module 3.)
DAY 1: 9:00 AM – 5:00 PM
9.00AM - 10.30AM
Module 5: Excel Power Query
10.30AM - 10.45AM Break
10.45AM - 1.00PM
Module 6: Excel Power Query (Continuation from Module 5.)
1.00PM - 2.00PM Lunch
2.00PM - 3.30PM
Module 7: Excel 3D Maps
3.30PM - 3.45PM Break
3.45PM - 5.00PM
Module 8: Excel 3D Maps (Continuation from Module 7)
The course is instructional, step-by-step in approach. Participants are also put through exercises on interesting datasets to apply their understanding & learning.
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.
SETUP REQUIREMENTS
1.Laptop is required. If you have two computer monitors, please use them. The second monitor could be a tablet/ surface/ tv screen to help you look at the trainer's screen while you work on your own laptop/ desktop's screen.
2. Required software (either one): Excel 2016 Professional Plus, Excel 2019, Excel 2021, Microsoft 365.
3. Ensure that Power Query and Power Pivot are working in your installed versions of your Excel.
Power Pivot info:
https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b
Power Query info:
https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16
Tutorial video:
https://youtu.be/8tWi4nSUyWA
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 industries. 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 require his expertise.
One of his highest achievements in the role of a Financial Controller for several multinational conglomerates 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, and 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 mimics closely the solutions that are needed in his participants’ organizations.
OR
Other professional trainers in this field.
To contact Vincent , please call +6012 6869 628, +603 8074 9056, +603 -8082 3707 or info@itrainingexpert.com
“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.
| Normal Fee | Early Bird | Group Fee |
|---|---|---|
| Sign up 1 pax | Sign up 1 pax | Sign up 3 pax or more |
| Pay 1 day(s) before course starts | Pay 14 day(s) before course starts | Pay 14 day(s) before course starts |
| MYR 2990 per pax | MYR 2600 per pax | MYR 2500 per pax |
| USD 890 per pax | USD 760 per pax | USD 730 per pax |
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
