Need advice about which tool to choose?Ask the StackShare community!

Looker

612
641
+ 1
9
Shiny

207
224
+ 1
13
Add tool

Looker vs Shiny: What are the differences?

Introduction

Here we will discuss the key differences between Looker and Shiny. Looker is a data exploration and business intelligence platform, while Shiny is a web application framework for creating interactive web applications using R. Let's explore the key differences below.

  1. Data Visualization and Exploration: Looker is primarily focused on providing powerful data visualization and exploration capabilities. It offers various visualizations, including charts, dashboards, and reports, to analyze and present data in an intuitive way. On the other hand, Shiny allows developers to build custom interactive web applications using R, enabling data scientists to create unique and specialized visualizations.

  2. User Interface Design: Looker offers a user-friendly and intuitive interface, designed to make it easy for non-technical users to explore and analyze data. It provides a drag-and-drop interface for creating and modifying visualizations. In contrast, Shiny offers a more customizable user interface, allowing developers to design and implement unique layouts and interactions tailored to specific needs.

  3. Data Source Connectivity: Looker can connect to various data sources, including databases, cloud storage, and file systems. It offers native connectors to popular data sources like Snowflake, Redshift, and BigQuery. Shiny can also connect to multiple data sources but typically relies on R packages and libraries to establish these connections. It provides flexibility with a wide range of data source options available in R ecosystem.

  4. Collaboration and Sharing: Looker provides features for collaboration and sharing of insights within an organization. Users can create and share reports, dashboards, and other visualizations with colleagues, enabling collaborative data analysis. Shiny, on the other hand, allows developers to create web applications that can be deployed and shared with others, providing a platform for sharing customized data-driven applications.

  5. Coding and Customization: Looker primarily uses a visual interface and SQL-like syntax for data modeling and analysis. It offers a query language called LookML, which abstracts the complexity of SQL and allows users to define reusable data models. Shiny, being a web application framework, allows developers to write R code to create customized data workflows and interactivity, providing extensive flexibility for data scientists.

  6. Integration with R Ecosystem: Shiny has seamless integration with the vast R ecosystem, allowing developers to leverage the extensive libraries and packages available in R for data analysis, machine learning, and statistical modeling. Looker, while offering some level of integration with R, is more focused on providing a self-contained data exploration and visualization platform.

In summary, Looker and Shiny differ in terms of their primary focus, user interface design, data source connectivity, collaboration and sharing capabilities, coding and customization options, and integration with the R ecosystem. While Looker is more focused on data exploration and visualization, Shiny allows for more customization and flexibility through code-based application development.

Decisions about Looker and Shiny

Very easy-to-use UI. Good way to make data available inside the company for analysis.

Has some built-in visualizations and can be easily integrated with other JS visualization libraries such as D3.

Can be embedded into product to provide reporting functions.

Support team are helpful.

The only complain I have is lack of API support. Hard to track changes as codes and automate report deployment.

See more
Vojtech Kopal
Head of Data at Mews Systems · | 3 upvotes · 320.8K views

Power BI is really easy to start with. If you have just several Excel sheets or CSV files, or you build your first automated pipeline, it is actually quite intuitive to build your first reports.

And as we have kept growing, all the additional features and tools were just there within the Azure platform and/or Office 365.

Since we started building Mews, we have already passed several milestones in becoming start up, later also a scale up company and now getting ready to grow even further, and during all these phases Power BI was just the right tool for us.

See more
Manage your open source components, licenses, and vulnerabilities
Learn More
Pros of Looker
Pros of Shiny
  • 4
    Real time in app customer chat support
  • 4
    GitHub integration
  • 1
    Reduces the barrier of entry to utilizing data
  • 8
    R Compatibility
  • 3
    Free
  • 2
    Highly customizable and extensible

Sign up to add or upvote prosMake informed product decisions

Cons of Looker
Cons of Shiny
  • 3
    Price
    Be the first to leave a con

    Sign up to add or upvote consMake informed product decisions

    What is Looker?

    We've built a unique data modeling language, connections to today's fastest analytical databases, and a service that you can deploy on any infrastructure, and explore on any device. Plus, we'll help you every step of the way.

    What is Shiny?

    It is an open source R package that provides an elegant and powerful web framework for building web applications using R. It helps you turn your analyses into interactive web applications without requiring HTML, CSS, or JavaScript knowledge.

    Need advice about which tool to choose?Ask the StackShare community!

    Jobs that mention Looker and Shiny as a desired skillset
    What companies use Looker?
    What companies use Shiny?
    Manage your open source components, licenses, and vulnerabilities
    Learn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Looker?
    What tools integrate with Shiny?
      No integrations found

      Sign up to get full access to all the tool integrationsMake informed product decisions

      Blog Posts

      What are some alternatives to Looker and Shiny?
      Tableau
      Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations, and share with a click.
      Superset
      Superset's main goal is to make it easy to slice, dice and visualize data. It empowers users to perform analytics at the speed of thought.
      Periscope
      Periscope is a data analysis tool that uses pre-emptive in-memory caching and statistical sampling to run data analyses really, really fast.
      Chartio
      Chartio is a cloud-based business analytics solution on a mission to enable everyone within an organization to access, explore, transform and visualize their data.
      Mode
      Created by analysts, for analysts, Mode is a SQL-based analytics tool that connects directly to your database. Mode is designed to alleviate the bottlenecks in today's analytical workflow and drive collaboration around data projects.
      See all alternatives