Hex.tech vs. Looker Studio

Hex.tech is an excellent tool for a product intelligence or product analytics team that wants to enable widespread use of available data for decision-making. It requires some SQL experience in many cases but makes it possible to go far without complex querying skills.

Incentivized

Does great at open canvas editing and letting you fully customize without the need for a grid. It is democratizing self-service no-code analytics. You do not need to be a data or analytics engineer to get started, and you can go very far based on how intuitive and straightforward the UI is. Some of the biggest challenges with Looker Studio relate to user management/security, embedding options, and issue support. For a long time, every user needed to have a Gmail to invite them to view a dashboard via login, not sure if that has been improved yet. You can let any user view without logging in, but that is not always recommended due to security reasons. In terms of embedding, you can only iframe dashboards. More sophisticated BI tools let you embed elements via API or Javascript. Iframing dashboards also make drill downs and dashboard to dashboard navigation tricky/near impossible. There is also no ability to contact Google for support when bugs or outages happen. They point everyone to the Data Studio community. There is some ability to get in contact with Google if you have an enterprise-level contract with Google Cloud, but the path for support is very ad hoc and not always fruitful.

Incentivized

• Powerful interactive notebook environment
• Balances the need of code and non-code users
• Provides free and easy sharing to viewers of analyses across the company
• Responds promptly to support requests and needs
• High quality native charting capabilities

Incentivized

• Self-service
• Easy to use, point and click
• Little to no training required
• Easy to share internally and externally
• Rich visualizations
• Canned reports
• Easy to copy/paste/dupe existing reports
• Ability to join data sets
• Easy integration with various data sources
• Flexible data integrations, including lowest common denominator (CSV, XLS, G-Sheets)
• Wide range of APIs
• Secure / authentication via Google SSO
• Easy to share / re-assign ownership of reports and data sources

Incentivized

• Limited support for R notebooks
• Limited sharing outside of the app (e.g., no slack integration)
• Some Python knowledge needed for highest levels of aggregations

Incentivized

• Few functionalities are very exclusive only for data studio.
• It's time taking to load data and at the same time only single Data source can be connected.
• When editing the reports you have to switch between Edit and View mode to see how does the change looks like.

It is the simplest and least expensive way for us to automate our reporting at this time. I like the ability to customize literally everything about each report, and the ability to send out reports automatically in emails. The only issue we have been having recently is a technical glitch in the automatic email report. Sadly, there is almost no support for this tool from Google, but is also free, so that is important to take into consideration

Incentivized

It is not ideal and requires time and dedication to understand how to work with it. Also, it has a lot of limitations around data it can accept. But in most cases, this tool is sufficient for everyday tasks of product and marketing departments. I wouldn't say that the interface is very user-friendly, but for people who regularly work with analytical tools, it must be ok.

Incentivized

I give it a lower support rating because it seems like our Dev team hasn't gotten the support they need to set up our database to connect. Seems like we hit a roadblock and the project got put on pause for dev. That sucks for me because it is harder to get the dev team to focus on it if they don't get the help they need to set it up.

Incentivized

Hex.tech is the easiest to use, most enjoyable experience, most powerful environment, and most cost scalable of all the above.

Incentivized

Looker Studio is far easier to implement, stand up, and learn. The interface is simpler and user-friendly for various levels of data visualization/analysis knowledge and experience. The biggest benefit of Looker Studio, however, is its ease of connection to GA data and speed. Furthermore, since it is an online program/tool, it requires less CPU/battery/storage on the user's device.

Incentivized

• Increased visibility into analyses with free membership tier across company
• Increased capacity for self-service analytics among R&D stakeholders (e.g., product managers)
• Improved productivity of data science team with ease of use

Incentivized

• Free, so the only investment is time
• Because it doesn't have native support of non-Google sources, it can cost more money than Tableau
• The time spent formatting the templates or building connectors can have a negative impact on ROI
• As a agency, charging for the reporting service is profitable after the first month or two after building the dashboard.

Incentivized