Data Query Setup & Export Guide [Video]

Data Query Setup and Export Guide: Transcript

Presenter: Tasneem Munjee, Research Analyst, APPA Research and Insights
Length: 6:40

Lightly cleaned for readability (filler words and false starts removed). Bracketed notes mark spots where the audio cut out or was unclear.

[00:03] Hello everyone, I’m Tasneem Munjee from APPA Research and Insights. In this video I’m going to show you how to set up a data query, run data tables, and then export those data tables into Excel. So let’s get started.

[00:20] This is the landing page of our APPA data portal. From here you can click on any of these blue cross table tool icons to start setting up your data query. As you can see on this landing page, the data is divided up into different animal modules as well as the screener and State of the Industry tables. This is just to make it easy for you to navigate when you’re running data tables.

[00:53] I’m going to show you how to run a data table, and let’s do this in the State of the Industry tables. So I’m going to click on this icon, and this will take me to the page where I can set up my data query and run the data table.

[01:13] On the left-hand side, as I’m scrolling, you can see all the questions that have been included, on which you can run your analysis. The center of the page is divided up into three what we call drop zones. In the Rows section, you can drop in the question that you want to run. Here is the Filter, where you can select what you want to filter your data by. And the Columns section is where you pick what you want to split your data by.

[01:46] I have chosen Wave Years. When you click on it, you can see the different waves and years, the time periods when we conducted the survey. You can select a specific year that you want to run the data in, or, as I’m doing, just select all. Then you click out of it.

[02:07] Now I’m going to go ahead and select a question on which I want to run the data. There are a couple of ways you can do this. You can either scroll and look for the question that you want, or, to be quicker, you can go into the search bar and put in [audio cuts out] the question number, or you can use the question text. Since I know the question number of the question I want to run, I’m going to put in the question number, which is S1, and I’m going to run pet ownership.

[02:44] Here is the question. There are a couple of ways you can add the question into the drop zone. You can hover over it, click on it, and add it as a question, or you can simply drag and drop it into the drop zone. Here we go.

[03:11] Once you have the question in there, you can just go ahead and click Generate Table. And there you go, you have your results.

[03:20] Once you have run this, you can customize how you actually want to see the data. You can do this by clicking on Calculations up at the top. Here you get a drop-down menu of all the things you can do to the table to make it more relevant to you.

[03:39] Looking at the calculations, you see Percentage, Share, and Count selected. I don’t really want to see the count, so I’m going to deselect that.

[03:50] I also want to add some significance testing to the data, so I’m going to click on Significance Testing and then Enable Significance Tests. Here, again, you can customize how you want to test your data.

[04:07] What is preselected is 5%, because we typically test significance at the 95% confidence level, but you could test it at 90 or 99, however you want to.

[04:22] Then you can pick how you want your results to show: positive only, positive and negative, or negative only. I typically want to look at positive only, so that’s what I’m going to select.

[04:35] Then you’re going to test between columns, because we typically want to look at the differences in the data between the different waves, or time periods.

[04:47] As for the base size limit, we typically don’t show significance testing on any base sizes lower than 30, so I’ve put in 30 there.

[04:59] Then you can select how you want to see the significance testing. Do you want it in the same cell, or in an extra row in a separate cell? I’m going to select values in the same row. Then I can go ahead and click Generate Table.

[05:16] You can see the count went away, and now you can see the significance testing. The letters denote significance between the data [audio unclear]. For example, the 67 is significantly higher than 2023, which has the D letter in it.

[05:37] So here you have your data table. Once you run this, you can do a couple of things. You can save it by clicking on the Save icon right here, if you want to just save it for now. Or you can click on this little icon here, which says Export to Excel. Once you do that, an Excel table will be generated, and then you have it for future use.

[06:10] If you want to go back and run some more data, you click on Rows, Columns, and Filters, which takes you back to the previous page, your data query setup page. Here you can add more questions and [audio cuts out] run whatever analysis you want.

[06:29] That’s it for now. I hope you found this video helpful. Thank you.