Excel Dashboards for Business Intelligence

Program Period

Duration 2-Days Time: 9:00 Am – 5:00 Pm

Who is this course for?

This course is best suited to anyone in Business Intelligence, data managers, data analysts, or Project Managers. This course would also suit anyone looking to extend their knowledge of Excel to understand some of the more advanced features and how they can be used to work together.

Why You Should Attend? 

Like a car dashboard, the objective of dashboard reporting is to provide clear and concise information of the key drivers of business performance. Dashboards are a synopsis of business operations and they provide information in visual format that is easy to read, remembered and understood by key decision makers in a business. This should in turn, improve decision making.

Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.

Prerequisites

Must be able to perform or have working experience with the following functions:

• • Basic Formulas – Addition, subtraction, multiplication and division

• • Basic Functions – AutoSum, Average, Count, Max and Min

• • Pivot Table

• • Conditional Formatting

• • Create Charts

• • Create Sparkline

• • Align Objects

• • Completion of our Excel Advanced course or equivalent knowledge

Benefits

• • At the end of this course you will understand what makes a dashboard.

• • You will learn how to build some of the most useful components when constructing your own dashboard reports.

• • During the course, you will build one complete dashboard projects to give you inspiration for your own solutions.

Course Syllabus

Unit 1: What is a dashboard?

Unit 2: PivotTables & PivotCharts

Unit 3: Useful functions

Unit 4: Conditional Formatting

Unit 5: Form Controls

Unit 6: Working with Charts 

Unit 7: Working with Sparklines

Unit 8: Design & Layout

 

Appendix I: Sample Dashboard Projects

• • Worldwide Salary Index