Overview
What is Microsoft BI (MSBI)?
Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
Multiple tools in single package.
"Microsoft BI is a powerful analytic tool for large data sets."
In the world of data visualization, this is one of the best virtualization tools
"Easy To Use BI Platform With Effective Reporting"
Microsoft BI
Microsoft BI: The only data analysis tool you will ever need
MSBI - Bang for the Buck
A smart tool for data analysts to generate awesome reports
Excellent BI Stack for an all-in-one solution architecture, however may need specialized platforms for non-traditional datasets
Powerful tool for data visualization
Best when used by larger companies in a predominantly Microsoft environment
Microsoft PowerBI unleashes the power of your data
Microsoft BI the killer data analytics and visualization tool
Casual User’s POC
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Report sharing and collaboration (49)8.989%
- Report Formatting Templates (47)8.989%
- Formatting capabilities (49)8.080%
- Customizable dashboards (49)8.080%
Reviewer Pros & Cons
Pricing
Power BI Pro
$9.99
Power BI Premium
4,995
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Features
BI Standard Reporting
Standard reporting means pre-built or canned reports available to users without having to create them.
- 9Pixel Perfect reports(42) Ratings
Pixel Perfect reports are highly-formatted reports with graphics and ability to preview the report before printing.
- 8Customizable dashboards(49) Ratings
Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.
- 8.9Report Formatting Templates(47) Ratings
Ad-hoc Reporting
Ad-Hoc Reports are reports built by the user to meet highly specific requirements.
- 8.9Drill-down analysis(44) Ratings
Drill down analysis is the ability to get to a further level of detail by going deeper into the hierarchy.
- 8Formatting capabilities(49) Ratings
Ability to format output e.g. conditional formatting, lines, headers, footers.
- 8.9Integration with R or other statistical packages(39) Ratings
Integration with the open-source R predictive modeling environment.
- 8.9Report sharing and collaboration(49) Ratings
Report sharing and collaboration is the ability to easily share reports with others.
Report Output and Scheduling
Ability to schedule and manager report output.
- 9Publish to Web(44) Ratings
- 9Publish to PDF(44) Ratings
- 8.9Report Versioning(40) Ratings
Report versioning is the assignment of version numbers to each version of a report to help in tracking.
- 8.9Report Delivery Scheduling(43) Ratings
Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.
- 8.9Delivery to Remote Servers(24) Ratings
Ability to deliver reports to remote servers
Data Discovery and Visualization
Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.
- 8.9Pre-built visualization formats (heatmaps, scatter plots etc.)(47) Ratings
Pre-built visualization formats are canned visualization types that can be selected to visualize different kinds of data.
- 8.9Location Analytics / Geographic Visualization(44) Ratings
Location analytics is the visualization of geographical or spatial data.
- 8.9Predictive Analytics(42) Ratings
Predictive Analytics is the ability to build forecasting models based on existing data sets.
- 9Pattern Recognition and Data Mining(1) Ratings
Pattern recognition and data mining mean the ability to recognize hidden patterns in large quantities of data.
Access Control and Security
Access control means being able to determine who has access to which data.
- 8.9Multi-User Support (named login)(46) Ratings
Named model access means that users have access based on name and password.
- 8.9Role-Based Security Model(43) Ratings
Role-based access means that access to data is determined by job or position in the corporation.
- 9Multiple Access Permission Levels (Create, Read, Delete)(46) Ratings
Multiple access permission levels means that different levels of users have different rights.
- 9Report-Level Access Control(1) Ratings
Report-level access control means that the type of report determines who has access to it.
- 9Single Sign-On (SSO)(28) Ratings
Allows users to use one set of login credentials to access multiple applications
Mobile Capabilities
Support for mobile devices like smartphones and tablets.
- 8Responsive Design for Web Access(36) Ratings
Web design aimed at producing easy-to-read sites across a range of different devices.
- 8Mobile Application(27) Ratings
A dedicated app for iOS and/or Android.
- 9.9Dashboard / Report / Visualization Interactivity on Mobile(36) Ratings
In-app dashboard reports and data visualization.
Application Program Interfaces (APIs) / Embedding
APIs are a set of routines, protocols, and tools for used for embedding one application in another
- 8.9REST API(19) Ratings
REST is an architecture style for designing networked applications
- 8.9Javascript API(19) Ratings
A Javascript API is a type of API
- 9iFrames(18) Ratings
An iFrame is an HTML document embedded inside another HTML document on a website
- 9Java API(17) Ratings
A Java application programming interface (API) is a list of all classes that are part of the Java development kit (JDK)
- 8.9Themeable User Interface (UI)(18) Ratings
A themeable user interface means that a specific visual them can be applied to it
- 8Customizable Platform (Open Source)(17) Ratings
A customizable, open source API Gateway is a fast and scalable type of API
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Microsoft BI (MSBI)?
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 (MSBI) Competitors
Microsoft BI (MSBI) Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(937)Attribute Ratings
- 8Likelihood to Renew25 ratings
- 9.5Availability2 ratings
- 7Performance2 ratings
- 8.9Usability14 ratings
- 8.9Support Rating15 ratings
- 8.5Online Training2 ratings
- 6.9In-Person Training3 ratings
- 9.6Implementation Rating7 ratings
- 10Configurability2 ratings
- 6.8Data Visualization10 ratings
- 8.4Data Sources42 ratings
- 8.5Data Sharing and Collaboration43 ratings
Reviews
(26-50 of 62)Great Graphics presentations
Microsoft BI - Advanced Surveys
Microsoft BI is the perfect Dash-boarding product
Microsoft BI - a complete BI offer at last!
Microsoft BI from a Consultant's Perspective
Microsoft BI Review
Microsoft BI- Multiple sources, One solution
- BizNet Excel Suite, Tableau Desktop and Tableau Online
Especially for marketing departments where data is coming from social media campaigns, email campaigns, and other campaigns, BI handles it all very well.
Clean and Clear Data Analytics
- SAP Business Objects and QlikView
Think hard on your BI goals
It's Excel for Big Data. So easy, so cheap, so fast, and powerful enough most everything.
- Tableau Desktop, Google Analytics, Google Charts, SAP Crystal Reports, SAS Visual Analytics, SAS Analytics, QlikView and D3.js
- Programming packages. Free and powerful, they let you make any diagram, at the cost of difficulty of use.
- Specialist software like Tableau and Microsoft BI. This is the best choice in most cases due to ease of use and quality of output.
- 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.
Microsoft BI helps you not only streamlines your data but you can create sleek reports from within the system and either do your presentation in real time or download the information to an offline report to help you show how successful your campaigns have run.
Microsoft BI - A Brand Trust worthy
Intelligent big boy Microsoft BI
- Tableau, Spotfire and Apptio Technology Business Management
Microsoft BI platform good for Reporting but always changing for the rest of the toolset so use caution for your needs.
Microsoft BI Review
Great value for money with Microsoft's BI
"MS BI" = $$$
Why I Love Microsoft BI.
- Pentaho,Crystal Reports,jasper
Microsoft BI platform review
Why is Microsoft BI Right for Me?
Microsoft BI -- Say GoodBI to the Competition for the Moment.
- SAP Business Objects,Tableau Server,MicroStrategy Analytics,Oracle BI Foundation Suite
We chose Microsoft BI due to performance, functionality, TCO and openness (yes, I know, this sounds strange for Microsoft).
- SAP Business Objects has a less attractive GUI for end users, inferior Excel integration, inferior SharePoint integration, requires more labor to enhance performance and has higher licensing costs than Microsoft BI.
- Tableau Server has no real ETL capabilities... and thus requires an underlying BI stack. So, while Tableau rules the visualization world with Tableau Desktop, Tableau Server doesn't give us all of the capability we need for a full BI solution for our clients. Tableau Desktop makes an excellent complementary product to Microsoft BI. We typically recommend using both to customers in certain situations.
- Microstrategy - Comprehensive Multidimensional/HOLAP platform, expensive, visualizations are better than SAP BO, but not as strong as Microsoft, especially Microsoft SSAS + Tableau (which can be acquired at a lower price point). Excel integration isn't as seamless as SSAS to Excel either.
- Oracle - Expensive, patchwork of acquired BI tools rather than a platform, inferior visualizations. This platform is meant for customers who are already trapped in Oracle licensing.