Dansk - English

Short version - Full version


Business Intelligence (Fall 2011)

Course code : PRBUS-U1
ECTS Credits : 5 Status : Compulsory
Revised : 25/08 2010 Written : 19/01 2010
Placement : 2. semester Hours per week : 4
Length : 1 semester Teaching Language : Danish

Objective : The increased demand for information to create competitive advantages and optimize business processes has stimulated an increased use of Business Intelligence (BI). The goal of the course is to give students professional competences to identify information deliverables in a strategic context to innovate business processes, a basic understanding of the technology in use, and skills to develop a BI solution by using a spreadsheet (MS Excel)

The specific objectives are:
The student will gain an understanding of Business Intelligence as a holistic discipline ranging from business strategy to data sources
The student will be able to identify major risk factors connected with information projects.
The student will be able to develop an information strategy. That means, based on a company strategy, to identify information deliverables to improve upon processes or start up new ones.
The student will gain insight into various analytical techniques that generate and deliver information for decision support and process improvement.
The student will gain insight into architecture and processes in a data warehouse, data marts, and typical data creating source systems in the business’s immediate environment
The student will gain insight into typical IT infrastructure components in Business Intelligence solutions
The student will be able to plan a Business Intelligence project by writing a business requirement document and apply business case methodic.
The student will be able to write basic SQL syntax code
Based on a case, the student will be able to develop a Business Intelligence solution by using a spreadsheet (MS Excel)
Principal Content : Overview of Business Intelligence and typical risk factors (pitfalls)
The relationship between business strategies and the BI function
The main components of an information system
The difference between data, information, and knowledge
How to create an information wheel and develop an information strategy
Maturity models
The competences and role of the analyst
Quantitative analytics, data mining, and reporting
Data warehouse, ETL, data marts, and SQL
Data-creating source systems
Business Intelligence Competence Center (BICC)
Business requirement and business cases
The BI software vendors and practical BI solutions
Developing your own BI solution by using MS Excel
Teaching method : Lectures with discussions, learning tasks, and casework in groups
Required prequisites : -
Recommended prerequisites : It is recommended but not required to have a basic understanding of calculus, statistics and SQL. Also you should be familiar with spreadsheet software such as MS Excel.
Relations : -
Type of examination : Look under remarks
Marking : 7 step scale
Remarks : Individual oral examination (30 minutes) without preparation based on teaching materials and final casework in report form.
Teaching material : Curriculum:
Business Analytics for Managers: Taking Business Intelligence beyond Reporting
Jesper Thorlund and Gert H.N. Laursen
Wiley and SAS Business Series, 2010
ISBN: 978-0-470-89061-5 (hardback)

Recommended supplementary reading:
Competing on Analytics, Thomas H. Davenport, Harvard Business School Press (2007)
ISBN: 978-1-4221-0332-6

The Lost-Trade System, Jesper Thorlund, Strategic Book Publishing, New York (2008)
ISBN: 978-1-60693-263-6
Responsible teacher : Jesper Thorlund , jestu@dtu.dk