Likelihood to Recommend 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 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 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 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 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 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 I find it helpful and easy to use
Read full review Usability 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 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 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 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 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 [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 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 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 erwin Data Modeler Screenshots Microsoft Power BI Screenshots