What users are saying about

Microsoft BI

594 Ratings

Microsoft BI

594 Ratings
Score 7.8 out of 101

Splunk Enterprise

184 Ratings
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 well suited for applications or companies that process and store large data. Some of these applications may be legacy but as long as you can retrieve this data, then you can use Splunk to transform this data into meaningful reports or dashboards. In addition, Splunk is great for a 24/7 monitoring operations tool that can be set up to send alerts for production support. Splunk is less suited for applications that may already have a GUI because the Splunk features would be less superior than what a graphical user interface could provide in terms of features and customization.
Trung Pham profile photo

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.2
Splunk Enterprise
Pixel Perfect reports
Microsoft BI
8.1
Splunk Enterprise
Customizable dashboards
Microsoft BI
8.1
Splunk Enterprise
Report Formatting Templates
Microsoft BI
8.4
Splunk Enterprise

Ad-hoc Reporting

Microsoft BI
8.5
Splunk Enterprise
Drill-down analysis
Microsoft BI
8.6
Splunk Enterprise
Formatting capabilities
Microsoft BI
8.3
Splunk Enterprise
Integration with R or other statistical packages
Microsoft BI
8.3
Splunk Enterprise
Report sharing and collaboration
Microsoft BI
8.8
Splunk Enterprise

Report Output and Scheduling

Microsoft BI
8.7
Splunk Enterprise
Publish to Web
Microsoft BI
8.7
Splunk Enterprise
Publish to PDF
Microsoft BI
8.5
Splunk Enterprise
Report Versioning
Microsoft BI
8.8
Splunk Enterprise
Report Delivery Scheduling
Microsoft BI
8.8
Splunk Enterprise
Delivery to Remote Servers
Microsoft BI
8.5
Splunk Enterprise

Data Discovery and Visualization

Microsoft BI
8.8
Splunk Enterprise
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft BI
9.0
Splunk Enterprise
Location Analytics / Geographic Visualization
Microsoft BI
8.8
Splunk Enterprise
Predictive Analytics
Microsoft BI
8.5
Splunk Enterprise

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

Microsoft BI
8.4
Splunk Enterprise
REST API
Microsoft BI
8.6
Splunk Enterprise
Javascript API
Microsoft BI
8.4
Splunk Enterprise
iFrames
Microsoft BI
8.4
Splunk Enterprise
Java API
Microsoft BI
8.3
Splunk Enterprise
Themeable User Interface (UI)
Microsoft BI
8.7
Splunk Enterprise
Customizable Platform (Open Source)
Microsoft BI
8.0
Splunk Enterprise

Security Information and Event Management (SIEM)

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

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
  • Parsing data without manual intervention is a true time saver. Not to say you can't tweak the parsing, but unlike my experiences with the ELK stack, Splunk's ingestion and parsing is so good you can focus on other priorities.
  • Splunk offers many free technology add-ons that provides real value immediately. For example, the Distributed Management Console (DMC) helps pull all the Splunk Architecture management together in one set of dashboards. To me, this is a true differentiator compared to its competitors.
  • Searching for data nuggets is fast. Even dense datasets returns results surprisingly fast.
  • Splunk works well with external data sources too. DBConnect is a feature that allows Splunk to interact with an existing data warehouse. So there's no need to move legacy data into Splunk indices since you can just use a SQL-like (dbquery) command to pull the data in for analysis.
No photo available

Cons

  • Report Builder 3.0 shipped with MSSQL 2012 is a nice free tool but our client users sometimes encounter problems such as the tool automatically shut down without saving the changes being made. We haven't implemented the new RB with MSSQL 2016 yet thus cannot comment on the latest version.
Haibo Yang profile photo
  • Maybe wizards to help you walk through different tasks might help the beginner.
Richard Wilbert, MBA profile photo

Likelihood to Renew

Microsoft BI8.0
Based on 25 answers
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.
Lee Cullom profile photo
Splunk Enterprise7.7
Based on 15 answers
Over time, Splunk becomes a part of the core business and the usefulness grows as the amount of data ingested grows.
Rick Yetter profile photo

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
Quick response. Lots of blogs and support forums are there to get the answer myself
No photo available
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

Breadth of Deployment

I have implemented Microsoft BI in small departments with less than 10 people all the way up to full enterprise deployments with multiple IT groups and 1000's of users. The only difference will be what of the provided Microsoft BI tools will you use and how many servers will it all be installed on. Once it is setup it is very easy to keep up-to-date and even expand in the future. Some of the tools do need more IT involvement to get up and running, but once it is setup and working it can easily go into a hands-off setup and just works. I have been oncall support for an enterprise SSRS deployment that was on multiple servers across multiple data centers and only received calls of issues once or month or less and most of time those were cause by human error and not following the procedures that were established.
Steve Wake profile photo
No answers on this topic

Alternatives Considered

Microsoft is a distant me too in a world that is crowded and drowning in BI Me too products. Visualizations 5/10. Micro Strategy, ClickView, Domo, BOBJ etc will kill this product. The issue is cost and speed to implementation. The cost is far less than any of the previously mentioned items. The implementation time could be a fraction of those products. The implementation of this product can be as simple as connecting Excel to the database (Create the relationships that you can do in the dbase or the query in Excel) and pushing to the Cloud. From the cloud based app you simply launch the gateway. The gateway is a breeze for anyone to connect with. The gateway only needs path back and its a breeze. No IT guys needed, no professional services, no firewalls or routing tables to configure. Just plug and play. This feature alone is the key product differentiation in my review. We already had the tables developed and ETL be damned, they all push from the MS-SQL dbase directly to cloud. Is this going to be big and fast in an environment with Data Universe's, API's to other products, and true Enterprise class features. I dont think so. Is it good enough for most small to medium companies or departments? Yes
Sean Warren profile photo
Loggly, LogLogic, AppSumo. Every one of these products have a scalability problem beyond the terabyte range and gets tremendously expensive in the long run keeping data in the cloud
Rick Yetter profile photo

Collaboration and Sharing

Microsoft BI8.2
Based on 27 answers
I wish it was simpler to share a dashboard or embed them outside of BI. Other than that sharing is easy enough with our 365 organization
Micah Jones profile photo
No score
No answers yet
No answers on this topic

Data Integration

Microsoft BI8.7
Based on 26 answers
Data source integration is one of a key for any software. Microsoft BI works well integrating with microsoft related products. For other data source integration, the integration is not straight forward.
No photo available
No score
No answers yet
No answers on this topic

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

  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.
Nathan Patrick Taylor profile photo
  • Increased efficiency in the NOC.
  • Reduction on app/dev lifecycles
  • Reduction on MTTR on most outage scenarios
Rick Yetter profile photo

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