What users are saying about
5 Ratings

Microsoft BI

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

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
613 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

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.
Marc Gilbert profile photo

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

Feature Rating Comparison

BI Standard Reporting

1010data
Microsoft BI
7.8
Pixel Perfect reports
1010data
Microsoft BI
7.6
Customizable dashboards
1010data
Microsoft BI
7.9
Report Formatting Templates
1010data
Microsoft BI
7.8

Ad-hoc Reporting

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

Report Output and Scheduling

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

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

1010data
Microsoft BI
8.1
Responsive Design for Web Access
1010data
Microsoft BI
8.0
Dedicated iOS Application
1010data
Microsoft BI
8.3
Dedicated Android Application
1010data
Microsoft BI
8.0
Dashboard / Report / Visualization Interactivity on Mobile
1010data
Microsoft BI
8.2

Application Program Interfaces (APIs) / Embedding

1010data
Microsoft BI
7.9
REST API
1010data
Microsoft BI
8.1
Javascript API
1010data
Microsoft BI
8.3
iFrames
1010data
Microsoft BI
7.9
Java API
1010data
Microsoft BI
7.2
Themeable User Interface (UI)
1010data
Microsoft BI
8.2
Customizable Platform (Open Source)
1010data
Microsoft BI
7.7

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
Marc Gilbert profile photo
  • 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

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • 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

Likelihood to Renew

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

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
Microsoft BI7.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 profile photo

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.
Robert Goodman profile photo

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.
Robert Goodman profile photo

Support

No score
No answers yet
No answers on this topic
Microsoft BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo

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.
Stephanie Grice profile photo

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.
Sean Brady profile photo

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.
Robert Goodman profile photo

Breadth of Deployment

No answers on this topic
It's deployed in departmental and company-wide implementations through our customer base. In the global 2000, we typically find either Microsoft or SAP as the corporate standard. There is probably a bit more SAP than Microsoft out there, particularly for ROLAP implementations. When MOLAP is leveraged, there are more Microsoft customers.
Lee Cullom profile photo

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
Looking at the visualization portion of BI, there are three types of tools.
  1. Programming packages. Free and powerful, they let you make any diagram, at the cost of difficulty of use.
  2. Specialist software like Tableau and Microsoft BI. This is the best choice in most cases due to ease of use and quality of output.
  3. More generic software offered by the big IT companies, often part of a BI suite. There's really a lot of variety here. Use this when it fits the workflow and you are already using the relevant software. But, personally, I'd still use the specialist software.
Alexander Lubyansky profile photo

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Microsoft BI8.3
Based on 32 answers
The way it works is that the analyst/developer/report creator builds the report and publishes it to the report server. From there, anyone who is given access to the report (which is synched up with Active Directory for authentication) can view the report and download a copy of the report. When you download a copy of the report itself (not a PDF or XLS of the report but the report definition file) it actually will download the application (Report builder) along with the report definition file. From here you can edit the definition, share it with others etc. Access control is very simple because of how it synchs up with Active Directory
Mashhood Syed profile photo

Data Integration

No score
No answers yet
No answers on this topic
Microsoft BI8.4
Based on 31 answers
I can only speak about the data source we used which was SQL Server. That worked flawlessly. I really am not sure how the application works when you connect it to any other data source or when you merge data (or if thats even possible).
Mashhood Syed profile photo

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.
Marc Gilbert profile photo
  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.
Nathan Patrick Taylor profile photo

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