Who doesn’t love a dynamic, animated Excel dashboard? Here’s one I’ve been working on recently, a data visualization of historical U.S. political data, showing party trends, state populations and sitting presidents over time: In the following post, I delve into the details of how I created this dashboard. It’s not a full cell-by-cell account of … Continue reading Excel tutorial: Building a dynamic, animated dashboard for U.S. political data
Learn the techniques to build powerful, free business dashboards directly in Google Sheets. Gather data through forms, transform data with formulas and create insightful visualizations you can share with friends and colleagues.
Please Note: I’m not taking on new clients at the moment. I’m focussing on creating new online courses. However, I’m happy to introduce you to an associate of mine who runs a Google Workspace consulting firm. Please complete this form as the first step. Data Analysis, Visualizations, Dashboard and Application Development using Google Sheets, Apps … Continue reading Collins Analytics LLC Consulting
This time last year I worked with The Write Life during their three-day sale of The Writer’s Bundle, a collection of digital products for writers. I built a dynamic dashboard using Google spreadsheets so the team could visually monitor progress throughout the sale. This year The Writer’s Bundle 2015 was bigger and better than ever, … Continue reading Building a dynamic dashboard for a 3-day digital flash sale
Continuing my recent infatuation with dashboards in Google spreadsheets, I’ve been playing around with the Google Analytics Add-on to build a custom web analytics dashboard in a Google spreadsheet. The idea originated from discussions with my wife about the tedium of preparing month-end website performance reports for her content management clients. This dashboard was a … Continue reading Creating a custom Google Analytics report in a Google spreadsheet