Degree | Type | Year |
---|---|---|
2500003 Business and Information Technology | OT | 4 |
You can view this information at the end of this document.
Since the course deals specifically with obtaining and organizing data, it is important to take into account, and refresh if necessary, the concepts introduced in the Database Analysis and Design compulsory course, especially in relation to SQL queries.
The main goal of the subject is to introduce students to the set of tools and skills necessary to create useful and complete dashboards for strategic decision-making within an organization.
At the end of the semester, students should be able to:
1. Business Intelligence, Data Wharehouse and Dimensional Model
2. Dimensional model applied to different business processes (transactions, sales, inventory, accounting, order management, electronic commerce, ...)
3. Tour of the Processes and Tasks of the ETL system (Extraction, Transformation, and Load)
4. Business Intelligence programs
5. The representation of the data: metrics, KPI, good visualization practices, ...
6. Creation of effective dashboards
7. Integration of Databases at the Dimensional level
8. Big Data and its implications in the BI
Title | Hours | ECTS | Learning Outcomes |
---|---|---|---|
Type: Directed | |||
Laboratory classes | 15 | 0.6 | 2, 3, 4, 5 |
Lectures, discussion of cases and presentation of works | 30 | 1.2 | 1, 2, 3, 4, 5, 6, 7, 8 |
Type: Supervised | |||
Tutorials and follow-up of the work to be done and the cases to prepare | 15 | 0.6 | 1, 2, 3, 4, 5, 6 |
Type: Autonomous | |||
Related readings, preparation of cases and practices, study and elaboration of schemes | 87 | 3.48 | 1, 2, 3, 4, 5, 6, 7, 8 |
The subject uses PBL (problem based learning) as methodology thoroughout the course, and, whenever possible, based on real challenges (challenge based learning) of companies or entities. Using this methodology, the teachers of the subject provide resources (readings, videos, podcasts, ...) so that the students can apply them to business intelligence projects.
Time in class is divided between the theory applicable to the specific tasks of business intelligence and its practical application. Both individual practical exercises and a Business Intelligence Project are proposed within the course. The BI Project consists of the proposal and development of a set of dashboards based on the real data of a company. Furthermore, group and individual tutoring sessions are held to solve doubts and guidance in the preparation and execution of the project.
Annotation: Within the schedule set by the centre or degree programme, 15 minutes of one class will be reserved for students to evaluate their lecturers and their courses or modules through questionnaires.
Title | Weighting | Hours | ECTS | Learning Outcomes |
---|---|---|---|---|
Delivery and participation of the activities carried out in the classroom | 20% | 0 | 0 | 1, 2, 3, 4, 5, 6, 7, 8 |
Individual tests and final test | 40% | 3 | 0.12 | 1, 2, 3, 4, 5, 6, 7, 8 |
Realization of a Business Intelligence project | 40% | 0 | 0 | 1, 2, 3, 4, 5, 6, 7, 8 |
The final grade of the subject is the result of a continuous assessment formed by:
1. Participation and delivery of the activities carried out in the classroom.
2. Completion of a Business Intelligence project, which covers a large part of the course, and which is divided into 3 parts:
a) Search for an operational database of a company and development of the dimensional model.
b) Definition of the most appropriate management indicators and the most appropriate display.
c) Presentation of dashboards with an appropiate software.
3. Individual tests carried out throughout the course and on the date set by the Faculty.
The final grade of the subject will be determined from the weighted sum of the assessments of each of the three previous components, using the following calculation:
N= 20% (Participation and delivery of individual activities) + 40% (Completion of a BI project) + 40% (Individual tests)
It will be a necessary condition to calculate this value: (1) Attendance and participation in a minimum of 60% of the planned activities during the semester (component 1), and (2) obtain a minimum average rating of 4.5 in the set the individual tests (component 3).
Important notes:
Calendar of evaluation activities
The dates of the evaluation activities (exercises in the classroom, assignments, ...) will be announced well in advance during the semester.
The date of the final exam is scheduled in the assessment calendar of the Faculty.
"The dates of evaluation activities cannot be modified unless there is an exceptional and duly justified reason why an evaluation activity cannot be carried out. In this case, the degree coordinator will contact both the teaching staff and the affected student, and a new date will be scheduledwithin the sameacademic period to make up for the missed evaluation activity."Section 1 of Article115. Calendar of evaluation activities (Academic Regulations UAB). Students of the Faculty of Economics and Business, who in accordance with the previous paragraph need to change an evaluation activity date must process the request by filling out an Application for exams' reschedule https://eformularis.uab.cat/group/deganat_feie/application-for-exams-reschedule
Grade revision process
After all grading activities have ended, students will be informed of the date and way in which the course grades will be published. Students will be also be informed of the procedure, place, date and time of grade revision following University regulations.
Retake Process
"To be eligible to participate in the retake process, it is required for students to have been previously been evaluated for at least two-thirds of the total evaluation activities of the subject." Section 3 of Article 112 ter. The recovery (UAB Academic Regulations). Additionally, it is required that the student to have achieved an average grade of the subject between 3.5 and 4.9.
The date of the retake exam will be posted in the calendar of evaluation activities of the Faculty. Students who take this exam and pass will get a grade of 5 for the subject. If the student does not pass the retake, the grade will remain unchanged, and hence, the student will fail the course.
Irregularities in evaluation activities
In spite of other disciplinary measures deemed appropriate, andinaccordance with current academic regulations, "in the case that the student makes any irregularity that could lead to a significantvariation in the grade of an evaluation activity, it will be graded with a 0, regardless of the disciplinary process that can be instructed. In case of various irregularities occur in the evaluation of the same subject, the final grade of this subject will be 0". Section 10 of Article 116. Results of the evaluation. (UAB Academic Regulations).
In this sense, any delivery that is identified plagiarized by other colleagues or any other source entails a zero in that evaluation. In case of plagiarism between classmates, the zero will be as much for the plagiarist as for the one that facilitates the plagiarism.
Kimball, Ralph y Ross, Margy ((2013): The Data Wharehouse Toolkit: The definitive guide to Dimensional Modeling. Tercera edicion
Few, Stephen (2013): Information Dashboard Design: Displaying data for at-a-glance monitoring, Second Edition, Analytics Press
Few, Stephen (2012): Show Me the Numbers: Designing Tables and Graphs to Enlighten, Second Edition, Analytics Press
Clark, Dan (2020): Beginning Microsoft Power BI. A Practical Guide to Self-Service Data Analytics, APress Berkeley, CA, Accés: https://link.springer.com/openurl?genre=book&isbn=978-1-4842-5620-6
Aspin, Adam (2020): Pro Power BI Desktop. Self-Service Analytics and Data Visualization for the Power User, Apress Berkeley, CA, Accés: https://link.springer.com/openurl?genre=book&isbn=978-1-4842-5763-0
Aspin, Adam (2021): Pro Power BI Theme Creation. JSON Stylesheets for Automated Dashboard Formatting, Apress Berkeley, CA, Accés: https://link.springer.com/openurl?genre=book&isbn=978-1-4842-7068-4
Seamark, Philip and Martens, Thomas (2021):Pro DAX with Power BI. Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular, Apress Berkeley, CA, Accés: https://link.springer.com/openurl?genre=book&isbn=978-1-4842-4897-3
Ehrenmueller-Jensen, Markus (2020): Self-Service AI with Power BI Desktop. Machine Learning Insights for Business, Apress Berkeley, CA, Accés: https://link.springer.com/openurl?genre=book&isbn=978-1-4842-6231-3
Wade, Ryan (2020): Advanced Analytics in Power BI with R and PythonIngesting, Transforming, Visualizing, Apress Berkeley, CA, Accés:https://link.springer.com/openurl?genre=book&isbn=978-1-4842-5829-3
Specific BI software, such as Power BI or Tableau, always in appropriate educational versions.
Name | Group | Language | Semester | Turn |
---|---|---|---|---|
(PLAB) Practical laboratories | 201 | Catalan | second semester | afternoon |
(TE) Theory | 20 | Catalan | second semester | afternoon |