Excel and BI - Opinto-opas

During the course, students will learn to manipulate data from various sources into a format that can be analyzed using Excel functions. Additionally, they will be introduced comprehensively to Pivot tools and Excel's data model, and will create visual reports based on the data, also utilizing Power BI.

ICT Competencies or equivalent knowledge. https://opinto-opas.haaga-helia.fi/course_unit/ICB001HH1AE
Advanced Use of Excel course recommended. https://opinto-opas.haaga-helia.fi/course_unit/ANA002AS2AE

Quick analysis of the area and table formatting
Traditional lookup functions and their limitations
XLOOKUP
Query - Importing and editing external data
Excel's data model
PowerPivot
Reporting and data visualization
Overview of Power BI Desktop program

When the implementation type of the course is CONTACT, ONLINE or BLENDED it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25 %, your grade will be lowered by one. If you are absent more than 50 %, the course is failed.

The student shows a basic understanding of Excel's common features and analysis tools. They can import and modify data in Excel under guidance, construct guided data models, and create simple dashboards for data analysis based on them.

The student shows proficiency in Excel's basic features and fundamental analysis tools. They are capable of importing and formatting data in Excel, constructing simple data models, and using them to analyze data effectively.

The student shows exceptional command of Excel's core features and key analysis tools. They adeptly utilize Excel's functionalities and techniques to a high degree. Additionally, they can proficiently source, import, and format data from diverse origins into Excel, construct advanced data models, and generate versatile dashboards for comprehensive data analysis.

Contact sessions with lecture and Excel & PowerBI exercises

Material available in Moodle.

Recommended sites:
https://support.microsoft.com/en-us/excel
https://learn.microsoft.com/en-us/training/powerplatform/power-bi

Pasila Campus

Will be informed in the beginning of the course.

English

21.10.2024 - 13.12.2024

03.06.2024 - 18.10.2024

IBE5PASCM
IBE5PAMAR
CONTACT
IBE5PACOM
IBE5PAACC
EXCH
ITE3PAICB1

Antti Mitronen, Timi Kohonen

15 - 45

Assessment criteria - grade 1
The student shows a basic understanding of Excel's common features and analysis tools. They can import and modify data in Excel under guidance, construct guided data models, and create simple dashboards for data analysis based on them.

Assessment criteria - grade 3
The student shows proficiency in Excel's basic features and fundamental analysis tools. They are capable of importing and formatting data in Excel, constructing simple data models, and using them to analyze data effectively.

Assessment criteria - grade 5
The student shows exceptional command of Excel's core features and key analysis tools. They adeptly utilize Excel's functionalities and techniques to a high degree. Additionally, they can proficiently source, import, and format data from diverse origins into Excel, construct advanced data models, and generate versatile dashboards for comprehensive data analysis.

Assessment criteria - failed
The above conditions are not met.

ITBBA Business Information Technology, INTBBA International Business

0.00 cr

H-5