Excel and BILaajuus (5 cr)

Learning objectives

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.

Contents

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

Lähtötaso ja sidonnaisuudet muihin opintojaksoihin

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

Implementation methods, demonstration and Work&Study

CONTACT
ONLINE
BLENDED
VIRTUAL
INTENSIVE
Work-based learning based on a plan (recognition of prior learning

Assessment criteria - grade 1

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.

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, approved/failed

The above conditions are not met.

Learning materials

Moodle