There are lots of tools out there that fetch Google Analytics data into Excel. With those other packages, you are left with repetitive monkey work, moving data around and fixing formulas.
Your bosses and clients aren’t even aware of that problem, you hate it, it’s not using your analytic skills, and you’re stuck doing it every [...]
I have seen tag clouds used all over the web to visualize what keywords are the most popular, and thought it would be a good additional to the Next Analytics dashboard collection. Tag clouds can easily be applied to situations where you want to see what people are looking for or talking about — anywhere [...]
A customer had a scorecard that had to be distributed for both Excel 2003 and Excel 2007.
It used Pivot Tables to lay out the data for a chart. When using Excel 2007 Save-As to create a Excel 2003 version, there’s a bug which resulted in an un-readable Pivot Table in Excel 2003! Thus, the Excel [...]
One of the new Excel dashboards we released this week downloads the friends and followers of a given Twitter user, and then compares the two lists, generating a short list of friends that don’t follow and followers that aren’t friends. I have seen a number of blog articles that go into long discussions about how [...]