Excel and BI - ANA001AS3AE - Opinto-opas

Excel and BI, 5 cr - ANA001AS3AE

Upcoming implementations

Excel and BI ANA001AS3AE-3001 21.10.2024-13.12.2024 5 op (IBE5PASCM, ...) +-
Teaching methods and instruction

Contact sessions with lecture and Excel & PowerBI exercises

Learning material and recommended literature

Material available in Moodle.

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

Campus

Pasila Campus

Exam dates and re-exam possibilities

Will be informed in the beginning of the course.

Teaching language

English

Timing

21.10.2024 - 13.12.2024
Groups
- IBE5PASCM
- IBE5PAMAR
- CONTACT
- IBE5PACOM
- IBE5PAACC
- EXCH
- ITE3PAICB1
Teachers

Timi Kohonen

Seats

15 - 45

Further information

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.

Degree Programme

ITBBA Business Information Technology, INTBBA International Business

R&D proportion

0.00 cr

Virtual proportion

0.00 cr

Evaluation scale

H-5

Current implementations

No ongoing implementations yet.

Past implementations

No past implementations yet.

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.

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

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

Moodle

In this course, you will learn to analyze data sets using Excel's Business Intelligence tools. You will retrieve external tables with queries and transform their content into versatile diagrams and map presentations. You will also learn to build Excel's data model and use Power Pivot. Additionally, you will become familiar with the reporting capabilities offered by the Power BI Desktop program.

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

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.

The above conditions are not met.