Q Division Field Training: Module 3 - Expense Statements

Dalton_Ruer · Feb 3, 2026 6:55:57 AM

Advanced Chunking, Enterprise Connections & The Power of Context

🎯 Mission Briefing

The name's Dork. 007 Dork. They say you're only as good as your questions. Well, lucky for you, I never miss.

THE SITUATION: Missions one and two involved rather static data. Today we're dealing with something much more near real-time: expense statements. After each Q Division mission closes, travel and expense statements get generated and logged. But something caught my eye while walking through accounting... a 4TB external hard drive and an encrypted USB drive on an agent's expense report. That seems a little "sus" to me, operatives. Double agent? Corporate espionage? Or legitimate operational expense?

YOUR MISSION: Build a knowledge base around agent expense statements using enterprise storage connections (like Amazon S3 buckets where files are constantly being inserted), enable advanced accuracy for complex multi-page tables, add this intelligence to your Field Training Assistant, and then test a theory about whether we've got a rogue agent on our hands.

DELIVERABLE: An enhanced assistant with three knowledge bases that can perform forensic accounting analysis across complex expense documents, understanding context that spans multiple pages and document sections.

PREREQUISITES: ⚠️ You must complete Modules 1 & 2 first! You'll need your existing Field Training Assistant with Agent Information and Application Design knowledge bases already configured.

📦 Field Equipment

What You'll Need:

Access to Qlik Answers in your environment
Completed Modules 1 & 2 (Field Training Assistant with 2 knowledge bases)
Q Division Expense Statement documents (15 PDF files included in download)
Approximately 20 minutes mission time
Optional: AWS S3 bucket credentials (we'll show you the manual alternative)

Download Mission Pack: 📥 QDivision_Field_Expense_Reports.zip attached

Video Intelligence Briefing: 🎥 Watch the Full Mission Walkthrough

🚀 Mission Steps

Step 1: Create Your Agent Expense Statements Knowledge Base

Navigate to your Answers section from your hub (not your applications - we don't want to see all that other junk cluttering our intelligence operations).

Click to create a new knowledge base and name it: "Agent Expense Statements"

Normally you'd add a description here, but we're field operatives on a mission, so let's keep moving!

Step 2: Enable Enhanced Accuracy (CRITICAL FOR THIS MISSION)

⚠️ FIELD NOTE: This is NEW and IMPORTANT!

Before adding files, toggle on the "Enhanced Accuracy" flag.

Why? These expense statements contain:

Multi-page tables that cross page boundaries
Timeline information mixed with expense line items
Mission notes at the top, expenses at the bottom, activities scattered throughout
Relationships between purchases and mission context that span three pages

Enhanced accuracy uses advanced chunking to handle these complex document structures. It takes a bit longer to process, but when you see what's in these expense statements, you'll absolutely understand why we need it.

The Trade-off:

Standard processing: Fast, good for simple documents
Enhanced accuracy: Slower, essential for tables and cross-page relationships

For expense forensics, we need enhanced accuracy. Period.

Step 3: Choose Your Data Source Approach

Here's where it gets interesting. I'm going to show you TWO approaches:

APPROACH A: Enterprise Storage Connection (S3 Bucket) - The Professional Way

Click "Add from connection" and select your space.

Choose your connection - in my case, "Q Division Expense Statements" which points to an Amazon S3 bucket.

The Power of Connections: When looking at enterprise file storage connectors, you can set up filters:

Only pull files after certain dates
Exclude files under/over specific sizes
File type filtering
Automatic indexing schedules

The Magic: As new expense statements get dropped into your S3 bucket, they can be indexed without manual uploads.

You can either:

Set up automatic filters (recommended for production)
Do manual selection (I'll select specific expense statements from my bucket)

In this scenario, the files stay in S3 - they're not copied to your Qlik tenant. You're indexing references to enterprise storage.

I would now select each expense statement from my bucket and add them to my knowledge base.

APPROACH B: Manual File Upload (The Field Operative Workaround)

But wait... my poor field operatives out there don't have access to MY S3 bucket, and I'm not giving you my secret key! That's classified information!

So here's what we're ACTUALLY going to do:

Click "Add files" and choose "Browse" to upload files directly.

Navigate to your unzipped mission pack containing the Q Division expense statement PDFs.

Select ALL 15 expense statement files and upload them.

You'll see them loading into your knowledge base.

Step 4: Index with Advanced Processing

I'm not even going to suggest it because you're going to wag your finger at me...

These are NOT indexed yet. You are NOT ready to use these until you've indexed them!

Click "Index All"

Now, because we turned on Enhanced Accuracy, this is going to take longer than our previous modules. Don't panic!

What's happening behind the scenes:

Advanced chunking is analyzing table structures
Vector embeddings are being created with enhanced precision

Watch the progress. You'll start seeing files complete their indexing. Keep scrolling to monitor status.

Wait for completion: You should see 39 pages across 15 different documents indexed.

Refresh and verify: "Index Status: Completed" with a recent timestamp (if it says "5 weeks ago" when you come back in 5 weeks, we've got problems!).

Step 5: Add Third Knowledge Base to Your Assistant

We're NOT creating another assistant. We want to tie ALL this intelligence together!

Navigate back to the Answers catalog. With all those files and knowledge bases accumulating, use the filter to show "Assistants and Knowledge Bases only" so you can find what you need.

Open your "Field Training Assistant" (the one you created in Module 1 and enhanced in Module 2).

Click to add content, then select "Add a knowledge base".

Filter to your "Q Division Field Academy" space.

Select "Agent Expense Statements" - notice it's the only one NOT grayed out (the others are already connected).

Click to add it.

Boom. Your assistant is now ready. Everything is indexed. Your agent has three knowledge bases:

Agent Information (Module 1)
Application Design (Module 2)
Expense Statements (Module 3)

This is business, operatives!

Step 6: The Forensic Accounting Test

Expand your assistant chat interface. I'm going to paste this question because you've seen my typing in other modules - it can be pretty bad:

"I reviewed the expense statement in the knowledge base for Case 103, and it seems suspicious to me that the agent purchased hard drives and a USB. Does that raise any red flags with you? Are they understandable?"

Before we see the AI's response, let me show you what I saw...

Scroll through the expense statements for Case 103. You'll find on November 16th:

External hard drives (4TB capacity)

10-port USB hub with encryption

I don't know why an agent who's out in the field getting wined and dined and meeting with clients is buying hard drives! That raises a red flag to me. If I were a human auditor reading this, that seems a little flaky!

Now watch what happens...

Step 7: The Answer Agent Goes to Work

You already guessed it - yes, the Answer Agent is on the job right away:

Gets all data sources
Understands the context is about Case 103
Tries to find the right information

The Knowledge Base Agent gets involved next:

Performs vector search for this information
Searches for hard drives related to this case
Returns a whole bunch of contextual information about what the case is about

Step 8: The Plot Twist (This Is Where It Gets Interesting)

I came in here assuming this agent was up to no good. I happened to read an expense statement. I think something's flaky. This is crazy!

But here's what the AI comes back with:

"The hard drive and USB are legitimate operational expenses. They don't raise any red flags. Let me give you the context: The case involved Operation False Precision, a data center investigation. These purchases are justified given that they were conducting forensic analysis of an ETL pipeline and code. All expenses comply with operational requirements."

WAIT, WHAT?!

When I jumped in to show you those suspicious expense line items, I didn't show you the mission notes at the top of the expense statement that documented the investigation activities and timeline!

Step 9: Understanding the Real Magic Here

Let me be crystal clear about what just happened, operatives:

This isn't just a search-and-find operation.

The other modules had super easy questions. I want you to understand the logic going on here - the collective wisdom of the world that's in that large language model that Qlik Answers is sitting on top of.

Here I am trying to do forensic accounting. I get the wisdom of the world saying:

"Whoa, whoa, whoa, 007 Dork! You've got binoculars on and you are FOCUSED on that expense line, and that is NOT what you need to see. You need to see the BIG PICTURE of what was going on!"

The AI was able to interpret from both contexts in a knowledge graph - these things are related:

The expense line items on page 3
The mission activities documented on page 1
The case notes explaining the investigation
The timeline showing when forensic analysis occurred

It connected the dots across multiple pages and document sections.

Operatives, you gotta be loving that! If you're not ready to dig in even deeper, I don't know what's gonna get you excited about Qlik Answers!

✅ Mission Debrief

What You've Accomplished:

✓ Created knowledge base with enhanced accuracy enabled
✓ Learned about enterprise storage connections (S3 buckets)
✓ Uploaded and indexed complex multi-page documents with advanced chunking
✓ Added third knowledge base to your Field Training Assistant
✓ Performed forensic accounting analysis with AI
✓ Witnessed contextual understanding that spans multiple document sections
✓ Experienced the difference between search and true intelligence

The Big Lesson: As a young Dork, I found that my focus could be very narrow. I would see one piece of information and jump to conclusions. If there's one thing I've learned here in Q Division, it's that the real story usually involves the ability to see a much larger context - one that's larger than even my Dork brain can handle.

Asking Qlik Answers is my way of ensuring that all the elements are being accounted for, and that in conjunction with the collective wisdom of the world in that large language model, the answers to my questions make me look a whole lot smarter.

Your Mission (Should You Choose to Accept It): Ask ONE better question today.

Next Mission: Module 4 will introduce data connections to live Qlik applications, combining structured data WITH all this unstructured intelligence. The Q Division Operation Data application will finally be revealed!

Challenge Exercise (Optional): See how far we can push this concept. Ask your assistant the following question: "The agent from Case 1006 returned from the mission acting a little sus, and an English-Russian dictionary slipped out of his attaché case. Please Conduct a comprehensive counter terrorism review of the expenses for case 1006 and please flag anything suspicious or out of scope for the mission, the target or the environment."

📚 Field Notes: Technical Deep-Dive

Why Use Storage Connections Instead of Direct Upload?

Auto-Update: New files automatically get indexed
Scale: Handle thousands of documents without manual uploads
Single Source of Truth: Files stay in your enterprise storage
Version Control: Updates to files are reflected automatically
Governance: Leverage existing access controls and permissions
Cost: Don't duplicate storage across systems

How Context Understanding Actually Works

When I asked about the suspicious hard drive purchase, here's what happened technically:

Step 1: Query Processing

User question parsed for intent: "Are these expenses suspicious?"
Key entities extracted: Case 103, hard drives, USB

Step 2: Vector Search

Knowledge Base Agent searches for semantically similar content
Finds expense line items matching "hard drives" and "USB"
Also finds mission notes containing related operational context

Step 3: Knowledge Graph Assembly

AI recognizes these chunks are from the same document
Identifies temporal relationships (mission timeline)
Maps expense items to mission activities
Understands cause-effect: "forensic analysis" → "data storage equipment"

Step 4: Collective Wisdom Application

LLM knowledge: "Forensic investigations typically require data storage"
Domain reasoning: "Hard drives are standard tools for ETL analysis"
Context synthesis: "Expenses align with documented mission objectives"

Step 5: Response Generation

Reframes the question with full context
Provides evidence from multiple document sections
Offers conclusion based on holistic understanding

This is NOT:

Simple keyword matching
Basic search and retrieval
Pattern recognition without understanding

This IS:

Semantic relationship mapping
Cross-document reasoning
Contextual intelligence with world knowledge
Evidence-based conclusions

The Difference Between Search and Intelligence

Traditional Search Would Return:

"Found: 4TB hard drive on line 47"
"Found: USB hub on line 52"
End of story

Qlik Answers Returns:

The expense items (with citations)
The mission context explaining WHY they were purchased
The operational justification from the case notes
A reasoned conclusion about legitimacy
Connections I didn't even know to look for

Real-World Application: This is the difference between:

❌ "Here are all documents containing 'budget overrun'" (search)
✅ "The budget variance is explained by Q3 supplier changes documented in procurement notes, which align with the strategic pivot mentioned in the board minutes" (intelligence)

Use Cases Where This Matters:

Compliance auditing (connecting transactions to policies)
Root cause analysis (linking symptoms to causes across documents)
Due diligence (connecting financial data to operational context)
Knowledge transfer (understanding the "why" behind the "what")
Decision support (seeing the full picture before acting)

🎬 Mission Accomplished, Operatives!

You've graduated from simple document retrieval to contextual intelligence that understands relationships across complex multi-page documents. You've seen firsthand how AI can provide the larger context that even a focused analyst might miss.

Your Field Training Assistant now has three knowledge bases working in harmony. It can answer questions about agents, application design, AND financial operations - all with citations and contextual understanding.

Remember: The most dangerous weapon in your arsenal isn't a golden gun - it's a golden question! And sometimes, the best answer is the one that shows you what you DIDN'T know to ask about.

Dork 007 Dork, signing off. Keep your chunking advanced and your context windows wide.

Questions? Feedback? What did the challenge question yield for you in terms of results and which agent do we need to investigate if Qlik Answers confirmed anything suspicious? 👎 Use the feedback button or share your forensic accounting stories

#QlikAnswers #QlikSense #DataAnalytics #BusinessIntelligence #AIAssistant #RAG #QlikDork #QDivision #007Dork #AdvancedChunking #EnhancedAccuracy #ForensicAccounting #ContextualAI #SemanticSearch #DocumentIntelligence #AIReasoning #KnowledgeGraph #AskBetterQuestions

Q Division Field Training: Module 3 - Expense Statements