Likelihood to Recommend IDERA (an Idera, Inc. company)
Data Architect is well suited at organizations of all sizes. It is never too early or unnecessary to enforce proper modelling and design standards on data solutions, and this tool will help that greatly by providing an industry leading data modelling tool, ability to import ETL mappings for data lineage, enforcing and managing naming conventions through the naming convention tool, and publishing of data dictionaries through the report publisher. I was successfully able to build models, provide traceability, and document source to target with lineage throughout for both the business (by providing business definitions in the descriptions), and technical teams (by documenting ETL instructions in text fields) along with field level mapping (by creating "Attachments" representing data sources, tables, and fields) providing easy search capabilities using business friendly terms
Read full review In operations we use the tool for many different topics, from factory quality systems to high level reviews. We have created kind of an internal "App Store" based on Power BI where you have a lot of different dashboards for different solutions (cost, cash, health and safety, sales, factories, distribution centers...) and you as an user just need to get in that "App Store" and enter in whatever tool can be useful for you. It is open to all the operations employees and can use on demand. Also it has raised the imagination of our colleagues, as they are not only working by themselves creating new reports, but also raising fantastic ideas that can be extended for the usage of all the community.
Read full review Pros IDERA (an Idera, Inc. company)
ER/Studio has the ability to provide consistent field names and data types through domains, which are templates. This provides a way to have consistent naming of common fields, like CreatedBy and the data types for the fields. They also have the ability to change all the fields that use that domain to a different data type. ER/Studio provides the ability to create custom macros. These macros can be used to apply everything from standard fields based on domains to naming all constraints and indexes. I've also used a macro that comes with ER/Studio to spell check field and table names. My favorite feature is the ability to compare your data model to databases for deployments of changes, and to other data models. Read full review Quickly filter and view granular data sets with easily configurable reporting figures. The ability to quickly switch between tabs allows for historical data comparisons and progress tracking. It's helpful to dive into the data and break it down from high levels to small. Achieve actionable insights faster by using real-time data. It's incredible to have online access to reports. Read full review Cons IDERA (an Idera, Inc. company)
ER\Studio licensing can be cumbersome and upgrading from one version to another usually takes several phone calls and emails to the licensing group to get the update installed and running. The repository can be slow when the model count gets larger. By large I mean 20 to 30 models. A nice feature that I would like to see is table comments be displayed on the model along with the attributes. Currently you have to choose between the two. Read full review The desktop app is great but needs a lot of performance improvements No MacOS Version for the Desktop app, this is a big limitation for business since executives prefer Macs Premium Cloud Version of Power BI is awfully expensive On-Premise Version of the Power BI Reports Server is bundled only with SQL Server Enterprise License and cannot be purchased separately and requires Software Assurance Subscription On-Premise Power BI Report Server doesn't support ADFS, AzureAD or any Claims-Based authentication platform, a sad disadvantage for enterprises Read full review Likelihood to Renew IDERA (an Idera, Inc. company)
I find it helpful and easy to use
Read full review Usability IDERA (an Idera, Inc. company)
At this point, I think we all know who has taken the lead in the business intelligence and analytics market worldwide. With fresh new updates every other day on top of an already robustly built product with all features that one can dream of is a no brainer, I feel. Microsoft will invariably be synonymous with quality and professionalism.
Read full review Support Rating IDERA (an Idera, Inc. company)
I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.
Read full review I can't really speak to the support overall, [but] I will say that in the almost three years I have used the system, I have only needed to contact their support team once. I think the team was helpful, but it did take some time for us to resolve the issues/ request that they had. I guess the good news is that the system is pretty stable, and I personally have rarely needed to contact their technical support team.
Greg Watkins Senior Customer Success Manager (Strategic Accounts)
Read full review Alternatives Considered IDERA (an Idera, Inc. company)
ER/Studio is the most mature, reach in features and quality and therefore useful. Unfortunately, it lacks compatibility with AWS Redshift.
Read full review [Microsoft] Power BI is practical and effective, like a hammer for a nail, it is easy to use and produces very quickly the results that in most cases are urgently required by clients (nice reports to share on the web). To start using [Microsoft] Power BI you need a business email address, with that you create an account in Power BI Service and in less than 1 hour you will have installed Power BI Desktop, a report will have been created and it will have been published on the web .
Dustin Ghia Lead Consultant - Solutions Architect - Software Engineer
Read full review Return on Investment IDERA (an Idera, Inc. company)
ER/Studio has had a positive impact on my project as we can develop the data model and have a clear understanding of business needs before we continue with the development phase. Read full review It helps us track and achieve company goals. It shows us [our] performance in areas we could not previously track and allows us to see and work on how to improve their performance. Quick easy access for executives to use in helping teams and addressing issues. Read full review ScreenShots ER/Studio Data Architect Screenshots Microsoft Power BI Screenshots