Now that we are finished connecting to and transforming data, there should be three active queries and four intermediate queries listed in the Queries pane.

Active queries include Budgets and Forecast, People, and Hours. These should not be italicized. These are the active queries that will create tables in the data model. There should also be four intermediate queries for Tasks, January, February, and March that are italicized. These queries will not create tables in the data model, but are used by the active queries.

The Queries pane should look as follows:

We can view how our sources and queries are related to one another by viewing the query dependencies. We can do this by performing the following steps:

1. First, click on the View tab of the ribbon.
2. Then, click the Query Dependencies button in the Dependencies area of the ribbon. This displays the Query Dependencies window, as shown in the following screenshot:

3. Click on the Tasks query to highlight the sources and other queries related to the Tasks query.
4. When you have finished exploring, click the Close button.