Excel and BI (5 cr)
Code: ANA001AS3AE-3001
Basic information of implementation
- Enrollment
- 03.06.2024 - 18.10.2024
- Enrolment for the implementation has ended.
- Timing
- 21.10.2024 - 13.12.2024
- Implementation has ended.
- ECTS Credits
- 5 cr
- Campus
- Pasila Campus
- Teaching languages
- English
- Seats
- 15 - 45
- Degree programmes
- INTBBA International Business
- ITBBA Business Information Technology
- Teachers
- Antti Mitronen
- Timi Kohonen
- Groups
-
IBE5PASCMINTBBA, 5. semester, Pasila, Supply Chain Management
-
IBE5PAMARINTBBA, 5. semester, Pasila, Marketing and Sales
-
CONTACTContact implementation
-
IBE5PACOMINTBBA, 5. semester, Pasila, International Business Communication
-
IBE5PAACCINTBBA 5. lukukausi, Pasila, Accounting and Finance
-
EXCHEXCH Exchange students
-
ITE3PAICB1Business Information Technology, 3rd semester, ICT and Business, Pasila, group 1
- Course
- ANA001AS3AE
Evaluation scale
H-5
Implementation methods, demonstration and Work&Study
CONTACT
ONLINE
BLENDED
VIRTUAL
INTENSIVE
Work-based learning based on a plan (recognition of prior learning
Intro
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.
Materials
Material available in Moodle.
Recommended sites:
https://support.microsoft.com/en-us/excel
https://learn.microsoft.com/en-us/training/powerplatform/power-bi
Teaching methods and instruction
Contact sessions with lecture and Excel & PowerBI exercises
Exam dates and re-exam possibilities
Will be informed in the beginning of the course.
Assessment methods
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.