Basics: How to filter and navigate

You'll learn how to navigate the dashboard, how to use filters to slice the data, and how many datapoints are used in the selected data and where the data comes from in each page.

Maurice Vanderfeesten
|
27 steps
|
8 minutes

Microsoft Power BI

Google Sites

Navigate to [https://bit.ly/aurora-sdgs](https://bit.ly/aurora-sdgs)

Click full screen icon to open in new window

Data information

"Publications in selection", On the top left. This number shows how many publications are used in the visuals on the page. This number changes when filtering and selecting stuff. Right below is a chart showing how many of the publications you see are related to an SDG. This is important, because it gives a way a hint on how much you can interpret to generalize about a university for example.

"Last update: 2022-05-01" This show when the data in the dashboard was last updated. the publications data, author data, and al the enrichment metrics.

"Data Source & Datapoints". On each page we explain what additional data source we have used to enrich the publication data, and how many data points we were able to link to the publications.

Filters, slicing data

On the left bar you can find several filters, explained below. The filters are synched with other pages. So this selection holds when you navigate to other pages.

"Filter un-/related publications" In general the dashboard visuals are rendered interpreting ALL publications. But in some cases you might explicitly want to exclude the publications that are 'unrelated to SDGs'. Click "Related to SDGs (with 98% certainty)" Click here.

"Filter SDGs" Click the SDG Tiles to filter an SDG. To select multiple SDGs, hold CRTL/Command button. (default is all selected)

"Filter University" Click the University Logo's to filter/focus on a University To select multiple Universities, hold CRTL/Command button. (default is all selected) Click this image.

"Filter Organisational Structure" Search, or Browse through the university organisational hierarchy. Click on the depart ment or faculty you want to focus on. This is only possible for the universities who provided extra data on their authors and their affiliated internal organisational units. Click here.

Navigate pages

Click the Tabs in the top navigation bar to switch pages. Click here.

... or click the bottom menu with the page count. Click "Universities"

Focus mode: zooming in to one diagram

Tip! Filter the data to your specific needs first, to focus in particular on that part.

Click here. "Focus mode"

Right-click here.

Get the numbers behind the bars. Click "Show as a table"

Including or excluding data segments

Click SDG segment in university bar

Right-click SDG segment of interest

Click "Show as a table"

Right-click SDG segment

Click "Include", to focus on that specific segment only.

Use sliders to scroll through the publications and columns

Drilling down in the data hierarchy

Right-click SDG segment

Click "Show next level"

See publications for that SDG segment as bars and as a table in Organisational level 1

Tool tips > a quick summary of data segment

Hover with Mouse over a data segment in the SDG donut/bar/circle chart, and a quick summary of the publications in that segment will appear.

Drill through > a detailed view on data segment

Right-click on an SDG data segment

Click "Drill through" and next click on "Publications Page"

Use filters on the top to filter even further.