You need to create a QuickSight account to try this demo.
audit-demo-logs
-> and enable “Write permission for Athena Workgroup”. -> Save.Select Athena → Connect.
Enter Data source name: AuditLogsAthena
→ Create data source.
On the data selection screen:
Database: audit_reports
Table: audit_logsaudit_demo_logs
Click Select → you will see a preview of the table.
Enable Import to SPICE for quicker analytics → Visualize.
timestamp
field from the Data pane to the X axis area in the Field wells pane.user
to Rows.timestamp
to Columns → click the right arrow and change Date granularity to Day.Draw Top Users:
Select the Horizontal bar chart icon.
In Field wells:
user
to Category.Count
to Value.Add a Filter by action.
After creating all visuals, click Save and name it AuditTrailInvestigation
.
In Analysis, click Publish dashboard.
Dashboard name: Audit Trail Investigation
.