For the VM exercises of the BI courses, there are a lot of common phrases for instructions that re-appear in each course. Below you will find a (non-exhaustive) list of these phrases which you can use when developing VM exercises. You can copy all of the relevant phrases and paste them individually using e.g. Maccy for Mac, or the built-in clipboard of Windows 10. This will facilitate the consistency of common instructions over all courses.

Check again! Take a hint if you need more help.

Context

_If you have lost progress, close any open workbooks and load `1_1_all.twbx` from the Exercises folder on the Desktop._

Instructions

Open the workbook `1_1_all.twbx`.

Drag `Variable1` to the _Rows_ shelf.

Add a new worksheet and call it "New Worksheet".

To duplicate a worksheet, right-click on it and select _Duplicate_. Double-click to rename it.

Hints

To open workbooks, click on _File > Open..._ in the upper menu.

To add a new worksheet, click the _New Worksheet_ icon at the bottom. Double click to rename it.

If you're still getting the wrong answer, try loading `1_2_workbook_name.twbx` from the Exercises folder on the Desktop.

Hint specific for case studies

_If you can't find the solution, you can load the workbook `1_2_workbook_name.twbx` from the Exercises folder on the Desktop._
​
​

Context

_If you have lost progress, close any open reports and load `1_1_all.pbix` from the Exercises folder on the Desktop._

Instructions

Open `1_1_all.pbix` from the Exercises folder on the Desktop.

Add a new page and call it _New Page_.

Create a _Clustered bar chart_ visual, with `Variable1` as the _Values_ and `Variable2` as the _Axis_.

_If for some reason a new table is not showing up in the Model view, you can manually add a relationship using the Manage relationships icon in the Home menu. Click _New..._ and select the tables and columns where you want to define the relationship._

Hints

To open an exercise file, click the _File_ menu and then _Browse reports_.

To add a new page, click the _+_ sign at the bottom. Double click to rename it.

In the _Report_ view, make sure that nothing is selected by clicking on a blank part of the canvas before adding a new visual.

In the _Report_ view, click _Get data_ in the _Home_ menu and then _Text/CSV_.

Right-click `_Measures` and select _New measure_.

If you're still getting the wrong answer, try loading `1_2_workbook_name.pbix` from the Exercises folder on the Desktop.

Hint specific for case studies

_If you can't find the solution, you can load the workbook `1_2_workbook_name.pbix` from the Exercises folder on the Desktop._