Single-Course Danish 5 ECTS

Business Intelligence

Overall Course Objectives

The increasing demand for information to create competitive advantages and optimize business processes has stimulated an increased use of Business Intelligence (BI), Analytics and Big Data. 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 (e.g. MS Excel) or other generally available BI-tool, e.g. Tableau, or Power BI.

Learning Objectives

  • Develop a Business Intelligence solution based on a case using Power BI, Tableau, Excel, or another BI tool.
  • Demonstrate basic knowledge of SQL and purpose of use.
  • Explain the main elements and steps in working out a business requirement specification and business case.
  • Explain the typical architecture and IT infrastructure components in Business Intelligence solutions.
  • Explain the purpose of the architectural components in a data warehouse, data marts and typical data creating source systems in the business’s immediate environment.
  • Explain various analytical techniques that generate and deliver information for decision support and process improvement.
  • Develop an information strategy based on a company strategy at the cooperate or department level and identify relevant information deliverables to improve upon processes or start new business processes.
  • Understand and explain business Intelligence as a holistic discipline connecting to business strategy and source data.
  • Identify and explain major risk factors related to information projects.
  • Develop and explain a plan and requirement specification for at business intelligence project.

Course Content

Overview of Business Intelligence and typical risk factors (pitfalls).
The relationship between business strategies and use of information and maturity models.
Productions of information at the functional organizational level (lead and lag information).
The competences and role of the analyst and reporting system.
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.
Quantitative analytics, data mining and reporting.
Data warehouse, ETL, data marts and SQL.
The businesses acquisition of source data.
Business Intelligence Competence Center (BICC).
Business requirement specification and business case.
The BI software vendors and practical BI solutions.
Case based project work and presentation.
Developing your own BI solution by using Power BI, Tableau, Excel, or another BI tool.

Recommended prerequisites

It is recommended, but not required,that the students have a basic understanding of statistics, SQL and MS Excel.

Teaching Method

Lectures with discussions, learning tasks using own PC and casework in groups

Remarks

Faggruppe: Business development
Eksport & teknologi: 5. semester. (from now 8. semester)
Mobilitet, logistik og transport: 4. semester
Produktion: Pendulerer mellem 3. og 4. semester (P: kun Forår)
Valgfag: IT og Økonomi.
Valgfag: IT-elektronik.
Valgfag: Softwareteknologi.
Valgfag: Sundhedsteknologi.

Individual oral examination (20 minutes) without preparation based on teaching curriculum and final casework report hand-in.

Limited number of seats

Minimum: 10, Maximum: 70.

Please be aware that this course has a minimum requirement for the number of participants needed, in order for it to be held. If these requirements are not met, then the course will not be held. Furthermore, there is a limited number of seats available. If there are too many applicants, a pool will be created for the remainder of the qualified applicants, and they will be selected at random. You will be informed 8 days before the start of the course, whether you have been allocated a spot.

See course in the course database.

Registration

Language

Danish

Duration

13 weeks

Institute

Engineering Technology

Place

DTU Ballerup Campus

Course code 62589
Course type Graduate Engineer
Price

7.500,00 DKK

Please note that this course has participants limitation. Read more

Registration