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.
$14
per month per user
Oracle Analytics
Score 7.6 out of 10
N/A
Oracle Analytics is a solution used to visually explore data to create and share compelling stories. Oracle Analytics Cloud is a cloud native service, and Oracle Analytics Server is the on-premise option.
Outsourcing work is easy to understand, and there are plenty of resources available in the marketplace. It is expensive, but it is still significantly less costly than the alternatives. Results from Microsoft BI (MSBI) are dependable; therefore, there is no problem with trust. …
Microsoft BI is ideal for proficient Excel users, and it is the best choice in terms of visualizations. We decided to use Microsoft BI for these reasons.
One of the main reasons Microsoft BI was chosen by our company is because it is a reliable program. We tried different programs in the past (and currently also use other ones for certain reporting and analysis needs) but Microsoft BI was the least buggy out of our top choices.
Oracle is primarily one amongst the leader in ERP applications and they have quite easily leveraged their BI products to offer pre-built dashboard and operational reporting which is received well by the users. But with Microsoft BI there are host of other features which beats …
Compared to Microsoft BI, Oracle BI has got good data modeling, adhoc reporting, scheduling and some rich visualization capabilities which definitely made us to choose Oracle BI against Microsoft BI.
Tableau BI is a very simple and easy tool to implement and helps business users …
Features
Microsoft BI (MSBI)
Oracle Analytics
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Microsoft BI (MSBI)
9.8
49 Ratings
18% above category average
Oracle Analytics
8.1
62 Ratings
1% below category average
Pixel Perfect reports
9.842 Ratings
8.055 Ratings
Customizable dashboards
9.749 Ratings
8.061 Ratings
Report Formatting Templates
9.847 Ratings
8.361 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Microsoft BI (MSBI)
9.8
49 Ratings
20% above category average
Oracle Analytics
8.1
66 Ratings
1% above category average
Drill-down analysis
9.844 Ratings
8.564 Ratings
Formatting capabilities
9.749 Ratings
8.365 Ratings
Integration with R or other statistical packages
9.839 Ratings
7.345 Ratings
Report sharing and collaboration
9.849 Ratings
8.262 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Microsoft BI (MSBI)
9.8
48 Ratings
18% above category average
Oracle Analytics
7.8
63 Ratings
5% below category average
Publish to Web
9.844 Ratings
7.755 Ratings
Publish to PDF
9.844 Ratings
7.762 Ratings
Report Versioning
9.840 Ratings
7.853 Ratings
Report Delivery Scheduling
9.843 Ratings
8.058 Ratings
Delivery to Remote Servers
9.824 Ratings
8.038 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
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.
Oracle Data Visualization is very effective if used in an enterprise context with huge volumes of data coming from different systems. It supports dashboard and reporting capabilities and is easy to scale. It also allows you to leverage machine learning capabilities to extract hidden data trends. Visualization capabilities are powerful but not so various if compared to other solutions on the market. If you want to present a dashboard to an executive audience and you want to make your dashboards beautiful you must adapt them through PowerPoint.
Available without of the box connectors for Salesforce and oracle Saas Cloud. This is a huge plus for our business since we don't need another middleware solution just for this sake.
We are able to connect to our on-prem SQL Server database where we have our RMA database and other applications seamlessly without writing custom APIs.
OAC writes directly into ADW which is another advantage for loading Excel files into ADW after dataflow transformations.
OAC allows replication of the database from fusion ERP and lets us create subject areas using the data modeler.
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.
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.
Scalability and rich integration capabilities. In the future, if we go with Hyperion for the Financial Consolidation and planning purposes -BI integration with Hyperion is going to be much simpler as it has native interface connectivity and even integration capabilities with well known CRM products (Siebel) and ERP Products (Oracle EBS, Peoplesoft, SAP) is going to be easy and straight forward.
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.
Great, if you are limited to using it along with other Oracle products; sadly, not if you are integrating with other products, which can be a challenge. It is a great product with tons of functionality and great integration with other in-house platforms. Great visuals and customization for data and analytics to provide decision-making data and analysis.
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.
Oracle Analytics Support team is very proactive and I have never had a situation where I had to wait for more than a day or two to get my issues resolved. This is a very big help for us and we appreciate Oracle and its team for guaranteeing that experience.
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.
A properly implemented Endeca solution performs extremely well on the largest of datasets and it positions your organization to immediately achieve your ROI.
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 Analytics Cloud, is one of the most agile and secure data analysis platforms that according to the budget and the amount of use, you can use the resources you need under the cloud. The Oracle brand is also very well known in this field and can meet all the needs of an organization or industry in any sector.
We have seen the results of this in our initial research and are not surprised that Oracle does this like it does soo many other things in this area, so well.
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.
We've used OBIEE (or it's previous named product) for over 13 years and it's still the most used tool for BI by the business.
We moved our largest business system off of Business Object into OBI so we could gain improved performance, reliability, and easier management of metadata.
