BI tools for business and policyanalysis

2022/2023

Учебный год

ENG

Обучение ведется на английском языке

3

Кредиты

Кто читает:

Департамент социологии

Статус:

Курс обязательный

Когда читается:

2-й курс, 2 модуль

Преподаватель

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

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

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

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

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

Assessment Elements

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

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

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