Business Intelligence (BI)

Business Intelligence | Altitude icon

Business Intelligence technologies provide historical, current, and predictive views of business operations. By giving this valuable insight, BI helps decision-makers make more informed decisions and gives end-users critical business information on their customers or partners, including information on behaviors and trends.

We deliver Business Intelligence solutions using technologies like SQL Server, MySQL, Crystal Reports, Excel, Microsoft Reporting Services, ETL (Extract, Transform & Load) tools and automation software, such as Microsoft Orchestrator.

Data Warehouse Design

The key to all good Business Intelligence solutions is a solid, well-constructed enterprise data warehouse.

We at Altitude have many years of experience designing and building data warehouses which typically involve importing, cleansing and transforming data to fit into a unified database structure.

We make use of automation and ETL (Extract, Transform & Load) tools to collate good quality data from various data sources into a Data Warehouse. If you have a need for better management reporting, let us help you design and setup your data warehouse.

OLAP Databases

If you have used pivot tables in Excel, then you are well on the way to understanding OLAP databases.  They hold pre-calculated values (taken from the data warehouse) and allow you to slice and dice your data in numerous ways.

An OLAP system is an important tool to provide a business with the information it needs to support important business decisions. They are widely used in forecasting and as source for data mining models.

Reporting Design & Delivery

In order for you to take advantage of the information stored in the data warehouse there is a need to design an effective and relevant reporting solution. Several solutions can be used, namely scorecards, dashboards, static and dynamic reports and OLAP browsers.

Organisations with a broad data warehouse containing cross-departamental information will have a great platform on which to create effective reports containing the right information for the right people.

Management Information Systems

A Management Information System (MIS) provides the Business with the information it needs to run its operations effectively.  A good MIS solution is created from an organised approach to combining people, technology and data together to provide business managers with appropriate information that aids decision-making.

We at Altitude have worked with many organisations helping them understand their data sources and building effective MIS solutions.

Our Business Intelligence Technology

Our key tools are:

  • MS SQL Server (2008 & 2012)
  • Pentaho (PDI)
  • SQL Server Analysis Services, inc. OLAP
  • SQL Server Reporting Services
  • Crystal Reports
  • MS Excel