30376 - BUSINESS INTELLIGENCE

Conoscenze e abilità da conseguire

At the end of the course students master the design, creation and interpretation of corporate Business Intelligence (BI) reports. They will understand the different design choices and technologies and the different options on how to implement a BI report. The course will also show how to include in a BI report forecasts and predictions (Business Analytics - BA).

Contenuti

Important: it is higly recommended to attend the course "Principi di Business Intelligence" (https://www.unibo.it/en/teaching/course-unit-catalogue/course-unit/2020/463901, taught in Italian) or to study in anyway the related contents before attending this course, as this will facilitate the learning process.

 

Data & big data management principles.

Databases architecture.

Business Intelligence in MS Excel through power pivoting.

Business Intelligence in Power BI Desktop and Cloud.

DAX functions, dashboarding, reporting.

Business Analytics using Power BI and R.

Testi/Bibliografia

Russo, Ferrari / The definitive guide to DAX, Microsoft Press, 2019 (2nd edition), 2nd edition.

Metodi didattici

Lectures and practical applications in laboratory.

Important note: up to 20 Erasmus students can be accepted, the criteria will be "first come, first served".

COVID update:

Lectures take place both on Microsoft Teams, at the online lectures link, and in class (simultaneously).

Students attending via Teams are supposed to connect in time to the lectures and are responsible of the following:

• Having a 64-bit computer firmly connected to the power network and (possibly via cable) to the Internet with a working camera and a working microphone;
• Having 64-bit Microsoft Windows installed and running - in case of a Mac, see here possible solutions to install Windows on Mac computers: https://www.youtube.com/watch?v=MuAVOpO7yFc&t=77s

  https://www.pcmag.com/news/how-to-run-windows-on-a-mac

• Having 64-bit Microsoft Office installed (Unibo provides a free copy to its students, to get it they are required to connect to www.office.com and login with their Unibo credentials, then download the 64-bit WINDOWS Microsoft Office, NOT the Mac one) - Excel - and Power Pivot activated and running (as an alternative it is possible to download 64-bit Power BI Desktop for free here: https://www.microsoft.com/en-us/download/details.aspx?id=58494).

Modalità di verifica e valutazione dell'apprendimento

The course mark is numeric.

The following information may change, based on the decisions of the University based on the COVID situation.

Practical test at the PC on MS Excel Power Pivot / MS Power BI, plus a few theory open questions.

COVID update:

Final tests take place on Microsoft Teams, the link will be automatically sent by mail to the students that applied on Almaesami.

Students are supposed to connect 15 minutes before the official start, for identification and troublshooting, and are responsible of the following:

• Having a 64-bit computer firmly connected to the power network and (possibily via cable) to the Internet with a working camera and a working microphone (also, an ID showing a picture must be at hand, to be identified);
• Having 64-bit Microsoft Windows installed and running - in case of a Mac, see here possible solutions to install Windows on Mac computers: https://www.youtube.com/watch?v=MuAVOpO7yFc&t=77s

  https://www.pcmag.com/news/how-to-run-windows-on-a-mac

• Having 64-bit Microsoft Office installed (Unibo provides a free copy to its students, to get it students are required to connect to www.office.com and login with their Unibo credentials, then download the 64-bit WINDOWS Microsoft Office, NOT the Mac one) - Excel - and Power Pivot activated and running (as an alternative it is possible to download 64-bit Power BI Desktop for free here: https://www.microsoft.com/en-us/download/details.aspx?id=58494);
• Having all the above mentioned softwares, plus a tool to convert a word into a pdf (PDFCreator can be downloaded for free here: https://www.pdfforge.org/pdfcreator/download) ready to work, running and tested;
  
• Applying in time on AlmaEsami to book the final test (no students will be accepted if out of the list, unless a specific agreement has been taken, with specified reasons).

When the application deadline on AlmaEsami is met, the Professor will send a mail to all the students that applied on AlmaEsami for that test date, sharing a folder where the datasets and the test files will be available, plus additional instructions, if needed. Students will have to check themselves their ability to upload and download files from that shared folder and inform the Professor with a mail in case something is wrong, so that issues are solved BEFORE the date of the test.

Strumenti a supporto della didattica

Blackboard, slides, PCs.

Orario di ricevimento

Consulta il sito web di Francesco Bergamaschi