Business Intelligence with Microsoft Excel 2010 2018-01-31T13:54:49+00:00

Project Description

Welkin Course Code: X0BI

Course Features

Business Intelligence refers to a range of technologies, applications and methods that allow companies to better understand their business performance and to help make better business decisions. This course explains the concept of business intelligence, as well as the application of business intelligence among different expertise. Microsoft Excel and other server technology, such as Microsoft SQL Server 2005/2005, would be implemented for business intelligence applications, including Report Optimization and Automation, Data Warehousing, Multidimensional Analysis and Data Mining. Learn to create your own business intelligence solution using the powerful features of Microsoft Excel, featuring:

  • Dashboard creations
  • Data model
  • Common Excel functions
  • Interactive interface for users
  • Dashboard components

By the end of the course you will be able to apply various Excel features to create business intelligence solutions to help effective modeling, analysis and visualizatoin of business data.

  • Qualified and experienced instructor
  • Easy-to-follow, step-by-step hands on approach
  • Best practice skills explained and demonstrated

Learn from the Experts

Get Your Skills Certified


Certify your Excel skills with Microsoft Office Specialist Excel certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.

Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Excel with the CEF reimbursable course Business Analysis with Microsoft Excel.

Course Fee


Course Duration

6 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Excel.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment
Business Intelligence with Microsoft Excel 2010/2007
 Cantonese / PC
1900-22006 hrs/
2 sessions
MON, WED1,400.00
 Cantonese / PC
1900-22006 hrs/
2 sessions
WED, FRI1,400.00
 Cantonese / PC
1000-13006 hrs/
2 sessions
 Cantonese / PC
1900-22006 hrs/
2 sessions
MON, TUE1,400.00
 Cantonese / PC
1900-22006 hrs/
2 sessions
MON, TUE1,400.00
 Cantonese / PC
1000-13006 hrs/
2 sessions
Business Intelligence with Microsoft Excel 2010/2007
Complete your Enrolment
How to enrol/pay online

Business Intelligence with Microsoft Excel is a 6-hour course designed for those who aim to focus on using Excel to achieve better business perfomances. The course focuses on features of Excel with the purpose to enhance work productivity and effectiveness around Business Intelligence.

  1. Introduction to Business Intelligence
    • What is Business Intelligence?
    • Excel as a BI Tool
    • Defining reports
    • Defining dashboards
  2. Preparing for the Dashboard
    • Establish the audience and purpose for the dashboard
    • Delineate the measures for the dashboard
    • Catalog the required data sources
    • Define the dimensions and filters for the dashboard
    • Determine the need for drill-down features
    • Establish the refresh schedule
  3. Building Data Model
    • Data Modeling Best Practices
    • Separating data, analysis, and presentation
  4. Common Excel Functions
    • The VLOOKUP function
    • Using data validation drop-down lists in your data model
    • The HLOOKUP function
    • The SUMPRODUCT function
    • The CHOOSE function
  5. Building Basic Dashboard Components
    • The Pivotal PivotTable
    • The Four Areas of a PivotTable
    • Creating Your First PivotTable
    • Customizing field names
    • Applying numeric formats to data fields
    • Changing summary calculations
    • Creating Useful Pivot-Driven Views
    • Creating views by month, quarter, and year
    • Creating a percent distribution view
    • Creating a YTD totals view
    • Creating a month-over-month variance view
  1. Building Advanced Dashboard Components
    • Components That Show Trending
    • Comparative Trending
    • Highlighting Periods of Time
    • Other Trending Techniques
  2. Components That Group and Bucket Data
    • Creating Top and Bottom Displays
    • Using Histograms to Track Relationships and Frequency
    • Highlighting Top Values in Charts
  3. Components That Display Performance against a Target
    • Showing Performance with Variances
    • Showing Performance against Organizational Trends
    • Using Thermometer-Style Charts to Display Performance
    • An Introduction to the Bullet Graph
    • Showing Performance against a Target Range
  4. Giving Users an Interactive Interface
    • Introducing Form Controls
    • Adding and Configuring Controls
    • Check Box Example: Toggling a Chart Series On and Off
    • Option Button Example: Showing Many Views through One Chart
    • Combo Box Example: Controlling Multiple PivotTables with One Combo Box
    • List Box Example: Controlling Multiple Charts with One Selector
  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.