What users are saying about

1010data

5 Ratings

Microsoft BI

593 Ratings

1010data

5 Ratings
Score 4.3 out of 101

Microsoft BI

593 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.
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
8.2
Pixel Perfect reports
1010data
Microsoft BI
8.2
Customizable dashboards
1010data
Microsoft BI
8.1
Report Formatting Templates
1010data
Microsoft BI
8.4

Ad-hoc Reporting

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

Report Output and Scheduling

1010data
Microsoft BI
8.7
Publish to Web
1010data
Microsoft BI
8.7
Publish to PDF
1010data
Microsoft BI
8.5
Report Versioning
1010data
Microsoft BI
8.8
Report Delivery Scheduling
1010data
Microsoft BI
8.8
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.0
Location Analytics / Geographic Visualization
1010data
Microsoft BI
8.8
Predictive Analytics
1010data
Microsoft BI
8.5

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

1010data
Microsoft BI
8.4
REST API
1010data
Microsoft BI
8.6
Javascript API
1010data
Microsoft BI
8.4
iFrames
1010data
Microsoft BI
8.4
Java API
1010data
Microsoft BI
8.3
Themeable User Interface (UI)
1010data
Microsoft BI
8.7
Customizable Platform (Open Source)
1010data
Microsoft BI
8.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
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
  • Report Builder 3.0 shipped with MSSQL 2012 is a nice free tool but our client users sometimes encounter problems such as the tool automatically shut down without saving the changes being made. We haven't implemented the new RB with MSSQL 2016 yet thus cannot comment on the latest version.
Haibo Yang 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
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.
Alexander Lubyansky 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
Quick response. Lots of blogs and support forums are there to get the answer myself
No photo available

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
Poorly adopted by users. Mostly caused by project priorities focused on technical aspect and not on reports and dashboards for final users.
Frederic Freyermuth ☁ 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.2
Based on 27 answers
You can publish dashboards or reports from the web or desktop versions in many ways. From the web side, you can distribute dashboards or reports over roll based, user based or user group. From the desktop side, you can distribute dashboards or reports by file (MS BI report file, MS Excel, MS Access, and other formats).
Celil ÇİYNEKLİ profile photo

Data Integration

No score
No answers yet
No answers on this topic
Microsoft BI8.7
Based on 26 answers
Data source integration is one of a key for any software. Microsoft BI works well integrating with microsoft related products. For other data source integration, the integration is not straight forward.
No photo available

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
  • 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
No photo available

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