Advanced Use of ExcelLaajuus (3 cr)
Code: LT00DL18
Objective
The student knows how to plan, implement and use Excel's PowerPivot functionality versatilely. The student knows how to import data into Excel from databases and a CSV file. The student knows how to build a PowerPivot data model and present results graphically and filter them. The student knows the basics of the DAX language and knows how to use it in building a data model and metrics.
Content
With the Excel spreadsheet program
- Data import from different data sources
- Building a PowerPivot data model
- Basics of the DAX language
- Preparing graphic and numerical reports
- Creating a dashboard
Qualifications
Information and communication technology, Spreadsheets
Assessment criteria, satisfactory (1)
The student passes the requirements according to the performance rule. The student knows how to import information from different sources into Excel and create a PowerPivot data model at a basic level. He knows how to satisfactorily create metrics, reports and dashboards based on a data model. The student knows how to use the basics of the DAX language.
Assessment criteria, good (3)
The student passes the requirements according to the performance rule. The student knows how to import information from different sources into Excel better than at the basic level. The student knows how to create a PowerPivot data model. He knows how to create metrics, reports, and a dashboard based on a data model. The student knows how to use the basics of the DAX language.
Assessment criteria, excellent (5)
The student fulfills the requirements according to the performance rule. The student knows how to create a PowerPivot data model. He knows how to apply metrics, reports, and dashboards based on the data model. The student knows the DAX language and can apply it.
Enrollment
13.11.2023 - 08.03.2024
Timing
04.03.2024 - 26.05.2024
Credits
3 op
Virtual proportion (cr)
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Business Administration, Business Management
Teachers
- Mikko Kulmala
Student groups
-
EXLI24Excel as Business Support Tool
-
VVO
Objective
The student knows how to plan, implement and use Excel's PowerPivot functionality versatilely. The student knows how to import data into Excel from databases and a CSV file. The student knows how to build a PowerPivot data model and present results graphically and filter them. The student knows the basics of the DAX language and knows how to use it in building a data model and metrics.
Content
With the Excel spreadsheet program
- Data import from different data sources
- Building a PowerPivot data model
- Basics of the DAX language
- Preparing graphic and numerical reports
- Creating a dashboard
Materials
Material provided by lecturer and online materials
Teaching methods
Lectures in Teams, excel exercises
Completion alternatives
Kurssi on mahdollista suorittaa itsenäisesti tehtäviä suorittaen
Student workload
Lectures 12h, independent work 69h
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
The student passes the requirements according to the performance rule. The student knows how to import information from different sources into Excel and create a PowerPivot data model at a basic level. He knows how to satisfactorily create metrics, reports and dashboards based on a data model. The student knows how to use the basics of the DAX language.
Assessment criteria, good (3)
The student passes the requirements according to the performance rule. The student knows how to import information from different sources into Excel better than at the basic level. The student knows how to create a PowerPivot data model. He knows how to create metrics, reports, and a dashboard based on a data model. The student knows how to use the basics of the DAX language.
Assessment criteria, excellent (5)
The student fulfills the requirements according to the performance rule. The student knows how to create a PowerPivot data model. He knows how to apply metrics, reports, and dashboards based on the data model. The student knows the DAX language and can apply it.
Assessment methods and criteria
Assingment
Qualifications
Information and communication technology, Spreadsheets