We here collate the official self-service training videos series for Q. For information on other training opportunities and help resources, please see our Learning More About Q page.
How to use this page
The content for Q's self-service training course is split into 3 sequences representing 3 case studies:
- Cola – critical content that is the bare minimum knowledge to operate Q.
- Supermarket – a recommended minimum for a person to get a handle on Q.
-
Burger – recommended so users get a more comprehensive foundation in using Q.
We recommend that you work through all 3 case studies in order.
The following is a guide to the control bar for all embedded videos on this page:
Volume control. Settings – we recommend at least 720p, ideally 1080p streaming. Full-screen - click this to enlarge your video to the size of your screen. Use "Esc" to escape the full-screen mode. Case Study 1 - Cola
Datafiles used in case study:
- File:Cola Tracking - January to September 2017.sav
- File:Cola Tracking - January to December 2017.sav
Title Video Content Length Links & further resources Starting a project Explains the concept of the Q project, its relationship to the data, and how you can save your analysis as .Q project or .QPack. It also shows how to import data from a file. 1:27 Making simple tables Shows how to create a table, change the statistics shown, manipulate the rows and columns (merging, netting and renaming) as well as other context-menu features. 5:37 Making and applying simple filters Shows to create (and apply) simple filters from tables and other automatic ways. 6:01 Making Top 2 Box questions Shows how to make a 'Top 2 Box' (and similar questions) in Q. In doing so, demonstrates the crucial process in Q of 'Restructuring' data. 6:02 Charting and Visualizing within Q Shows how to turn tables into charts and visualizations within Q. Explains the difference between 'Charts' and 'Visualizations'. 8:02 Exporting directly to PowerPoint Shows to directly export data from Q to PowerPoint to make Excel Charts (within PowerPoint). Included is how to use Chart Template Files and how to automatically update your PowerPoint document 5:16 Updating a project Explains how to update a project when you receive new or revised data. 3:39 Case Study 2 - Supermarket
Datafile used in case study:
Title Video Content Length Links & further resources Checking value attributes Walks you through the essential checks one should do with a new project, including the setting of values including missing values. 9:23 Calculating NPS scores Shows how to set up NPS recoding in Q, both manually and automatically. 2:42 Splitting variables from a question Shows how to separate variables from questions, and in doing so form new questions 4:23 Creating lots of tables Shows how make multiple crosstabs all at once, and how to manipulate multiple tables in the Report at once. 5:02 Creating simple banners Shows how create and modify simple banners using the Drag-and-drop method. 7:38 Creating custom filters Shows how to use the Binary - Complicated Filter menu option. 7:24 Understanding Q's statistical testing Explains the default significance indicators on Q's tables, how you can change them, and the use of the Alpha button. 7:19 Shortcuts to the story Shows two ways Q can help you find the story in your data more easily: deleting tables not significant (at a certain level) and Smart Tables. 3:52 Advanced analysis in Q Gives a general overview of how advanced analysis is conducted in Q (using R). For detail on specific analysis, see our blog, webinar and eBook archives under the Resources tab of Q's main homepage 4:50 Case Study 3 - Burger
Datafilse used in case study:
Title Video Content Length Links & further resources Create tables for data checking Creating a set of tables to prioritise your data checking and cleaning before you begin the analysis of your project 13:18 Creating and applying weights Shows how to create and apply weights in Q, including recomputing for each time period and the use of rim weighting 7:48 Writing custom variables (JavaScript) An introduction to how to write your own variables using basic JavaScript 8:34 Using Date questions Exploring the benefits of Date questions within Q 3:51 Exporting to Excel A simple explanation of the Excel export feature 3:15
Next