The Ultimate Demo Prompt
The Full Stack Deliverable
One prompt. MCP queries live Qlik data, then produces four simultaneous deliverables. This is the jaw-drop moment for any audience - a consultant would spend a full day producing these separately.
🌐
HTML Dashboard
Interactive charts, KPIs, filters
📊
PowerPoint Deck
Board-ready branded slides
📄
Word Document
Formal audit report with narrative
📋
Excel Workbook
Raw data + pivot-ready tables
The Prompt
Pull all supplier quality data from the SAP Procurement app - top vendors by defect rate, defect cost by year, material risk ranking, and company code breakdown.
Using that live data, produce all four of the following:
① HTML Dashboard - dark-themed interactive dashboard with KPI tiles, a bar chart for vendor defect rates, a trend line for 2016–2020, and a filterable table. Client-presentable quality.
② PowerPoint - 6-slide executive deck: title, executive summary, top vendor risks, year trend, cost analysis, and recommended actions. Professional dark theme.
③ Word Document - formal supplier quality audit report with: scope, methodology, findings, risk matrix table, and 5 recommendations.
④ Excel Workbook - 3 sheets: raw vendor data, pivot-ready summary by year, and a risk scorecard with RAG status applied.
qlik_create_data_objectqlik_list_measures
qlik_get_fieldsqlik_select_valuesqlik_clear_selections
Why this wins every room
HTML
No BI licence needed. Anyone with a browser sees live Qlik data - instantly shareable outside the organisation.
PPTX
Real numbers in slides. No copy-paste from Qlik. No stale screenshots. Rebuilds from live data every time.
DOCX
ISO-auditable written report. Not a template - a real narrative built from the data it just read.
XLSX
Finance gets structured numbers without Qlik access. MCP bridges the tool gap automatically.
HTML Dashboards
Interactive · Browser-based · Zero Qlik licence required
01
🌐 HTML Dashboard
The Executive Portal
Query the SAP Procurement app for: total spend, defect rate, top 10 vendors by risk, and year-on-year trend 2016–2020.
Build a single-page HTML dashboard:
- Hero KPI strip (Spend · Defect Rate · Cost of Defects · At-Risk Vendors)
- Horizontal bar chart: vendors ranked by defect rate
- Line chart: defect rate trend by year
- Sortable data table with RAG status column
Dark theme. Mobile-responsive. CDN chart library only. Client logo placeholder top-left.
📁 dashboard.html📊 Chart.js🔴🟡🟢 RAG
qlik_create_data_objectqlik_list_measuresqlik_get_fields
Impact: Share a single HTML file with a client who has no Qlik access. They get a live-data feel with real numbers - looks like a BI product, built in one prompt.
02
🌐 HTML Dashboard
The Supplier Scorecard Portal
Pull all vendors with more than 50 defects from SAP Procurement.
Create a filterable HTML scorecard page:
- Filter bar: by country, company code, year
- Card grid: one card per vendor showing name, defect rate, spend, risk badge (HIGH/MED/LOW)
- Clicking a vendor card expands to show their top 3 defective materials
- Export-to-CSV button for the visible filtered set
Professional B2B aesthetic. Subtle animations on load. No build tools - pure HTML/JS.
📁 scorecard.html🔍 Live filter⬇️ CSV export
qlik_create_data_objectqlik_get_field_valuesqlik_select_values
Impact: A supplier-facing portal the procurement team can use without Qlik credentials. Filtering + drill-down makes it feel like a real app - one prompt.
03
🌐 HTML Dashboard
The Boardroom Briefing Screen
Get total defects, spend, defect rate, and top 5 at-risk vendors from SAP Procurement.
Build a fullscreen TV briefing display for meeting rooms:
- Large animated KPI numbers with subtle pulse
- Scrolling ticker of high-risk vendor names
- Donut chart: defect distribution by company code
- "As at [date]" timestamp
- 16:9 layout · High contrast · No scrollbars
Designed to run on a wall screen during a steering committee meeting.
📁 briefing-screen.html📺 TV 16:9✨ Animated
qlik_create_data_objectqlik_list_measures
Impact: Numbers live from Qlik, displayed without opening Qlik. The "as at" timestamp is the detail that makes executives ask "how does it do that?"
04
🌐 HTML Dashboard
The Geo Intelligence Map
Query vendor country, total defects, defect rate, and spend for all vendor countries in SAP Procurement.
Build an HTML bubble-map dashboard:
- World map with vendor countries shown as bubbles
- Bubble size = spend volume · Bubble colour = defect rate (green → red)
- Hover tooltip: country, defect rate, spend, vendor count
- Side panel: ranked table of top 10 countries by risk
- Toggle: view by defect rate OR by spend volume
Use D3.js from CDN. Clean, minimal design. Downloadable as standalone HTML.
📁 geo-map.html🗺️ D3 map💡 Tooltips
qlik_create_data_objectqlik_get_field_valuesqlik_list_dimensions
Impact: Qlik's own geo charts require config. This produces a custom interactive world map from your data in one prompt - runs in any browser, shareable to anyone.
PowerPoint Presentations
Board-ready · Data-embedded · Zero copy-paste from Qlik
05
📊 PowerPoint
The Board Quality Review
Pull supplier quality KPIs from SAP Procurement: defects, defect rate, cost of poor quality, top 5 vendors by risk, year trend 2016–2020.
Build a 10-slide PowerPoint board presentation:
1. Title - "Supplier Quality Review Q4 2020"
2. Executive Summary - 4 KPI cards with real numbers
3. Defect Trend - bar chart 2016–2020
4. Top Risk Vendors - horizontal ranked bars
5. Worst Products by Rate - table with RAG
6. Cost Exposure - financial impact
7. Geographic Risk - vendor country breakdown
8. Root Cause Summary - 3 categories
9. Recommended Actions - 5 action items
10. Next Steps - timeline
Dark navy theme. Real chart data. No placeholders.
📁 board-review.pptx📊 10 slides🎨 Branded
qlik_create_data_objectqlik_list_measuresqlik_select_valuesqlik_clear_selections
Impact: A consultant typically spends 4+ hours building a board deck from Qlik exports. This produces a fully populated, properly designed PPTX with real numbers - in minutes.
06
📊 PowerPoint
The Vendor Business Review
For vendor "Mara S.A." only, pull all their data: products, defect rates, spend, year trend, vs company average.
Build a 6-slide vendor QBR deck presented TO the vendor:
1. Vendor Profile - name, country, total spend
2. Performance vs Benchmark - their rate vs average
3. Product Deep Dive - all materials + defect rates
4. Trend Analysis - year-by-year performance
5. Areas of Concern - top 3 flagged products
6. Improvement Targets - 3 measurable KPI targets for 2021
Professional, fact-based tone. Suitable for a supplier quarterly business review meeting.
📁 vendor-qbr.pptx🤝 Supplier-facing📈 Benchmark
qlik_select_valuesqlik_create_data_objectqlik_clear_selections
Impact: Vendor QBR decks are high-effort, politically sensitive. MCP filters to one vendor, computes benchmark comparisons live, builds the deck - no manual data lookup at all.
07
📊 PowerPoint
The Meetup Showcase Deck
Pull headline stats from SAP Procurement: total records, vendor count, defect rate, cost of poor quality, most interesting outlier.
Build the Johannesburg Qlik Meetup showcase deck (March 25, 2026):
- Slide 1: What is Qlik MCP?
- Slides 2–3: Live demo flow - what I asked, what it did, what it built
- Slides 4–5: Real numbers from SAP Procurement as proof points
- Slide 6: 5 use cases any Qlik customer can do today
- Slide 7: Call to action
Dynamic, modern design. Use real data as proof throughout. Qlik green branding.
📁 meetup-deck.pptx🎤 Conference-ready✅ Real proof
qlik_describe_appqlik_create_data_objectqlik_list_measures
Impact: You use MCP to pull the data, build the deck about MCP, and present using slides MCP just made - with real numbers. The meta-ness of it is the entire point.
Word Documents
Formal reports · Audit-ready · Data-backed narrative
08
📄 Word Document
The Supplier Audit Report
Query SAP Procurement for all supplier quality findings: defect rates, financial exposure, top offenders, year trend, geographic distribution.
Generate a formal supplier quality audit report (.docx):
- Cover page with date and classification
- Executive Summary (half page, non-technical)
- Scope and Methodology
- Findings with embedded data tables
- Risk Matrix: vendors × risk level
- Financial Impact Analysis with real figures
- 5 Numbered Audit Recommendations
- Appendix: full vendor data table
ISO 9001 style. Professional heading hierarchy. Table of contents. Page numbers.
📁 audit-report.docx📑 TOC📊 Data tables
qlik_create_data_objectqlik_list_measuresqlik_select_values
Impact: Audit reports take days to write. MCP pulls the findings and writes the document. ISO-style framing means it lands as a credible governance artefact, not just a summary.
09
📄 Word Document
The App Technical Handover
Describe the SAP Procurement Qlik app completely: data model, tables, fields, master measures with expressions, master dimensions, sheets, data sources.
Produce a technical handover document (.docx):
- App Overview and Purpose
- Data Architecture (tables, row counts, key relationships)
- Master Measures - full list with expressions explained in plain English
- Master Dimensions - fields, labels, use cases
- Sheet Inventory
- Known Limitations and Technical Debt
- Developer Onboarding Checklist (10 items)
Targeted at a Qlik developer inheriting this app. Use code formatting for expressions.
📁 app-handover.docx💻 Code blocks✅ Dev checklist
qlik_describe_appqlik_get_fieldsqlik_list_measuresqlik_list_dimensionsqlik_list_sheets
Impact: Every consultant's nightmare is inheriting an undocumented Qlik app. This produces complete technical documentation in one prompt - all 27 measure expressions explained in plain English.
10
📄 Word Document
The Business Case Document
Pull cost of poor quality, defect volumes, at-risk vendor count, and financial exposure from SAP Procurement.
Write a business case document (.docx) for supplier quality investment:
- Problem Statement - backed by real data figures
- Current State Analysis - actual numbers from the app
- Cost of Inaction - projected 3-year exposure
- Proposed Solution: Supplier Quality Management programme
- Expected Benefits with ROI calculation
- Implementation Roadmap (3 phases, 12 months)
- Risk and Mitigation
- Approval and Sign-off section
Executive reading level. Every claim backed by a figure from the data. No invented numbers.
📁 business-case.docx💰 ROI calc📋 Sign-off section
qlik_create_data_objectqlik_list_measures
Impact: A business case needs real numbers to be credible. MCP pulls the actual cost exposure and injects it into a properly structured investment document. Zero placeholders.
Excel Workbooks
Finance-ready · Pivot-structured · RAG scorecards
11
📋 Excel Workbook
The Finance Team Data Pack
Extract from SAP Procurement: all vendors with defects, their spend, defect count, defect rate, cost of poor quality, and company code.
Build an Excel workbook (.xlsx) with 4 sheets:
- "Raw Data": every vendor row, autofilter on
- "By Year": pivot-ready - year × company code × defect rate × spend
- "Risk Scorecard": vendors with RAG column (Red >0.15%, Amber 0.10–0.15%, Green <0.10%) and conditional formatting applied
- "Top 20": ranked by financial risk exposure
Frozen header rows. Column widths adjusted. Number formats applied. Print-ready layout.
📁 data-pack.xlsx4️⃣ 4 sheets🔴🟡🟢 Conditional format
qlik_create_data_objectqlik_get_field_valuesqlik_list_measures
Impact: Finance never wants to log into Qlik. Hand them a structured Excel with conditional formatting already applied - pulled from live Qlik data - and they'll trust it immediately.
12
📋 Excel Workbook
The Monthly Ops Tracker
Pull monthly defect data from SAP Procurement: defects by month × year × vendor × company code.
Create an Excel operational tracker (.xlsx):
- "Monthly View": month × year grid, defect counts per cell, heat-map colour scale white-to-red
- "Vendor Trend": each vendor as a row, columns = 2016–2020 yearly rates, sparkline in final column
- "Alerts": vendors where defect rate increased YoY in the last 2 periods, flagged red
- "Data Dictionary": field names, descriptions, calculation methodology
Ready for monthly operations review. No Qlik access needed to use or share it.
📁 ops-tracker.xlsx🌡️ Heat-map📉 Sparklines
qlik_create_data_objectqlik_select_valuesqlik_clear_selections
Impact: The heat-map month grid is something most analysts build manually in 2 hours. MCP queries the time-series data and formats it as a ready-to-use operational review document.
Bonus: Email + Meeting Pack
Stakeholder comms · Full meeting packs · One-shot deliverables
13
📧 HTML Email
The Monthly Quality Digest
Pull the latest quality stats from SAP Procurement: total defects, defect rate vs prior year, top 3 risk vendors, biggest mover (improved or worsened).
Generate a professional HTML email digest ready to paste into Outlook:
- Suggested subject line
- Header banner with month/year
- 3-column KPI summary (Defect Rate | vs PY | Cost Exposure)
- Top 3 vendors at risk - name, rate, trend arrow (↑↓ →)
- One-paragraph narrative for a non-technical procurement director
- Footer: data source, Qlik app link, unsubscribe placeholder
Inline CSS only (email-safe). Mobile responsive.
📁 digest-email.html📧 Inline CSS📱 Mobile-safe
qlik_create_data_objectqlik_list_measuresqlik_select_values
Impact: Automated quality digest emails normally need NPrinting or a custom integration. This produces a pixel-perfect data-populated HTML email in one prompt - no NPrinting licence needed.
14
🎯 Multi-Format
The Complete Meeting Pack
It's the day before the Supplier Quality Steering Committee.
Pull all relevant data from SAP Procurement and produce everything needed for tomorrow's meeting:
① Pre-read email - 5-bullet executive summary, ready to send tonight
② Meeting PowerPoint - 8 slides: findings, agenda, decisions required
③ Data Annex Excel - supporting numbers for any question in the meeting
④ Action Log Word doc - pre-populated with 5 likely actions from the data, owner/date columns blank for the room
All four outputs use consistent numbers, same vendor names, same framing. No contradictions.
📧 Pre-read email📊 8-slide deck📋 Data annex📄 Action log
qlik_create_data_objectqlik_list_measuresqlik_select_valuesqlik_clear_selectionsqlik_describe_app
Impact: "Everything for tomorrow's meeting" is the moment that redefines what an AI assistant means to a consulting team. Four consistent outputs from one data pull. This is the prompt that closes contracts.