Image for
Home

Data warehousing and business intelligence

  • Class 30
  • Practice 30
  • Independent work 90
Total 150

Course title

Data warehousing and business intelligence

Lecture type

Elective

Course code

22-02-508

Semester

1

ECTS

5

Lecturers and associates

Course overview

Introducing students to metodologies and technologies used for implementation of analystical information systems based on data warehouses.

Content

Introducing students to metodologies and technologies used for implementation of analytical information systems based on data warehouses. Students will acquire methodological knowledge necessary for implementing data warehouses, reporting systems and multi-dimensional analysis. Also, on implementing systems for planning and budgeting, predictive analysis and big data analysis. Through the practical part they will acquire skills of using Microsoft tools for developing analytical systems.

Literature

Course handbook prepared and printed by Algebra University College

Additional reading

Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker: The Data Warehouse Lifecycle Toolkit 2nd Edition, Wiley, 2008 Robert Laberge: The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights, McGraw-Hill Education; 2011

Download student guide

Minimal learning outcomes

  • Understanding the purpose of analytical systems.
  • Understanding data warehouse design elements
  • Understanding the data quality concepts.
  • Understanding data integration process elements.
  • Understanding role and purpose of OLAP structures, reports structure and analysis process.
  • Understanding new trends and the metodology of implementing analytical systems.

Preferred learning outcomes

  • Specify user requests for the analytical system.
  • Designing the data warehouse.
  • Analyzing operational data and identifying data quality issues.
  • Integrating data from different sources using the data integration platform.
  • Designing OLAP structures, building reports and making analysis.
  • Participating as a team member in the implementation of an analytical system.
Share: Facebook Twitter