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
Mode of Study
Start Date
Course Length
Mode of Attendance
  • On Campus
Mode of Study
  • Full Time
Start Date
5 December 2018 and 1 May 2019
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 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 Disability & Dyslexia 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.

Disability & Dyslexia Centre

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

Study Skills 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:

Other Fees and Charges

Disclaimer

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:

STUDENT FINANCE

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

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

Apply

Register direct to the university using our online application form. 


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