Getting started with Looker [Data of Thrones]

(Maire Newton) #1

We’ve put together a quick start guide for your first time exploring data with Looker.

Using an Explore in Looker allows you to ask questions and then find the answers using data. You will always start by asking a question. Maybe you are interested in knowing which Game of Throne characters have gotten the most screen time. Maybe you then want to find the season in which your favorite character was featured the most heavily.

Once you have your question, you will need to break it down to identify the data that you need. To answer the question “Which Game of Thrones characters have gotten the most screen time during the series?”, you will need to figure out the total screen time for each character.

To find this out, you would start by clicking on Name, a dimension. Dimensions are attributes, or categories that you might use to group your data. If you click on Name and hit Run, you will see a unique list of all Game of Thrones characters.

To find out how much screen time each character has had, you would need to add a measure into your data set. Measures are aggregate values, like sum totals or counts of things. These will appear in orange in Looker. Clicking on the measure Screentime (Minutes) and hitting Run will show us the number of minutes of screen time each character has had during the series.

The downward arrow that you see in the column header of the Screentime (Minutes) measure means that the data is sorted, or ordered, by screentime. It’s in descending order, meaning that the characters with the most screentime are listed first.

If you want to limit your results to only show, say, the top10 characters, you could use a Row Limit. This will simply limit the number of results that you see on the page.

Congratulations! You now have all of the data that you need to answer your question. It’s time to interpret the results. It is clear to see from the data that Tyrion Lannister and Jon Snow have dominated the screen. Visualizing these results can make it very easy to share your findings with others.

To visualize the data set, use the visualization pane to select a chart. You can then make additional adjustments to the visualization by using the edit menu in the upper right corner of the visualization pane.

Now you might want to dig in a bit deeper to find out which season your favorite character was on screen the most. This means that you will need to look just at your favorite character and analyze screentime by season.

To focus on only your favorite character, perhaps Daenerys Targaryen, you need to apply a filter. A filter provides you with a way of limiting the data set to only the values that you care about. Since the only name you want in this case is Daenerys, you would click on Filter next to the name field to add a filter into the Filter pane of the Explore. You can then type in Daenerys Targaryen so that the filter reads “Name is equal to Daenerys Targaryen”, and hit Run.

You want to know which season Daenerys was featured most heavily, so you will need to replace the Name dimension with the Season dimension. This will cause the Screentime to be grouped by Season instead of by Name.

You now have the data set, so it’s time to interpret the results. Looking at data across seasons is like looking at data over time, so a line chart can be a great way to visualize this so that you can identify any trends.

It’s easy to see from the chart that Daenerys was most prominent in Season 7, and that she had a massive increase in screentime from Season 6 to Season 7. So if you want to do some rewatching before getting too deep into the final season, you should check out Season 7 to maximize your Mother of Dragons sightings!

Now you just need to keep asking, and keep digging! Who knows what you’ll uncover.

More Resources

Check out our Getting Started Guide for more tips and videos on how to start exploring and building Looks!

Have a question? Our Community is a great place to start! Explore the Community and ask your questions about Looker.

Want to create custom fields and calculations? Learn more about custom dimensions, custom measures, and table calculations.

3 Likes