Covid-19 (Temporary Notice)
As part of our social responsibility, we will be limiting all courses to a maximum of 10 people. Our placement will be 1 person per desk, seating arrangements that allow provision of sufficient distancefrom personal contact. Precautionary measures for COVID-19 will be in place.
A business intelligence dashboard is a data visualization tool that displays the current status of metrics and key performance indicators for an enterprise. Dashboards consolidate and arrange numbers, metrics and sometimes performance scorecards on a single screen. They may be tailored for a specific role and display metrics targeted for a single point of view or department. The essential features of a BI dashboard product include a customizable interface and the ability to pull real-time data from multiple sources.
This course is customized for corporate managers and executives who are required to prepare various types of impressive executive management reports and business key performance reports. The main objective of this course is to provide the participants invaluable insights and equip them with advanced charting and reporting skills to professionally present their reports.
This fast pace Intermediate-Advanced level course is aimed at frequent Excel users who have to prepare interactive, informative and maintenance-free reports for management to analyze key pieces of business information.
Prerequisite:
You should be a confident Excel user who has experience in using and maintaining Excel reports and be able to create Excel table-driven reports and charts. A pre-requisite questionnaire will be provided to you to ensure the suitability and level is right for you.
Notice:
The course will actively be using Excel 365 subscription version. It will be running and taught based on the PC Windows software and not Mac versions. (All Laptops and materials will be provided)
A business dashboard gives business leaders valuable information and provides a quick outlook of all the most valuable numbers, which allows them to perform an accurate business analysis and make actionable decisions.
Participants will learn about:
Slicers are an easy-to-use filtering component that give you the ability to quickly filter your Dashboard and its respective views as well as add an attractive and interactive user interface to your dashboards.
Participants will learn how to:
The benefit of using advanced charts in Excel is they enable you focus on a specific data and make it easily understandable. You can use them in your dashboards to provide visualizations that help focus attention on key trends, comparisons, and exceptions.
Participants will learn how to:
Excel and PowerPoint are perfect partners for presenting dashboard on big screen. Simple dashboard on multiple slides will work better than one complex dashboard on a single slide.
Participants will learn how to:
Excel offers a set of Form controls such as option buttons, combo boxes and checkboxes that allow you to add interactivity to your dashboard and make it easier for users to interact with the charts and tables on dashboard.
Participants will learn how to:
Analytical dashboards are designed to help decision makers, executives and senior leaders, establish targets based on insights into historical data, set goals and understand what and why something happened so that appropriate changes can be implemented. For example, a Sales dashboard enable you to monitor and investigatie different aspects of sales process from the beginning until the end of its lifecycle and it’s useful to showcase sales data during annual meetings or quarterly meetings.
Participants will learn how to:
Dashboard automation in Excel can be achieved using macro buttons. Macro Recorder is a handy tool for a beginner who is unable to write the VBA (Visual Basic for Applications) code by hand to create macros.
Participants will learn how to:
Participants will have chance to design a user-friendly dynamic dashboard. The case study helps participant to apply the skills and functions they learned from the training so that they know exactly how to build interactive and informative dashboards in their work.
Free Excel Templates and Spreadsheet
Cutomised case study for In-house companies to suits your business needs
Free comprehensive list of Excel resources
After Course support