Report Generation- Crank out automated reports!

report generation

Report Generation

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!

Report Generation- Crank out automated reports!

 

Standardized naming convention via SharePoint

Standardized naming conventionsStandardized 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.

Standardization of email naming convention

 

 

Making sense of survey data: Laying the Foundation for Data Analysis

making sense of survey data

Making Sense of Survey Data

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

Making Sense of Your Survey Data

I’m hoping to have another one getting a bit more specific on using SPSS and cranking-out Excel / PowerPoint slides.  🙂