Why MRDCL for crosstabs / tabulations?
MRDCL is one of a small number of software produc…Read more
We are frequently asked by potential clients whether QPSMR Insight or MRDCL is the most suitable product for their needs. It can be confusing as both software programs have similar functionality, but the key difference is that they are aimed at different types of users. The right product will be dependent on the work that needs to be handled and the staff that will be using the software. There is another blog article called Ways to organise market research data analysis and data processing, which might offer additional insight.
Both programs use almost the same engine, which means that a run of tables will take the same amount of time to process in most cases using QPSMR and MRDCL. This engine has proven to outperform its competitors for many years, particularly for bigger runs where there are thousands of tables or big data files. So, whether you use QPSMR or MRDCL, you will get a high performance in terms of runs times.
There is a clear difference here. Instructions in QPSMR are entered using the user interface within the software whereas MRDCL instructions are entered as commands using an editor – and, sometimes Excel spreadsheets – which MRDCL then reads and processes. These commands are commonly called ‘scripts’. MRDCL scripts can have what are called compilation errors where commands or instructions are not logical or have been incorrectly entered. These will need to be corrected before a run will complete.
QPSMR produces tables by taking the instructions entered in the user interface and converting them to MRDCL script. It then runs that script automatically. In other words, it is creating the script for you. QPSMR has the advantage of producing error free script as the user interface will protect users from making logical errors. However, QPSMR only has access to a fairly small percentage of the tools available in the full MRDCL language. It means that there will be little choice in how you can handle complex or repetitive tasks. Indeed, there will be a number of tasks that QPSMR cannot handle that MRDCL can handle.
QPSMR gives you some access to the scripting language that sits behind it. It is only available in a limited way and is not practical to use where you would want to enter large amounts of script to enter. One practical use of QPSMR with scripting language is the use of ‘snippets’ of MRDCL code. These snippets are tried and tested MRDCL scripts that perform a particular function. They are used within QPSMR to perform a function that QPSMR can either not handle or would be laborious to specify through the user interface. They are usually comprised of a list of parameters and the insertion of a script file. A blog article on using snippets in QPSMR will be released in March.
The next section compares QPSMR and MRDCL for the main tasks that they are designed for use.
MRDCL does have some tools for data collection but it is unlikely that you would want to use them – complex data entry can be scripted but MRDCL would not usually be the right tool. QPSMR, on the other hand, has all the tools you need for most paper or telephone (CATI) questionnaires. QPSMR retains these texts so that they are available for tabulations. If you choose to use some other software for data collection, both QPSMR and MRDCL have tools to read in Triple-S or SPSS data files as well ASCII data.
QPSMR and MRDCL work quite differently when it comes to data cleaning. QPSMR allows you to build in checks so that illogical entries are flagged during data entry. Additionally, a report can be produced showing logic errors in the data. Changing data can be carried out by physically changing the data or by updating data from a CSV file.
MRDCL offers more power in terms of what errors can be flagged. Repetitive or complex checks which may be laborious or impossible in QPSMR will be able to be handled in MRDCL. When it comes to changing data, the recommended methodology is to log changes in an Excel workbook so that an audit trail of changes can be retained. This means that data is not physically changed, it is amended before it is processed. If necessary, the data can be output as clean data, but this audit trail makes it easy to follow any changes that have been made to data and to correct it if something has been amended wrongly.
QPSMR can handle ASCII data and a number of forms of binary data. The maximum record size for an ASCII data file is 200000 characters. QPSMR cannot handle hierarchical data. MRDCL has no limit for the record size that can be processed, it can handle hierarchical data as well as data from more than one file.
For straightforward cross tabulations, QPSMR and MRDCL have more or less the same options to provide you with the statistics, percentage options and other comprehensive controls that allow you to output tables as you choose. QPSMR will generally be quicker to use to produce the most basic analysis – for example, every question by a standard banner. However, basic straightforward tables can still be time consuming to prepare when they are different types of analysis required for different questions – for example, summaries of mean scores, additional banners, additional filtered tables etc. The more intricate that the table requirements become, the more likely it is that MRDCL will be a more efficient tool to produce the tables.
As tables become more complex, the more likely it is that MRDCL will prove the be more efficient. There are tables that QPSMR cannot handle, there are tables where the specifications are quite laborious to input using QPSMR and tables where the automation tools within MRDCL would mean that systems or efficient MRDCL script can make the task very easy. So, let’s look at some examples of where QPSMR will be outperformed by MRDCL.
There are numerous examples where a scripting language offers power to make time consuming tasks relatively quick or possible.
MRDCL has a lot of tools for handling repetitive variables and tables. Adding something simple like a top two box and a bottom two box to a series of rating statements and getting a net satisfaction percentage for 100 variables is quick to script in MRDCL. In QPSMR, this can be a slow process.
Tasks which are repetitive from project to project or within the same project can be handled far more easily within MRDCL.
If you need several set of tables with modifications for each run, there are some powerful automation techniques within MRDCL that will mean that the sets of reports can run automatically. In QPSMR, this will be a more manual task.
MRDCL and QPSMR have the same tools available for exporting data to other formats. Both have good but different solutions for importing projects from Triple-S and SPSS.
Learning QPSMR is significantly easier than MRDCL. You can learn the basics of QPSMR in one day and can become competent after handling two or three projects. MRDCL is a much steeper learning curve, but it can be learnt in stages so that you begin by learning the basic tools and progress to more advanced techniques.
With QPSMR, there is little choice in the way each task can be approached, so users tend not to improve much in terms of productivity once they have handled two or three projects. With MRDCL, you can always learn better ways of doing things. Typically, a new MRDCL user will find the first project quite difficult but will gradually become more productive over the course of 2-3 months. Moving to the real power features that can dramatically increase productivity can follow soon afterwards. Users of MRDCL will need to have the right skill set to make the most of MRDCL and be regular users in their job role; QPSMR users can be far less skilled and be irregular users.
One feature of QPSMR is that it automatically generates MRDCL script when running tables. This can be a good way to learn and a way of migrating to the more powerful software. The MRDCL script that QPSMR produces is not the most efficient script, but still shows you how to get started using MRDCL. Later this year, MRDC Software will be releasing a new tool that will produce much better MRDCL script, which, in turn, will make it easier to manipulate and develop to do more complex tasks efficiently.
However, we would always recommend that if QPSMR does what you want fairly efficiently, there is no benefit in moving to MRDCL.
The blog article Ways to organise market research data analysis and data processing has already discussed how you can become highly efficient in many cases by using both MRDCL and QPSMR. This methodology is being adopted by many of our customers. It means that simple projects can be handled by less skilled staff while more complex projects can be handled by more skilled staff with junior staff handling some of the more basic tasks like entering basic definitions and texts. We are always happy to discuss this if you think this might benefit you.
Both QPSMR and MRDCL offer a lot of advantages. Both products offer different things and when used together can offer the greatest productivity gains. If you feel you need more information, please write to us. You can use our You Ask, We Answer form on our website.