Amazon QuickSight connector

Feed Amazon QuickSight from one warehouse model, not from a stack of SPICE refreshes.

Data Panda lands the data from your CRM, ERP, ecommerce and finance systems in a warehouse, then lets QuickSight read from one curated model. Dashboards, embedded views and Amazon Q answers come off the same numbers, and SPICE capacity stops being a monthly surprise.

Data Panda Reporting Automation AI Apps
Amazon QuickSight logo
About Amazon QuickSight

AWS's serverless BI, billed per session instead of per seat.

Amazon QuickSight became generally available in November 2016 as AWS's native cloud BI service, built around SPICE (Super-fast, Parallel, In-memory Calculation Engine), an in-memory columnar store that holds dataset extracts for fast dashboard queries. The pricing model is the unusual part: Authors pay a monthly seat (Standard at $24/user, Author Pro at $40/user), while Readers can be billed per active session ($0.30 per 30-minute session, capped at $5/user/month) or per seat. That per-session option is why QuickSight shows up so often as the engine behind embedded customer-facing analytics, where seat counts would be unworkable.

The platform layers Amazon Q in QuickSight on top, generally available since April 2024, for natural-language questions, dashboard summaries and generative dashboard authoring. Native connectors lean heavily into the AWS stack: S3, Athena, Redshift, Aurora, RDS, OpenSearch, Timestream and the Glue Data Catalog, plus the usual Snowflake, BigQuery and Databricks for cross-cloud setups. The strength is the AWS gravity: if your data already sits in S3 or Redshift, QuickSight is a single VPC hop away. The weakness is the same one that hits Power BI and Tableau pages: SPICE refreshes multiply, capacity bills creep, and embedded sessions stack up across tenants. We curate the warehouse so SPICE holds a small set of well-shaped tables and the per-session bill tracks actual reader behaviour.

What your Amazon QuickSight data is for

What you get once Amazon QuickSight is connected.

One model, every dashboard

Curated warehouse tables feed every QuickSight analysis, embedded view and Q topic from one source.

  • Revenue, margin and active customers defined once on the warehouse
  • Analyses branch from shared datasets, not from one-off SPICE imports
  • Embedded customer dashboards read the same facts internal teams read

SPICE that fits the readership

SPICE refresh schedules and capacity track actual dashboard usage, not historical extract sprawl.

  • Heavy joins land in the warehouse, not in SPICE on every refresh
  • Refresh cadence matches how often the source itself changes
  • Capacity bill scales with real readers, not with abandoned datasets

Amazon Q on a governed model

Q in QuickSight answers off curated topics with named measures, not from raw warehouse columns.

  • Natural-language questions resolve against the same fields analysts use
  • Generative dashboard authoring builds on the warehouse semantic layer
  • Q topics curated alongside the warehouse marts, not invented per dataset

Embedded analytics that scale per session

Customer-facing embeds read the warehouse, and per-session pricing tracks real product usage.

  • Anonymous and registered embeds backed by row-level security
  • Tenant isolation enforced on the warehouse, not just in QuickSight
  • Session pricing matches portal traffic instead of paying for idle seats
Use cases

Use cases we deliver with Amazon QuickSight data.

A list of concrete reports, automations and AI features we have built on Amazon QuickSight data. Pick the one that matches your situation.

QuickSight on RedshiftDatasets sitting on a curated Redshift schema instead of raw fact tables.
Athena on S3 lakeQuickSight reading the warehouse via Athena over a partitioned S3 layout.
SPICE capacity disciplineRefresh cadence and dataset count sized to actual readership, not legacy extracts.
Embedded SaaS analyticsCustomer-facing dashboards inside your product, paid per session, not per seat.
Amazon Q topicsCurated Q topics that mirror the warehouse marts so NLP answers stay consistent.
Author Pro on Gen BIAuthor Pro seats reserved for the people who lean on generative dashboard authoring.
Reader-session right-sizingReader licensing tuned between per-session and capped monthly per-user.
Multi-tenant row-level securityPer-tenant filters enforced at warehouse and QuickSight RLS, not just in the app.
Pixel-perfect reportsScheduled paginated reports off the same warehouse model the dashboards use.
Cross-account QuickSightQuickSight in one AWS account reading curated data shared from another via Lake Formation.
Anomaly and ML insightsQuickSight ML Insights and anomaly alerts on warehouse history, not on partial extracts.
Real business questions

Answers you will finally get.

Why did our QuickSight SPICE bill grow faster than our reader count?

SPICE bills against stored capacity and refresh frequency, not against active readers. A tenant that loaded twenty datasets early on and kept refreshing them hourly keeps paying for those refreshes whether dashboards open or not. Pulling QuickSight onto a curated warehouse means SPICE holds a smaller set of well-shaped marts, refresh cadence matches how often the source itself changes, and the bill tracks readership instead of historical setup choices.

Are we paying Reader seats or per-session, and which is cheaper for our usage?

QuickSight Readers can be billed per active 30-minute session at $0.30, capped at $5 per user per month, or as a Standard Reader seat at $3 per user per month. Per-session is the right call for embedded customer-facing dashboards or internal users who only check in occasionally; per-seat wins for daily power users. Looking at actual session telemetry against the seat list usually shifts the mix in one direction or the other and surfaces a real saving.

How do we keep Amazon Q answers consistent with what Finance sees in the dashboards?

Q in QuickSight answers off topics, which are curated layers over datasets with named fields and synonyms. If topics are built ad-hoc per dataset, the same question gets different answers in different parts of the org. Building Q topics alongside the warehouse marts, with one definition of revenue, customer and order, keeps the natural-language answers aligned with the same numbers Finance reads in the board pack.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Finance gets one revenue and margin definition that feeds every QuickSight analysis and any Amazon Q answer about turnover, reconciled to the boekhouding. The board pack and the analyst's exploration view land on the same number, and the SPICE capacity bill becomes a line item Finance can put in the next quarterly forecast with confidence.

For sales leaders

Sales sees pipeline, win rate and forecast in QuickSight analyses that join Salesforce or HubSpot to billing and product usage on the warehouse. The same numbers travel into embedded customer-facing dashboards inside the product, so internal QBRs and customer scorecards do not contradict each other.

For operations

Operations leads see throughput, SLA and cost-to-serve from the same warehouse Finance reads, and SPICE refresh schedules align with real source-change frequency. Embedded session usage becomes a knob ops can pull, instead of a surprise on the AWS bill at month end.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Amazon QuickSight data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Amazon QuickSight to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Amazon QuickSight connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Do you load everything into SPICE or query the warehouse directly?

Both, by design. SPICE holds the marts that need sub-second dashboard response or that get hit by many embedded sessions, with refresh cadence matched to how often the underlying warehouse table itself changes. Direct query stays in play for low-traffic analyses, ad-hoc exploration on Redshift or Athena, and anywhere the cost of an extra SPICE refresh outweighs the latency saving.

We embed QuickSight in our SaaS product. How does the per-session pricing really work?

Reader sessions are billed at $0.30 per active 30-minute window, capped at $5 per user per month for named readers, with anonymous embedded sessions priced through capacity bundles instead of named seats. For a customer-facing portal where most users open one dashboard a week, per-session is dramatically cheaper than buying every customer a seat. We model the expected session pattern against the capacity-bundle break-even and pick the structure that fits.

Does QuickSight only make sense if we are already on AWS?

It is the strongest fit when your data already lives in S3, Redshift, Athena or Aurora, because the connectors are first-class and the network path stays inside AWS. QuickSight does connect to Snowflake, BigQuery, Databricks, Postgres and the usual SaaS sources, so a cross-cloud setup is supported. The honest answer is that if you are not already in the AWS account graph, Power BI or Looker often fits the BE/NL mid-market motion better, and we will say so.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Amazon QuickSight setup and the systems around it. Together we pick the first thing worth building.