The majority of the Datasets created for this dashboard will be in SPICE (Super-fast, Parallel, In-memory Calculation Engine) Query mode, and therefore the SPICE capacity should be verified before taking the next steps.
Click the top right user menu and choose Manage QuickSight
Click SPICE capacity from the left. The following information displays:
The Total SPICE capacity section displays the total amount of used and unused SPICE capacity. A bar graph shows how much of this storage space is in each of the following categories for this AWS account in the AWS Region that’s currently selected in QuickSight:
Purchased SPICE capacity – This is the additional SPICE capacity you previously purchased.
Free SPICE capacity bundled with QuickSight – This is the total default capacity associated with your paid users.
Hover over any section of the meter to see details on that capacity type.
The SPICE usage section displays the total amount of the used and unused SPICE capacity. A bar graph shows how much of this storage space is in each of the following categories for this AWS account in the AWS Region that’s currently selected in QuickSight:
Used SPICE capacity – This is the used portion of the default SPICE capacity that you get for each user.
Unused SPICE capacity – This is the unused portion of the default SPICE capacity that you get for each user.
Releasable unused capacity – This is the purchased capacity that isn’t in use, and so can be released to reduce costs.
Click purchase more capacity if you are running low on Unused capacity NOTE: Purchased SPICE capacity can be released after purchase if it is not being used.
Go to the QuickSight service homepage inside your account. Be sure to select the correct region from the top right user menu or you will not see your expected tables
From the left hand menu, choose Datasets
Click New dataset displayed in the top right corner
Choose Athena as your Data Source
Enter a data source name of Cost_Dashboard and click Create data source
Select the database which holds the views you created (reference Athena if you’re unsure which one to select), and the daily_anomaly_detection table, then click Edit/Preview data
Select SPICE to change your Query mode
Select the daily_anomaly_detection dataset
Click Schedule refresh
Enter a daily schedule, in the appropriate time zone and click Create
Click Cancel to exit
Click x to exit
Repeat steps 3-14 to create data sets with the remaining Athena views. Select each of the following views as the table in step 6 & step 9:
For monthly_bill_by_account edit the dataset to change datatypes of region_latitude and region_longitude fields as latitude and longitude respectively and save, as per below picture.
When this step is completed, your Datasets tab should have 3 new SPICE labelled Datasets as above.
This completes the QuickSight Data Preparation section. Next up is the Import process to generate the QuickSight Dashboard.