Dashboard Design (Full Course)
Design static one-pagers in Excel that inform, inspire, and look great.
Yes, you need a one-pager.
Leaders have more important things to do than read Dusty Shelf Reports.
No, not this one-pager.
Here's what my work looked like in 2009...
More of these dashboards, please.
Design dashboards that inform, inspire, and look great--all from the comfort of spreadsheet software you already have, like Excel.
Wait, what? There's no way you did that in Excel.
Stop searching for the perfect software program. You're already sitting on a gold mine.
But how do I share these dashboards with my audience?
The completed dashboards get shared with your audiences as PDFs.
- Your dashboards will make outstanding printouts for your staff meetings, board meetings, and conference sessions.
- You can also share your polished masterpieces as email attachments.
What about interactive dashboards?
Save your boss time. Send them a one-pager.
Don't make them remember another password to another dashboard software program. Don't make them click through a million drop-down menus and checkboxes to find the insights they're looking for.
Static dashboards deliver the right information to the right person at the right time.
What's included in this Full Course?
I'm going to transform you into the dashboard hero that your organization needs. Here's what's included to make that happen.
- Video lessons that you can watch anytime (the equivalent of our two-day Dashboard Design workshop)
- Step-by-step instructions for transforming dense spreadsheets into skimmable one-pagers
- 2 Office Hours sessions every month to talk about your drafts and hear from guest speakers
- 6 additional Live Sessions just for participants in this cohort
- Mini Course on Automating a Series of Matching Dashboards in Excel (taught during two live sessions in 2021)
- Mini Course on Designing Your First Tableau Dashboard (taught during two live sessions in 2021)
- 2 live webshows with guest speakers
- Dashboard Design ebook with our checklists and case studies
- Discussion boards to ask questions and post your own work
- Private Facebook community of fellow participants
- Weekly emails to cheer you on
- Lifetime access so you don't feel rushed
- Examples from a variety of industries (public health, foster care, libraries, satisfaction surveys, revenue/expenses budgeting, international development, juvenile justice, museums, and more)
- Behind-the-scenes Excel magic tricks guaranteed to make your jaw drop
Video Lessons to Watch Anytime
You'll get instant access to videos lessons--the equivalent of a two-day training. You can watch these lessons anytime around your own schedule.
Office Hours Twice a Month
We'll even provide feedback on your projects. You'll get instant access to recorded lessons that you can watch anytime and two live Office Hours sessions every month to get targeted feedback on your drafts.
Guest Speakers in Office Hours
Sometimes we invite guest experts to speak with us during Office Hours. You'll be able to access recordings from our sessions with Elizabeth Grim (about Connecticut's COVID-19 response), Ione Farrar (about Tennessee's COVID-19 response), Brenna Butler (about user experience), Chris Lysy (about using data for social action), and Sara Vaca (about visualization qualitative data).
6 Live Sessions
We'll hold 6 live sessions--spaced out between December 2020 and May 2021--just for participants in this cohort.
- Orientation and Self-Assessment
- Icons & Symbols
- Case Study: Comparing Spending Over Time
- Case Study: Comparing Public Health Data by County
- Visual Appendices
- Graduation Ceremony
For example, in one of these live trainings, you'll learn how to build visual appendices to accompany your technical report. Visual appendices are an advanced application of the dashboard techniques that you'll master in this course.
Mini Course on Automating a Series of Matching Dashboards in Excel
You'll learn how to create a series of matching dashboards--one per country, school, program, etc. that you're monitoring. You'll be invited to join two live sessions in 2021 about these automation techniques.
We'll build and automate two dashboards from start to finish. You'll get to keep the templates and adapt them to your own projects.
This Mini Course is normally $497participant, but it's included in the 2020 Dashboard Design registration.
Mini Course on Your First Tableau Dashboard
Dashboard Design focuses on static one-pagers since these PDFs are so useful for our busy, non-technical audiences.
By popular demand! We'll also hold two live trainings in 2021 about building your first Tableau dashboard.
In the first live session, we'll create a dashboard together from start to finish using a fictional spreadsheet about participant demographic data. This training is ideal for beginners who are making their very first Tableau dashboard.
In the second live session, Ann will share her lessons learned from judging Tableau's Iron Viz entries. This training is ideal for intermediate Tableau users who want to level up.
This Mini Course is normally $197participant, but it's included in the 2020 Dashboard Design registration.
2 Live Webshows with Guest Speakers
You'll also be invited to two special events with guest speakers in 2021.
First, we'll hear from Zach Bowders, a Tableau Public Ambassador and host of the popular Data + Love podcast.
Then, we'll hear from Steve Wexler, author of The Big Book of Dashboards.
Dashboard Design Ebook
You'll get a license to download our ebook, which contains our Dashboard Cheat Sheet and a dozen case studies from real projects.
Discussion Boards to Ask Questions
Every module includes discussion boards where you can ask questions, comment on the lessons, and share your own tips with the community.
Private Facebook Community of Fellow Participants
You'll be invited to join our private Facebook community, which is where we host Office Hours. You can also post your own questions and get feedback from me and from your colleagues.
Weekly Emails to Cheer You On
I know you’re going to skip straight to the juicy Excel magic tricks, but I’m going to email you on Mondays around 11 am EST and pretend like we’re working through the course one module at a time.
First 25 People -- SOLD OUT
Mark your calendars! This course only opens once a year for registration. The 2020 enrollment window is Monday, November 16th through Friday, November 20th. When it's open, it's open. When it's closed, it's closed.
We've also got special Early Bird Bonuses for the earliest registrants.
The first 25 people to register will receive a Swag Bag with a dataviz shirt, stickers, buttons, and magnets. This cohort's shirts will say "Information Architect."
First 10 People -- SOLD OUT
The first 10 people to register will ALSO receive a 1:1 consultation with me about your draft dashboard. We'll meet over Zoom for 30 minutes and work through your questions together. The feedback will be recorded and posted as a case study inside the course.
4,071+ participants from around the globe
have already taken the leap into better reports, slideshows, dashboards, and infographics by participating in our online courses.
"As a former teacher now working as an ecology center director, I came to the course with a bit of a different background and purpose.
While I will certainly use the tools and ideas from the course for standard non-profit management and reporting tasks, my primary goal was to expand my ability to engage teachers and kids with data. Working through the course has helped me to conceptualize the design and deliverables for a "dashboard based" curriculum project I'm working on.
Ann's creative synthesis of software skills, data analysis, and page design come together to spark my own thinking about how to do this most effectively. My experience has been that getting really good at the software you use is more useful than being adequate at a buffet menu of software options.
Ann Emery's courses help me to do just that."
- Bob Coulter, Missouri Botanical Garden
"This course was perfect in regards to my work. I knew all the Excel tricks that were used to create the dashboards, but I never knew how to utilize them properly to build amazing dashboards!"
- Participant in a recent Dashboard Design training
"I appreciated the ability to follow along with the spreadsheet on my computer and practice as Ann was showing us the steps – very engaging and hands on!
- Participant in a recent Dashboard Design training
Frequently Asked Questions
Each year, I lead dozens of in-person workshops for thousands of people. My online courses bring those skills to you, too.
Depict Data Studio also consults to the United Nations, State Department, and Centers for Disease Control, plus dozens more foundations, nonprofits, film companies, banks, hospitals, and universities worldwide.
Your data deserves to be out in the world--actionable, talked about, used--not gathering dust in spreadsheets.