Tag: <span>How-To Tutorials</span>

A Two-Hour Turnaround: How to Transform a Text-Heavy Report into a Visual-Lite Report

Aug 7th, 2018 / Data Visualization

Most of my early reports looked exactly like this: a few pages of 11-point font and some bullet points here and there. Except… Mine were way worse! I loved to write 100 pages of 11-point font and bullet points instead of these four summarized pages. If you’re a full-time graphic designer, then you have 40 hours a week to get fancy with covers and other visuals. If not, your time to mess around with reports is limited. I’m going to walk you through five easy steps that you can tackle in just two hours.

How to Explore Your Spreadsheets with Miniature At-a-Glance Graphs

May 1st, 2018 / Dashboards, Data Analysis, Data Visualization

I worked in several university research centers before transitioning to applied settings and learned data analysis and data visualization as two distinct phases. But nowadays I mix and mingle them a lot. My favorite exploratory visualization techniques are sparklines and data bars. I use these techniques daily, and I want to share them with you, too.

How to Categorize Values in Your Dataset with If and Vlookup in Microsoft Excel

Apr 17th, 2018 / Data Analysis

The raw dataset you’re given is rarely the one you actually want for your analyses. Clean, re-code, and re-categorize until you’ve got the groupings you need. I like to recode my data with two techniques: =IF() and =VLOOKUP().

How to Visualize Workshop Evaluation Results

Mar 20th, 2018 / Dashboards, Data Visualization, Reports

I give dozens of workshops, webinars, and conference keynotes each year. Which means I receive dozens of evaluation surveys each year. After my sessions, the clients who sponsored the workshop ask their participants to rate my session and often times a software program automatically compiles the results. I’m grateful for this automated reporting technology. But, at the same time, survey scanning tools drive me crazy.

Giving Your Tableau Visualizations a Makeover: Custom Colors

Nov 21st, 2017 / Dashboards, Data Visualization

Now you’ve got some fonts that aren’t basic in Tableau, how about some custom colors? I really like matching my visualizations to my report, which is almost always based on the color scheme of the organization I’m working with. I’ll walk you through how to get custom colors in Tableau.

Giving Your Tableau Visualizations a Makeover: Custom Fonts

Nov 7th, 2017 / Dashboards, Data Visualization

Whether you are using Tableau, Excel, or any other visualization tool, you will come across defaults. The problem with using something right out of the can is that it often does not speak directly to your audience. I’ll show how to use custom fonts in Tableau.

Blog