QuickSight Dashboards
Amazon QuickSight(QS) is a cloud-scale business intelligence (BI) service that you can use to deliver easy-to-understand insights to the people who you work with, wherever they are. Amazon QuickSight connects to your data in the cloud and combines data from many different sources. In a single data dashboard, QuickSight can include AWS data, third-party data, big data, spreadsheet data, SaaS data, B2B data, and more. As a fully managed cloud-based service, Amazon QuickSight provides enterprise-grade security, global availability, and built-in redundancy. It also provides the user-management tools that you need to scale from 10 users to 10,000, all with no infrastructure to deploy or manage.
To learn more, view the QuickSight User Manual
- JPL (Commercial or GovCloud) Account
- AWS Athena
- AWS QuickSight
The PDS QuickSight Dashboard references the prd_vw_all_agg dataset imported from AWS Athena. This table aggregates PDS Node server logs for each day from 11-29-20 to 3-22-22. We've filtered out requests for the data archives contained within each site so we could focus on the tools and web services. See "Filters" below for more info on that.
You can schedule refreshes for a dataset in QS so that any updates in AWS will be automatically pushed to the respective dashboard. The following illustration shows this basic workflow:
For more info on scheduling refreshes, view the documentation here.
The All PDS Dashboard is organized into several pages, each containing visuals created from the PDS dataset. The first page displays usage and metrics aggregated across all the PDS Nodes while the others focus on the information coming from a single Node.
To get a better look at a visual, click it once to "select" it in the sheet. Then, click the "fullscreen" icon in the top right menu. Click the icon again to reset the size.
By default, each bar chart aggregates data transfer by month over the entire timespan of the dataset. To change the time interval, click a bar on the chart and select one of the "Drill down" or "Drill up" options that appears in the menu. You can view by Quarter, Month, Week, and Day. To return to the default view, click the "Reset" button in the top left of the QS UI.
If you'd like to
Formula used for calculated field with normalized score (gb_score etc.)
(sum(gigabytes) - minOver(sum(gigabytes), [date])) /
(maxOver(sum(gigabytes), [date]) - minOver(sum(gigabytes), [date]))