What users are saying about
765 Ratings
199 Ratings
765 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100
199 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100

Likelihood to Recommend

Microsoft BI

Flexibility, engagement, training resources, updates, cost, implementation, ease of use, support; these are the reasons why I would recommend Power BI. Power BI is best suited for situations where collaboration is needed among several different groups who are working concurrently on different activities. Where there are multiple levels of data that need to be parsed through. It's difficult to think of a scenario where it wouldn't be beneficial other than the obvious.
Jason Leidig | TrustRadius Reviewer

SSIS

  • SSIS is particularly well suited for jobs that need to be consistent, repeatable, and error managed.
  • Ongoing extract, transform, load [ETL] jobs that are scheduled or manual.
  • One-time ETL with complex datasets.
  • Migrations of large datasets.
SSIS is not well suited for small or simple datasets that can be copied or exported safely to flat files for import. It is possible to do this but would generally take longer to build in SSIS unless there was a good reason to .remove manual handling of the data in transport or the action needed to be testable/repeatable.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
7.9
SSIS
Pixel Perfect reports
Microsoft BI
7.7
SSIS
Customizable dashboards
Microsoft BI
7.9
SSIS
Report Formatting Templates
Microsoft BI
8.1
SSIS

Ad-hoc Reporting

Microsoft BI
8.0
SSIS
Drill-down analysis
Microsoft BI
7.8
SSIS
Formatting capabilities
Microsoft BI
8.0
SSIS
Integration with R or other statistical packages
Microsoft BI
7.8
SSIS
Report sharing and collaboration
Microsoft BI
8.4
SSIS

Report Output and Scheduling

Microsoft BI
7.6
SSIS
Publish to Web
Microsoft BI
7.7
SSIS
Publish to PDF
Microsoft BI
8.2
SSIS
Report Versioning
Microsoft BI
7.6
SSIS
Report Delivery Scheduling
Microsoft BI
7.4
SSIS
Delivery to Remote Servers
Microsoft BI
7.3
SSIS

Data Discovery and Visualization

Microsoft BI
7.7
SSIS
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft BI
7.9
SSIS
Location Analytics / Geographic Visualization
Microsoft BI
7.7
SSIS
Predictive Analytics
Microsoft BI
7.6
SSIS

Access Control and Security

Microsoft BI
8.2
SSIS
Multi-User Support (named login)
Microsoft BI
8.2
SSIS
Role-Based Security Model
Microsoft BI
7.8
SSIS
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft BI
8.4
SSIS
Single Sign-On (SSO)
Microsoft BI
8.4
SSIS

Mobile Capabilities

Microsoft BI
7.9
SSIS
Responsive Design for Web Access
Microsoft BI
7.8
SSIS
Dedicated iOS Application
Microsoft BI
7.9
SSIS
Dedicated Android Application
Microsoft BI
7.8
SSIS
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
7.8
SSIS

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.4
SSIS
REST API
Microsoft BI
7.2
SSIS
Javascript API
Microsoft BI
7.8
SSIS
iFrames
Microsoft BI
7.4
SSIS
Java API
Microsoft BI
7.8
SSIS
Themeable User Interface (UI)
Microsoft BI
7.2
SSIS
Customizable Platform (Open Source)
Microsoft BI
7.1
SSIS

Data Source Connection

Microsoft BI
SSIS
8.5
Connect to traditional data sources
Microsoft BI
SSIS
9.4
Connecto to Big Data and NoSQL
Microsoft BI
SSIS
7.6

Data Transformations

Microsoft BI
SSIS
9.1
Simple transformations
Microsoft BI
SSIS
9.9
Complex transformations
Microsoft BI
SSIS
8.2

Data Modeling

Microsoft BI
SSIS
7.1
Data model creation
Microsoft BI
SSIS
7.4
Metadata management
Microsoft BI
SSIS
6.7
Business rules and workflow
Microsoft BI
SSIS
8.1
Collaboration
Microsoft BI
SSIS
6.3
Testing and debugging
Microsoft BI
SSIS
7.3
feature 1
Microsoft BI
SSIS
7.0

Data Governance

Microsoft BI
SSIS
8.1
Integration with data quality tools
Microsoft BI
SSIS
8.7
Integration with MDM tools
Microsoft BI
SSIS
7.5

Pros

Microsoft BI

  • 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 | TrustRadius Reviewer

SSIS

  • SSIS works very well pulling well-defined data into SQL Server from a wide variety of data sources.
  • It comes free with the SQL Server so it is hard not to consider using it providing you have a team who is trained and experienced using SSIS.
  • When SSIS doesn't have exactly what you need you can use C# or VBA to extend its functionality.
Anonymous | TrustRadius Reviewer

Cons

Microsoft BI

  • 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 | TrustRadius Reviewer

SSIS

  • SSIS memory usage can be quite high particularly when SSI and SQL server are on the same machine
  • SSIS is not available on any environment other than Microsoft Windows
  • SSIS does not function with any database engine back-end other than Microsoft SQL Server
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Microsoft BI

Microsoft BI 8.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 | TrustRadius Reviewer

SSIS

SSIS 9.5
Based on 3 answers
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
Luca Campanelli | TrustRadius Reviewer

Usability

Microsoft BI

Microsoft BI 7.0
Based on 5 answers
Usability is great. This product will make most feel right at home. I feel like this question should be asked from two points of view:1. Creator of reports, Data Models, Views etc: Most Advanced users will still rate the usability as very high. Its capabilities are still robust. However when compared to other Enterprise Class products it will not do many of the advanced application queries. 2. End user, Consumer: All end users will feel right at home. Many will be able to create connections to already created data models and other external publicly available sources like twitter, Facebook, World Health order etc... These connections are then in turn very very easily available to publish to SharePoint and Power BI. It took me a while to understand what I think is Microsoft's strategy. This will handle all but the most of robust needs. Much like many American made cars and my favorite Corvette, Microsoft is fast, has it own break downs from time to time but all of these are really to tolerate when the price is considered and the next one up that can out perform it is three to four times as much money makes this an easy one to still recommend
Sean Warren | TrustRadius Reviewer

SSIS

SSIS 8.8
Based on 8 answers
If you use any of the Microsoft tools, it is easy to get using and understand since it uses Visual Studio and SSMS to work with. There are extensions you can get and some of those can be difficult to work with but usually they slide in nicely. The one thing to understand though is there is some installation and configuration on the SQL Server side that can take some time.
Steven Gockley, MBA, MCSA | TrustRadius Reviewer

Reliability and Availability

Microsoft BI

Microsoft BI 9.5
Based on 2 answers
The product has been reliable.
Robert Goodman | TrustRadius Reviewer

SSIS

No score
No answers yet
No answers on this topic

Performance

Microsoft BI

Microsoft BI 7.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 | TrustRadius Reviewer

SSIS

SSIS 8.4
Based on 6 answers
You can, of course, accidentally make sloppy code or workflows but it’s not a tools issue if you run packages in an inefficient way. With a company of our size, we never had any performance issues but I can imagine for larger companies that this will have a greater focus.
Anonymous | TrustRadius Reviewer

Support Rating

Microsoft BI

Microsoft BI 7.1
Based on 6 answers
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.
Jacob Saunders | TrustRadius Reviewer

SSIS

SSIS 8.5
Based on 7 answers
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
Chris Morgan | TrustRadius Reviewer

In-Person Training

Microsoft BI

Microsoft BI 6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice | TrustRadius Reviewer

SSIS

No score
No answers yet
No answers on this topic

Online Training

Microsoft BI

Microsoft BI 8.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 | TrustRadius Reviewer

SSIS

No score
No answers yet
No answers on this topic

Implementation Rating

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
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.
Jacob Saunders | TrustRadius Reviewer

SSIS

SSIS 10.0
Based on 1 answer
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Luca Campanelli | TrustRadius Reviewer

Alternatives Considered

Microsoft BI

Microsoft BI is a great tool when it comes to various integration with line of business applications and its own ecosystem which contains office applications widely used all over the world. Hence, it is well suited for organizations that are complex and have global foot-print. It is also well suited for Power Users who may not have deep technical knowledge but familiarity with day-to-day applications such as word, excel etc...Tableau, Spotfire, Apptio and other tools are much better suited for web-friendly visualizations and for smaller organizations.
Ved Mishra | TrustRadius Reviewer

SSIS

Look for where you are going to load the data and from where are you extracting it. A lot of those who sell you the DB already have tools for ETL. I have heard good things at an enterprise level from great colleagues about Informatica, but honestly, I prefer SSIS.Although I did like TIBCO Jaspersoft and it can be mixed with TIBCO Spotfire for data analysis. If your ERP is SAP, then you must keep in mind using SAP BusinessObjects. As for free tools, and if you have a great and constant team of scripting (Perl, Python) engineers, then you can think about going open source.
Jose Pla | TrustRadius Reviewer

Return on Investment

Microsoft BI

  • Business users easily learned self service BI with training and what to do and what not to do with self service BI
  • Learning curve for Powerpivot and other office 365 tools for IT team who already knew about data warehousing concepts is steep
Anonymous | TrustRadius Reviewer

SSIS

  • I use SSIS to automate tasks that I'm repeatedly asked to do. "Hey, can you go into the system and close any open orders that we've fully filled?" Sure....then I schedule a package to do that for me every hour so I'm never asked again. It saves me time, which gives value to the company.
  • It removes the risk of human error. When people build files and send them, there's the risk that it doesn't happen the same way every time or gets forgotten. With SSIS, you spend some up front time building a process, but then you deploy it and forget it (unless it emails you that there was an error. You are putting error handling in your ETL, right?). Very repeatable and consistent business solution.
Greg Goss | TrustRadius Reviewer

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

Edition
Power BI$0
Power BI Pro$102
  1. per user per month
Additional Pricing Details

SSIS

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

SSIS Editions & Modules

Additional Pricing Details

Rating Summary

Likelihood to Recommend

Microsoft BI
8.4
SSIS
8.7

Likelihood to Renew

Microsoft BI
8.0
SSIS
9.5

Usability

Microsoft BI
7.0
SSIS
8.8

Reliability and Availability

Microsoft BI
9.5
SSIS

Performance

Microsoft BI
7.0
SSIS
8.4

Support Rating

Microsoft BI
7.1
SSIS
8.5

In-Person Training

Microsoft BI
6.9
SSIS

Online Training

Microsoft BI
8.5
SSIS

Implementation Rating

Microsoft BI
9.6
SSIS
10.0

Add comparison