What users are saying about

1010data

5 Ratings

Microsoft BI

576 Ratings

1010data

5 Ratings
Score 4.7 out of 101

Microsoft BI

576 Ratings
Score 7.9 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.7
Pixel Perfect reports
1010data
Microsoft BI
8.7
Customizable dashboards
1010data
Microsoft BI
8.6
Report Formatting Templates
1010data
Microsoft BI
8.6

Ad-hoc Reporting

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

Report Output and Scheduling

1010data
Microsoft BI
9.1
Publish to Web
1010data
Microsoft BI
9.2
Publish to PDF
1010data
Microsoft BI
9.0
Report Versioning
1010data
Microsoft BI
9.1
Report Delivery Scheduling
1010data
Microsoft BI
9.1
Delivery to Remote Servers
1010data
Microsoft BI
9.0

Data Discovery and Visualization

1010data
Microsoft BI
9.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
1010data
Microsoft BI
9.4
Location Analytics / Geographic Visualization
1010data
Microsoft BI
9.1
Predictive Analytics
1010data
Microsoft BI
8.6

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

1010data
Microsoft BI
9.1
REST API
1010data
Microsoft BI
9.2
Javascript API
1010data
Microsoft BI
8.8
iFrames
1010data
Microsoft BI
9.3
Java API
1010data
Microsoft BI
8.7
Themeable User Interface (UI)
1010data
Microsoft BI
9.3
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
  • Wide variety of tools : Microsoft BI possesses a wide variety of tools to cater needs of presentation, performance caching, integration and ease of use.
  • Popular online and location communities : Online and local communities around Microsoft BI is very popular. You can find a lot of resources and helpful information online and within your communities more efficiently and effectively.
  • Tighter and broad integration options : Microsoft BI tools are very well integrated with other Microsoft products (Office 365, SharePoint, .NET Apps, Project Server etc...) and Line of Business (LOB) applications. Being a large player in BI domain, there are various third party components available which compliment MS BI.

Cons

  • The ten.do interface could use more detailed documentation
  • SQL Server Data Integration (also knows as SSIS) seems to provide most functionality you would expect from an ETL tool. However, when you start using it you quickly find out that most transformations perform slower than equivalent functionality when coded directly in SQL. So you go ahead with creating joins, using case statements and data type conversions directly in SQL input statements and potentially end up with a huge piece of code that performs nicely but is hardly maintainable in the future.
  • The development environment takes quite a while to get used to. Once you are all set up and doing your development work it is all fine but if you accidentally close some window or 'pane' just figuring out how to get it back can take quite some time.

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft BI8.0
Based on 25 answers
Assuming that I will continue to have a need to monitor and report on the operational aspects of the organization using transactional data, Microsoft BI is a solid choice. Its kind of like how you still have legacy applications that serve a strong need that is critical to the day to day operations. The fact that the tools are similar to stuff the users have already been using makes the adoption and buy in that much easier.

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
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.

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.
The major difference from the other competitors is its user-friendly screens (UX). You can get data very easily and you can design or query it.

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Microsoft BI8.5
Based on 26 answers
Security is very good with a lot of options, for sharing you need yet another solution on the visualization side, which makes another point where something might go wrong.

Data Integration

No score
No answers yet
No answers on this topic
Microsoft BI8.8
Based on 25 answers
The data is what really matters on a graphic presentation, and if I'm not allowed to edit or to update this data somehow it's like I'm cutting the progress I've been making and have to it do all over again. This is not a solution. On the other hand, the color and options to present graphics solutions are really nice but could be better. That's my goal.

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