Certificate and Executive Programs

Certificate in Visual Analytics and Dashboards (i2VSA)


SEP 12 - SEP 19



8:30 AM - 12:00 PM




14 Hours


0 Hours


Registration closed on

Sep 05, 2022


NOTE:This newly revised course has shifted online into four, half-day, live, instructor-led sessions. We have adapted the interactive sessions to include regularly scheduled breaks and digital breakout rooms for virtual networking and group discussions. Recordings of all sessions will be available to all registrants:


  • Mon, Sept 12, 2022 @ 8:30 AM - 12 PM
  • Wed, Sept 14, 2022@ 8:30 AM - 12 PM
  • Fri, Sept 16, 2022 @ 8:30 AM - 12 PM
  • Mon, Sept 19, 2022 @ 8:30 AM - 12 PM

CAREER STAGE: Mid - career

How much of our data is actionable information?

Effective data visualization and dashboarding is more than just creating charts in Excel. It starts with understanding what users need, identifying relevant data, and using appropriate visual techniques, structures and “stories” to support understanding, insights and action.

This CPA Ontario Certificate program provides participants with the skills to create effective visual reports and dashboards and how to introduce these new ideas into your organization. The course will cover some new charts in Excel, but the principles and process of design can be applied to any software. Using case studies and activities, the course includes information for decision making, misleading visuals, plus a comprehensive team-based case study creating a board level dashboard design.

Participants will receive an Excel workbook that provides practical instructions on how to build the new charts and illustrates other techniques covered in the program.

This Certificate program includes pre-course reading and preparation.

Participants will have the option to put their design knowledge into practice by submitting a post-course project assessment of a dashboard for an existing organization. Successful completion the project assessment will entitle participants to a Certificate from the Institute of Business Analytics (IBA).


  • Six step process to effective visual reporting and dashboards
  • Five key categories of actionable information
  • Impact of memory on choice of techniques, report structure, and dashboards
  • Metrics, KPIs, leading indicators and data transformation
  • Data in tables: When to use tables and when to use visuals
  • Pareto, box-plot, trellis, heat maps, bullet charts and other critical techniques for your design toolkit
  • Use Excel to create pareto, box-plot, trellis and other techniques
  • Benefits and limitations of pie charts, waterfall or bridge charts
  • Colour, minimalism, non-data ink design and considerations of alternate techniques
  • “Pretty” versus effective design
  • Trade-offs and considerations of how much information to include
  • Dashboard summaries, dashboard types, and when to break the “rules”
  • Telling stories with data – “ad-hoc” reports versus fixed format dashboards
  • Story structures for different scenarios
  • Business Intelligence (BI), data flow, and data sources for dashboards
  • Visualization and Exploratory Data Analysis (EDA)
  • Introduction to linear regression and predictive analytics

Successful completion of this program, including the post-course project, will entitle participants to a Certificate in Business Analytics and Reporting from the Institute of Business Analytics.


Business professionals who want to understand why traditional reporting often fails to address user needs and who want to improve the clarity and communication of key messages in reports and dashboards.




$2495.00 Member

$2495.00 Student

$2895.00 Public

Status: Registration closed on Sep 05, 2022




Simon Lindley is an international trainer, speaker and consultant in business transformation through analytics. He brings expertise in visual analytics and dashboard design to transform the role and performance of finance teams. Simon is a Chartered Accountant, Chartered Engineer (IT) and MBA with a Masters Diploma in corporate governance. He also has training and qualifications in statistics and data science.


Participants must use MS Excel (version 2010 or later). An external mouse is strongly recommended for the hands-on work, as well as a functioning internal microphone to experience the full audio portion of the course. After registration participants will be given access to the trainers’ learning portal where they can register to receive the pre-course reading and learning materials. Participants will be provided with course notes to review prior the course.

This CPA Ontario certificate program is a live webinar, delivered over four, half-day, morning sessions. You must attend all four live sessions to receive your verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time of each session. Recordings of all sessions will be available to all registrants.


  • Mon, Sept 5, 2022 @ 8:30 AM - 12 PM
  • Wed, Sept 7, 2022@ 8:30 AM - 12 PM
  • Fri, Sept 9, 2022 @ 8:30 AM - 12 PM
  • Mon, Sept 12, 2022 @ 8:30 AM - 12 PM

To access the course please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.

Please allow at least four hours after registration for the seminar to appear on your BlackBoard page.

Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.