Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
Oracle Fusion Cloud Enterprise Performance Management (EPM) is a solution that helps users model and plan across finance, HR, supply chain, and sales, streamline the financial close process.
Pricing per user varies by component within the Oracle EPM Cloud solution. Please see pricing information for the EPM Cloud components on cloud.oracle.com or contact Oracle Sales at +1.800.633.0738.
Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.
It is well suited in a geographically distributed environment where you have various key participants in multiple time zones providing input and necessary explanations on performance and measured success It is less appropriate where you have a single office environment with a single finance department working together. It is also less suited when the GL is NOT an Oracle product and the interface between the GL and the reporting software needs to be implemented with utmost care and handling.
Account Reconciliation CLoud Services provides tight integration with Oracle R12 and 11i . Provides drillback capability. It is flexible and provides rich functionality to users.
We have implemented ARCS on cloud and migrated planning and budgeting from On premise to PBCS and EPBCS. Functionality is onpar with onpremise. Provides regular updates monthly
We don't need to upgrades every year and saved a lot on Hardware.
The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.
The limitation of constrained out of the box dimensions that requires ripping the initial implementation to add the new dimensions is a major drawback.
Smartview interface is cumbersome for many.
The only financial adapter is available for integration for other modules we have to go with file-based uploads which is cumbersome and not real-time.
It is very costly in terms of licensing unlike other Oracle products.
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
We have a pretty good userbase who are at the high level who gained value from this tool. Discontinuing this tool is prone to impact their day to day operations. Also the data in this tool cannot alter the source, which maintains the integrity of this tool. Smartview is a cool addition that gained lot of traction as well.
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
It produces consolidated multi currency reports faster and more accurately whilst adding additional pivotal functionality. The Smartview reporting is a key for us and a flagstone of the application
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
Support from our implementation partner is a 10/10, but support from Oracle is awful. Case in point: recently over a 2-day period, there were a series of intermittent outages. Oracle actually asked US for the outage time-stamps. I would have thought that, since we were paying them, they should probably be able to tell us!
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
I suggest doubling the time to implement from the initial quote you get from the Sales team. That's always been the case for me for multiple EPMs now. The out-of-the-box functionality of Oracle Planning and Budgeting Cloud is pretty robust so I appreciate that and it really helped us get the ball rolling quickly.
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
Oracle Planning and Budgeting Cloud fared very well against Adaptive, Anaplan, and Host Analytics. We ultimately decided on Oracle due to its reputation and strength of existing customers. We are happy with our decision.
As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
