What users are saying about

1010data

5 Ratings

Microsoft BI

559 Ratings

1010data

5 Ratings
Score 5.2 out of 101

Microsoft BI

559 Ratings
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.

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.

Feature Rating Comparison

BI Standard Reporting

1010data
Microsoft BI
8.4
Pixel Perfect reports
1010data
Microsoft BI
8.4
Customizable dashboards
1010data
Microsoft BI
8.5
Report Formatting Templates
1010data
Microsoft BI
8.4

Ad-hoc Reporting

1010data
Microsoft BI
8.5
Drill-down analysis
1010data
Microsoft BI
8.7
Formatting capabilities
1010data
Microsoft BI
8.3
Integration with R or other statistical packages
1010data
Microsoft BI
8.2
Report sharing and collaboration
1010data
Microsoft BI
8.9

Report Output and Scheduling

1010data
Microsoft BI
8.8
Publish to Web
1010data
Microsoft BI
9.0
Publish to PDF
1010data
Microsoft BI
8.8
Report Versioning
1010data
Microsoft BI
8.8
Report Delivery Scheduling
1010data
Microsoft BI
9.0
Delivery to Remote Servers
1010data
Microsoft BI
8.5

Data Discovery and Visualization

1010data
Microsoft BI
8.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
1010data
Microsoft BI
9.2
Location Analytics / Geographic Visualization
1010data
Microsoft BI
8.8
Predictive Analytics
1010data
Microsoft BI
8.3

Access Control and Security

1010data
Microsoft BI
9.0
Multi-User Support (named login)
1010data
Microsoft BI
8.9
Role-Based Security Model
1010data
Microsoft BI
8.9
Multiple Access Permission Levels (Create, Read, Delete)
1010data
Microsoft BI
9.4
Single Sign-On (SSO)
1010data
Microsoft BI
8.7

Mobile Capabilities

1010data
Microsoft BI
8.7
Responsive Design for Web Access
1010data
Microsoft BI
8.7
Dedicated iOS Application
1010data
Microsoft BI
8.8
Dedicated Android Application
1010data
Microsoft BI
8.5
Dashboard / Report / Visualization Interactivity on Mobile
1010data
Microsoft BI
8.7

Application Program Interfaces (APIs) / Embedding

1010data
Microsoft BI
8.7
REST API
1010data
Microsoft BI
9.0
Javascript API
1010data
Microsoft BI
8.3
iFrames
1010data
Microsoft BI
9.0
Java API
1010data
Microsoft BI
8.0
Themeable User Interface (UI)
1010data
Microsoft BI
9.0
Customizable Platform (Open Source)
1010data
Microsoft BI
9.0

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
  • 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.

Cons

  • The ten.do interface could use more detailed documentation
  • Visualization and presentation is an area that may need some improvement. I have used a competitive tool Tableau which has better visualization capabilities against Pivot Charts/Power BI.
  • For ultra large organizations, certain BI solutions require more volume of data to be processed. Although Microsoft Windows Azure, HDInsight and various other big data mechanism can cater to this need, other MS BI tools like Power Pivot, SharePoint etc... need to be more performance oriented.
  • Licensing is one aspect which is relatively more complex as compared to its competitors. Microsoft is now following subscription-model approach in a lot of areas but still there is a scope of improvement in providing more clarity and simplicity when purchasing MS BI tools.

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft BI8.0
Based on 25 answers
Flexibility and ease of use! I have not found something that I can't do with the Microsoft BI tools. Some things may be a struggle, but that comes with any tool. The online community support for developers and users of Microsoft is tops as well. If you have a problem you can post in the forums provided by Microsoft or just post on Twitter and you will get an answer from the experts in the field in no time. There is no better community out there for technology that is very supportive and will not bash you even for asking the most basic question. There are plenty of options for support that don't require you to contact Microsoft and that helps save a lot of dollars and time. The tools are keep up-to-date and are constantly evolving.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
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.

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft BI9.5
Based on 2 answers
The product has been reliable.

Performance

No score
No answers yet
No answers on this topic
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.

Support

No score
No answers yet
No answers on this topic
Microsoft BI7.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.

In-Person Training

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

Online Training

No score
No answers yet
No answers on this topic
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.

Implementation

No score
No answers yet
No answers on this topic
Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.

Breadth of Deployment

No answers on this topic
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.

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Microsoft BI provides the most flexibility and best integration across of the products in the SQL Server Microsoft BI Suite (and with other Microsoft tools). The tools are flexible enough to work just as well in a small group as they are in a large enterprise and without having to re-learn the products to fit those different scenarios. All of the tools in the SQL Server Microsoft BI stack are provided with one licenses (assuming you install everything on one server) and all of the development tools required are available for free if they they aren't included with the main installer. The Microsoft BI tools will work with most of the major database systems out of the box and if it doesn't, there is a very active 3rd party software environment that develops free or paid add-ons that will cover the options that Microsoft doesn't out of the box. The tools are easy to learn and use and updated on a very regular basis. There is always the flexibility to add or take away from the products installed as part of a Microsoft BI solution, so you never have to be locked into using only the tools provided by Microsoft.

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Microsoft BI8.3
Based on 25 answers
It is easy to export anything you build in Microsoft BI to Excel or other tools and then share it from there. With SSRS being a web based reporting tool, that makes it very easy to share reports with anyone that has access to the internet or the network. At this point the weak point in report accessibility is on tablets and smartphones, Microsoft is working to make all of their tools HTML5 compliant, but it is not there yet. Security for all of the tools is baked in and is easy to setup if you already have a Microsoft Active Directory infrastructure. If you are not using Microsoft Active Directory you can still enhance the tools to use your own security tools without a lot effort. I believe that in the very near future this rating will be a 10 as well, once all of the tools are supported on all platforms using established standards.

Data Integration

No score
No answers yet
No answers on this topic
Microsoft BI8.5
Based on 24 answers
There is no data that I have not been able to get with the Microsoft BI tools. The tools will accept flat files and access any database that has a way to query it, even if that is through a web API. If you need to get some data into a Microsoft BI solution, there is a way to do it. You can go down the custom development route if you have to, but in most cases there is someone else that has tried to do the same thing and shared their solution online for you to use. The Microsoft BI tools are used in so many different companies and scenarios that it is very rare these days that you are first one doing something. There is also the speed factor, depending on the source of the data I have run into more issues with the source systems not being able to keep up with the processing on the Microsoft BI side.

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
1010data Editions & Modules
1010data
Additional 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