Services for Organizations

Using our research, best practices and expertise, we help you understand how to optimize your business processes using applications, information and technology. We provide advisory, education, and assessment services to rapidly identify and prioritize areas for improvement and perform vendor selection

Consulting & Strategy Sessions

Ventana On Demand

    Services for Investment Firms

    We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

    Consulting & Strategy Sessions

    Ventana On Demand

      Services for Technology Vendors

      We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

      Analyst Relations

      Demand Generation

      Product Marketing

      Market Coverage

      Request a Briefing



        David Menninger's Analyst Perspectives

        << Back to Blog Index

        Looker Simplifies Business Intelligence in the Cloud

        Organizations face various challenges with analytics and business intelligence processes, including data curation and modeling across disparate sources and data warehouses, maintaining data quality and ensuring security and governance. Traditional processes are slow when transforming large and diverse datasets into something which is easily consumable in BI. And, it can take days or weeks to create reports and dashboards — maybe longer if processes change and new data sources are introduced. Our Analytics and Data Benchmark Research shows that the most time-consuming processes are preparing data, reviewing it for quality issues and preparing reports for presentation and distribution.

        Looker is a business intelligence software that offers the capability to explore, analyze and share business analytics. It enables workers to connect and visualize data across various databases including Google Cloud, Azure, Amazon Web Services, on-premises databases and various cloud-based applications. The platform includes embedded analytics, workflow integrations and the ability to build and deploy custom data applications. Looker is entirely web-based and offers multi-cloud and hybrid capabilities. It supports over 50 SQL dialects. The Looker Marketplace is its central location for finding, deploying and managing various types of Looker content, such as Looker Blocks, applications, visualizations and plug-ins. It includes pre-built applications for several use cases such as web, marketing and sales analytics.

        LookML is Looker’s markup language that describes dimensions, aggregates, calculations and data relationships in a SQL database. It provides predefined data types and syntax for data modeling. Data analysts can write SQL expressions once, in one place, and Looker will use the code repeatedly to generate ad hoc SQL queries. For business users, LookML offers the ability to build queries focusing on the content needed, without having to deal with complexities of the SQL structure. Looker offers more than 100 pre-built LookML modeling patterns to enable accelerated development.

        Last year, Looker introduced Looker Mobile, which offers data access on both Android and iOS devices. Workers can access dashboards and filter information from within the application. Looker requires initial setup of a semantic model for storing business logic and metrics to build a single source of business truth. This simplifies the data for end users through a curated catalog and built-in transformation capabilities. Looker can also scan data and infer relationships between tables in schema to build a basic model, using the relationships already defined within the database to speed up the process.

        Organizations are increasingly adopting self-service BI to enable workers across all departments to easily access required data, increasing opportunities to generate business value. But there are still some challenges with the democratization of data and analytics at scale. Our research lists a variety of concerns organizations have about analytics and BI. Common complaints include difficulty integrating data with business processes, data sources hard to access and systems not flexible or adaptable to change. Another big challenge is the time spent creating ad-hoc reports for decision-making, which also consumes too many resources. Using a software such as Looker can enable line-of-business workers to manipulate data, iterate and transform it in any way required, lowering the burden on IT.

        Organizations with multiple data storage environments looking to make data more accessible throughout the organization should consider Looker. It can connect to various cloud databases including Redshift, Snowflake and BigQuery. Its Explore Layer enables workers to experiment with ad hoc queries or perform one-off calculations. Looker’s platform enables organizations to provide self-service analytics to a wide range of skilled workers, saving valuable IT time otherwise spent addressing requests from stakeholders.

        Regards,

        David Menninger

        Authors:

        David Menninger
        Executive Director, Technology Research

        David Menninger leads technology software research and advisory for Ventana Research, now part of ISG. Building on over three decades of enterprise software leadership experience, he guides the team responsible for a wide range of technology-focused data and analytics topics, including AI for IT and AI-infused software.

        JOIN OUR COMMUNITY

        Our Analyst Perspective Policy

        • Ventana Research’s Analyst Perspectives are fact-based analysis and guidance on business, industry and technology vendor trends. Each Analyst Perspective presents the view of the analyst who is an established subject matter expert on new developments, business and technology trends, findings from our research, or best practice insights.

          Each is prepared and reviewed in accordance with Ventana Research’s strict standards for accuracy and objectivity and reviewed to ensure it delivers reliable and actionable insights. It is reviewed and edited by research management and is approved by the Chief Research Officer; no individual or organization outside of Ventana Research reviews any Analyst Perspective before it is published. If you have any issue with an Analyst Perspective, please email them to ChiefResearchOfficer@ventanaresearch.com

        View Policy

        Our Analysts

        Subscribe to Email Updates

        Posts by Month

        see all

        Posts by Topic

        see all


        Analyst Perspectives Archive

        See All