Microsoft 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.
Microsoft BI is mainly based on Microsoft SQL Server, so it is perfectly integrated. Many of the Microsoft BI components require using SQL Server as the database engine. Generally, the functionalities that are achieved when using SQL Server as a database engine are greater than when using any other engine.
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.
Microsoft BI allows users to access a portal where reports and indicators are published. Sharepoint also integrates very well with Microsoft BI, which greatly improves collaboration capabilities. The access through mobile devices improved a lot in the last versions and it is possible to access the reports, indicators, and dashboards natively from iOS.
Well suited for: - Customers with a Microsoft landscape who use MS Office or Office 365, SQL Server and Active Directory a lot. - Departmental deployments. - Self-Service Capabilities - Small Budgets - Mobile Capabilities
Some issues with: - non-Microsoft environments - Complex data sources like SAP. - Complex calculations in Power BI