| Course label : | Business Intelligence |
|---|---|
| Teaching departement : | MIN / Applied Mathematics and General Computing |
| Teaching manager : | Mister BENOIT TROUILLET |
| Education language : | French |
| Potential ects : | 0 |
| Results grid : | |
| Code and label (hp) : | IE5_BINT_MIN_BIN - Business Intelligence |
Education team
Teachers : Mister BENOIT TROUILLET / Madam ISABELLE LE GLAZ
External contributors (business, research, secondary education): various temporary teachers
Summary
This course aims to acquire knowledge about the business intelligence paradigm. This course covers the architectural aspects of Business Intelligence Information Systems (BIIS), focusing on their specificities and differences compared to Transactional Information Systems. In this perspective, this course also covers the data modeling aspects of CIS, and puts into practice a methodology to develop data models that ensure the necessary performance for CIS uses. This course covers the data feeding technologies of a BI Systems (ETL), their specificities and constraints, as well as market tools. Finally, this course covers the analysis and reporting aspects of the BI Systems and the tools dedicated to these types of production. In this course, we also focus on implementing high-performance BI Systems , providing significant freedom of analysis for their users, with a constant focus on data quality and consistency. The summary content of the course is as follows: Why build a BI Systems ?; OLTP/OLAP comparisons; BI modeling ; ETL issues: specificities, solutions, tools; Reporting: needs, tools; Tools used : ETL: Talend Studio Reporting: Tableau Software
Educational goals
At the end of the course, the student will be able to: Establish the needs for business intelligence data analysis in a company; Model the data to be included in the BI Systems; Model ETL flows ; Implement an industrialised ETL process Build reports from the BI Databases at the end of the course, the student will have progressed in: design a system; to realize, develop a system; set up test protocols; make and execute test sets; produce technical project documentation. Industrialize a computer production Working knowledge: business intelligence vocabulary; good development practices; decision modeling ; industrialization of production; security, confidentiality management Skills developed: Study and synthesis of the need Star modeling good development practices in ETL programming; perform unit tests; carry out industrialisable production start-up processes;
Sustainable development goals
Knowledge control procedures
Continuous Assessment
Comments: Defense + report
Online resources
Tableau Software licences
Pedagogy
1 course session to present business intelligence 2 modeling sessions on practical cases (TD) The other sessions on a mini-project of dashboards and data analysis on a reporting tool (Tableau Software)
Sequencing / learning methods
| Number of hours - Lectures : | 0 |
|---|---|
| Number of hours - Tutorial : | 12 |
| Number of hours - Practical work : | 20 |
| Number of hours - Seminar : | 0 |
| Number of hours - Half-group seminar : | 0 |
| Number of student hours in TEA (Autonomous learning) : | 0 |
| Number of student hours in TNE (Non-supervised activities) : | 0 |
| Number of hours in CB (Fixed exams) : | 0 |
| Number of student hours in PER (Personal work) : | 0 |
| Number of hours - Projects : | 0 |
Prerequisites
SQL, n-Tier architectures