Logi Symphony vs. Looker Studio

For all the scenarios I have so far worked on or I am currently working on, Dundas BI has proved to be more than adequate and apt to handle all of those. It is a very easy-to-use tool with quick shortcuts enabling you to prepare ad-hoc reports or dashboards in a matter of minutes.

Incentivized

Looker Studio is well-suited for those wanting to analyze web/site data and performance quickly. It is simple enough to learn/use for quick report-building or drilling into data. Looker Studio is easier to use/understand than the GA4 console and thus has a better UI/UX. It is an efficient tool for fast, simple data needs—especially for team members with limited analytical capabilities and knowledge.

Incentivized

• Project organization from Development to Production, you get a production and development license but I think the best way to do it is with DEV and Prod project in the Production box. Use the development box for testing updates and really crazy things. With the Dev and Prod projects on the same box, you just publish from Dev to Prod and you are done. Users only have access to the Prod projects so no one can mess up what you are working on.
• Security - If you have a hierarchy (subsidiaries, divisions, department, teams) and you want each group to see only their data, then Security hierarchies are for you!
• Dependent filters! What's this you ask? Here is an example of how it can be used, in your company you have departments and who works for what department is in your database. You make a dashboard that has a department filter (only show these departments), a managers filter, and employee filter. Not every manager or employee is in multiple departments usually only one. With dependent filters you can say that the manager and employee filter are dependent on what is selected in the departments filter so when you go to filter them they only show the managers or employees that are part of that department, and you can even it do so employees are not only dependent on department but on manager as well. Then it gets even better as it can be done in reverse as well so when you select a manager then go to the department it only shows the departments he works for (there are better situations where this is more useful).
• It is scriptable! From calculate columns, null replacements, button actions, load actions, hover over events there a way to do what you want.
• They are constantly improving and listens to your suggestions.

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

• Not too many cons for how we use the application. It really is easy and powerful. Very powerful.
• Licensing is one thing that could be looked into. It is simple, but a little confusing. For example, if I get a license today, but a new release comes out tomorrow, it seems that the license doesn't work with the new release. Maybe that is by design, but it would be nice to clearly understand.

• 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

We are still in the implementation phase, but so far we are finding it to be easy to use and learn. The eLearning courses that they have made available for free, as well as User Forums and other training videos have made even difficult concepts easier to understand.

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

We have bi-weekly calls with our Success Manager, as well as access to support as needed. Any question that I have had, multiple people have been willing and able to jump on a call to talk me through it, or send an email with the solution

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

Providing that you have the client's needs well known, creating BI content using Dundas BI is a walk in the park!

Per dollar spent, it offers the widest range of features of the tools that we evaluated. It offers lots of options for how to configure your environment, though they are not always intuitive to figure out. Having an ETL layer was a must have for us, as well as the ability to host to secure HIPAA compliance. It is not a replacement for ad hoc reporting, but does a great job of creating parameterized reports and dashboards that look great.

Incentivized

The free version of Looker Studio is still better than the leading enterprise-embedded BI tools, despite its weaknesses. The leading embedded BI platforms have terrible visualizations that can be spotted a mile away. They are also primarily locked to a grid, making it very hard to fully customize. The price point is also a major deterrent, since users end up paying for lots of features they might never use. Looker Studio has weaknesses on the blending and modeling side, but we've been able to get by via connection to GBQ and transformation done in dbt.

Incentivized

• Coming from an SQL based standard delivery model, Dundas BI has provided a fantastic rate of ROI.
• The preparation and delivery time has reduced from weeks to just a few hours.

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