Introduction to Business Intelligence

Short Course
Introduction to Business Intelligence

This 2 day short course has been specifically designed for professionals who wish to maximise their use of business intelligence in order to leverage the power of data integration and analysis.

The course will outline the key concepts and tools you need to implement an effective business intelligence solution and improve your organisation's decision-making process. You will also gain the ability to easily present information and performance indicators combining multiple data sources.

This course has one study option

Mode of Attendance

  • On Campus

Mode of Study

  • Full Time

Start Date

To be confirmed

Course Length

2 days

This course will introduce the key concepts of business intelligence, data integration, data warehousing, data virtualisation and data mining through a case study of a fictitious retail company, consisting of multiple branches, that aims to consolidate its view of the business, establish a consistent way of reporting on key performance indicators, and gain a competitive advantage by leveraging the power of data integration and analysis.

You will have the opportunity to learn to use the Microsoft Business Intelligence suite of tools (SQL Server, SSAS, SSIS, SSRS, Excel PowerPivot and Excel Data Mining) and Tableau.

Session 1

Definitions, Concepts, Architecture, and Tools for Data Warehousing (DW) and Data Virtualisation (DV)

An overview of the motivation for adopting DW, the difference between DW and a traditional database, the applications of DW, the characteristics of DW, the major DW solution providers, Data virtualisation, etc.

Session 2

DW Design and Dimensional Modelling

An overview of the DW development life-cycle and in particular the Design phase. A hands-on practical session to build a data warehouse and its underlying dimensional model (dimensions and cube) using Microsoft SQL Server Analysis Services (SSAS).

Session 3

Data Integration: Extract, Transform and Load (ETL)

An overview of how data from multiple data sources (e.g., Excel spreadsheets, text files, various databases, etc.) can be pulled together in a single DW. A hands-on practical session to build a data integration solution using Microsoft SQL Server Integration Services (SSIS).

Session 4

Data Analytics using SQL/OLAP and MDX (Multi-Dimensional eXpressions)

An overview of how analysts can leverage the power of data analytics using their preferred tools (e.g., Excel or Tableau) or using query languages such as SQL and MDX.

Session 5

KPIs (Key Performance Indicators) and Dashboards

An introduction to the design and use of KPIs in Microsoft SSAS and Excel, as well as the design of reports in Microsoft SSRS.

Session 6

Data Mining Techniques and Applications

An overview of the use of data mining techniques on real-life applications (shopping basket analysis, forecasting, clustering, etc.) using Microsoft SSAS and Excel.



The University regularly reviews its courses. Course content and structure may change over time. See our course and module disclaimer for more information.

The key concepts will be delivered via short lectures to give you the opportunity to spend most of the time applying your learning via hands-on interactive labs.

The same case study will be used throughout the duration of the course to give you a consistent experience of the entire BI lifecycle.


Academic Support

The Inclusion Centre advises and supports students who disclose a sensory or mobility impairment, chronic medical condition, mental health issue, dyslexia and other specific learning differences. Applicants are encouraged to arrange a pre-entry visit to discuss any concerns and to view the facilities.

Study Skills Support

The Study Support Team provides training and support to all students in:

  • Academic writing
  • Study skills (note taking, exam techniques, time management, presentation)
  • Maths and statistics
  • English language
  • Information technology support

Who Should Attend?

Anyone with an interest in the effective use of business intelligence e.g. Project Managers, Business Analysts, Marketing Directors, Database Analysts and Database administrators.

Entry Requirements

There are no entry requirements for this course

  • Course fees: £500

Additional Costs

The following course-related costs are not included in the course fees:


For new intakes course fees are reviewed and published annually for each mode of delivery. Tuition fees are fixed for the duration of a course at the rate confirmed in the offer letter. For further information see:


Have a question about the course? Get in touch with the team and we'll do our best to help.

Get in touch

Taking this course, you will have access to some of the world's best facilities. 

We've invested more than £100 million in the development of our campus, new facilities and new resources.

University Wide Facilities

Cookie Consent