Often times reporting in Excel—especially when you are creating charts—is a non-flexible task. Each time you run the report with any kind of change in data requires a change in formulas. This process greatly limits automation. Solving the problem requires a bit of initial setup, but allows for a lot more flexibility down the road.
Author Archives: Justin Goodman
In the previous post, we established a bit of what goes into a solid dashboard. Now we’ll talk about how to get there. First we start with discovery. Start with the end result that’s important to the consumer(s). Align on the Source Data of Your Dashboard Once you know what should be on the dashboard, now you
(Photo credit: “Navigator” by Thomas Abbs under the Creative Commons License) I was recently on a business trip and listening to the Digital Analytics Power Hour podcast (what a great title!) about “What is Dashboarding?” and had some thoughts. I am doing lots of “dashboarding” myself, so the timing was great. After listening to
Keeping Organized makes most processes easier (find a process that is easier when you are unorganized, it’s a challenge!). How do you establish naming conventions, when are they really important, and how does everyone stay in line with the established conventions. These challenges often result in a lack of adoption all together. How do you