erwin Data Modeler vs. Looker Studio

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
erwin Data Modeler
Score 9.0 out of 10
N/A
erwin Data Modeler by Quest is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It can discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives, accomplishing this whil esupporting data governance and intelligence efforts.N/A
Looker Studio
Score 8.1 out of 10
N/A
Looker Studio is a data visualization platform that transforms data into meaningful presentations and dashboards with customized reporting tools.N/A
Pricing
erwin Data ModelerLooker Studio
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
erwin Data ModelerLooker Studio
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeOptionalNo setup fee
Additional Details
More Pricing Information
Community Pulse
erwin Data ModelerLooker Studio
Top Pros
Top Cons
Features
erwin Data ModelerLooker Studio
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
erwin Data Modeler
-
Ratings
Looker Studio
7.4
51 Ratings
13% below category average
Pixel Perfect reports00 Ratings8.235 Ratings
Customizable dashboards00 Ratings9.450 Ratings
Report Formatting Templates00 Ratings4.649 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
erwin Data Modeler
-
Ratings
Looker Studio
6.2
50 Ratings
26% below category average
Drill-down analysis00 Ratings7.442 Ratings
Formatting capabilities00 Ratings8.546 Ratings
Integration with R or other statistical packages00 Ratings2.623 Ratings
Report sharing and collaboration00 Ratings6.150 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
erwin Data Modeler
-
Ratings
Looker Studio
7.4
50 Ratings
12% below category average
Publish to Web00 Ratings9.444 Ratings
Publish to PDF00 Ratings6.743 Ratings
Report Versioning00 Ratings8.131 Ratings
Report Delivery Scheduling00 Ratings4.234 Ratings
Delivery to Remote Servers00 Ratings8.818 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
erwin Data Modeler
-
Ratings
Looker Studio
9.0
49 Ratings
10% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings9.549 Ratings
Location Analytics / Geographic Visualization00 Ratings9.646 Ratings
Predictive Analytics00 Ratings8.024 Ratings
Best Alternatives
erwin Data ModelerLooker Studio
Small Businesses
Egnyte
Egnyte
Score 7.7 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
Mathematica
Mathematica
Score 8.2 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
erwin Data ModelerLooker Studio
Likelihood to Recommend
6.1
(7 ratings)
8.9
(51 ratings)
Likelihood to Renew
-
(0 ratings)
9.0
(1 ratings)
Usability
9.0
(2 ratings)
9.0
(3 ratings)
Support Rating
9.0
(3 ratings)
6.7
(10 ratings)
User Testimonials
erwin Data ModelerLooker Studio
Likelihood to Recommend
Quest Software
I have had a chance to use few other data modeling tools from Quest and Oracle, but I am most comfortable using erwin Data Modeler. They understand your data modeling needs and have designed the software to give you a feeling of completeness when you are designing a data model.
Read full review
Google
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
Pros
Quest Software
  • Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database.
  • Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made.
  • Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.
Read full review
Google
  • 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
Cons
Quest Software
  • Cost is the single largest barrier to entry with this tool.
  • Would like to see a greater variety of export options available for use outside of the tool, for example as a vector graphic.
  • Support has been uneven at times.
Read full review
Google
  • 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
Likelihood to Renew
Quest Software
No answers on this topic
Google
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
Quest Software
I had a lot of experience using erwin Data Modeler for designing data models. I think it's pretty intuitive and easy to use. It has enough features to represent your database requirements in form of a model.
Read full review
Google
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
Support Rating
Quest Software
CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.
Read full review
Google
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
Alternatives Considered
Quest Software
Not listed, but I've only used alternatives built into something like the Squirrel SQL editor. That one is semi-functional but lacking many features and, in some instances, just plain wrong. The only pro there is that it's freely available and works over ODBC. I've tried some of the other free ones like Creately but didn't have much success.
Read full review
Google
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
Return on Investment
Quest Software
  • It is difficult to assign a monetary value to it. The initial learning curve was fairly long.
  • It allows us to have better support documentation.
  • It allows ease of communications between functional units.
Read full review
Google
  • 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
ScreenShots

erwin Data Modeler Screenshots

Screenshot of Screenshot of Screenshot of