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.
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
•Data Analysis Expressions (DAX) language overview
•Visualizing data from Power Pivot
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.
|Sign up 1 pax|
|Pay before course starts|
|Sign up 1 person|
|Pay 14 days before course starts|
|Sign up 3 pax or more|
|Pay 14 days before course starts|
(Fee inclusive Training Materials & 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 IN CHEQUE
Bank in and then scan the Bank-in slip and email to us before the course commence to confirm your seat.
Courier your cheque payment to our Finance HQ.
*Note that we DO NOT take any payments during the event.
3. BANK IN CASH: You can also pay by cash through bank-in our company bank account.
4. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.