Advanced Use of Excel (3cr)

Evaluation scale

1-5

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, excel exercises

Student workload

Lectures 15h, independent work 66h

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.

Qualifications

Information and communication technology, Spreadsheets