For most people, a spreadsheet full of numbers and letters is both daunting and confusing to look at. This unstructured data has needed processing for years by specialized staff who undertake time-consuming manual procedures to extract accessible insight for use by the wider business.
With platforms like Looker, you can automate insight generation and improve access to information. You no longer need a dedicated team of analysts to create and send reports. Instead, the Looker platform can automate, extract, transform, and load (ETL) processes and provide visualized data insights that are easily understood by all employees.
With the latest version of Looker 7.0, you have access to industry-leading tools and integrations for data analytics. There are also some experimental features coming with the release of Looker 7.2 on the 20th of February 2020.
Here are some features to keep an eye on:
Looker supports a massive range of SQL database dialects, including:
Google BigQuery Legacy/Standard SQL
Microsoft Azure PostgreSQL
Microsoft Azure SQL Server 2016
This is just a small selection of the most popular database dialects you can use natively with Looker. A database dialect refers to the specific structured query language (SQL) fork used by that database system.
Looker has two separate support levels for dialects, which are ‘supported’, and ‘integration’. Looker fully supports all of the above, and they actively work to fix implementation issues as part of their platform support offering. There are other “integration” level dialects that you can connect to Looker, but they don’t offer any support for these.
Looker has been working to broaden the scope of their hosting platform support, and now supports SOC 2 Type 1 compliance as standard when deploying through the Google Cloud Platform.
A SOC 2 Type 1 certification guarantees the security, availability, and confidentiality of your datasets on a GCP hosted environment, alleviating many cybersecurity concerns for IT departments. Looker already maintains a more comprehensive SOC 2 Type 2 audit report on AWS, which covers a period of months, rather than a single point in time for SOC 2 Type 1.
Looker is continuing to expand its support, with plans for native Microsoft Azure hosting in early 2020.
Looker Actions offers a standardized form of communication between your existing collaborative work management platform, enterprise instant messaging applications, and various cloud platforms.
Collaborative Workflow and IM Integration - With Slack and Jira, you can deliver pre-compiled reports directly into your workflows to expedite cross-business communication. These can be exported directly from Looker, negating the need for conversion and manual sending.
Cross-Platform Data Delivery – Looker uses something called “cloud storage buckets” to deliver data between your various hosting platforms. Supported cloud platforms include Azure Blob Storage, Google Cloud Storage, Amazon S3, DigitalOcean Storage, and more. This makes data available across your heterogeneous network, while simultaneously decreasing bandwidth requirements by reducing the number of cross-platform network requests.
Looker provides managed data infrastructure services through its platform on AWS and GCP but still lacks Azure as an option.
For those who want to self-manage, Looker is compatible out of the box with any cloud hosting provider. You can consolidate your analytics to a single cloud platform or use the multi-cloud to take advantage of better pricing on each platform.
Trianz is a leading business intelligence and analytics consulting firm with a comprehensive understanding of the complex world of data management. We have partnered with Looker to deliver expert assessment and implementation services for their platform.
Get in touch with our BI consulting team to learn how you can remove the barriers to analytics accessibility with Trianz.
Contact Us Today
What Is an SQL Query Engine? SQL query engine architecture was designed to allow users to query a variety of data sources within a single query. While early SQL-based query engines such as Apache Hive allowed analysts to cut through the clutter of analytical data, they found running SQL analytics on multi-petabyte data warehouses to be a time-intensive process that was difficult to visualize and hard to scale.Explore
A Winning Base for Successful Digital Transformations When it comes to developing a successful digital strategy, it is not just corporations planning to maximize the benefits of data assets and technology-focused initiatives. The Government of Western Australia recently unveiled four key priorities for digital reform in its new Digital Strategy for 2021-2025.Explore
Engage Your Workforce with a Modern Employee Intranet Solution The employee intranet has changed significantly since it was first introduced in the early 1990s. What started as HTML-based static portals have now evolved into intuitive communication tools complete with search engines, user profiles, blogs, event planners, and more. Today, many organizations are taking a second look at employee intranets to bridge gaps between teams, build company culture, centralize information, increase productivity, and improve workflow.Explore
Adopting emerging cloud technologies, consolidating resources, and improving processes is the key. “IT no longer just supports corporate operations as it traditionally has but is fully participating in business value delivery. Not only does this shift IT from a back-office role to the front of business, but it also changes the source of funding from an overhead expense that is maintained, monitored, and sometimes cut, to the thing that drives revenue,” said John-David Lovelock, research vice president at Gartner.Explore
Deliver Powerful Insights Instantaneously with Federated Queries - No Matter Where Your Data Resides The concept of federated queries isn’t new. Facebook PrestoDB popularized the idea of distributed structured query language (SQL) query engines in 2013. Over the years, AWS, Google, Microsoft, and many others in the industry have accelerated the adoption of a distributed query engine model within their products. For example, AWS developed Amazon Athena on top of the Presto code base, while Google’s BigQuery is based on Cloud SQL.Explore
What is Unstructured Data? Almost 80% of the data that enterprises and organizations collect is unstructured - data without a set record format or structure. Unstructured data includes data such as emails, web pages, PDFs, documents, customer feedback, in-app reviews, social media, video files, audio files, and images.Explore