In market research I would very frequently have to crank out a ton of different versions of reports for a given study. In the corporate world, like it or not, PowerPoint is still king. 🙁 By building a generic template I was able to drastically speed-up my report generation.
Setting up the template takes a little time at first however, in the long run, it will save you an amazing amount of time!
There is a lot more I automated however having a flexible template is always a great place to start!
A lot of interest has been generated in the AutoHotkey User Survey. We shared the report in PowerPoint and PDF as well as walked-through it in an hour-long webinar here. In the survey we asked many “qualitative”…
Standardized naming conventions are a must for consistent email metrics.
In this post I demonstrated how I used a regular expression to automate email metrics. I thought I’d create a short video demonstrating how we were able to use SharePoint to automate the creation of our campaign names. Pre-SharePoint our clients would create and enter names manually. This was a nightmare!
Standardized naming conventions
This video demonstrates how we managed to get SharePoint to ease the creation of our naming conventions.
Care to get some tips on how to look at your survey data? I’ve been an analyst for nearly 20 years now and was featured in a joint webinar with SurveyGizmo (my favorite survey tool) .
The webinar will be covered the basics of reporting of data, types of variables (Nominal/Categorical, Ordinal, Interval and Scale/Ratio) and best practices of how to report on them. I also reviewed how, by creating binary variables, you can simplify a lot of your reporting. The webinar is sightly over an hour long. I showed a few tips for using Excel pivot tables and demonstrated how to replicate graphs quickly & easily.
Making Sense of Survey Data: Laying the Foundation for Data Analysis
I’m hoping to have another one getting a bit more specific on using SPSS and cranking-out Excel / PowerPoint slides. 🙂