Microsoft provides a complete range of BI tools, making a suitable solution available for all kinds of information needs. Cost-effective standard reports can easily be distributed through Reporting Services, with or without using reporting models in Analysis Services. For corporate wide information with dashboards, fast analytics and ad hoc tools the Microsoft BI tools integrate seamlessly with Office and Sharepoint.

Visit the knowledge session

Microsoft's Azure platform offers considerable advantages. New developments always appear first on this platform as a result of Microsoft's cloud first strategy. It is possible to purchase most BI products as a service, paid for in terms of use. A complete virtual machine can also run on Azure as an alternative to hosting with another party.

  • Reducing administration costs
  • Receiving new developments earlier
  • Highly scalable

screen microsoft azure w385x217

With Power BI Microsoft has an accessible data discovery tool. In a simple way, without any technical knowledge, new insights can be extracted from a variety of sources. Whether or not the data is stored in a database in Excel or Salesforce. Power BI is a combination of PowerView (for assembling drag-and-drop dashboards), PowerPivot (own multiple data sets linking) and Power Query (self-service BI).

  • Wide range of connectors available
  • Data extraction, modelling and visualisation in 1 tool
  • Ideal for analysts
  • Free start!

screen microsoft power bi w385x217

Mobile Report Publisher is a tool one can be easily create (mobile) KPI reports. It was also known under the name Datazen before it was acquired by Microsoft in 2015. The tool is part of SQL Server Reporting Services 2016 (also known as SSRS) and without using additional licenses. With Mobile Report Publisher, you can make connection to Excel files or shared datasets in SSRS. The KPI reports made in the Mobile Report Publisher can be placed in the Report Server Web portal for distribution or can be viewed in the Microsoft PowerBI app on any device.

  • Part of SQL Server
  • Mobile KPI reports
  • Automatically rendering to any screen size

screen microsoft mobile rep

SQL Server Reporting Services (also known as SSRS) is part of SQL Server. Chances are that you already have this in house. With Reporting Services reports can easily be developed and distributed. Reports can be created using Data Tools in the, familiar for developers, Visual Studio, or using Report Builder. From both environments, reports can easily be placed in the Report Server web portal for distribution. For this, it does not matter whether the data is stored in SQL Server or not.

  • Part of SQL Server
  • Making and distributing standard rapports
  • Exceptionally low costs

Related items:

SQL Server Analysis Services (also called SSAS) is part of SQL Server. It makes fast access to large amounts of data possible. Both in multidimensional mode (classic OLAP) and in Tabular mode (in memory analytics engine), it is possible to 'browse' through the data quickly. In Analysis Services are reporting models are created with Data Tools that can be used by Microsoft's own BI tools (e.g. Power BI and Report Builder), but also by many BI tools from other providers.

  • Real-time or in memory
  • Accessible to querytools of third parties
  • Part of SQL Server

As underlying foundation of countless applications, the SQL Server database is the Microsoft platform when it comes to data. However, SQL Server also includes a full suite of business intelligence tools, for both reporting and advanced analytics. It is for this reason that Ensior uses SQL Server as the basis for the data warehouse product Ensior Datawarehouse Automation.

  • Cost effective
  • World class database engine
  • Complete Business Intelligence suite

SQL Server Integration Services (also known as SSIS) is associated with the SQL Server and is a workflow-based data migration, integration and transformation (ETL) tool. Integration Services integrates seamlessly with the SQL Server database engine.

  • Configurations (OTAP)
  • Part of SQL Server

This website uses cookies: more information