Business Intelligence
Code: 102194 ECTS Credits: 6| Degree | Type | Year | Semester |
|---|---|---|---|
| 2501232 Business and Information Technology | OT | 4 | 1 |
Contact
- Name:
- Daniel Blabia Girau
- Email:
- daniel.blabia@uab.cat
Teaching groups languages
You can check it through this link. To consult the language you will need to enter the CODE of the subject. Please note that this information is provisional until 30 November 2023.
Prerequisites
It is important to refresh concepts already treated in subjects such as Database, especially in relation to SQL queries.
Objectives and Contextualisation
Knowing how to collect the information available in a company and organize it correctly in order to analyze it and represent it in a way that is useful for making decisions.
Competences
- Capacity for working in teams.
- Demonstrating a comprehension of the business information systems, taking into account their three specific dimensions (informational, technological and organisational) and being active in the specification, design and implementation of said systems.
- Demonstrating a comprehension of the impact of the information systems on the decision making processes in different levels of organisations, searching and designing solutions to specific problems.
- Demonstrating creativity and initiative.
- Demonstrating the ability to plan in accordance to the objectives and available resources.
- Students must be capable of adapting to new situations and new knowledge that may lead to new analysis and different stances.
- Students must be capable of communicating information, ideas, problems and solutions to both specialised and non-specialised audiences.
Learning Outcomes
- Demonstrating a comprehension of the impact of the information systems on the decision making processes in different levels of organisations, searching and designing solutions to specific problems.
- Demonstrating creativity and initiative.
- Demonstrating the ability to plan in accordance to the objectives and available resources.
- Efficiently managing storing, collecting and keeping the knowledge of the organisation.
- Implementing treatment methods in order to obtain relevant information in the strategic decision making of the organisation.
- Students must be capable of adapting to new situations and new knowledge that may lead to new analysis and different stances.
- Using the more effective and up-to-date technical means in oral and written communication.
- Working in teams, sharing knowledge and communicating it to the rest of the team and the organisation.
Content
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
Methodology
In this subject, the teaching methodology of project work is applied, and whenever possible, based on real challenges (challenge based learning) of companies or entities. With this methodology, the teacher provides the student with resources (readings, videos, podcast, ...) and apply them in business intelligence projects. In class, time is divided into the theory applicable to business intelligence tasks and its practical application, both in individual practices based on PowerBI and Google Cloud, and in a Business Intelligence Project that consists of developing dashboards based on the real data of a company. Group and individual tutoring sessions are held to resolve doubts and guidance in the preparation and execution of the project.
With these practices and project, students will learn to:
* Collect and understand the information generated in business processes
* Structure the information to obtain a dimensional model that generates the Data Wharehouse of the company
* Analyze the Business Intelligence programs available in the market
* Use intensively one of the Business Intelligence programs. In particular, Microsoft Power BI software is studied in depth.
MS Power BI data visualization software is included in the university's MS Office 365 educational license.
In addition, we are supported by DataCamp (www.datacamp.com), a learning platform for data science, and Microsoft Azure Dev Tools for Teaching, a Microsoft program to offer students software design and development tools, access to Cloud Computing and learning resources.
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.
Activities
| Title | Hours | ECTS | Learning Outcomes |
|---|---|---|---|
| Type: Directed | |||
| Laboratory classes | 15 | 0.6 | 6, 2, 4, 5 |
| Lectures, discussion of cases and presentation of works | 30 | 1.2 | 6, 3, 2, 1, 4, 5 |
| Type: Supervised | |||
| Tutorials and follow-up of the work to be done and the cases to prepare | 15 | 0.6 | 6, 3, 2, 1, 4, 5 |
| Type: Autonomous | |||
| Related readings, preparation of cases and practices, study and elaboration of schemes | 87 | 3.48 | 6, 3, 2, 1, 4, 5, 8, 7 |
Assessment
This subject/module does not offer the option for comprehensive evaluation.
The mark of this subject is the result of a continuous evaluation formed by:
1. Delivery and participation of the activities carried out in the classroom. Assistance and participation are required for 80% of the planned activities (20%). In the non-face-to-face format, attendance will be understood as being available on the proposed connections.
2. Realization of a Business Intelligence project (40%). This project is divided into 3 parts:
a) Locate an operational database of a company and development of the dimensional model.
b) Definition of the most appropriate management indicators and the most appropriate visualization.
c) Presentation of a scorecard with MS Power BI.
3. Individual tests carried out throughout the course and on the date set by the Faculty (40%).
To calculate the grade of the subject, in addition to the attendance and participation to 80% of the planned activities, it is essential to obtain an average score higher than 5 in the set of individual tests.
A student is considered to be "Not evaluable" in the subject when informing the teacher that he/she leaves the subject before week 7 of the course.
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 Article 115. 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 significant variation 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.
Assessment Activities
| Title | Weighting | Hours | ECTS | Learning Outcomes |
|---|---|---|---|---|
| Delivery and participation of the activities carried out in the classroom | 20% | 0 | 0 | 6, 3, 2, 1, 4, 5, 8, 7 |
| Individual tests and final test | 40% | 3 | 0.12 | 6, 3, 2, 1, 4, 5, 8, 7 |
| Realization of a Business Intelligence project | 40% | 0 | 0 | 6, 3, 2, 1, 4, 5, 8, 7 |
Bibliography
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
Software
Microsoft Power BI: https://powerbi.microsoft.com/es-es/desktop/
Google Cloud plattform: https://cloud.google.com/
Azure Dev Tools for Teaching: https://www.uab.cat/web/serveis-dtic/programari-microsoft-1345826750494.html?detid=1345838132569