Data Visualization and Business Dashboard in Excel for Business Intelligence
Details
Outline
•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
Speaker/s
Special Offer
Normal fee Sign up 1 pax: Pay before course starts MYR 2,890/ USD 800
Early Bird Sign up 1 person: Pay 14 days before course starts MYR 2,290/ USD 640
Group Fee Sign up 3 pax or more: Pay 14 days before course starts / MYR 2,190/ USD 610
(Fee inclusive of Buffet Lunch, Refreshment, Welcome Pack, Training Materials & Certificate of Achievement)
Certificate
Upon successful completion of this program, you will receive a Certificate of Achievement.
Certificates are distributed on the final day of the program.
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. 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.
ITRAININGEXPERT GLOBAL PLT is the corporate training arm of The English Expert Publishing and Training Group established since 1999 by consulting partners with extensive training experience from both the government and corporate sector covering Malaysia, Singapore, Australia, China, Vietnam and Indonesia.
All our trainers are experienced practitioners, professionally certified, dedicated and specialized in their respective fields. Our corporate philosophy is of Total Customers Satisfaction. We carry out our task with integrity and full commitment. We continue to keep abreast with industry developments through individual and ongoing continuing education, in-depth training and consulting that your organization demands and deserves.
For 18 years now and counting, we have trained more than 100,000 people to improving their work productivity, leadership & communication skills, language proficiency, sales, negotiation & presentation skills, workplace management and personal development.
What do we SPECIALISE in?
Put it in an easy way, we specialize in Training and Human Development training and consultancy services covering both soft skills and technical skills, a wide range of courses pertinent to the human capital development of high performing organization. ...