Logi Symphony vs. Power BI For Office 365 (discontinued)

Considering it's price point in the market, Dundas BI offers a lot of functionality. They are constantly adding features and bug fixes which is great, but also means there are always updates to take if you want everything to work as expected. The standard user interface is pretty easy to understand, but it takes a while for developers and power users to become independent of documentation.

Incentivized

If you want to create a visual dashboard or report that utilises various data sources then PowerBI can do this. It is great in that it takes your on-premises data and stores it on Microsoft servers where it can interact with it faster, reducing load on your own servers, while being efficient in what it transfers out. We have found it not well suited if you wanted to publish a simple report to many staff as they may all need a Pro license which can get expensive. Even if embedding the report onto a shared platform like SharePoint, it will not display if the users doesn't have a PowerBI Pro license.

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

• Ease of use. Most people have experience working with Excel. If you know how to create pivots, you can use Power BI.
• Data extraction and transformation (ETL). ETL is a joy with Power Query. It is intuitive, simple and a magical experience to transform poor data into something useful.
• Visuals. Power BI is beautiful to behold, especially Power View.
• Maps. The interactive maps are great built-in tools.
• Cost You cannot find anything cheaper than Power BI, unless you want to give it to every user in your company.

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.

• Like many Microsoft products, you can get by with a small understanding of the product, but to truly realize the entire potential does take a while to learn.
• Hooking up SQL databases to the cloud version is a more complex than just querying right into the database from the desktop version.

Incentivized

If I were a small business owner, I would likely use Power BI for Office 365 for the sheer fact that I would get the Office licensing I need, along with powerful capabilities. As a Microsoft Partner, we continue to see Microsoft invest heavily in the Power BI capabilities, and will continue to implement and support BI solutions around this product, as we believe this is in the best interest of our clients.

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.

We are satisfied with the functionality and capabilities of Power BI. Product is cost effective and full-fill the reporting requirements of the organization. You can perform most of the report level complex analysis with the help of DAX which makes Power BI very powerful analytic tool. Power BI for Office 365 has gone away and Power BI is the next evolution of it. Power BI comes with your Office 365 E5 subscription or you can purchase licensing for it separately.

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

as of now there is strong community for Power BI, you can get solution for most of your problems from there. Also you can send your error to Microsoft as well. After every 15 days they release updates to overcome all the issues of defects.

Incentivized

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

We have tested Tableau prior to Dundas BI and though Tableau is a great package in itself, Dundas BI is much more cost-effective for our needs and requirements and hence zeroed in on Dundas BI. We have also tried microstrategy but it has a very dated UI and doesn't suit our needs in today's more modern world

Incentivized

One main competitor of Power BI is Tableau. Tableau has been around longer than Power BI so it can feel a little more refined in areas, however Power BI is catching up quickly. Tableau can be more expensive than Power BI. If you want more features and more refinement, and don't mind extra cost, then Tableau may be a better choice. But if you want something that's integrated with many things in O365, and are satisfied with fewer bells and whistles, Power BI may be the better option.

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

• As a Microsoft Partner implementing Business Intelligence solutions, Power BI has removed the barrier for our clients to begin the "BI journey". So often, projects get hung up in that early phase of procuring and installing/configuring expensive hardware and software. Just simply getting started and designing a beginning solution has allowed our clients to see results in 1-2 weeks using their data that might have taken months to achieve otherwise.
• One significant ROI example is process improvement. In many cases, individuals or teams are spending days each month gathering data from multiple sources for reporting to their constituents. We are reducing these times to minutes by automating many of the data collection and integration processes that were previously manual.