(613) 818-2848

Courses to change your game

For more information on this course, please see the Intersol Group website at https://intersol.ca For inquiries, please contact Sue Perron at 613-850-6564 or sperron@intersol.ca or, of course, contact me, at jburrett@haikuanalytics.com

For my book, please go to https://www.amazon.ca/How-Clear-Compelling-Data-Principles-ebook/dp/B07QW3FFYH/ref=sr_1_4?keywords=John+Burrett&qid=1578334384&s=digital-text&sr=1-4

More about the courses

How To Be Clear and Compelling with Data

My data visualization and presentation workshop engages you and your staff or conference participants for a full day. You will learn the principles behind focused messaging and high-quality data presentation as taught by the leaders in the field. You will then move on to hands-on application of these principles as we build, and rebuild, some of the classic data graphics and tackle some of the newer forms, like bullet charts and heat maps. We will finish by learning to incorporate the new charts in succinct and engaging digital reports.

My approach to this emphasizes the principles behind good visual data presentation, so that you can make good decisions for any kind of data, report or audience, and so that you can continue to learn more while avoiding the stuff out there that is, frankly, junk. This isn’t just about how to make a collection of charts.

My approach is shaped by my experience in a range of data-driven communications environments, including political messaging and government relations working with mayors and councillors of Canada’s largest cities. That taught me how to focus on the message and tell a story, fast. To that I’ve added principles-driven data design and presentation.

I’ve done various versions of this for conferences of the Canadian Evaluation Society (CES), learning events and special workshop engagements with the CES National Capital, Prince Edward Island and (in April0 Nova Scotia Chapters and for clients including the Atlantic Canada Opportunities Agency and the Agency for Co-operative Housing, Canada. It gets better every time as I pick up new ideas and challenges from participants.

combined viz data analysis images

A few years ago, as I was getting seriously into this data visualization stuff, I decided to go straight to the top and travelled to Boston and View, California, to take training with with Stephen Few and Duarte Design, prominent among the original leaders in effective data visualization and presentation design. What I learned sharpened my approach to data presentation immeasurably.  My course material is also based on diverse perspectives and contributions, from academics and practitioners of cognitive science and data presentation all the way to the world of sleight of hand and magic.

I have been delivering this course as a pre-conference workshop at the Canadian Evaluation Society Annual Conference and at CES learning events for the past several years. I’ve also given the full course to staff of the audit and evaluation directorates at the Atlantic Canada Opportunities Agency, and in part to the management and staff of The Agency for Cooperative Housing. The response to these courses is always very positive. Nevertheless, I learn how to improve it every time I deliver it. As a result, depending on your strong points and needs, I can put more weight on briefing and reporting strategies or on data and chart design.

The course is designed to fit into one fairly intense day, with the content falling into the areas of:

  • principles of effective data presentation
  • applications of visual data, including visual data analysis, dashboards, infographics and interactive displays
  • hands on practice at producing effective charts, tables and displays

The first part of the day is spent learning about focussing messages and discarding the chaff, then on to the principles behind effective data presentation and how to apply them. Examples of common, but poor, data graphic designs and how to transform them, usually very easily, into effective designs help to illustrate the principles.

Following this,, we move to a more hands-on approach. Participants get to build effective data visuals from scratch, in order to “burn in” some of the theory to which they’ve now been exposed. To date, I have offered this using Microsoft Excel, as this is both what most clients tend to use and is a common denominator for most, even if they use other platforms as well. If requested, I can provide the same training using Tableau. (I am now also producing javascript-based data graphics, but am not ready to teach much of it. For now I will provide some examples so that you can see the possibilities, and point you to some sources. Stay tuned on that, though, because soon I will offer the basics of coding your way to any interactive data graphic you want).



In this section, you will work with supplied datasets and follow along with me, but I provide worked examples and instructions for all of the data graphics that we build, so that you can refresh your memory, practice, and use the examples as templates for your own work.

We’ll then look at some applications of your new charts, including examples of visual analysis, dashboards/displays and interactive displays.

An important part of this will be a look at visualizing qualitative data, taking advantage of the pictorial superiority effect and principles based on characteristics of visual perception and memory. Many chart forms that are often used for quantitative data visualization are easily and effectively adapted to representing qualitative data, where there are relationships between qualitative data and concepts.

We will look at how to handle relational data, where one thing connects somehow to another, to handle both quantitative and qualitative information.

Other visual concepts are available as well, as promoted by Nancy Duarte and company, where an abstract concept, like “convergence” or “connection”, needs reinforcement.

We’ll cover approaches to infographics that emphasize informative content and storyline and avoid the common pitfalls of “data decoration”.

We will then return to another hands-on session on building more advanced devices like table lenses, small multiples and heat maps and combining them into well-designed visual data analyses, dashboards and displays.

We’ll learn about effective briefing and reporting formats and lhow to design and use a flexible and engaging digital reporting format called the “slidedoc”.
Slidedoc page example copy


We will conclude with a look at advanced and creativity-boosting options like Tableau and D3js for sophisticated chart creation and mapping capabilities and interactive content.
Advanced visuals with Tableau:


Interactivity using D3.js – try moving your cursor over the bars below:

Participants will receive a written step-by-step summary of the course content and an Excel or Tableau (see knowledge and equipment requirements) workbook containing worked examples and sample data, so that learning is easily reinforced and continued.

When we are finished, you’ll know how to use data visuals to focus your message; you can apply your new knowledge on which chart will work best for what data and circumstance, and how to use purposeful chart design and colour to maximize the effectiveness of your data and make your work compelling and, dare I say it, beautiful. You’ll also know how to situate your beautiful new charts in documents and report forms that draw the reader in and keep them. You will have new options for digital reporting that will make people glad to see what you’ve got for them, because you will inform them and you won’t waste their time with thick reports and extraneous verbiage. And because your work will just be so damned cool.



Powerful Presentation Design: How to kill with PowerPoint, but in a good way

This is a quick start course in planning, designing and executing presentation for conferences and events.

A few years ago I was getting really tired of terrible, boring presentations, both seeing them and giving them… there must be a better way…



How is it that some people are able to rivet us with their presentation skills? There had to be an answer.

So I went to see what the masters of the verbal-visual presentation form did, and boy, was it eye-opening! Duarte Design, Mountain View California.

It turned out that you don’t need to be some kind of amazing, extroverted performer. It’s actually all about knowing how to prepare, and then simply executing. Since then I have designed my presentations using what I learned, and the change was like going from night to day – my presentations carry the audience’s attention and drive home the point I am making. And I just feel so much better, more relaxed and confident, standing up there.




It’s highly worthwhile, and it is even a fun creative process:



We’ll cover the steps in developing a killer presentation:

Actively consider who your audience is and what do you want them to get out of the presentation.
Check your big idea with your audience, and clarify it to its essence
Brainstorm your ideas and cluster them into themes
Decide what to keep, what supports your message
Story board your presentation and make sure it has structure
Choose images, film clips etc to support your message
Open your presentation software and choose images
Practice, time and refine

We’ll do lots of hands on practice:
Defining messages and audiences
Structuring a presentation for effect

With a a half-day course, you’ll walk in with an idea for a presentation, or a presentation you’d like to improve, and you’ll walk out with a start to a really great presentation. With the full day version, you will learn more from each other as you build your presentations and leave with a presentation design well on the way to completion.




One day to network analysis

Business and government operates increasingly in:
• A highly information-based economy and technologically-linked society;
• Complex social and economic systems;
• Diverse market and social landscapes.

Entrepreneurs and managers with their eye to the bottom line, and government policy makers and program evaluators with an escalating imperative of policy and cost-effectiveness will need to find ways to adapt. The ability to map and understand networks of economic and social players and relationships will be more and more critical.

This one-day course is based on standard theory and instructional sources and my experience on various projects in evaluation, planning and communications.

I’ll get you up to speed on the basics and the key characteristics of networks to look for and measure.

This part of the day will focus on applications of social network analysis and basic theory: links and nodes, matrices, metrics and groups.

We’ll then take the first step into the driver’s seat. We’ll start working with NodeXL, which is one of the best social network analysis software packages and probably the most straight forward with which to learn.

We’ll first cover data – using a simple dataset as an example:
– node and attribute data
– edge data
– loading data and understanding the data editor

The next step will be analysis – we’ll generate and interpret:
– metrics
– communities
– network diagrams, including generation of node/edge characteristics based on metrics and groupings

Once you are able to drive the car, let’s take it for a spin.

I have designed the course’s group work examples around mapping Twitter messages because many communications professionals have an interest in this and other social media (you can then go on yourself to apply these techniques to other data like Facebook and email) and because it lends itself very well to illustrating the key structures and measures involved in network analysis.

If your group would strongly prefer to choose a different type of data, we can try to arrange that. It is important to understand, however, that simplicity is important for first steps, and that this class is about learning the technique.

The image below is a mapping of Twitter traffic generated by the Canadian Evaluation Society Annual Conference in June 2016. See also the address by outgoing American Evaluation Association President John Gargani at the closing plenary of the AEA Annual Conference 2016, where at the 1:30 mark through 3:25 he discusses our Twitter mapping of that conference and what it revealed:


CES Twitter 5


For our working example data, we’ll pick something happening that day and map the current Twitter traffic about it.

We’ll cover:
– uploading and analysing \data
– contents of uploaded data
– analysis and display

We’ll finish by learning how to present your new knowledge to the world:
– generating images
– exporting data

We’ll then extend that knowledge to visit and understand important applications of network analysis in program evaluation, program administration/planning to which you will have been introduced earlier. You’ll understand how to apply the same techniques and interpretation of results that you’ve just been working with to many other kinds of data and network issues.