• A
  • A
  • A
  • ABC
  • ABC
  • ABC
  • А
  • А
  • А
  • А
  • А
Regular version of the site

BI tools for business and policyanalysis

2022/2023
Academic Year
ENG
Instruction in English
3
ECTS credits
Course type:
Compulsory course
When:
2 year, 2 module

Instructor


Петрова Анастасия Алексеевна

Course Syllabus

Abstract

Students will explore the types and fundamentals of databases, Relational Algebra and Entity Relationship modelling. We will cover data modelling and Structured Query Language (SELECT, FROM, WHERE, JOIN, logical operators, GROUP BY, ORDER BY, sub-queries, HAVING, LIMIT etc.). Students will learn how to design a complex domain area and implement databases. Basics of BI and dashboard designs will be covered in this course: students will explore the types and history of dashboards, rules and mistakes in creating dashboards. Moreover, the course will cover an introduction to software programs for data visualisation.
Learning Objectives

Learning Objectives

  • provide a basic understanding of how to understand databases, SQL operators and principles of data visualization
Expected Learning Outcomes

Expected Learning Outcomes

  • model domain areas
  • design and implement normalized database structures
  • create queries using SQL
  • produce BI reports and design dashboards with chosen software program
Course Contents

Course Contents

  • Fundamentals of Databases
  • Database Design
  • SQL
  • Dashboards design and basics of BI
Assessment Elements

Assessment Elements

  • non-blocking 80 minutes Final test
  • non-blocking Seminar participation
  • non-blocking In-class test on SQL queries
  • non-blocking In-class test on ER diagrams and Relational Schemas
  • non-blocking BI Project
Interim Assessment

Interim Assessment

  • 2022/2023 2nd module
    0.25 * BI Project + 0.3 * 80 minutes Final test + 0.15 * In-class test on ER diagrams and Relational Schemas + 0.15 * In-class test on SQL queries + 0.15 * Seminar participation
Bibliography

Bibliography

Recommended Core Bibliography

  • Churcher, C. (2012). Beginning Database Design : From Novice to Professional (Vol. 2nd ed). New York: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1173722
  • Foster, E. C., & Godbole, S. (2014). Database Systems : A Pragmatic Approach. [Berkeley, CA]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=933677

Recommended Additional Bibliography

  • Khan, A. (2016). Jumpstart Tableau : A Step-By-Step Guide to Better Data Visualization. [United States]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1250591
  • Laursen, G. H. N., & Thorlund, J. (2010). Business Analytics for Managers : Taking Business Intelligence Beyond Reporting. Hoboken, N.J.: Wiley. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=330345
  • Monsey, M., & Sochan, P. (2016). Tableau For Dummies. Hoboken, NJ: For Dummies. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1082334
  • Rockoff, L. (2017). The Language of SQL (Vol. Second edition). Hoboken, NJ: Addison-Wesley Professional. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1601663