| Course code: | 4IT436 |
| Course title in language of instruction: | Business Intelligence |
| Course title in Czech: | Business Intelligence |
| Course title in English: | Business Intelligence |
| Number of ECTS credits allocated: | 6 (1 ECTS credit = 26 hours of workload) |
| Mode of delivery: | face-to-face; 2/2 (hours of lectures per week / hours of seminars per week) as semestral course
face-to-face; 2/2 (lectures per period / seminars per period) for distance (combined) programs |
| Mode of completion: | examination |
| Language of instruction: | czech |
| Level of course and year of study: | master (second cycle): 1 |
| Semester: | SS 2011/2012 |
| Name of lecturer(s): | Ing. Daniel Arnošt, CSc. (lecturer)
doc. Ing. Ota Novotný, Ph.D. (instructor, supervisor)
doc. Ing. Jan Pour, CSc. (instructor)
Ing. David Slánský, Ph.D. (lecturer) |
| Prerequisites and co-requisites: | not to be taken after 4IT435 |
| Recommended optional programme components: | none |
| Work placement: | none |
| |
| Aims of the course: |
| Gain pre-requisites for the positions of analysts or consultants of managerial applications (directed to support business and strategic decision making), demonstrate in the real environment managerial applications based on MS SQL Server and ProClarity software products, learn the basics of the MS SQL data mart and data warehouse technology, provide the knowledge about the possibilities of Business Intelligence use in management and business. |
| |
| Learning outcomes and competences: |
| Upon successful completion of this course, students will be able to design and implement Business Intelligence solution (strarting form multidimensional analysis, ETL, multidimensional cubes to client reporting). |
| |
| Course contents: |
basic principles of Business Intelligence, development in BI area, position in IS/ICT architecture, links to other applications, core OLAP (On Line Analytical Processing) technologies, demonstration of principles on examples,
BI application areas, specification of these areas, BI in the company management, effects of BI applications,
database environment, data warehouse in MS SQL Server-- principles, architecture, components, management basics,
BI tasks management, effect and critical success factors of BI, planning and analysis
design and modeling -- principles of dimensional modeling, relationship between measures and relevant dimensions, physical design and modeling, data quality management, data granularity problems management,
BI implementation principles, data pumps, ETL -- principle, documentation in MS -- DTS, ActiveX script, data pumps parameters and logging,
Server applications solution, basic principles of MS Analysis Services, functions and options
Client applications solution, ProClarity, MS Office - Excel, Access, export of OLAP cube - off-line solution, query tools in multidimensional databases,
Data Mining -- core principles and application options, relations to BI and other applications, relationship between CRM and BI - Customer Intelligence.
BI market segment, BI trends, BI product examples- SAP, Oracle,
|
| |
| Learning activities, teaching methods and workload (hours): |
| Type of teaching method | Daily attendance | Distance form |
|---|
| Participation in lectures | 26 h | 0 h | | Preparation for lectures | 13 h | 0 h | | Attendance at seminars/workshops/tutorials | 26 h | 6 h | | Preparation for seminars/workshops/tutorials | 13 h | 18 h | | Preparation of term paper | 39 h | 93 h | | Preparation of presentation | 13 h | 0 h | | Preparation for final oral exam | 26 h | 39 h | | Total | 156 h | 156 h |
|
| |
| Assessment methods and criteria: |
| Requirement type | Daily attendance | Distance form |
|---|
| Term paper | 45 % | 70 % | | Mid-term test(s) | 25 % | 0 % | | Final oral exam | 30 % | 30 % | | Total | 100 % | 100 % |
|
| |
| Special requirements and details: |
| Successfull completion of this subject is possible only if student will gain at least 15 points out of 30 from the Final Exam |
| |
| Reading: |
| Type | Author | Title | Published in | Publisher | Year | ISBN |
|---|
| RQ | NOVOTNÝ, O. -- POUR, J. -- SLÁNSKÝ, D. | Business intelligence : jak využít bohatství ve vašich datech. | Praha: | Grada, | 2005. | 80-247-1094-3 | | RQ | LACKO, Ľ. | Business Intelligence v SQL Serveru 2005 : reportovací, analytické a další datové služby. | Brno: | Computer Press, | 2006. | 80-251-1110-5 |
|
| |
| Regular course units: |
| Day | From-till | Room | Teacher | Type | Frequency | Capacity |
|---|
| Wednesday | 14:30-16:00 | SB 103 | O. Novotný | Seminar | Every week | 25 | | Thursday | 07:30-09:00 | SB 309 | D. Slánský, D. Arnošt | Lecture | Every week | 80 | | Thursday | 09:15-10:45 | SB 103 | J. Pour | Seminar | Every week | 25 | | Thursday | 14:30-16:00 | SB 103 | J. Pour | Seminar | Every week | 25 |
|
| |
| Block course units: |
| -- item not defined -- |
| |
| Type of course (eligible study programmes and course groups): |
| Faculty | Programme/field code | Programme mode | Course group code | Study period |
|---|
| FFU | B-FU-BP | full-time | cVOR | WS 2011/2012 | | B-FU-DP | full-time | cVOR | WS 2011/2012 | | B-FU-FI | full-time | cVOR | WS 2011/2012 | | B-FU-UC | full-time | cVOR | WS 2011/2012 | | B-FU-UP | full-time | cVOR | WS 2011/2012 | | C-FU-BP | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013 | | C-FU-DP | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013 | | C-FU-FG | full-time | cVM | WS 2011/2012
WS 2012/2013 | | C-FU-FI | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013 | | C-FU-FO | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013 | | C-FU-UC | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013 | | C-FU-UP | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013 | | FIS | B-AI-IN | full-time | cVOR | WS 2011/2012 | | B-KM-MM | full-time | cVOR | WS 2011/2012 | | B-KM-SD | full-time | cVOR | WS 2011/2012 | | B-KM-SE | full-time | cVOR | WS 2011/2012 | | B-KM-SM | full-time | cVOR | WS 2011/2012 | | C-AI-IM | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-AI-IT | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | hV | WS 2008/2009
WS 2009/2010
WS 2010/2011
SS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-AI-KI | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-AI-PI | distance | hV | WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-AI-ZT | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-KM-ED | full-time | cVM | WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-KM-EK | full-time | cVM | WS 2008/2009
WS 2010/2011 | | C-KM-EO | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-KM-SP | full-time | cVM | WS 2008/2009
WS 2010/2011 | | IM | full-time | cVM | WS 2008/2009 | | IT | full-time | cVM | WS 2008/2009 | | hV | WS 2008/2009 | | L-MIM-ITR | full-time | oP | WS 2012/2013 | | MM | full-time | cVM | WS 2008/2009 | | SP | full-time | cVM | WS 2008/2009 | | 4IP | full-time | sV | WS 2010/2011
SS 2010/2011
WS 2011/2012 | | 4RV | full-time | sP | SS 2011/2012
WS 2012/2013
SS 2012/2013
WS 2013/2014 | | FMV | B-ME-MO | full-time | cVOR | WS 2011/2012 | | B-ME-MS | full-time | cVOR | WS 2011/2012 | | B-ME-PP | full-time | cVOR | WS 2011/2012 | | B-ME-RC | full-time | cVOR | WS 2011/2012 | | B-PL-PL | full-time | cVOR | WS 2011/2012 | | C-ME-CR | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ME-EI | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ME-IDS | full-time | cVM | WS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ME-MO | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ME-MP | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ME-PP | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-PL-PL | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | FPH | C-EM-PE | full-time | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013
WS 2013/2014 | | distance | cVM | WS 2008/2009
WS 2010/2011
WS 2011/2012
WS 2012/2013 | | NF | B-ES-EK | full-time | cVOR | WS 2011/2012 | | B-ES-NH | full-time | cVOR | WS 2011/2012 | | B-ES-RE | full-time | cVOR | WS 2011/2012 | | C-ES-EA | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
SS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ES-HD | full-time | cVM | WS 2010/2011
SS 2010/2011
WS 2011/2012
SS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ES-HP | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
SS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ES-LAE | full-time | cVM | WS 2010/2011
SS 2010/2011
WS 2011/2012
SS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ES-RS | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
SS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ES-VS | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
SS 2011/2012
WS 2012/2013
WS 2013/2014 | | C-ES-ZPE | full-time | cVM | SS 2010/2011
SS 2011/2012 | | C-HP-ZP | full-time | cVM | WS 2008/2009
WS 2010/2011
SS 2010/2011
WS 2011/2012
SS 2011/2012
WS 2012/2013
WS 2013/2014 | | L-MIM-LAEM | full-time | cVM | WS 2010/2011
SS 2010/2011
WS 2011/2012
SS 2011/2012 |
| xP (oP, hP etc.) | core curriculum courses | | xV (oV, hV etc.) | field elective courses | | cVx (cVB etc.) | general elective courses | | xJx (fJ1, oJ2 etc.) | language (elective) courses |
|