Likelihood to Recommend 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.
Read full review Mode is a clear category winner for how it easy it is to go from interactive analysis to professional quality reporting. You can easily do all your SQL and quite a bit of R/Python. If you want to quickly go from your database to simple charts, this is your pick. If you need to do heavier data modeling, scheduling jobs, or ML, you'll need something else, like Databricks. In my opinion, the quality of visualizations and some developer/analyst features make Databricks an unacceptable substitute.
Read full review Pros 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 Read full review It allows me to undertake data visualization tasks by creating really insightful charts and dashboards It allows for easy sharing and work collaboration on data analysis tasks Mode has an easier to use SQL editor as well I love how it organizes all our SQL data tables into easy-to-view data we can draw insights on Read full review Cons 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. Read full review Date ranges aren't always the most intuitive to set, strangely Faster refresh rates would be ideal Would love more dynamic mobile device integration (alerts, etc) Read full review Likelihood to Renew 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
Read full review Usability Google Data Studio has a clean interface that follows a lot of UX best practices. It is fairly easy to pick up the first time you use it, and there is a lot of documentation on line to help troubleshoot, if needed
Read full review For the advanced user already familiar with Python. It is just the same tool, already managed and connected to the data.
Read full review Support Rating 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.
Read full review Mode has dedicated agents who are online in a chatroom, ready to take on any questions and provide helpful feedback.
Read full review Alternatives Considered Google Data Studio provides a great feature set considering its price point, especially when compared to commercial options from Microsoft and
Tableau . While it may not be as versatile when it comes to working with and developing complex datasets, there is enough charm in its simple, easy-to-use UI to allow not-so-complex analytics to be conducted without having to hire a data analyst.
Read full review We used both Qlik and Mode at our organization. The mode was used a quick analysis SQL tool while Qlik was our enterprise BI solution.
Read full review Return on Investment 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. Read full review Extremely positive. It's a key feature in our application. Were it not for the account management bit, Mode would be hands-down our recommendation for anyone looking for cloud BI. Read full review ScreenShots