1. technology and computing
2. software
3. databases

High Impact Workshop
EFFECTIVE INFORMATION MANAGEMENT FOR
BUSINESS INTELLIGENCE USING MS EXCEL
Date: 12 - 13 May 2015
Venue: Istana Hotel Kuala Lumpur
Course Overview
Business intelligence (BI) is what you get when you analyze raw data and turn that information into actionable knowledge. BI can help an
organization identify cost-cutting opportunities, uncover new business opportunities, recognize changing business environments, identify data
anomalies, and create widely accessible reports.
Master business intelligence modeling and analysis techniques with Microsoft Excel, and transform data into bottom-line
results. This hands-on, scenario-focused workshop shows you how to use the latest Excel tools to integrate data from
multiple tables and how to effectively build a relational data source inside an Excel workbook. We will also show you
how you can turn Excel into your own personal BI tool. With a few fundamentals and some of the new BI functionality
Microsoft has included in the latest versions of Excel, you can go from reporting data with simple tables, to creating
meaningful dashboards sure to wow everyone.
At the end of this training, participants will be able to:
¾¾
Create eye-catching visualizations and Dashboards with Power View
¾¾
Use Power Pivot to create powerful reporting mechanisms
¾¾
Get better visibility into data from different perspectives
¾¾
Automate data integration with Power Query
¾¾
Use Excel Functions to analyze large amounts of data
¾¾
Use Excel pivot tables to access and
analyze data
¾¾
Automate repetitive tasks and processes
¾¾
Gain insight and analytical power with Data Mining tools
¾¾
Publish dashboards and reports
Who should attend?
This 2-day workshop is designed for professionals who want to analyse business data and produce meaningful reports and dashboards using
Excel. If you use Excel for more than 6 hours a week, you will benefit from this Masterclass.
Prerequisite
Before attending this workshop participants should have some experience working with data and familiarity with the basic concepts of data
analysis such as working with tables, aggregating data, and performing calculations. Experience using Excel with a strong grasp of concepts
such as tables, filtering, sorting, creating basic charts and using formulas.
As this is a hands-on workshop, participants are requested
to bring along a Laptop or Notebook computer with
Microsoft Office 2010 or 2013 installed.
www.kcomacademy.com
High Impact Workshop
EFFECTIVE INFORMATION MANAGEMENT FOR
BUSINESS INTELLIGENCE USING MS EXCEL
Date: 12 - 13 May 2015
Course Outline
Rueben is a PSMB Certified Trainer, the
Human Resource authority governing
corporate trainers in Malaysia. He has
spent the past 15 Years facilitating
numerous
workshops
for
key
organizations in Malaysia and Brunei,
which include Bank Negara, MIMOS,
Securities Commission, the Defence
Ministry, the Malaysian Department of
Accountants, JPMC, Brunei Investment
Authority, Tabung Amanah Pekerja,
Department of Islamic Education and
the Prime Ministers Office just to namedrop. The list also includes government
organizations and many public-listed
companies.
Rueben’s X-Factor is his personality.
There are countless trainers with
similar knowledge content however
what sets Rueben apart is his engaging
personality that is anchored by an
innate air of humbleness and a deep
respect for the participants of his
workshop.
The synergy of this combination results
in workshops that are fun and lively,
because he makes the learning process
fun and easy to understand. At the
close of the workshops, participants
feel empowered because they return to
their organizations with confidence to
apply their new-found knowledge and
skill.
He has an easy-going approach with
a unique ability to take all his training
programs and turn them into a walk
in the park. You will enjoy his insights
on the subject, sometimes even
challenging you to take a different view
on the tasks you routinely perform, so
that you can use it effectively at work.
Currently Rueben is a Corporate
Consultant and Trainer with KCOM
Academy. Apart from training, his
career in training has spanned across a
number of training organizations.
t: + 603 9102 1021
Understanding Database Concepts
How Databases Help
¾¾ Scalability
¾¾ Transparency of analytical processes
¾¾ Separation of data and presentation
Database Terms
¾¾ Databases, Tables, Records, fields & values
¾¾ Queries
¾¾ How Databases Are Designed
PivotTable Fundamentals
Introducing the PivotTable
¾¾ Anatomy of a PivotTable
¾¾ Creating the basic PivotTable
Customizing Your PivotTable
¾¾ Changing the PivotTable layout
¾¾ Renaming the fields
¾¾ Formatting numbers
¾¾ Changing summary calculations
¾¾ Suppressing subtotals
¾¾ Hiding and showing data items
¾¾ Hiding or showing items without data
¾¾ Sorting your PivotTable
Understanding Slicers
¾¾ Creating a standard slicer
¾¾ Formatting slicers
¾¾ Using multiple PivotTables with one slicer
Creating a Timeline Slicer
Understanding the Internal Data Model
¾¾ Building out your first Data Model
¾¾ Using your Data Model in a PivotTable
Introduction to Power Pivot
The Power Pivot Internal Data Model
Linking Excel Tables to Power Pivot
¾¾ Preparing your Excel tables
¾¾ Adding your Excel tables to the Data
Model
Creating Relationships among Your Power
Pivot Tables
Creating a PivotTable from Power Pivot Data
Power Pivot Data with Calculated Columns
¾¾ Creating a calculated column
¾¾ Formatting your calculated columns
¾¾ Referencing calculated columns in other
calculations
¾¾ Hiding calculated columns from end users
Utilizing DAX to Create Calculated Columns
¾¾ Building DAX-driven calculated columns
Understanding Calculated Fields
Loading External Data into Power Pivot
Loading Data from Relational Databases
¾¾ Loading data from SQL Server, Microsoft
Access databases and other relational
database systems
Loading Data from Flat Files
¾¾ Loading data from external Excel files
f: + 603 9102 1022
Venue: Istana Hotel Kuala Lumpur
¾¾ Loading data from text files
¾¾ Loading data from the clipboard
Loading Data from Other Data Sources
Refreshing and Managing External Data
¾¾ Manually refreshing your Power Pivot data
¾¾ Setting up automatic refreshing
¾¾ Preventing Refresh All
¾¾ Editing your data connection
Creating Dashboards with Power View
Activating the Power View Add-In
Creating a Power View Dashboard
¾¾ Creating and working with Power View
charts
¾¾ Visualizing data in a Power View map
¾¾ Changing the look of your Power View
dashboard
Adding Location Intelligence with Power Map
Installing and Activating the Power Map Add-In
Loading Data into Power Map
¾¾ Choosing geography and map level
¾¾ Handling geocoding alerts
¾¾ Navigating the map
Managing and Modifying Map Visualizations
¾¾ Visualization types
¾¾ Adding categories
¾¾ Visualizing data over time
¾¾ Adding layers
Adding Custom Components
¾¾ Adding a top/bottom chart
¾¾ Adding annotations and text boxes
¾¾ Adding legends
¾¾ Customizing map themes and labels
Customizing and Managing Power Map Tours
¾¾ Understanding scenes
¾¾ Configuring scenes
¾¾ Playing and sharing a tour
¾¾ Sharing screenshots
Using the Power Query Add-In
Installing and Activating the Power Query Add-In
¾¾ Downloading the Power Query Add-In
Power Query Basics
¾¾ Searching for source data
¾¾ Shaping the selected source data
¾¾ Understanding query steps
¾¾ Outputting your query results
¾¾ Refreshing Power Query data
¾¾ Managing existing queries
Understanding Column and Table Actions
¾¾ Column level actions
¾¾ Table actions
Power Query Connection Types
Creating and Using Power Query Functions
¾¾ Creating and using a basic custom
function
w: www.kcomacademy.com
2
High Impact Workshop
EFFECTIVE INFORMATION MANAGEMENT FOR
BUSINESS INTELLIGENCE USING MS EXCEL
Date: 12 - 13 May 2015
4 ways to register or enquire:
Contact us via
Venue: Istana Hotel Kuala Lumpur
Tel Fax Email Web :
:
:
:
(60) 3 9102 1021
(60) 3 9102 1022
info@kcom.net.my
www.kcomacademy.com
Fax to: +603 9102 1022
Please register the following delegate(s) for the event
(Please photocopy for more delegates)
Delegate 1
Delegate 2
Delegate 3
Name ( Dr / Mr / Mrs / Ms )
Job Title
Email Address
Mobile
Approving Manager
Name
Job Title
Direct Line
Email
Job Title
Direct Line
Email
Registration Contact
Name
Registration Contact
Full Company Name
Nature of Business
Billing Address
Important Note
Signature & Company Stamp
Please tick/fill-in any of the corresponding boxes below to select your choice of
participation:
BI_KC
Important Note
Upon sending in this registration page, it is understood that you agreed upon
the following terms of service. KCOM Management Sdn Bhd reserves the right
to change the content, the speaker, the time and/or the venue for the program
due to unforeseen circumstances. KCOM Management Sdn Bhd will also not be
held responsible should the program be delayed or cancelled due to unforeseen
circumstances.
Cancellations & Replacements
Upon registering, delegate(s) are considered successfully enrolled in the
program. Should the delegate(s) decide to cancel their enrolment, a cancellation
fee will be levied.
Cancellations 14 days or greater prior to start of the program will be subjected
to 50% cancellation fee. Cancellations received less than 14 days to the program
is subject to no refund.
Cancellations must be submitted in writing. ‘No shows’ during program days are
not considered cancellations, payment will not be refunded. ‘No show’ individuals
will be sent a copy of the program’s proceedings. Please note that substitutes are
always welcome.
Upcoming Workshops



3 participants or more*
RM 2,199.00 x
Early Bird Price*
RM 2,399.00 x
Normal Price
RM 2,599.00 x



delegate (s)
delegate (s)
delegate (s)
Send 3 participants or more at RM 2,199 each
* validity is until 27th April 2015.
* early bird price is only valid if payment is received before or on the program date(s).
Payment Method
100% HRDF CLAIMABLE
Crossed Cheque / Bank Draft to be made in favor of:KCOM MANAGEMENT SDN BHD
B-3A-2, Block B, Jalan 2/142A,
Megan Phoenix, 56100 Cheras,
Kuala Lumpur, Malaysia.
Bank : CIMB Bank Berhad
A/C No : 8002371909
Bank swift code : CIBBMYKL
visit us @ www.kcomacademy.com
Please send me the brochures for the following conferences and workshops as ticked below 
 Creating a Coaching & Mentoring Culture In Your Organization
 Effective Information Management for Business Intelligence using MS Excel
 High Performance Skills for Secretaries & Support Staff
 Business and Career Success using Neuro Linguistic Programming (NLP)
 Conducting Effective Performance Reviews and Appraisals
t: + 603 9102 1021
 Managing Projects from Start to Finish using MS Project
 OSH Workshop for Awareness & Management
 Applying Emotional Intelligence for Career Success
 Blueprint for Successful Business Planning
 Building & Managing Functional Databases using MS Access
f: + 603 9102 1022
w: www.kcomacademy.com
3