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)9.090%
- 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.
- 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.
- 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.
- 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.
- 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
- 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)
- 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
(934)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
(1-5 of 5)Great value for money with Microsoft's BI
- SQL Server Management Studio provides a nice interface to view, query, and modify the database tables. The interface is user friendly and logical.
- Microsoft, in general, has fantastic educational pricing. This allowed the TCO to be much lower for our university.
- Microsoft tools integrate nicely with one another. We are also in the process of implementing SharePoint. We plan to use SSRS (.rdl) reports which will integrate with SharePoint - and also will have the ability to experiment with PowerView (.rdlx) dashboards and PowerPivot (Microsoft's in-memory BI tool).
- The end-user reporting tool, Report Builder, is not that flexible. We feel that the Cognos Report Studio tool is more robust in this area.
- Firstly, reduction in cost from the three previous vendors which we were supporting. Just by replacing these legacy pieces of software, we have saved money.
- We are working to quantify the cost savings achieved in business improvement from the reporting that we have provided. We don't have a specific figure as of yet, but the reports that are now available 'on-the-fly' have saved many man hours. Previously, data needed to be consolidated across multiple systems which could have taken weeks of manual manipulation. Now, this data is available in one platform and we have cross-functional reporting capability.
- We use the database platform to warehouse the data from our disparate admissions, student information, human resources, finance, and advancement systems.
- SQL Server Integration Services (SSIS) is used to move the data from these ERPs into staging - then onto our dimension model and SSAS cubes.
- SQL Server Reporting Services (SSRS) is used to report on this dimensional data and provide parameterized, drill-through reporting.
- SQL Server Analysis Services (SSAS) is used to build cubes for specific functional areas. These cubes can then connect back to the dimensional data as required for drill-through analysis.
- Using the enterprise version, we leveraged data-driven subscriptions. This feature allows you to publish reports to specific individuals or groups based upon data events. This has become useful for a wide variety of things. In a previous company, I used this feature to drive process improvements by notifying teams of early task completion. In some cases, we were able to drive a process that typically took 4 weeks down to a process that only took 2.5 weeks. That led to revenue gains.
- Since Microsoft BI contains an out-of-the-box ETL tool (SSIS), we've been able to leverage this functionality to help support other projects. Recently, we created a SalesForce integration to Workday.
- We have been able to setup nightly data feeds using SSIS which extract known sets of data for our statisticians. While the data isn't formatted in SAS dataset, it outputs the data in a common format that is easy for the statisticians to consume and transform into a useful SAS dataset.
- Implemented in-house
- Professional services company
- Self-taught
- Ellucian Banner.
- Workday HCM.
- Workday Financials.
- PeopleSoft Admissions.
- Apply Yourself.
- Sage Millennium.
- We will continue to support systems that are key pillars to our business units.
Microsoft BI platform review
- Easy development tools with ability to support large data.
- Features of the predictive analytics are not the best in the industry yet.
- Rapid report development, simple web-based reporting tools, easy support, common development techniques.
- SQL Server Data Warehouse and Microsoft BI platform allow us to collect data from transactional sources, transform to reportable format, and aggregate to a level that can be used to measure business operational metrics.
- Implemented in-house
- Self-taught
- Microsoft SharePoint
Thoughts on MS BI
- Overall it is a robust BI platform that is not difficult for a technically-oriented person to learn and use.
- I am a huge fan of Analysis Services and actively try to find ways to get data into cubes for reporting. While learning MDX may be one of the more difficult aspects of MS BI, it is powerful and anyone who has prior experience using T-SQL alone to build complex reports can appreciate its power.
- 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.
- We use Microsoft BI products to publish accounting reports and automatically generate general ledger journal entries to distribute departmental expenses.
- Implemented in-house
- In-person training
- Self-taught
Best TCO of any comprehensive database and analytics platform
- The Microsoft Business Intelligence stack has come a very long way since its inception. For value and TCO there's really no comparison. Where other vendors charge hundreds of thousands of dollars for database systems, ETL tools, MDM solutions, reporting portals, etc. Microsoft ties all this functionality and more together for the price of just one of those components. Developers that know the toolset well are readily available worldwide and at a lower cost than those with expertise in competing platforms. In partnership with both Dell and HP, Microsoft has recommended reference architectures running on commodity hardware to create highly performant, highly available warehousing and OLTP systems. The SharePoint layer adds a rich user interface and collaboration platform for analytics, data discovery, reporting (both ad-hoc and scheduled) and data driven subscriptions.
- The Microsoft platform - today - comes up short in cross-platform delivery. While efforts are being made to port the Power BI tools to HTML5, so far these tools are only available with this rendering engine in the online (O365) version of the platform. Silverlight is a dying technology, and it can be frustrating to explain the design and interop limitations of the end user facing dashboard tools. For true styled enterprise dashboarding where the look and feel of the artifacts is important (external audiences), it's often necessary to turn to a Microsoft partner tool such as Dundas to augment the stack. These problems will resolve themselves over time, but right now Microsoft comes up short in this area.
- The MDM solution in the Microsoft toolset, Master Data Services, is effectively a blank slate. This is both a strength and a weakness, in that you can model any data domain imaginable without being pushed in a particular direction but having some basic customer or other key domains available either via Codeplex or otherwise would be helpful. Additionally, record lineage isn't handled well OOTB in MDS and this key function shouldn't require a custom implementation.
- Traditional "canned" reporting.
- Online transaction processing systems.
- Data warehousing.
- High availability.
- Self-service analytics.
- Collaborative decision making.
- Implemented in-house
- Online training
- In-person training
- Self-taught
Build a highly automated and flexible BI solution for your organization!
- Analysis Services by far outperforms in-memory ROLAP type systems - this allows for very fast ad-hoc drill-down and discovery of huge data sets. Don't believe otherwise - I can assure you it is true. Of course, you have to know what you are doing on the data modeling side in order to get there.
- Analysis Services's ability to integrate with Reporting Services and Microsoft Excel is extremely attractive to business users, especially analysts who are very familiar with the powerful analysis tools already in Excel. The performance of reports built on Analysis Services is really a stand-out feature as well.
- Integration Services is hands-down the most flexible and powerful ETL tool you have ever used. Just try it - there is no one else even close. You will be able to pull data from anywhere, push data to anywhere, and build just about any workflow you can think of around those processes. It is also an all-around great automation tool for your BI environment.
- Reporting Services has both a feature-rich developer-oriented authoring environment (Visual Studio / BI Development Studio) as well as a simplified end-user authoring tool (Report Builder). It has an enormous collection of visualization components built in, as well as an even bigger set of 3rd party controls to allow you to create just about any report you can imagine. The ability to extend Reporting Services with .Net code (if you have the developers) expands your options even further.
- The report authoring solutions in Reporting Services could be better, especially on the Report Builder (end-user oriented) side.
- 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.
Also, remember that Excel is your friend! No, it should never be used to store data, but it is an amazingly flexible and powerful analysis and reporting tool - especially when combined with Power Pivot and SharePoint.
- Forcasting
- Asset Management
- Pricing
- Sales Reporting
- Customer Satisfaction Reporting
- Detailed Account-level Cost and Revenue Reporting
- Implemented in-house
On the development side, you will want to have a full time data architect making sure that the model you are developing holds together and supports the reporting requirements of the business. You will also want a technical lead who has rich experience with the stack - that person will be able to shepherd the rest of the development team and help them come up to speed with the tools.
- Online training
- Self-taught