Skip to main content

Deep Dive into Looker

 Looker Architecture

Looker Modeling Diagram

Looker Features:
  • Highly Scalable
  • Better Performance - as it uses Virtual Data Modelling Layer
  • Better Data Governance
  • Develop using Agile Methodology
  • Fexible
  • Self Service - Text Based YAML 
  • Zero Redundant Data Storage
  • Less Hardware procurement
  • Enterprise wide Metric Accuracy
Advantages of using Virtual Data Modelling Layer
  • Less Hardware
  • Zero Redundant Data Storage
  • High Performance Data Querying
  • Real time Analytics
  • AI and ML 
  • Flexible Data Pipelines
Looker Helps in :
  • Version Controlled ,unified analytical layer
  • Single source of truth for KPIs and Metrics
  • Content Security
  • Scalable data access to Non Tech users
  • Multi/Hybrid cloud support for data sources outside of google cloud
What Looker lack:
  • Selection of Columns and adding Join Columns to auto build queries for non technical users.
  • Need to have knowledge in  LOOKML text based creation for building dashboards
  • it Doesn't support Radio buttons and Selection on dashboard.
  • Uploading Excel files and building dashboards
What Looker Good for:
  • Simple and intuitive dashboards
  • Real time Metrics 
  • Zero Data Redundant Storage
  • UI Based - No need for installing 
  • Cache and Auto Refresh 
  • Perform Data Actions by creating pipelines
Component in Looker:
  • LookML
  • Model
  • View
  • Dashboard
  • Manifest

Comments

Popular posts from this blog

LookML

  What Is LookML? LookML is a language for describing dimensions, aggregates, calculations, and data relationships in a SQL database. Looker uses a model written in LookML to construct SQL queries against a particular database. LookML Projects A LookML Project is a collection of model, view, and dashboard files that are typically version controlled together via a Git repository. The model files contain information about which tables to use, and how they should be joined together. The view files contain information about how to calculate information about each table (or across multiple tables if the joins permit them). LookML separates structure from content, so the query structure (how tables are joined) is independent of the query content (the columns to access, derived fields, aggregate functions to compute, and filtering expressions to apply). LookML separates content of queries from structure of queries SQL Queries Generated by Looker For data analysts, LookML fosters DRY style...

A Deep Dive Into Google BigQuery Architecture

Introduction Google’s BigQuery is an enterprise-grade cloud-native data warehouse. BigQuery was first launched as a service in 2010 with general availability in November 2011. Since inception, BigQuery has evolved into a more economical and fully-managed data warehouse which can run blazing fast interactive and ad-hoc queries on datasets of petabyte-scale. In addition, BigQuery now integrates with a variety of Google Cloud Platform (GCP) services and third-party tools which makes it more useful. BigQuery is serverless, or more precisely data warehouse as a service. There are no servers to manage or database software to install. BigQuery service manages underlying software as well as infrastructure including scalability and high-availability. The pricing model is quite simple - for every 1 TB of data processed you pay $5. BigQuery exposes simple client interface which enables users to run interactive queries. Overall, you don’t need to know much about underlying BigQuery architecture or...

Data Warehouse 101 - Part 2

  Traditional Data Warehouse Concepts A  data warehouse  is any system that collates data from a wide range of sources within an organization. Data warehouses are used as centralized data repositories for analytical and reporting purposes. A traditional data warehouse is located on-site at your offices. You purchase the hardware, the server rooms and hire the staff to run it. They are also called on-premises, on-prem or (grammatically incorrect) on-premise data warehouses. Facts, Dimensions, and Measures The core building blocks of information in a data warehouse are facts, dimensions, and measures. A  fact  is the part of your data that indicates a specific occurrence or transaction. For example, if your business sells flowers, some facts you would see in your data warehouse are: Sold 30 roses in-store for $19.99 Ordered 500 new flower pots from China for $1500 Paid salary of cashier for this month $1000 Several numbers can describe each fact, and we call these...