What users are saying about
10 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
694 Ratings
10 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

Microsoft BI

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

Likelihood to Recommend

D3.js

D3.js is great for visualizing with medium and small size datasets. It's also great for prototyping visualizations quickly and sharing on the web so others can view it without having to install any software on their machines
Firaz Peer 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

D3.js
Microsoft BI
7.9
Pixel Perfect reports
D3.js
Microsoft BI
7.7
Customizable dashboards
D3.js
Microsoft BI
7.9
Report Formatting Templates
D3.js
Microsoft BI
8.2

Ad-hoc Reporting

D3.js
Microsoft BI
8.4
Drill-down analysis
D3.js
Microsoft BI
8.1
Formatting capabilities
D3.js
Microsoft BI
8.4
Integration with R or other statistical packages
D3.js
Microsoft BI
8.2
Report sharing and collaboration
D3.js
Microsoft BI
8.8

Report Output and Scheduling

D3.js
Microsoft BI
8.0
Publish to Web
D3.js
Microsoft BI
8.2
Publish to PDF
D3.js
Microsoft BI
8.5
Report Versioning
D3.js
Microsoft BI
7.9
Report Delivery Scheduling
D3.js
Microsoft BI
7.4
Delivery to Remote Servers
D3.js
Microsoft BI
8.2

Data Discovery and Visualization

D3.js
Microsoft BI
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
D3.js
Microsoft BI
8.4
Location Analytics / Geographic Visualization
D3.js
Microsoft BI
7.9
Predictive Analytics
D3.js
Microsoft BI
7.9

Access Control and Security

D3.js
Microsoft BI
8.3
Multi-User Support (named login)
D3.js
Microsoft BI
8.3
Role-Based Security Model
D3.js
Microsoft BI
8.0
Multiple Access Permission Levels (Create, Read, Delete)
D3.js
Microsoft BI
8.4
Single Sign-On (SSO)
D3.js
Microsoft BI
8.3

Mobile Capabilities

D3.js
Microsoft BI
8.2
Responsive Design for Web Access
D3.js
Microsoft BI
8.2
Dedicated iOS Application
D3.js
Microsoft BI
8.4
Dedicated Android Application
D3.js
Microsoft BI
8.1
Dashboard / Report / Visualization Interactivity on Mobile
D3.js
Microsoft BI
8.2

Application Program Interfaces (APIs) / Embedding

D3.js
Microsoft BI
7.8
REST API
D3.js
Microsoft BI
7.8
Javascript API
D3.js
Microsoft BI
8.3
iFrames
D3.js
Microsoft BI
7.6
Java API
D3.js
Microsoft BI
7.6
Themeable User Interface (UI)
D3.js
Microsoft BI
7.8
Customizable Platform (Open Source)
D3.js
Microsoft BI
7.5

Pros

D3.js

  • It provides multiple ways of visualizing data easily.
  • It is fast and light on system resources. It is built with JavaScript and visualizations can be easily hosted on the web across browsers.
  • It has a huge community backing it so it is easy to find people to help with whatever you're doing.
Firaz Peer profile photo

Microsoft BI

  • SSIS is by far the easiest and most efficient ETL (Extract, Transform & Load) tool available, after trying many different tools over the years there is no tool that is more flexible and easier to develop solutions with. What takes days/weeks or longer to setup in other tools can be done in at least half the time and perform better.
  • SSRS is one of the best web reporting tools available for companies of any size that doesn't require you to re-architect your entire existing database structure. SSRS can connect to all of the major databases and work with data from multiple of them all in the same report. For web reporting that needs to be up and running fast, but be secure and easy to develop on there is no better tool available today.
  • SSAS is for more in depth analysis of your data and it has the same capabilities as all other Microsoft tools to connect to multiple data sources and present the data to the user in standardized format. Most users will love that they can access so much of the companies data in Excel using the PivotTables that they probably already use today, but now you are controlling the data and know that it is the correct data. With the new Tabular capabilities in SQL Server 2012 and up it allows end users to help build the initial version of these complex data structures which can then be migrated over to IT to add security, automation and quality control to the final solution.
Steve Wake profile photo

Cons

D3.js

  • Has a steep initial learning curve.
  • It is slow when dealing with really large datasets.
  • Not great for making maps.
Firaz Peer profile photo

Microsoft BI

  • I have been disappointed in how all the front-end delivery tools have been centered around Excel and SharePoint. I understand it from a business sense but I much preferred the ProClarity interface as a stand-alone ad-hoc reporting tool. Many end-users are intimidated by merely mentioning pivot tables and therefore do not even try to create their own queries.
Stephanie Grice profile photo

Likelihood to Renew

D3.js

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 8.0
Based on 25 answers
Ease of use and amazing possibilities
Jerome Lambert, PhD profile photo

Usability

D3.js

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 7.0
Based on 5 answers
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.
Robert Goodman profile photo

Reliability and Availability

D3.js

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

D3.js

No score
No answers yet
No answers on this topic

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 profile photo

Support

D3.js

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 7.1
Based on 6 answers
Microsoft support in general is good, did not have any issues.
Boris Skylar profile photo

In-Person Training

D3.js

No score
No answers yet
No answers on this topic

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 profile photo

Online Training

D3.js

No score
No answers yet
No answers on this topic

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 profile photo

Implementation

D3.js

No score
No answers yet
No answers on this topic

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Alternatives Considered

D3.js

Protoviz does not require as much knowledge of programming to build visualizations as with D3.js or Google Charts. Highcharts or AnyChart are other alternatives that are more specific to building charts only
Firaz Peer profile photo

Microsoft BI

Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady profile photo

Return on Investment

D3.js

  • We've only used D3.js as a tool to learn data visualization and programming.
Firaz Peer profile photo

Microsoft BI

  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady profile photo

Pricing Details

D3.js

General

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

D3.js Editions & Modules

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

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

Add comparison