Anagh's Tech Docs
  • Welcome
  • Data Science
    • Coursera Machine Learning
      • Supervised Machine Learning
        • Week 1
        • Week 2
        • Week 3
      • Advanced Learning Algorithms
      • Unsupervised Learning
    • Projects
      • Predict NBA Games
    • Numpy Fundamentals
  • Databases
    • SQL
      • Aggregation and Joins
  • Scrum
    • 📑2020 Scrum Guide Summary
  • Resources
  • Technical Interview Prep
    • Data Structures
      • Linked LIsts
      • Trees, Tries and Graphs
      • Stacks and Queues
      • Heaps
      • Arrays and Lists
      • Hash Tables
    • Algorithms
      • Breadth-First Search
      • Depth-First Search
      • Binary Search
      • Merge Sort
      • Quick Sort
    • Concepts
      • Bit Manipulation
      • Memory (Stack vs. Heap)
      • Recursion
      • Dynamic Programming
      • Big O Time and Space
  • AWS
    • Cloud Computing Fundamentals
      • Cloud Practitioner Exam Blueprint
      • Foundations of Cloud Computing
      • AWS Compute
      • Resources
  • Web Development
    • React
      • Fundamentals
        • Folder Structure
        • Components
        • JSX
        • Props
        • State
  • Software Engineering
    • Introduction
  • Operating Systems
    • AT&T Archives Unix Video Summary
    • Lecture 1
    • C Programming
    • x86 Assembly
  • Derivatives and Options Market
    • Introduction
  • Linux
    • Introduction
  • Google Cloud
    • BigQuery
    • Looker
  • System Design
    • Web Architecture 101
    • System Design
Powered by GitBook
On this page
  • Introduction
  • General Process
  • "Explore" in Looker and techniques
  • Looker Studio
  1. Google Cloud

Looker

Introduction

  • Tool to access and review data

  • Answer data-questions in real-time

  • Stay up-to-date with the status

General Process

  1. Identify the data questions you want to answer

  2. Identify the data required to answer your questions

  3. Analyze the data ("exploring" in Looker)

  4. Combine dimensions and measures in Looker to find the answers

  5. 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

PreviousBigQueryNextWeb Architecture 101

Last updated 1 year ago