Skip to main content

Advanced Use of ExcelLaajuus (3 cr)

Course unit code: LT00DL18

General information


Credits
3 cr

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.

Go back to top of page