Looker
Introduction
Tool to access and review data
Answer data-questions in real-time
Stay up-to-date with the status
General Process
Identify the data questions you want to answer
Identify the data required to answer your questions
Analyze the data ("exploring" in Looker)
Combine dimensions and measures in Looker to find the answers
Interpret results
"Explore" in Looker and techniques
An Explore is a report-builder interface, and a portal to ask questions using your data
Language called LookML
Left side displays field picker - groups called "Views"
Dimensions are attributes or characteristics of your data. Each column is a Dimension
Measures are calculations performed across multiple rows. Aggregates are measures.
Combine dimensions and measures to answer data questions
Pivots create a matrix of your data. Let you turn a selected dimension into several columns
When you pivot on a dimension, each unique possible value of that dimension becomes its own column header
Measures are repeated under each column header
If you find your visualization interesting, you can save your work to a dashboard as a Look
A Look is a single saved report or visualization
A Dashboard is a series of saved reports, all in one page. Presents answers to multiple data questions.
Looker Studio
Looker Studio features less analytics functionality and an easy to use interface
Share and collaborate on reports
Publish reports to the web, embed reports
Drag and drop interface
Use Looker connector for Looker Studio
Connect to any Cloud-hosted Looker instance and create reports and dashboards
Use Looker connector
Enable integration in Looker instance
Create a new report in Looker Studio and select Looker connector as data source
Visualization tips for Looker Studio
What type of data?
What insights are you trying to get?
Who is the audience?
Most common visualization categories
Bar chart - compare data across categories
Line charts - data changes over time
Area chart - line chart, but area below line is filed in
Pie charts - relative proportions
Donut charts - pie chart but with a hole in the center
Scatterplot - relationship between variables
heatmaps - distribution of data
Maps - geographically located data
A Report in Looker Studio is same as a dashboard in Looker, and consists of charts
Last updated