BUSINESS INTELLIGENCE

What is Business Intelligence & Analytics?

Business Intelligence Image 1

Business Intelligence encompasses a range of technologies and methodologies that allows a company’s data to be transformed into meaningful decision supporting information.


Traditionally, users of systems would rely solely on the static reporting produced by their ERP (Enterprise Resource Planning) systems, combined with extracts to spreadsheets to form summarized visual information. BI allows the next level of reporting that among other things, allows powerful drill through and interactive technologies to analyse a company’s data in a meaningful way.

Business Analytics for your Organisation

Because BI starts with data and ends with meaningful information presented through a toolset, there are many building blocks that are required in-between.

Typically, the first step is to collect data from systems such as an ERP solution and store this in a data warehouse in structures that would support the BI tools.
The second step would be to transform the data warehouse into aggregated data with meaningful measures and KPI’s (Key performance Indicators). How data is to be sliced and diced (the way a user would want to query the data) involves identifying the dimensions to be used.
The final step is creating a range of BI reporting visuals that use this model or allow the user to simply use the model using a BI tool. Virtual BI prefers to deploy systems based on the Microsoft BI stack which includes technologies such as SQL Server (for Data warehousing), SQL Server Analysis Services (for data mining and cubing), SQL Server Reporting Services (for rich detailed static reports) and Power BI (for interactive dashboards delivered to multiple devices including mobile).

Business Intelligence Image 2

Our Business Intelligence Process

Most of our BI solutions involve the following steps:

  1. Analysis of Requirements
  2. Data Warehousing including the setup and configuration of SQL Server
  3. Data Modelling including the setup of “the universe” in SQL Server
  4. Power BI modelling and Dashboard generation that can be deployed to a Power BI Service

We provide data analytic skills to assist your organization to make better business decisions. This is done by collecting your raw data, drawing conclusions, creating data models that turn it into  meaningful information.