Business intelligence - business use of data warehouses
Some basic information about the module
The aim of studying and bibliography
The main aim of study:
Concept of data warehouse, OLAP architecture and issues related to Data Manning. Introduction of key concepts, definitions and areas of Business Intelligence applications. Architecture of the Business Intelligence system.
The general information about the module:
The subject discusses the construction of decision support systems, technology of multidimensional data sources and interfaces of such systems.
Bibliography required to complete the module
| 1 | Pelikant A. | Hurtownie danych. Od przetwarzania analitycznego do raportowania | Helion. | 2011 |
| 2 | Surma J. | Business Intelligence. Systemy wspomagania decyzji biznesowych | PWN. | 2010 |
| 3 | Ch. Todman | Projektowanie hurtowni danych | WNT, Warszawa. | 2003 |
Basic requirements in category knowledge/skills/social competences
Formal requirements:
The student satisfies the formal requirements set out in the study regulations.
Basic requirements in category knowledge:
He knows the relational databases, has basic knowledge about the functioning of web applications.
Basic requirements in category skills:
He can use the SQL language. He can detect and use relationships in database tables.
Basic requirements in category social competences:
He can participate in laboratory classes.
Module outcomes
| MEK | The student who completed the module | Types of classes / teaching methods leading to achieving a given outcome of teaching | Methods of verifying every mentioned outcome of teaching | Relationships with KEK | Relationships with PRK |
|---|---|---|---|---|---|
| MEK01 | He knows what data warehouses are and can use open source tools to create them. | lecture / lab | observation of performance, pass |
K-W06+ K-U07+ K-K02+ |
P6S-KK P6S-KO P6S-UW P6S-WG |
| MEK02 | He knows the concept of a multidimensional data source and can create it | lecture / lab | observation of performance, pass |
K-W07+ K-U07+ |
P6S-UW P6S-WG |
| MEK03 | He knows the key concepts, definitions and areas of Business Intelligence applications | lecture | pass |
K-W11+ K-U17+ K-U18+ K-K02+ |
P6S-KK P6S-KO P6S-UW P6S-WK |
| MEK04 | He is able to use the reporting and analytical application | lecture / lab | observation of performance, pass |
K-W07+ K-U07+ K-K02+ |
P6S-KK P6S-KO P6S-UW P6S-WG |
The syllabus of the module
| Sem. | TK | The content | realized in | MEK |
|---|---|---|---|---|
| 4 | TK01 | W1 | MEK01 | |
| 4 | TK02 | W2,L1-3 | MEK01 MEK02 | |
| 4 | TK03 | W3,W4,L4-5 | MEK01 MEK02 | |
| 4 | TK04 | W5,L6 | MEK02 MEK03 | |
| 4 | TK05 | W6 | MEK03 | |
| 4 | TK06 | W7,L7 | MEK04 | |
| 4 | TK07 | L1-L7 | MEK01 MEK02 MEK03 MEK04 |
The student's effort
| The type of classes | The work before classes | The participation in classes | The work after classes |
|---|---|---|---|
| Lecture (sem. 4) | The preparation for a test:
20.00 hours/sem. |
contact hours:
15.00 hours/sem. |
|
| Laboratory (sem. 4) | contact hours:
15.00 hours/sem. |
||
| Advice (sem. 4) | The participation in Advice:
2.00 hours/sem. |
||
| Credit (sem. 4) | The preparation for a Credit:
4.00 hours/sem. |
The written credit:
2.00 hours/sem. |
The way of giving the component module grades and the final grade
| The type of classes | The way of giving the final grade |
|---|---|
| Lecture | Assessment issued on the basis of credit / test. |
| Laboratory | Assessment based on observation of performance and pass / test. |
| The final grade |
Sample problems
Required during the exam/when receiving the credit
(-)
Realized during classes/laboratories/projects
(-)
Others
(-)
Can a student use any teaching aids during the exam/when receiving the credit : no