Sydney based Q Research Software has expanded operations to New York. Opening later this month, the New York office will be led by former Illuminas Research Executive, Steven Kawalek.

New York based Kawalek says: “I am excited to see how researchers here respond to Q – I feel like I am about to expose one of the best kept secrets in the US market research industry”

The new offices will serve as a sales and technical support hub for the region. Q usage has recently grown exponentially in the UK with steady sales in the US. It is the leading market research analysis software in Australia and New Zealand.

Marketing Director Matilda Sarah says: “We were very lucky to find Steve. He is a skilled researcher, a seasoned Q user and he has a great understanding of the US market.”

Q research software is developed by Numbers International, based in Sydney Australia. Q was launched in 2007.

Matilda Sarah will be in New York from 29th April to meet with current and prospective Q users. For more information visit our website  www.q-researchsoftware.com or contact us at matilda.sarah@q-researchsoftware.com or steven.kawalek@q-researchsoftware.com

The New York office address is: 116 West 23rd St, 5th Floor, New York, NY 10011.

Beta users can now export nicely formatted tables directly to PowerPoint. Click the Export to PowerPoint icon, select 'To PowerPoint as PowerPoint Table' in the Format dropdown. This feature is currently only available for Beta users. If you would like to become a beta user please email support@q-researchsoftware.com and request a beta license.

Q4.2 allows you to share your project as a dashboard.  The key benefits to your clients are the ability to:

• view the report on a web browser, iPad (and other tablets) or iPhone (and other smartphones),
• filter the report using your pre-made filter variables and see the tables and plots update live, and
• further Explore the report data by creating ad-hoc crosstabs and filters.

The hosting of dashboards is charged separately to Q Professional licenses.  Pricing and further details are listed at q-demo.com.  To set up a hosting account and for other enquiries, send us an e-mail.

Here are two examples of dashboards, as you would present them to clients:

• Cola Study Dashboard
• Bank Tracking Dashboard

 

An example of an uploaded dashboard:

 

If you are tired of updating the same PowerPoint charts in your tracking study in every report, you'll like this new feature in Q! In Q4.2, you can update the data in exported charts in PowerPoint while retaining all of the changes you have made to the chart. This still works when you move multiple charts onto the same PowerPoint slide!

This is how it works in action:

     1. For a tracking study, I have exported two charts into PowerPoint.

     2. I have cut and pasted the two charts into a single slide and changed the colours of the columns. Note that my data is currently up to February 2011.

     3. When I import a new data file that contains an additional month of data into the project, the tables in Q will be automatically updated with March 2011 data. If I export the same tables again into PowerPoint, Q will ask me whether I want to update the existing charts or create new charts.

 

     4. By choosing to update the existing charts, you can see that the charts are updated with March 2011 data whilst all of the formatting that I have done before has stayed the same.

Other benefits:

• This feature also works in Excel tables and charts
• It automatically updates the data in Q plots (e.g., time series plots) that are exported to PowerPoint
• It automatically updates the data when you apply a filter or a weight
• It automatically updates base sizes in PowerPoint charts

Limitations:

• This feature does not work in Microsoft Word
• Microsoft Graph exports cannot be updated (only as an Excel Chart)
• Table split across multiple slides cannot be updated

In Q4.2, PowerPoint charts exported to Office include a chart title by default. You can turn it off using chart templates.

 

Coded questions now show spans and sub-NETs for parent codes in the code frame in Q4.2.

In Q4.2, you may now sort by statistics on multiple tables.  To do this, the tables first need to have a common statistic selected in Statistics – Right or Statistics – Below.  You then select the tables in the Report tree, and right-click on the common statistic header as it appears in the blank table (see Average in screenshot).

Sorting by the Average statistic of multiple tables

Q4.2 allows you to have projects that incorporate multiple data files at once.  This is done by selecting File and Add Data File to Project.

You can do simple things, such as overlay tracking data with advertising spend (where each is saved in a different data file).  For example:

 

And, you can do more complex things, such as create crosstabs between the different data files (e.g., crosstabbing data from a survey with data from a customer databases).  This is done by specifying variables to be used when matching the data (File and Edit Data File Relationships).

In addition to our automatic exporting and updating of Microsoft Office charts, you can now create and view charts in Q.  You can quickly create all the “standard” market research charts that cannot easily be created in Word, PowerPoint and Excel, including:

• Stacked charts where the bars go above and beneath the axis and where neutral points are placed in a separate table.
• Marimekko/mosaic charts.
• Charts containing separate bar charts for different sub-groups.
• Scatterplots with labels.
• And, there are some special new chart types developed just for tracking research.

Check out examples at Plotting in Q.

In Q4.2 you can customize the names of statistics for selected tables (Edit | Table/Plot Options | Output Text) or for the entire project (Edit | Project Options | Output Text). For example, change:

• Average to NPS.

• Column n to Base.

• Average to 均值 (if you are Chinese).