Metadata Dashboard for RR

[gomezcatalina]

Proposed activity

To build a metadata dashboard to support Spatial Reproducible Reporting

Why this is important

Looking for an interactive tool for product owners and others to quickly visualize what is available in the Spatial Reproducible Report, without having to render reports

Action items

• [x] Connect Metadata Google Spreadsheet to Power BI (Sharepoint Connection to PowerBI failed)
• [x] Quentin, Jake, Catalina to clean metadata spreadsheet
• [x] Catalina to build dashboard (https://app.powerbi.com/links/y1MvqkDfD1?ctid=1594fdae-a1d9-4405-915d-011467234338&pbi_source=linkShare)
• [x] Teams to provide feedback
• [x] Share with SCRUM team

[gomezcatalina]

I provided the wrong link for the dashboard. Please le me know if the new one does not work: https://app.powerbi.com/links/y1MvqkDfD1?ctid=1594fdae-a1d9-4405-915d-011467234338&pbi_source=linkShare

[PJCoates]

That one works! Having a look now :rocket: :rocket: :rocket:

[stoyelq]

Immediate notes from my first passthrough:
Metadata summary slide:

• [x] - There are four types of data use constraint, not sure its worth capturing the "environmental response only" + ISDB and Marfis's "DFO INTERNAL USE ONLY -WE REALLY MEAN IT DO NOT SHARE".

-----> Quentin will add the customized wording for ISDB and MARFIS in the Rmarkdown. Protected B will capture this in the metadata tool.

• [x] - There are actually 12? records in emergency response, although they only show up as a single line on the sheet -----> yes, the RR metadata tool generally summarizes by number of rows in the google spreadsheet, not by number of species within a record.

• [x] General:

• [x] - It might be fun to capture the shape type? Polygons/lines/points? -----> done!

• [x] - Search years would be fun, but have fun with the string field : ) -----> added in one of the sections but TBD in the future how to improve it

• [x] - Quality tier would also be cool -----> we discussed this is a bit of a contentious topic but something to think about how to update in the metadata before highlighting it in the tool itself