Setup QuickSight Dashboard

We will now setup the QuickSight dashboard to visualize your usage by cost, and setup the analysis to provide Savings Plan recommendations.

1. Go to the QuickSight service:

2. Click on Manage data:

3. Click on New data set:

4. Click Athena:

5. Enter a Data source name of SP_Usage and click Create data source:

6. Select the costmaster database, and the sp_usage table, click Select:

7. Ensure SPICE is selected, click Visualize:

8. Click on QuickSight to go to the home page:

9. Click on Manage data:

10. Select the sp_usage Dataset:

11. Click Schedule refresh:

12. Click Create:

13. Enter a schedule, it needs to be refreshed daily, and click Create:

14. Click Cancel to exit:

15. Click the x in the top corner:

Advanced Setup

This section is optional and replaces the next two steps by creating the dashboard from a template. You will require access and knowledge of the AWS CLI, and Enterprise edition of QuickSight. If you do not have the access, go to the next step and manually create the dashboard as per the lab.

1. Go to this web page to request access to the template. Enter you AWS AccountID and click Submit: Template Access

2. Edit the following command, replacing AccountID and region, then using the CLI list the QuickSight datasets and copy the Arn for the sp_usage dataset:

    aws quicksight list-data-sets --aws-account-id (AccountID) --region (region)
   

3. Edit the following command, replacing AccountID and region, then using the CLI list your QuickSight users ARNs:

    aws quicksight list-users --aws-account-id (AccountID) --namespace default --region (region)
   

4. Create a local file create-dashboard.json with the text below, replace the values (Account ID), (User ARN), (Dataset ARN):

    {
        "AwsAccountId": "(Account ID)",
        "DashboardId": "SP_usage_analysis",
        "Name": "sp_usage analysis",
        "Permissions": [
            {
                "Principal": "(User ARN)",
                "Actions": [
                        "quicksight:DescribeDashboard",
                        "quicksight:ListDashboardVersions",
                        "quicksight:UpdateDashboardPermissions",
                        "quicksight:QueryDashboard",
                        "quicksight:UpdateDashboard",
                        "quicksight:DeleteDashboard",
                        "quicksight:DescribeDashboardPermissions",
                        "quicksight:UpdateDashboardPublishedVersion"
                ]
            }
        ],
        "SourceEntity": {
            "SourceTemplate": {
                "DataSetReferences": [
                    {
                        "DataSetPlaceholder": "sp_usage",
                        "DataSetArn": "(Dataset ARN)"
   
                    }
                ],
                        "Arn": "arn:aws:quicksight:us-east-1:869004330191:template/SP-Analysis-template"
            }
        },
        "VersionDescription": "1"
    }
   

5. Edit the following command, replacing (region), Run the command to create the dashboard and you should get a 200 response:

    aws quicksight create-dashboard --cli-input-json file://create-dashboard.json --region (region)
   

6. After a few minutes the dashboard will become available in QuickSight, click on the Dashboard name:

7. Click Share, click Share dashboard,

8. Add the required users, or share with all users, ensure you check Save as for each user:

9. Click Save as:

10. Enter an Analysis name and click Create:

11. You will now have the analysis created automatically from the template: