Vividata is useful because...

25 STEPS

1. We are going to create a nested table that helps us identify how many times a month males in Toronto watch European football. Find where your values may be. In this case I am going to click Television (Generic).

Step 1 image

2. Scroll through the list of values until you find the one you are looking for. You could use the search bar, but browsing can help more. The search in Vividata is a little touchy.

Step 2 image

3. Once you've found it you can select it and drag-and-drop it under Rows or select Add as question.

If you're not sure a value is going to have the information you're looking for, select View answers to see the responses.

Step 3 image

4. If there is anything in your boxes, click the X to remove them.

Step 4 image

5. With your mouse, click and drag the value over to the bottom grey box.

Step 5 image

5b. Drop

Step 5b image

6. Next we'll add our demographic values. Select Demographics.

Step 6 image

7. Identify the values you want to add. We have selected Markets. Drag and drop it over under Columns.

Step 7 image

8. We don't want all markets, just Toronto. We can isolate to it by selecting the 40 of 40 selected.

Step 8 image

9. We now have a list of all the answers participants could have responded with. You can select multiple options if you would like. So let's select those from the "Horseshoe" region of Ontario. To select multiple options you CTRL + click.

Step 9 image

10. When you click away you will now see a 5 of 40 selected.

Step 10 image

11. Let's add a value to break down our audience by age. In this case I have selected Age(Summary) but there are other ways age can de displayed such as birth year, generation, and specific age.

Step 11 image

12. Drag and drop your value over under the Columns section.

Step 12 image

12b. Drop

Step 12b image

13. We will add our final value, Demographics\Gender.

Step 13 image

14. Drag and drop the value to Columns.

Step 14 image

14b. Drop

Step 14b image

15. To narrow down to males, select 3 of 3 selected.

Step 15 image

16. There are very few options here, but we will select Male.

Step 16 image

17. Click Generate table when you've added all your values.

Step 17 image

18. You will now have a lot of data to look over but it's not finding the intersections of the values. We want to create a Nested Table. Select the Splits icon along the top second level menu.

Step 18 image

19. Click Nest variable splits

Step 19 image

20. Click Update table

Step 20 image

21. Now we have all our data nested! But perhaps this data isn't quite what we wanted. We can edit our tables by selecting Rows, Columns and Filters along the top.

Step 21 image

22. Perhaps in this case you decide you only want the ages of 18-65+ and only in the true Toronto market. We can update these answers by selecting the # of # selected.

Step 22 image

23. Update to select all the 18-24 and 65+.

Step 23 image

24. Once you've updated your values select Generate table again.

Step 24 image

25. We now have some very specific data about European soccer viewing habit of Toronto males.
You can adjust this data more or even export it to Excel from the options along the top.

Step 25 image

Here's an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1884241/Nested-Tables-in-Vividata