Amazon QuickSight Course

Lesson 1 • QuickSight Editions and Pricing

Covers Standard vs. Enterprise editions, capacity pricing, and per-session models. Helps students select the right tier for organizational needs.

Lesson 2 • What Is Amazon QuickSight

Defines QuickSight as a cloud-native BI service and contrasts it with traditional BI tools. Sets context for the entire course by anchoring the platform's value proposition.

Lesson 3 • Navigating the QuickSight Console

Walks through the QuickSight interface, menus, and workspace layout. Builds the navigation fluency needed for all subsequent hands-on exercises.

Lesson 4 • Core Concepts and Terminology

Defines datasets, analyses, visuals, dashboards, and SPICE. Provides the shared vocabulary used throughout every chapter.

Lesson 1 • Supported Data Source Types

Surveys all supported connectors including databases, files, and SaaS sources. Frames the data ingestion landscape before hands-on connection work begins.

Lesson 2 • Connecting to External Databases

Covers JDBC-based connections to MySQL, PostgreSQL, SQL Server, and others. Expands connectivity skills beyond the AWS ecosystem.

Lesson 3 • Connecting to AWS Data Services

Demonstrates connections to S3, Athena, Redshift, and RDS. Reinforces AWS integration patterns central to enterprise QuickSight deployments.

Lesson 4 • Managing Data Source Credentials

Teaches secure credential storage, rotation, and shared data source governance. Connects data access security to organizational compliance requirements.

Lesson 1 • Filtering and Row-Level Preparation

Explains dataset-level filters that restrict rows before analysis begins. Reduces data volume and enforces business rules at the source layer.

Lesson 2 • Dataset Editor Fundamentals

Introduces the dataset editor interface, field types, and preview pane. Establishes the workspace where all data preparation tasks are performed.

Lesson 3 • SPICE Import and Refresh Strategies

Details SPICE ingestion, capacity management, and incremental refresh configuration. Optimises query performance and controls storage costs.

Lesson 4 • Joining and Blending Data

Covers inner, left, right, and full joins across tables and data sources. Enables multi-table analysis essential for real-world reporting scenarios.

Lesson 1 • Geospatial and Advanced Visual Types

Introduces maps, heat maps, tree maps, and funnel charts. Expands the visual toolkit for specialised analytical and executive reporting needs.

Lesson 2 • Tables, Pivot Tables, and KPIs

Builds tabular visuals, pivot tables with drill-down, and KPI cards. Addresses reporting needs that require exact values alongside visual summaries.

Lesson 3 • Formatting and Visual Customisation

Covers titles, labels, colours, legends, and axis configuration. Ensures visuals communicate clearly and meet organisational style standards.

Lesson 4 • Analysis Workspace Overview

Introduces the analysis canvas, field wells, and visual menu. Provides the operational foundation for all visualisation work in this chapter.

Lesson 1 • Filter Controls and UI Elements

Adds dropdowns, sliders, date pickers, and text inputs to the analysis canvas. Transforms static analyses into interactive self-service tools.

Lesson 2 • Drill-Down and Hierarchies

Sets up field hierarchies and enables drill-down within visuals. Gives users the ability to explore data at multiple levels of granularity.

Lesson 3 • Actions and Cross-Visual Filtering

Configures filter actions, URL actions, and navigation actions between sheets. Enables drill-through and linked exploration across an analysis.

Lesson 4 • Parameters and Dynamic Values

Teaches parameter creation, data types, and binding parameters to filters and visuals. Enables reusable, flexible analyses driven by user-selected values.

Lesson 1 • Publishing Dashboards from Analyses

Walks through the publish workflow, versioning, and replacing published content. Establishes the production deployment process for finished analyses.

Lesson 2 • Dashboard Design Principles

Covers layout, visual hierarchy, whitespace, and storytelling structure. Grounds dashboard construction in design principles before technical publishing steps.

Lesson 3 • Themes and Branding

Applies custom themes, fonts, and colour palettes to align dashboards with brand standards. Produces visually consistent outputs across all published content.

Lesson 4 • Sharing and Access Control

Configures dashboard sharing with users, groups, and public embedding. Connects access control to organisational security and governance policies.

Lesson 1 • Audit Logging and Compliance

Integrates CloudTrail logging, monitors API activity, and generates access reports. Supports compliance requirements by providing a complete audit trail.

Lesson 2 • Namespaces and Multi-Tenancy

Covers QuickSight namespaces for tenant isolation in SaaS deployments. Enables scalable multi-tenant architectures with separate user pools and assets.

Lesson 3 • Row-Level Security Fundamentals

Explains RLS concepts, permission datasets, and how rules restrict row visibility. Establishes the security model before configuration steps are introduced.

Lesson 4 • Column-Level Security

Restricts visibility of sensitive columns to authorised users or groups. Complements RLS by adding field-level access control to the governance model.

Lesson 1 • QuickSight Q Natural Language Queries

Enables Q, configures topics, and trains the NLQ engine with business terminology. Empowers non-technical users to query data using plain language.

Lesson 2 • Narrative Insights and Auto-Narratives

Adds auto-generated text narratives to visuals using QuickSight's insight engine. Converts chart data into plain-language summaries for executive audiences.

Lesson 3 • Integrating External ML Predictions

Connects SageMaker-generated prediction columns to QuickSight datasets. Extends analytics with custom ML outputs beyond QuickSight's native capabilities.

Lesson 4 • Anomaly Detection and Alerts

Sets up ML-powered anomaly detection and threshold-based email alerts. Enables proactive monitoring without manual data review.