Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.
N/A
Prophix
Score8.4 out of 10
Enterprise companies (1,001+ employees)
Prophix One, a Financial Performance Platform, is used to improve the speed and accuracy of decision-making within a harmonized user experience. To reduce complexity and uncertainty, the software offers automated insights and planning, budgeting, forecasting, reporting, and consolidation functionalities.
If you're already using Office 365, Power BI for O365 is an easy choice. Start playing around with the free version and then easily add individual Pro licenses with little risk. However, if you anticipate using this with many users, it can get expensive quickly.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Prophix is best suited if you have a very extensive budgeting process that currently relies on multiple Excel spreadsheets. It is also great if you have on-prem tools that may no longer be supported for reporting. It may not be appropriate if you require an unlimited number of mid-tier users, as it can be very expensive annually. It's definitely not a cheap tool, but the cost can at least be optimized based on users' use cases. In both organizations I've worked for that use it, cost has been mentioned.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Easy to make visual dashboards from SQL queries. Previously we had to use a third party application that had to run on a web server that was so complex to setup and run. PowerBI removes all that.
Ability to control who/which group has access to each dashboard or report. Ties in well with the rest of the Office 365 ecosystem.
Has many connectors to allow pulling data from various systems, both onsite (via gateway) or external (via APIs), and join the data to create a report/dashboard.
Ability to show data but also export the data, if permitted.
Easy to show PowerBI dashboards on SharePoint or on other websites via embedded code.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Reporting - single report that can be opened by multiple users, each will see only aspect specific to them based on their security access.
Budgeting - workflow driven budget data collection, visibility of its current status, ability to take action to ensure timely completion. Ability to snapshot budget data at a point in time. Ability to perform what-if scenarios.
Forecasting - as above with added benefit of either reusing budget level of grain or forecasting at high level.
Granular planning - ability to create unlimited number of subsidiary models to assist with the planning process. Non-financial data collected during budget/forecast process help with operation planning and variance analysis.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Licensing: Currently, Microsoft has a fixed pricing model for Office 365 users, regardless of role/function of the user. Most organizations have a small number of "power users" that create usable content and many more "consumers" that simply view/run reports created by power users. Microsoft does not differentiate between these users, and thus the pricing limits organizations from large deployments of the software.
Version incompatibility: Excel 2010 and 2013 workbooks are compatible with each other. However, workbooks created in 2010 that include PowerPivot databases must be upgraded to 2013 format to run in 2013. Subsequently, you cannot open these upgraded PowerPivot workbooks in 2010. This requires ALL users to be on the same version.
Visualization: Excel charting with PowerPivot workbooks is adequate for many users. Power View also contains a number of GREAT visualizations, including animated bubble charts and a very flexible dashboard/report design canvas. However, compared to some of the other self-service BI solutions, it is still limited in its visualization capabilities.
Ability to filter report views for report binder without creating duplicate reports.
More extensive documentation and examples in the ProCalc library.
More ProCalc functions that deal with the time dimension and allow functions that can utilize the system date. So if it is day 8 of the month.
Ability to save company color scheme for use in reporting.
Would like to create a link between the account dimension and another dimension so I can easily report on account properties. For example, an account property could be columns in a report.
Would like to see the ability to have a report view on a dashboard. The tables are poorly formatted, and I’d like more formatting ability.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I will continue to recommend this suite to folks looking for a reporting and analytics solution, as I find in MOST cases, it's great at meeting almost every requirement I've been given by a multitude of clients across a range of industries. I've built Capacity Planning solutions that allowed end user input which was then submitted to SharePoint, Executive Dashboards, custom applications, simple analytical tools for teams to easily slice and dice data, and super simple reports as well as some very complicated ones. If you haven't seen the demos online, do a search, and see for yourself - this is a great BI suite! (I do not work for Microsoft, although I do consult out there from time to time. I do occasionally make a recommendation for a different BI reporting tool, but in general, find Excel can accomplish quite a bit for less money and in less time.)
The system works well for us, and meets all of our needs. All of our future plans can and will be achieved within Prophix, so there is no need to pursue another product. Prophix has continuously proven to improve their product over the years, which provides an even higher level of confidence in this tool, and future developments
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I don't rate anybody a 10 because I believe there's always room for improvement, so I'll go with an 8. And I'm giving 8 because it has helped us do more than we were doing before, and I believe there's still room for improvement.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
There have been very few times that Prophix has not been available and we have been informed ahead of time. The only issue that we have is when we update cubes or import information and run processes during working hours which stops access for a short period of time but this is more about our processes than Prophix.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Prophix has always performed consistently. We are using on-premise so many factors can contribute to slower than desired performance, most having nothing to do with Prophix itself. If we move to the web-client cloud based solution I believe performance will even be better.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We’ve gotten moved around a lot and so we don’t always know our pod people. Also when we book sessions with a random person it seems like we have to take the first 15-20 minutes explaining our system and process.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Training is essential for this software to be successful for any company. We unfortunately had a bad implementation and training manager so I can say with confidence that if we had the CSM we have now - we would be light years ahead of our knowledge of the system. I highly suggest taking all training opportunities and not rushing the implementation training
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We used our system and created a test cube to work with our own data. We ran through the different functions of Prophix and covered alot of material. We did two sessions a week, with homework tasks assigned. We were able to ask questions and cover any questions during the followup sessions.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Prophix Consulting should bring, in house, chargeable expertise in Oracle EBS table access for Drill Across and provide reasonable limits on dimension member combinations so there are no unreasonable expectations about the application of multi dimensional cubes to detail, such as revenue by product and customer.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Oracle was nice, super expensive to implement if it's not in use already. JobDiva is choppy and heavy on the system while does not give great reports. Salesforce is good; remote access is good however their support is terrible
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Prophix is so much easier to use that other platforms or products. It can be customized so much easier than other larger, more expensive products. I work for a small university where we have a small finance team and Prophix allows us to tailor reporting to emerging needs in real time without having to reconfigure clunky systems with expensive modifications
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Prophix is a capable tool of growing with an organization and the uses for different items in the software. Our organization was able to scale the product to lots of different end users and the needs of the departments. There are plenty of updates and features to grow and bring in new data.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
Prophix has made it possible to move away from some Excel reporting we were doing, which allows for 50% quicker reporting on a monthly basis.
Although it has saved us time, an improved PowerPoint feature that automatically updates our decks would save an additional 75% on top of what we already do.
Our Board Reporting has improved by 10 hours by moving our reports fully into Prophix.
