TrustRadius
Microsoft BI is great if you're looking for a BI product that feels like the other Microsoft products you useMicrosoft BI is used across many departments within the organization. Due to the availability of other software tools, Microsoft BI is only used in certain parts of the business. Microsoft Power BI is used for automated data reporting and interactive visualizations. The software is also used for some analytics processes.,As with most every other Microsoft product, Microsoft BI makes setting up and analyzing data about as easy as it gets. Creating graphics is very easy. Connecting to multiple data sources works just fine. Simple reporting and integration with other Microsoft products is great.,Microsoft BI is not top of the for advanced analysis and modeling. Reshaping and restructuring data is doable, but not super simple. Customizing visualizations is sometimes difficult to impossible.,8,Tableau Online, Tableau Public, Alteryx Analytics, TIBCO Spotfire, MicroStrategy Analytics, Microstrategy Usher, SAS Business Intelligence, SAS Advanced Analytics and SAS Data Integration Studio,9,8,Tableau Online, Tableau Public, SAS Business Intelligence, SAS Advanced Analytics, Alteryx Analytics, Microsoft SQL Server, MySQLMicrosoft BI - Putting the power into your reportingWe use Microsoft BI primarily just within our lab group and department due to its very specific and powerful data visualization capabilities. While it is applicable to almost any work involving data analytics, it might seem like overkill for some people. We have found that it does an excellent job in preparing and displaying the more complex data that we deal with.,Data display in graphs and tables Compatibility with other Microsoft products User-friendly and informative reporting,Data compatibility with non-Microsoft products Data sourcing functionality is poor Offline server functionality impedes out of country work,7,Torqus Systems POS, UltiPro, Sisense, Domo, Zoho Analytics, Dundas BI, Looker, Qualtrics, Infragistics ReportPlus, QlikView, Tableau Desktop, SAP BusinessObjects Business Intelligence (BI) Platform and IBM Cognos,5,9,Torqus Systems POS, UltiPro, Sisense, Domo, Zoho Analytics, Dundas BI, Looker, Qualtrics, Infragistics ReportPlus, IBM Cognos, SAP BusinessObjects Business Intelligence (BI) Platform, Tableau Desktop, QlikViewGood for visualisations and reporting!Microsoft BI is used by a few data teams in my organisation in conjunction with other business intelligence tools. One of the primary reasons for using Microsoft BI is its simplicity, user friendliness, and good palate of visualisation options. Unlike most other standard BI tools in the market, Microsoft BI does provide a good array of graphical representations - thereby making it a good choice for reporting purposes.,Good range of visualisation features. Very easy to setup and get onboard. Handles data integration from multiple sources decently well.,Not advisable to use Microsoft BI as a standalone primary tool for data management. The process of moulding or repurposing data is not easy. Integrating Microsoft BI with non-Microsoft tools is a huge pain.,7,Oracle Business Intelligence Cloud Service, Tableau Public and Looker,6,8,Looker, Tableau Server, Power BI For Office 365Great BI toolWe have been using a number of Microsoft products in our company and decided to go with the Microsoft BI platform due to its easy integration with Microsoft Office suite. We wanted to incorporate a business intelligence tool into our enterprise to get a full 360 view of our mission-critical data. Microsoft BI helped fill that role.,Report generation from our back end data warehouse has become way more streamlined using this tool. By using the Power Pivot and Power View it has enabled us to access and mash up data from a variety of sources. Plus it can easily be shared with other users through simple Office applications.,The implementation time for Microsoft BI can be fairly lengthy. It's definitely longer than some of the other products we evaluated. The upfront investment in terms of capital and time is fairly large with this tool. It requires a compliant Microsoft SQL server in the back end to leverage most of its functionality.,8,Oracle BI Foundation Suite,8,8,Adobe Advertising Cloud, Amazon DynamoDB, Amazon CloudFront, Amazon Elastic Compute Cloud (EC2), Amazon CognitoFor the IT professional on the goWe use it in various pockets across our organization. We use trend analytics, reports, and interactive dashboards all the time, but the real workhorse is the Marketing cost data aggregation toolkit. We also connect PowerBI with SQL integrated OLAP databases, enabling us to leverage data housed within SAP with extracted data to create visual dashboards to track various KPI metrics on a daily basis.,Microsoft BI allows us to combine data from multiple sources, build data models, create visualizations, and share the results. Cloud Interactive charts in a cloud that can be easily shared Connectors to popular data sources, allowing us to integrate with almost any system,More authentication methods to allow power users to connect directly to Web APIs. It can be quite difficult to setup without guided assistance from experienced users Limits on dataset size.,8,Google Analytics and IBM Cognos,8,8Microsoft BI is the program you've been waiting for!My company deals with a lot of data, and it is extremely important that we have an efficient, easy to use program with visually appealing outputs. Microsoft BI can do it all. We collect a lot of data in the field and have to look at trends in that data through time. After our own analysis, that all has to be presented to our clients who generally need self-explanatory figures. Microsoft BI has been a great program for us.,It is a very user-friendly interface! Doesn't take long to learn and be able to make some great graphs. The accessibility and sharing capabilities are beyond wonderful-- it has made it easy to share between employees before sending out final reports and it is easy to share with clients who need something to look at before the full report is finished. There are a lot of options for data display and they can be as complex or simple as you want and still look amazing. They have a great online resource for help and tutorials. If you don't catch on quickly on your own, it is quite easy to do some reading online and teach yourself.,The Microsoft BI app can be finicky at times and it would be great for that to be more streamlined. We sometimes require data to be shown during fieldwork, and a functional app makes a big difference. The program doesn't always remember my settings. This may just be a glitch with the program on my computer, but it would be a huge timesaver if I didn't have to reset my preferences every week.,10,Tableau Desktop, Keen IO, Domo, Qualtrics, Google Analytics and Google Analytics Premium,10,10,Qualtrics, WordPress, Blogger, Google Drive, Apple iCloud, Microsoft Access, Dropbox, Dropbox BusinessOutstanding Report CreatorSeveral people that I know use Microsoft PowerBI. It is mainly used for reporting for several teams, then I am able to access those reports for my own use. When I use it I import Excel sheets in, and use PowerBI to make them more visually appealing and easier to filter. It works like a charm. I have not seen any issues other than the occasional drag with data sets.,Makes reports more visually appealing Very good variety of formats for charting information Good cloud connectivity (most of the time),Need to be proficient with Excel before diving into PowerBI Only available with a monthly subscription Steep learning curve for many users (including me),10,Whatagraph,10,10,Microsoft 365 Business, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Cisco Aironet Access Points, Cisco Data Center Network Manager, Oracle VM VirtualBox, Oracle Java SE, DameWare Remote Support, Microsoft System Center Configuration Manager, Citrix NetScalerMicrosoft BI - A diamond in the roughData modeling, visualization, and analytics. Microsoft BI is currently only used for dashboarding (descriptive analytics), where data relationship is simple, while most of the predictive analytics are done in other tools.,Easy integration with other Microsoft products. Great integration with R/Python.,Map visualization limit on data count Inability to model data relationship with multiple non unique keys,7,TIBCO Spotfire,9,9,TIBCO SpotfireBusiness Intelligence like you never seen beforeMicrosoft BI is being used by specific departments, providing analysis of different types of data, how resources are being used and even showing how well Support Departments are doing, responding to tickets that are eventually fed to Microsoft BI. There are many problems being addressed, including allowing several types of connections to our data.,Allow many types of connections to our data Makes impressive graphics from the data collected Provides interactive resources and dashboards,Should have support for other operating systems Prices could be a bit better for organizations with more users,10,Zoho Reports,6,10,Microsoft 365 Business, Windows Server, Microsoft Exchange, SolarWinds Netflow Traffic Analyzer, Google Ads (formerly AdWords)Power BI just works!We currently have limited use of Power BI within our IT and accounting departments for relaying reporting information. We use Power BI to create an efficient interface for our executive team to gain access to vital sales information from our restaurants in a concise, detailed manner as opposed to our traditional Excel spreadsheets. IT uses Power BI to track purchasing as well as within our help desk department.,Great for translating numbers in graphics that are easy to understand and manipulate for anyone with no technical expertise,Additional training and tutorials that exist with Power BI as users are working with it would be beneficial.,9,9,8,Microsoft Office 365, Microsoft Dynamics GP, Windows ServerMIcorosft BI - Gather, share and take action on your dataMicrosoft BI is a great tool to allow for the visualization and communication of data to my whole team. Microsoft BI is being used in conjunction with many operational KPI's to better drive action and responses to improve or address issues that arise. The main problem solved by BI is the ability to gather and bring together information from multiple sources and unify this data.,Bringing data together from multiple sources Allows for graphical representation of data to improve communication up and down the management chain. Tracking of data for use in the future,Could be more user friendly Improve the learning curve for new users Allow for better integration with mobile app.,4,SAP Access Control,8,6,Microsoft 365 BusinessMultiple tools in single package.In my organization, we are using MSBI to create, maintain and deploy reposts. We use all three component of MSBI like SSIS, SSRS, SSAS. We use ETL packages to maintain Dataware hosts using SSIS. We create reports using SSRS and analyze the data using the SSAS tool,Create packages to move data and perform different data related tasks using SSIS Create reports to summarize the data in an understandable form using SSRS Analyze the data provided by teams and create data cubes and reports to understand the data properly using SSAS.,It should be an open source tool for a vast variety of implementation. You need to buy a licensed server to maintain MSBI Need a proper course or content to learn concepts, which sometimes creates difficulty.,8,Pentaho, WebSphere DataPower Gateway and Informatica Enterprise Data Integration,8,8,Microsoft Office 2016, Pentaho, Skype for Business (formerly Lync)A Very Powerful and Innovative BI and Virtualization Tool: MS BIPower BI is a dashboard, data query and, data modeling tool. You can report your data as quickly and easily as with other competitors. With machine learning ability you can easily query, model and report your data. With the AI supported insight ability, you can drill down to the problems. If you want more analyzing tools, you can do it with the R scripts in Power BI.,User experience (UX) is the top priority for Microsoft in Power BI. It has incredible abilities to query data from the source, such as machine learning. Query, design, and reporting is in one tool. There is no need for additional tools. It can get data from all resources, even in the reporting frame structure. There is no need for a table structure anymore. If you have unstructured data in any resource, machine learning can recognize/learn how to capture it and get data as you wish. If a data requires editing with some Excel operator (mid, left, find, etc), you no longer need to write any command. Power BI is doing it for you with machine learning technology. You just give some example about what you need in data and it recognizes/ learns how to get it and then populate it. Power BI has a lot of dashboard charts, very different range, very different purpose and you can find what you need. Charts look so pretty and configuration is so easy too. If you want to create a report (using a chart), you can type what you need while you are talking to a friend. Power BI creates it simultaneously as you are writing.,Actually, there is one thing I can say. If you are working with huge data, depending on your computer configuration and only with the desktop (free) version, it is a little bit slow.,10,QlikView, SAP BusinessObjects Business Intelligence (BI) Platform and Tableau Desktop,10,10,Micro Focus PPM (formerly HP PPM), Xmind, SAP Analytics CloudMicrosoft Business Intelligence is a quick and cheap way to start practicing with data visualization.Microsoft BI is currently being used across the organization by all departments who have staff interested in tapping the hidden value of their data. It allows users to create their own queries and visualize them without a large time investment to learn the software. Ad hoc reporting is easier to accomplish using MS BI than some of the other data mining software out there.,Easy to learn the software. Allows complex queries to be created ad hoc and ran against databases quickly. Gives the users the ability to empower their departments by setting up easy to implement visualizations.,Understanding the full scope of the software takes a lot of time. It doesn't handle very large datasets well, importing can take a while. I have not found a way to build scheduled reports.,9,Microsoft SQL Server and MS SharePoint,7,8,Microsoft SQL Server, MS SharePointPower BI will put an S on your chestIt is currently being used at a program level by project controls to provide project performance data to the project team. Engagement with Power BI allows the different stakeholders for the project to engage with performance data providing them the opportunity to be more responsive to issues and opportunities. It keeps everyone that is a part of the project on course and helps drive collaboration with the team members.,The layout of Power BI is very intuitive. Someone that is familiar with Excel and working with Charts and Graphs in that environment will find the learning curve a rather short one to start using Power BI. I like the way Power BI fits an assortment of users and how the functionality that you engage is replicated in Excel, that being Power Query and Power Pivot. So what you learn in one tool can be readily applied towards the other which allows you to more effectively apply your training. I appreciate how Microsoft is working to develop tools that go a long ways to empowering the end user. Prior to Power BI I would have had to consult with a "BI" professional to develop a dashboard. With Power BI I don't have to consult with anyone, I can work to put together the dash board I want and using a tool set that is really robust and allows me to engage an enormous amount of data. It's provides a great deal of flexibility and the types of data I can connect to. Updates...Microsoft is working diligently to keep Power BI current with monthly updates. They do a really good job of listening to the end user, if there is functionality not currently present just give them a month or so. Just to be clear, even though it's easy to get going right out of the gate with Power BI it provides plenty of opportunities to create some really sophisticated reporting solutions. With DAX in Power Pivot and M language in Power Query, you are provided with plenty of head room to do some really amazing things in Power BI. Training...there are resources across the web for learning and growing your skills and Power BI. And what's even better is the majority of those resources are free. Data engagement, when presenting the data to the end user Power BI goes a long way to allowing that end user to engage the data and begin to identify root cause by simply interacting with the graph/chart/data set. It allows for really fluid engagement. Prior to Power BI so many times during the presentation of data we often times ended the engagement with that data with more questions than what were answered. With Power BI, more often than not, the end user is able to get answers to the questions by simply clicking on the data in the graph/chart/dataset to see the details. This tool really does have the capacity to make you look like a rock star.,The desktop version is free, monthly updates, free training resources...what's not to love. I'm sure that someone with a higher degree of technical learning will be able to better articulate some negatives for Power BI, I'm just not that guy. I have nothing but appreciation for Power BI.,10,10,10Ideal for Data Analytics and Visualization, but not for noobsWe use Microsoft Power BI for one of our client's project data management. He has a database of mobile app users who sign up for the premium account and Power BI is used to analyze the data and build a graphical representation of the given data, which is very convenient when you need to create a presentation or something (or simply want to see your data presented visually.),Data analytics features - you can filter the data according to a billion (it feels like) ways and make sure your data is just what you need. Graphs, charts, and everything else visual - not only you can analyze your data according to filters and everything, you can also make it look good and understandable without having to look through a ton of numbers. It can handle quite large amounts of data input, so this makes it a good addition for the projects that require big data. Works well with other Microsoft products (including .NET projects).,It's not very user-friendly (at least, not if you use it every single day and can tell where a feature is located when you wake up in the middle of the night). It takes some time to get the hang of it. Sometimes it feels like there is just a bit TOO MANY features. I mean, they are all awesome, but it's easy to get lost.,8,9,7Microsoft BI - Good choice for departmental deployments and limited budgetMicrosoft BI is being used as part of a departmental implementation, especially for self-service capabilities. We build our solutions using different Microsoft BI components or tools such as Reporting Services, Integration Services, and Power BI Report Server.,Self Service Capabilities Easy to use Integration with MS Office,Data Quality Capabilities Performance issues in Power BI with some source systems Data Governance features,8,Microsoft SQL Server,7,7,IBM Cognos, MicroStrategy AnalyticsGreat Graphics presentationsThe software is being used as a way to develop different outputs graphics for different analysis and solves problems that I and my collaborators take from field surveys for planning new strategies in order to preserve nature and biodiversity in our territory. The people that use this software are me with the data being stored in Excel sheets.,The customized colors and presentation Introduces Excel data for graphics Innovate the way we used the data and new elements for analysis,Printable graphics is a must The whole concept of the presentation for a company is missing Is not easy make changes to the graphics,7,Tableau Desktop,8,8,QlikViewMicrosoft BI - Advanced SurveysMicrosoft BI is being used in a department to manage Advanced Surveys. It served as a gateway to developing the reporting system for the administrators of the department doing the said surveys.,Easy to use. Integration with other systems. Quick development.,More advanced reporting options. Reporting tools interface update. Drag and drop functionalities improved.,9,Microsoft SQL Server,10,9,OutSystems, SQL Server Business Intelligence Manager, Microsoft SQL ServerIt's Excel for Big Data. So easy, so cheap, so fast, and powerful enough most everything.Microsoft BI is, and seemingly shall be, the "BI Tool Of Tomorrow" forever. There are few people using it at my organization. In general, whenever I tell technically savvy people in the analytics/consulting space that there's a free visualization tool in Microsoft Excel that's 90-95% as good as Tableau, they are like "What?!" Then, they forget all about it in favor of expensive clunky tools and straight up coding. Microsoft BI is a many-times-relabelled tool for visualization and lite analytics. It's like super duper Pivot Tables and Pivot Charts that let you work with big data. As an analytics tool per se, it's as good as Excel since it is Excel. I wouldn't do any analytics heavy lifting with it personally, but you can easily do algebra stuff and make derived variables. The real business benefit is visualization. It's just very easy and powerful.,EASY visualization of business data. Excel is the killer app so anybody remotely good at basic office tools knows how to make PivotTables and PivotCharts. If you don't, it's really easy to learn; give it a try... People think big data visualization is hard but it's not for most business use cases. FAST visualization of business data. There are BI/Analytics tools out there, some of them beginning with the letter S, that are slooow. I do my taxes waiting for them to run basic queries/filters/charts. Microsoft BI (and Tableau, etc.) create compact data models to allow for pretty fast data loading and slicery. FREE or at least REALLY CHEAP visualization of business data. Who has MS Office on their business computer? Oh, everybody. If you don't have Office Pro, pony up for that or get the monthly license. The bigness of data you can run on your own machine is fairly big; don't use cloud if you don't need it. By comparison, who enjoys throwing thousands of dollars away on bloated legacy BI software? Well, too many companies, apparently.,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.,10,Tableau Desktop, Google Analytics, Google Charts, SAP Crystal Reports, SAS Visual Analytics, SAS Analytics, QlikView and D3.js,Tableau Desktop, Anaconda, Google Drive,8,7,20,,Familiarity. It's Excel. It's a spreadsheet. Come on. Thinking in matrices (PivotTables) takes a little getting used to, but it's not hard. For people without a good high school math background, it may seem unintuitive. Charts and PivotCharts are fairly easy, but Microsoft has a ways to go to make them less ugly.,Data source connections. It's sometimes difficult to replace and update connections. Dropping certain types of fields into the Pivot Table (example: default aggregation type for values). The weird interface. Microsoft tried to have it both ways by using the standard Excel interface for some tasks, and the "Power" interface for others. It's just awkward, cumbersome, and confusing.,7Microsoft BI is the perfect Dash-boarding productCurrently, Microsoft BI is used across entire organization for production performance and other performance KPIs.,Drill down function from higher level to more granular levels work perfectly, other products do not provide this functionality User-friendly graphics Data access is almost instant,Charts configuration are not so easy Database table connections are not so straight forward Requires too much hardware power,9,TIBCO Spotfire,TIBCO Spotfire,6,10Microsoft BI is Worth a Look for Business IntelligenceI use it to analyze data from our CRM.,Connections to third parties is really nicely done. Graphically it is a clean experience with nice color screens Integration with Microsoft products is tight.,They need a lot more tutorials. Using the application is not very intuitive so better training would help greatly.,7,Tableau Desktop,Join.me, Fonality, MindManager,10,6Intelligent big boy Microsoft BIMicrosoft Business Intelligence (MS BI) is integral part of our technology eco-system across whole organization. Various tools of the MS BI stack are used to Extract Transform and Load (ETL) data from various data sources and provide and platform to do analytics using pivot tables, pivot charts, power BI, SharePoint, SSRS reports, BI Semantic Model (BISM) reports etc.,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.,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.,10,Tableau, Spotfire and Apptio Technology Business Management,Tableau Server, Apptio Technology Business Management, TIBCO Spotfire Cloud Unpublished,8,7Microsoft BI platform good for Reporting but always changing for the rest of the toolset so use caution for your needs.Our entire organization, W.B. Mason, uses Microsoft BI for reporting. Putting critical and up to date data in the hands of our sales people and managers making decisions is critical in the changing market place of Office Supplies.,SSRS Reports allows browser based access on multiple mobile devices to reports and dashboards quickly,Focus their strategy on what is offered for the toolset. I believe they are starting to clarify this. Creation of and deployment of new reports is difficult for your average end user who doesn't use Visual Studio.,7,,10,9Microsoft BI ReviewMicrosoft BI is used mainly for visualizations and dashboards,Pivot tables Charts Dashboards,Interactive mapping Web publishing of dashboards USer access,8,Tibco Spotfire Platform,TIBCO Spotfire,8,8
Unspecified
Microsoft BI
677 Ratings
Score 8.0 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Microsoft BI Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Microsoft BI
677 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.0 out of 101
Show Filters 
Hide Filters 
Showing 38 of 677 Microsoft BI ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-25 of 38)

  Vendors can't alter or remove reviews. Here's why.
Thomas Young profile photo
February 17, 2019

Review: "Microsoft BI is great if you're looking for a BI product that feels like the other Microsoft products you use"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

9
I have yet to run across a data source that Microsoft BI can't connect to. Microsoft BI easily connects to JSON, SQL, and pretty much every other data source. The software is not the best at merging data from disparate sources. It takes some time to get things up and running with different data sources. Real-time updating of Microsoft BI visualizations is probably one of the best BI tools out there. Works just fine.
Read Thomas Young's full review
Shelby Bowden profile photo
January 23, 2019

Review: "Microsoft BI - Putting the power into your reporting"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

5
I think Microsoft BI firmly sits in the average zone for data sourcing. It does very well when sourcing data from Microsoft-related products, but begins to falter when dealing with other, non-Microsoft analytical programs. Anything with Microsoft cloud works great, and if your organization solely runs on Microsoft products, this is a great program.
Read Shelby Bowden's full review
No photo available
March 19, 2019

Microsoft BI Review: "Good for visualisations and reporting!"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

6
Data source connectivity is one of the weak points of Microsoft BI. When compared to other standard business intelligence tools like Oracle Business Intelligence Cloud Service (OBICS) or Tableau which comfortable allow data integration from across multiple sources, Microsoft BI falls behind on that front. Microsoft BI does support real time data streaming, but it is below par in terms of that capability.
Read this authenticated review
No photo available
February 05, 2019

Microsoft BI Review: "Great BI tool"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
Microsoft offers lots of data connectivity capabilities. It has enterprise software drivers for easy integration with a wide variety of data sources including LDAP, Oracle, SAS etc.
Read this authenticated review
No photo available
January 23, 2019

Microsoft BI Review: "For the IT professional on the go"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
The ease of combining data from multiple, non-integrated programs into a single environment where reports can be easily designed and managed is a wonderful ability. The mobile application is also very useful for the IT professional on the go. Lastly, the visualization tools come in quite handy when trying to explain complex scenarios to middle management.
Read this authenticated review
No photo available
January 23, 2019

Review: "Microsoft BI is the program you've been waiting for!"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
Mircosoft BI makes it very easy to bring in data from multiple sources and compile them into a single format that is ready for analysis. It has been a refreshingly easy process to learn and allows data importing from multiple sources and processes things very quickly. They also allow quite a wide range of data sources so you don't have to reformat or adjust documents before importing.
Read this authenticated review
Michael Timms profile photo
January 17, 2019

Microsoft BI Review: "Outstanding Report Creator"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
I use PowerBI to edit reports that I have already ran and make them look awesome. Microsoft PowerBI is perfect for this, as all I have to do is import my Excel spreadsheet, apply a template, and edit the document until I make it look how I want. PowerBI makes it super easy to do this.
Read Michael Timms's full review
Jean Franco profile photo
January 09, 2019

Microsoft BI Review: "Business Intelligence like you never seen before"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

6
There are several formats of data sources allowed and also possibilities to import. But for the real-time data sources, there are only specific sources supported, most of them being Microsoft Products. Unlike other rival products where there are a bigger variety of real-time data sources.
Read Jean Franco's full review
Brian Caulfield profile photo
October 19, 2018

Microsoft BI Review: "MIcorosft BI - Gather, share and take action on your data"

Score 4 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
I really like how Microsoft brings data from multiple sources together. I think this is one of the strengths of the software allowing for a more complex accumulation of data and information. This results on more complex analysis but again Microsoft BI does a superb job at making this complex data easy to interpret and take action on.
Read Brian Caulfield's full review
Celil ÇİYNEKLİ profile photo
September 07, 2018

Microsoft BI Review: "A Very Powerful and Innovative BI and Virtualization Tool: MS BI"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
Microsoft BI uses the Machine Learning tool when gathering data from the web. It can detect page elements and learn what you want to get then find itself a way to get this data.
Read Celil ÇİYNEKLİ's full review
No photo available
December 07, 2018

Microsoft BI Review: "Microsoft Business Intelligence is a quick and cheap way to start practicing with data visualization."

Score 9 out of 10
Vetted Review
Verified User
Review Source

Data Integration

7
Microsoft BI allows for a large number of data sources to be imported and worked with easily. The data can be pulled real time or from a warehouse depending on the customer requirements. We did not pull data from a large number of disparate sources but multiple SQL databases can be connected to easily.
Read this authenticated review
Jason Leidig profile photo
June 19, 2018

Microsoft BI Review: "Power BI will put an S on your chest"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
Power BI allows you to connect to a wide range of data sources from Excel workbooks, to enterprise solutions such as SAP, Azure, IBM systems and a myriad of online solutions like Facebook and GitHub and the list of connections is growing rapidly.
Read Jason Leidig's full review
Zee Gimon profile photo
July 14, 2018

Microsoft BI Review: "Ideal for Data Analytics and Visualization, but not for noobs"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

9
Microsoft Power BI offers a good set of data sources - anywhere from Excel / CSV to JSON to Azure databases. For our client's project, we use the Azure database (the backend of the project is written using .NET) and it's quick and convenient - you simply login and ta-da, you have all your data to manage.
Read Zee Gimon's full review
Gonzalo Angeleri profile photo
April 09, 2018

Review: "Microsoft BI - Good choice for departmental deployments and limited budget"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

7
Microsoft BI supports a variety of different data sources such as SQL Server, Oracle DB, DB2, Sybase, Excel, Access, Text files, MySQL, Teradata, Amazon Redshift, Azure SQL Database, Azure SQL Data Warehouse, Impala, SAP Business Warehouse, SAP Hana.
Read Gonzalo Angeleri's full review
Yemsi Pino profile photo
May 03, 2018

Microsoft BI Review: "Great Graphics presentations"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
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.
Read Yemsi Pino's full review
Alexander Lubyansky profile photo
August 07, 2016

Microsoft BI Review: "It's Excel for Big Data. So easy, so cheap, so fast, and powerful enough most everything."

Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
It's pretty good in terms of range of data sources, the ability to pull from both databases and the hard drive, and the way it compacts/autoformats data. There is still room for improvement in terms of access speed and smarter data formatting.
Read Alexander Lubyansky's full review
Ved Mishra profile photo
February 19, 2016

User Review: "Intelligent big boy Microsoft BI"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
Microsoft BI tools can connect to various data sources using ODBC, OData protocols. There are options to connect a range of data sources like Oracle, SQL, IBM DB2, Teradata, Sybase, Informix, Text file and data various other feeds. BI reports can bring data from various data sources and separate data connection. All data is alike once it is imported/connected and available in data-model.
Also, tools and solutions can be modified to fetch data real-time. Minimum download strategy ensures and tool is responsive to latest data changes in the back-end.
Read Ved Mishra's full review
Deanne Damato profile photo
February 12, 2016

Review: "Microsoft BI platform good for Reporting but always changing for the rest of the toolset so use caution for your needs."

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
We are standardized on SQL as a platform so connecting databases and data warehouse cubes is extremely easy. The only other data we strive to connect to is data is SharePoint lists and that is easy as well.
Read Deanne Damato's full review

Feature Scorecard Summary

Pixel Perfect reports (30)
7.8
Customizable dashboards (36)
7.9
Report Formatting Templates (34)
8.2
Drill-down analysis (32)
8.2
Formatting capabilities (36)
8.4
Integration with R or other statistical packages (29)
8.2
Report sharing and collaboration (36)
8.9
Publish to Web (33)
8.3
Publish to PDF (32)
8.8
Report Versioning (29)
8.1
Report Delivery Scheduling (33)
7.5
Delivery to Remote Servers (14)
8.2
Pre-built visualization formats (heatmaps, scatter plots etc.) (35)
8.4
Location Analytics / Geographic Visualization (32)
7.9
Predictive Analytics (31)
8.1
Multi-User Support (named login) (34)
8.4
Role-Based Security Model (31)
8.1
Multiple Access Permission Levels (Create, Read, Delete) (34)
8.5
Single Sign-On (SSO) (15)
8.4
Responsive Design for Web Access (25)
8.2
Dedicated iOS Application (20)
8.4
Dedicated Android Application (20)
8.1
Dashboard / Report / Visualization Interactivity on Mobile (26)
8.2
REST API (12)
7.9
Javascript API (13)
8.3
iFrames (12)
7.7
Java API (11)
7.6
Themeable User Interface (UI) (11)
7.8
Customizable Platform (Open Source) (9)
7.5

About Microsoft BI

Microsoft BI benefits from the ubiquity of SQL server and the set of tools built around the database, including an ETL layer, master data management, data cleansing, report and reporting.

The reporting engine is SQL Server Reporting Services which does not have the visualization capabilities of  visualization tools like 
Tableau or Qlik. Excel has historically been the platform visualization tool. Power BI for Office 365 has done much to improve the discovery and visualization capabilities of Excel.

Microsoft  now offers Power BI cloud as the visualization platform with geospatial 3D, natural-language query generation, and self-service ETL along with charting and other data visualizations that can be uploaded and shared through the Power BI service. 

The Power BI platform also provides  live access to on-premises Microsoft SQL Server instances, and self-service access to third-party cloud sources including Salesforce, Marketo, Zendesk, and GitHub. Mobility is supported through a native iPad app, an iPhone app.

This new platform is viewed by Microsoft as a visualization layer sitting on top of their earlier generation of installed SQL-based technology.

Microsoft BI Competitors

Pricing

Does not have featureFree Trial Available?No
Has featureFree or Freemium Version Available?Yes
Does not have featurePremium Consulting/Integration Services Available?No
Entry-level set up fee?No
EditionPricing DetailsTerms
Power BI$0
Power BI Pro$10per user per month

Microsoft BI Technical Details

Deployment Types:SaaS
Operating Systems: Unspecified
Mobile Application:No