Microsoft BI

Microsoft SQL Server
SQL Server is Microsoft’s data platform that contains enterprise-ready BI technologies which unlock new insights with managed self-service options, large-scale data warehousing and powerful analytics solutions.

  • The SQL Server Analysis Services (SSAS) platform can be used to build rich and high performance analytical models (multidimensional, tabular and data mining). These can be used for interactive data analysis, reporting, visualization and predictive analysis using a number of BI tools.
  • SQL Server Reporting Services (SSRS) accelerates report creation and eases collaboration and management by providing access to data from virtually any data source to meet your business reporting needs.
  • SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration (and ETL) solutions. You use SSIS to create packages that automate tasks such as copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. Unlock and integrate the data in your SQL Server, Oracle, Teradata, CRM, SharePoint, real-time, … and even cloud-based applications.
  • Master Data Services (MDS) is the SQL Server solution for master data management, focusing on creation, maintenance and storage of master data structures that are used for providing object mapping, reference data, metadata management, and dimensions and hierarchies for data integration operations, such as business intelligence and data warehousing, and integration between operational systems.
  • Data Quality Services (DQS) is a new offering as of SQL Server 2012 allowing customers to cleanse, match, standardize, and enrich their data to deliver trusted information for business intelligence, data warehouse, and transaction processing workloads. DQS abstracts the creation of a knowledge base for end users who understand the business to manage the governance, and compliance of their data. IT can then rapidly deploy this knowledge base or other third party rules they can easily acquire from Azure Marketplace and be up and running within minutes.

SharePoint for BI
Using an already existing (or newly installed) SharePoint environment as BI portal allows for an easy to use and generally well known BI portal interface. Through the use of powerful features like Performance Point end-users can create rich dashboards and scorecards that convey the right information the first time, aggregating content from multiple sources and displaying it in a web browser. Furthermore users can access and configure the information in databases, reports and business applications to fit their exact needs from within SharePoint.

Office for BI
As from office 2010, Excel can be used to rapidly mash-up, explore, analyse and visualise any data ranging from a few rows to hundreds of millions of rows. Excel now allows to quickly build out a self-service BI solution through the use of two add-ins:

  • Power View: Provide stunning data visualization to discover new insights with a highly interactive and familiar data exploration, visualization, and presentation experience with Power View, now in Excel and SharePoint.
  • Power Pivot: Access, mash-up and analyze data from virtually any source and rapidly create compelling analytical models with Power Pivot, now in Excel and SharePoint.