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

AtScale

24
81
+ 1
0
Looker

584
629
+ 1
9
Add tool

AtScale vs Looker: What are the differences?

AtScale vs. Looker: Key Differences

  1. Data Source Connectivity: AtScale provides the ability to connect to a wide variety of data sources, including Hadoop, cloud storage, and traditional databases, enabling users to work with diverse data sets. On the other hand, Looker is more focused on connecting to relational databases and cloud data warehouses, providing seamless integration with these sources but offering limited connectivity options compared to AtScale.

  2. Data Modeling Approach: AtScale uses a multi-dimensional OLAP (Online Analytical Processing) approach that empowers users to create complex data models and define hierarchies for in-depth analysis. In contrast, Looker employs a modeling layer that simplifies data exploration by creating a semantic layer on top of the raw data, allowing users to easily navigate and analyze information without the need for extensive modeling expertise.

  3. Scalability and Performance: AtScale is designed to handle large-scale data sets and complex analytical queries efficiently, making it suitable for enterprise-level applications with high performance requirements. Looker, while capable of handling sizable data volumes, may face scalability challenges when dealing with extremely large datasets or complex analytical workloads due to its architecture and design limitations.

  4. Customization and Extensibility: AtScale offers extensive customization options through the use of MDX (MultiDimensional eXpressions) and SQL for creating custom calculations and measures, giving users more flexibility in tailoring their analytics solutions. Looker, on the other hand, provides a robust platform for building custom data models and visualizations using LookML (Looker Modeling Language), allowing users to extend and enhance the functionality of the tool according to their specific requirements.

  5. User Interface and Visualization Capabilities: Looker emphasizes user-friendly interfaces and intuitive visualization tools that enable business users to explore data and generate insights without extensive technical knowledge. While AtScale also offers visualization capabilities, its focus is more on empowering data analysts and IT professionals to work with complex data structures and perform advanced analytics, which may require a deeper level of technical expertise compared to Looker's user-friendly approach.

In Summary, AtScale and Looker differ in their data source connectivity, data modeling approaches, scalability and performance capabilities, customization options, and user interface designs, catering to distinct user needs and preferences in the realm of data analytics and business intelligence.

Decisions about AtScale and Looker

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 · 303K 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
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of AtScale
Pros of Looker
    Be the first to leave a pro
    • 4
      Real time in app customer chat support
    • 4
      GitHub integration
    • 1
      Reduces the barrier of entry to utilizing data

    Sign up to add or upvote prosMake informed product decisions

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

      Sign up to add or upvote consMake informed product decisions

      What is AtScale?

      Its Virtual Data Warehouse delivers performance, security and agility to exceed the demands of modern-day operational analytics.

      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.

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

      Jobs that mention AtScale and Looker as a desired skillset
      What companies use AtScale?
      What companies use Looker?
      See which teams inside your own company are using AtScale or Looker.
      Sign up for StackShare EnterpriseLearn More

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

      What tools integrate with AtScale?
      What tools integrate with Looker?

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

      Blog Posts

      What are some alternatives to AtScale and Looker?
      Denodo
      It is the leader in data virtualization providing data access, data governance and data delivery capabilities across the broadest range of enterprise, cloud, big data, and unstructured data sources without moving the data from their original repositories.
      Apache Impala
      Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time.
      Druid
      Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
      Snowflake
      Snowflake eliminates the administration and management demands of traditional data warehouses and big data platforms. Snowflake is a true data warehouse as a service running on Amazon Web Services (AWS)—no infrastructure to manage and no knobs to turn.
      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.
      See all alternatives