This exercise explores the creation and presentation of compelling data narratives, framing the process as a journey from initial questions to actionable outcomes, such as solutions, opportunities, or well-informed decisions.

This example uses LOD and table calculations to find an employee’s weighted percent of goal.

In this exercise, we begin with a default relationship with two connections. Next, we explore joins and look at the new table joins create. Finally, we look at two data sources with data blending on a worksheet.

After replacing a data source, we’ll fix several errors highlighted with red fields, red warnings, and red exclamation marks.

Explore data to uncover new insights.

Filter the view but still use all the data in calculations

Create a dashboard that navigates between three different views and corresponding filter controls.

Create a box and whisker plot and add mark labels.

Use a parameter as a “menu” to switch between two worksheets.

Explore how totals change with different level of detail expressions.

Explore several exercises to select Top N with sets, filters, and parameters.

Use a calculated field and parameter to add a date to a title.