BUSINESS INTELLIGENCE: ADVANCED MANAGEMENT CONTROL AND PLANNING SYSTEMS
cod. 1012308

Academic year 2024/25
1° year of course - Second semester
Professor
Fabio VERGA
Academic discipline
Economia aziendale (SECS-P/07)
Field
A scelta dello studente
Type of training activity
Student's choice
28 hours
of face-to-face activities
4 credits
hub:
course unit
in ITALIAN

Learning objectives

Knowledge and Understanding:
- Understand the fundamental principles of BI and their practical application.
- Learn to use Microsoft Power BI for analyzing and presenting business data.

Applied Knowledge and Understanding:
- Ability to collect, transform, and visualize business data using Power BI.
- Develop skills in analysis and reporting.

Independent Judgment:
- Critically evaluate analytical results and propose data-driven solutions.

Communication Skills:
- Ability to create and present interactive reports and clear, compelling visualizations.

Learning Skills:
- Develop the ability to independently explore and deepen knowledge of Power BI and related technologies.

Prerequisites

- - -

Course unit content

The course aims to introduce students to the fundamental concepts of Business Intelligence (BI) and provide practical skills for using Microsoft Power BI, one of the most popular BI tools. The program is divided into two main modules:

Theoretical Concepts of Business Intelligence
Practical Applications with Microsoft Power BI:
- Introduction to the Power BI environment: functionalities and main components.
- Importing and transforming data using Power Query.
- Creating interactive reports and dashboards.
- Building a Data Model and using DAX (Data Analysis Expressions) for advanced calculations.
- Sharing and collaborating through Power BI Service.

Full programme

- - -

Bibliography

Fabio Verga, "Introduzione alla Business Intelligence con Microsoft PowerBI", materials available on the course platform.
Microsoft Documentation (https://learn.microsoft.com/it-it/power-bi/).
Additional support materials will be provided during the course through the course platform (e.g., sample files, tutorials, YouTube channels).

Teaching methods

Acquisition of Knowledge: Interactive lectures with practical demonstrations and hands-on exercises in the computer lab.

Acquisition of the Ability to Apply Knowledge: Students will participate in practical lab exercises using simulated datasets to develop reports and dashboards with Microsoft Power BI. Case studies will be proposed to apply the techniques learned during the lectures for analyzing and solving business problems.

Acquisition of Independent Judgment: During the course, students will be encouraged to critically evaluate the results obtained using Power BI and identify areas for improvement or alternative approaches.

Acquisition of Learning Skills: Each topic will start with the illustration of the problem to be solved, followed by a critical analysis of possible solutions.

Acquisition of Technical Language: The course will explain the meaning of technical terms used in the field of Business Intelligence and Power BI, such as "dataset," "Data Visualization," "ETL," "Data Model," and more.

Assessment methods and criteria

Practical Exam using a Computer:
Students will create a Power BI report, which will be evaluated based on criteria of completeness, clarity, and technical accuracy.

The maximum score is 30/30, with the possibility of honors.

Honors will be awarded when all components of the exam demonstrate excellence in completeness, clarity, brilliance, vivacity, and organization of the work.

Other information

- - -

2030 agenda goals for sustainable development

- - -