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.

General phrases

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

Tableau

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`.

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.



Power BI

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".

Did this answer your question?