Practicing what you have learned

You need to create a public dimension that will be used multiple models. You have all of your hierarchy information in an Excel file and need quickly add them to your dimension.

In this practice exercise, you will perform the following tasks:

• Create a public dimension
• Add properties to the dimension
• Use Excel to add hierarchies to the dimension

ExerciseStart Exercise

You need to use a new model for analytical purposes and want to use both public and private dimensions.

In this practice exercise, you will perform the following tasks:

• Create an import model
• Configure the model to enable planning capabilities
• Add the required dimensions
• Change between structure view and foundation view

ExerciseStart Exercise

Before an upcoming board meeting, the HR department hands you an Excel file to incorporate into the board presentation. You must upload the file to a story and use a series of transformations to clean up and format the data. You must perform a series of quick transformations can help clean up data in the application.

In this practice exercise, you will perform the following tasks:

• Import data from a file
• Manipulate the data using grid view
• Wrangle and extract data
• Create a level-based hierarchy

ExerciseStart Exercise