What users are saying about

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
617 Ratings

Splunk Enterprise

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
191 Ratings

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
617 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Splunk Enterprise

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
191 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101

Add comparison

Likelihood to Recommend

Microsoft BI

Most suitable scenarios:
-Large scale report automation and distribution.
-Self service BI for internal and external users.
-Relational databases and multidimensional models.
-Comprehensive security & access control.

Less appropriate scenarios:
-Non-relational databases
-Low budget
-Tight timeframe

I'd invite anyone reading this far to think hard on his/her goals with BI. Are you trying to build a solid and endurable BI service for your clients or your own organisation? Or do you just need to have some quick visualisation of the data you have to make strategic or operational decisions in a few weeks time?

Implementing a MicrosoftS BI stack takes time, knowledge, and skills, none of these comes cheaply these days. If your answer to my first question is "yes", go ahead and study Microsoft BI a bit more then make your decision on your own. If you see my second question is most relevant to you, go and grab a web-based BI tool such as SiSense, Tableau, Splunk, and so on. Take the free trial option and see if you can test your ideas fast and at a lower cost. Good luck!
Haibo Yang profile photo

Splunk Enterprise

Splunk is a great data analytics tool for you if you have a large amount of data to analyze. Splunk provides accurate and real-time analysis of data through its dashboard. But if you not quite a technical person or not willing to learn Splunk before using it, I will not recommend it to you. Also, Splunk is less appropriate for static data.
Rahul Shinde profile photo

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.0
Splunk Enterprise
Pixel Perfect reports
Microsoft BI
7.9
Splunk Enterprise
Customizable dashboards
Microsoft BI
7.9
Splunk Enterprise
Report Formatting Templates
Microsoft BI
8.2
Splunk Enterprise

Ad-hoc Reporting

Microsoft BI
8.4
Splunk Enterprise
Drill-down analysis
Microsoft BI
8.2
Splunk Enterprise
Formatting capabilities
Microsoft BI
8.4
Splunk Enterprise
Integration with R or other statistical packages
Microsoft BI
8.1
Splunk Enterprise
Report sharing and collaboration
Microsoft BI
8.9
Splunk Enterprise

Report Output and Scheduling

Microsoft BI
8.2
Splunk Enterprise
Publish to Web
Microsoft BI
8.3
Splunk Enterprise
Publish to PDF
Microsoft BI
8.8
Splunk Enterprise
Report Versioning
Microsoft BI
8.1
Splunk Enterprise
Report Delivery Scheduling
Microsoft BI
7.6
Splunk Enterprise
Delivery to Remote Servers
Microsoft BI
8.1
Splunk Enterprise

Data Discovery and Visualization

Microsoft BI
8.1
Splunk Enterprise
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft BI
8.4
Splunk Enterprise
Location Analytics / Geographic Visualization
Microsoft BI
7.9
Splunk Enterprise
Predictive Analytics
Microsoft BI
8.0
Splunk Enterprise

Access Control and Security

Microsoft BI
8.4
Splunk Enterprise
Multi-User Support (named login)
Microsoft BI
8.4
Splunk Enterprise
Role-Based Security Model
Microsoft BI
8.1
Splunk Enterprise
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft BI
8.6
Splunk Enterprise
Single Sign-On (SSO)
Microsoft BI
8.5
Splunk Enterprise

Mobile Capabilities

Microsoft BI
8.2
Splunk Enterprise
Responsive Design for Web Access
Microsoft BI
8.2
Splunk Enterprise
Dedicated iOS Application
Microsoft BI
8.4
Splunk Enterprise
Dedicated Android Application
Microsoft BI
8.1
Splunk Enterprise
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
8.3
Splunk Enterprise

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.8
Splunk Enterprise
REST API
Microsoft BI
7.9
Splunk Enterprise
Javascript API
Microsoft BI
8.3
Splunk Enterprise
iFrames
Microsoft BI
7.7
Splunk Enterprise
Java API
Microsoft BI
7.5
Splunk Enterprise
Themeable User Interface (UI)
Microsoft BI
7.8
Splunk Enterprise
Customizable Platform (Open Source)
Microsoft BI
7.4
Splunk Enterprise

Security Information and Event Management (SIEM)

Microsoft BI
Splunk Enterprise
8.6
Centralized event and log data collection
Microsoft BI
Splunk Enterprise
9.2
Correlation
Microsoft BI
Splunk Enterprise
8.0
Event and log normalization
Microsoft BI
Splunk Enterprise
9.1
Deployment flexibility
Microsoft BI
Splunk Enterprise
8.3
Integration with Identity and Access Management Tools
Microsoft BI
Splunk Enterprise
8.0
Custom dashboards and views
Microsoft BI
Splunk Enterprise
9.4
Host and network-based intrusion detection
Microsoft BI
Splunk Enterprise
8.5

Pros

  • Point 1. User defined automation of report execution and distribution. Microsoft SSRS so far is one of the most user friendly report scheduling and distribution platforms available. Our client users, often non-technical business people, can subscribe to any reports they have access to on the report server and make a customised execution by setting up parameter values, export formats, receipients, etc. etc. Many users use this feature to monitor their action lists and risk profiles on a regular basis. They absolutely love it!
  • Point 2. Extensive programmability. Programmability has always been a great strength of many Microsoft products. Adding to my point 1, take Microsoft SSRS for example, it comes with a great deal of programmability. This means what client users need do in point 1 to set up the report execution and distribution by themselves, can now be programmed and completed automatically. One trick we often do is to program on SSRS for automatically executing and distributing a report using different parameter values to generate different results and then send to the email boxes of tens, if not hundreds of line managers within client organisations. Every line manager will only receive the results relevant to his/her own business unit(s). Once set up, a client organisation can save hundreds hours of work on Excel spreadsheets each month. Clients are willing to pay you a fortune for such a level of automation in reporting process!
  • Point 3. Flexible integration with SSAS. Instead of praising the more techinical features such as partitions and actions shipped with SSAS, I'd make my point 3 to be more business user friendly by emphasising the integration options of SSAS. Excel, Power BI, SharePoint, and third party tools such as Tableau, can all be easily and nicely integrated with SSAS objects. Not to mention since MSSQL 2012 you also have got the choice between Tabular models and Multidimensional models. Your business analysts will love the flexibility SSAS can provide!
  • Point 4. Stability of the IDE. Of course this one is to me when I'm in a BI developer mode. Using Visual Studio to develop SSAS, SSIS, and SSRS objects is a relaxing experience and will be good to the longevity of your developers. Why? Because VS is stable enough to not crash your developers' computers. As a matter of fact, VS has never crashed my OS since 2008...I mean it.. though a few times before 2008...Unlike some other seemingly simpler IDEs which may freeze or overpower your OS while processing your design changes... VS is a powerful yet stable tool and your developers will love it.
Haibo Yang profile photo
  • Powerful Data Analytics application
  • Excellent and very informative dashboard
  • Defining Field Extractor is very easy and also you can use them to search again
  • Can analyze large amount of data very effectively
Rahul Shinde profile photo

Cons

  • More than two dimensions. Yes, I know that 2D is the core of Excel's DNA. However, we're starting to deal with higher-dimensional arrays here in analytics land so better visualization support would be cool.
  • UI weirdness. By default, you are flipping back between regular Excel tabs and super-top-secret BI tabs. You create charts in one place, but look at them in the other. That kind of stuff. I know there are a couple of other ways to interact with Microsoft BI, but please figure out the main way.
  • Better hookups to other analytics tools including Microsoft's. Microsoft BI has a good variety of data connections, and I don't expect it to bloom into a full-fledged analytics tool, but it may be a good idea to keep hammering at connectivity with "hardcore" analytics. In my case, Python stuff.
Alexander Lubyansky profile photo
  • Even though there is a search tool as a help function, you still have to read through many documentation to find the answers you're looking for and sometimes you don't find it. The help function in Splunk could be improved to be more intuitive or have a built-in help per report, panel or dashboard.
  • Creating a Splunk dashboard is rather straightforward however, customization is not. Splunk could be improved to provide more tools or features for customization such as adding colors and font options for text and graphs or graphics.
  • My dashboard has a lot of useful information and I want the important panels and reports at the top but there is no easy way to do this. Perhaps Splunk could be improved to allow features such as adding URL links to other dashboards or some other clever way to emphasize the important data in my dashboard without compromising space.
Trung Pham profile photo

Likelihood to Renew

Microsoft BI8.0
Based on 25 answers
Microsoft is widely adopted and it does get the job done. For legal reasons, support perspective and resourcing it is often the tool of choice and, of course, the technology is there to support the day-to-day business.
Julia Gusman profile photo
Splunk Enterprise7.7
Based on 15 answers
We are using Splunk extensively in our projects and we have recently upgraded to Splunk version 6.0 which is quite efficient and giving expected results. We keep track of updates and new features Splunk introduces periodically and try to introduce those features in our day to day activities for improvement in our reporting system and other tasks.
No photo available

Usability

Microsoft BI7.0
Based on 5 answers
It's a good rating for people willing to learn and get used to it, but it's not inherently user friendly, especially to people who are not Excel power users.
Alexander Lubyansky profile photo
Splunk Enterprise9.9
Based on 2 answers
You can literally throw in a single word into Splunk and it will pull back all instances of that word across all of your logs for the time span you select (provided you have permission to see that data). We have several users who have taken a few of the free courses from Splunk that are able to pull data out of it everyday with little help at all.
Kenneth Taitingfong profile photo

Reliability and Availability

Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo
Splunk Enterprise10.0
Based on 1 answer
When properly setup and configured, Splunk is extremely reliable.
No photo available

Performance

Microsoft BI7.0
Based on 2 answers
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.
Robert Goodman profile photo
No score
No answers yet
No answers on this topic

Support

Microsoft BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo
Splunk Enterprise8.9
Based on 3 answers
Support from Splunk to our company is extremely good . Our team developed many dash boards , reports and alerts in Splunk which saved so many hours of our development time and made us very very efficient . We are extremely happy with current functionality provided by Splunk and have no complaints at all . I would definitely recommend it to everyone
No photo available

In-Person Training

Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo
No score
No answers yet
No answers on this topic

Online Training

Microsoft BI8.5
Based on 2 answers
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.
Sean Brady profile photo
No score
No answers yet
No answers on this topic

Implementation

Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo
Splunk Enterprise8.0
Based on 1 answer
Engage professional service early on in the implementation
No photo available

Alternatives Considered

I have been using the open source open standards BI tool 'Pentaho' before moving into the Microsoft space and I must admit I was surprised how much more difficult it is to do development in Microsoft. Having said that the cubes (SSAS) and reporting (SSRS) side does seem more robust and not all that difficult to get your head around. Where Microsoft is lacking in comparison with Pentaho is the ETL tool. SQL Server Integration Services (SSIS) is much more difficult to learn than Pentaho Data Integration (PDI) and even when you know exactly what you are doing it still takes more steps to get the same job done. Regarding the performance it seems that since a lot of the ETL logic gets put onto the database (using SQL statements) it won't make much of a difference which tool you use.
Julia Gusman profile photo
We are using this because it has lots of advantage over others. And it seems to be a good fit for us. Splunk provides lot more features than others and its UI is user-friendly, so for a new developer, it would not be too difficult to use it and do something around it.
Rounak Jangir profile photo

Scalability

No score
No answers yet
No answers on this topic
Splunk Enterprise9.1
Based on 1 answer
Splunk can scale in to the petabyte per day range which of course is awesome
Rick Yetter profile photo

Return on Investment

  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady profile photo
  • Splunk has been used as a one-stop-shop for log collection, indexing, alerting, analytics and dashboarding
  • Splunk is a costly software however ROI on our engineering and operations is huge.
  • Negative could only be its high licensing costs. It might not be a viable option for all companies.
No photo available

Pricing Details

Microsoft BI

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft BI Editions & Modules
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details

Splunk Enterprise

General
Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Splunk Enterprise Editions & Modules
Splunk Enterprise
Additional Pricing Details