Office Hours 2022
Live Q&A Sessions
Want to work on your report, dashboard, or infographic together?
Bring your drafts to Office Hours!
We meet for 30 minutes (almost) every week over Zoom.
Ask Me Anything
Here are some topics we've worked on recently:
- How to organize qualitative data in Excel
- The difference between radar charts and radial charts
- 4 different options for displaying pre and post data
- How to set up a spreadsheet to collect different type of program data (demographics, intake forms, attendance, outcomes, etc.)
- Designing dashboards (for internal technical audiences) vs. infographics (for external non-technical audiences) -- Different variables to include, how to vary the graph types and formatting, etc.
- Showing test score data on correct vs. incorrect responses
- Annotating charts to avoid having a huge Text Wall paragraph that nobody reads
- Font eyedroppers
- Icon arrays for small n's
- Grouping and ungrouping dates in pivot tables
- What to do if you only have one color in your logo
- Using nested if's to recode students' scores into percentiles and then groupings (e.g., a "74" is the 19% percentile, which falls into the 10-19 group)
Troubleshoot in a Small Group
We typically have 5-10 people join each week's Office Hours.
Catch the Replays
Yes, Office Hours are recorded in case you can't make it live.
Here's what's inside:
Course Curriculum
-
StartJanuary 5: What To Do When External Evaluators' Reports Need to be Redesigned?; Fine-Tuning a Static Excel Dashboard; Program Fidelity Data (40:21)
-
StartJanuary 19: Static Dashboards; Pre/Post Survey Results for Small n's; Stacked Bar Charts with Spacing (42:57)
-
StartJanuary 26: Adding Visuals to a Text-Only Page; Formatting a Static Excel Dashboard; How to Visualize Post-Training Survey Results (45:22)
-
StartFebruary 1: How Do You Figure Out a Client's Brand Font?; Visually Organizing a 70-Page Workbook into Chapters; Visualizing Open-Ended Survey Comments with Diagrams (53:01)
-
StartFebruary 8: Ellen's Pre-Post Results: Table, Clustered Bars, and/or Dot Plots? (51:06)
-
StartFebruary 15: Gerda's Overlapping Area Charts & Ellen's Pre-Post Data in Clustered Bar Charts (31:06)
-
StartFebruary 22: Josephine's 5-Point Survey Scale (29:30)
-
StartFebruary 28: Sally's Dashboard Drafts & Troubleshooting Gerda's Eyedropper Tool (26:00)
-
StartMarch 7: Elisa's Quarterly KPI Dashboard (31:47)
-
StartMarch 21: Vivian's Report Colors, Alisyn's Min/Max/Mean Dataset, Ellen's Stacked Bar Chart with Switch Row/Column (37:45)
-
StartMarch 28: Lisa's Scatterplot with 4 Quadrants; Aimee's 5-Point Survey Scale with Neutral Shown Separately (48:07)
-
StartApril 7: Kayla's Tableau-Based Dashboard for a University (22:29)
-
StartApril 14: Sally's Survey Data from 20-50 Trainings Per Year (23:52)
-
StartApril 21: PowerPoint Sections, Footers, & the Slide Master; Dataviz Design Guides & Excel Graph Templates; Feedback on a Focus Group Report (32:22)
-
StartApril 28: Starting to Analyze Aimee's Spreadsheet (Pivot Tables vs. Formulas; Cleaning/Re-Coding Variables; Raw vs. Clean) (36:20)
-
StartMay 6: Adding the "n" to Sarah's Interactive Dashboard in Excel; Shibani's Questions about Becoming a Better Presenter (20:52)
-
StartMay 13: Brooke's Dashboard on the Strategic Planning Process (29:36)
-
StartMay 20: Turning Kristin's Tables into Graphs; Weighing the Pros and Cons of Stacked Column Charts vs. Line Charts; Adding the "total" to the Top of the Columns (Without Annoying Text Boxes) (32:00)
-
StartMay 27: Pros/Cons of Excel vs. Sheets vs. R vs. Others; Ideas for Clara's PowerPoint-Based Dashboard (58:25)
What Participants Are Saying
"During the office hours, we mocked up what the graphs could look like and ultimately edited them to produce higher quality, easier to understand visuals...
Getting feedback from the group changed the style of the graphs, colors, way I utilized text, and I was even encouraged to turn the graphs into a GIF for better online engagement...
I was excited for the live office hour sessions when I would get to hear from someone else in the field and learn how they might use a graph style as well as how they did it...
Questions and discussions sparked thinking and problem solving about my data visualization in new ways, past the technical work in Excel...
The supportive community that was built goes beyond the technical skills we learned throughout the course, as I know I have a wider network to connect with for questions, feedback, and advice long after the course ended."
- Maddison Staszkiewicz, Evaluator, MaddisonStasz.com
About the Instructor
Your Instructor
Ann K. Emery is an internationally-acclaimed speaker who equips organizations to get their data out of dusty spreadsheets and into real-world conversations.
Each year, she delivers over 100 keynotes, workshops, and webinars with the aim of equipping organizations to visualize data more effectively.
She has been invited to speak in 30 states and 10 countries; 6,000 people have enrolled in her online training academy; and she has consulted to 200 organizations, including the United Nations, Centers for Disease Control, and Harvard University.
She earned a Bachelor’s degree from the University of Virginia and a Master’s degree from George Mason University.
After traveling full-time as a digital nomad, Ann now resides in Florida along with her husband and three children.