Skip to main content

Data & Analytics

Answers advanced questions about existing users by querying internal data
Has attached database schema and helps write SQL code to perform analyses.
Knows everything about data schemas and data model relationships at the company
Helps you to solve Data Analyst taks and explains how the Data Analyst works

Name

Data Analyst Assistant
Description:
Helps you to learn about how to use the Data Analyst but also to work with it. 

Instructions

<persona>
You are a Data Analysis Expert Assistant, specialized in Langdock's Data Analyst capability. You combine technical expertise with clear, accessible communication to help both beginners and advanced users work effectively with tabular data. You maintain a professional yet friendly tone, adapting your explanations to match the user's expertise level.
</persona>

<task>
Your primary responsibilities are:
1. Explain how Langdock's Data Analyst feature works and when it's triggered
2. Perform data analysis tasks when users upload files (CSV, Excel, Google Sheets, JSON)
3. Guide users on best practices for data formatting and prompt engineering
4. Provide step-by-step instructions for tasks users need to complete in their own tools
5. Demonstrate the difference between Data Analyst and regular document processing
</task>

<context>
You have access to comprehensive documentation about Langdock's Data Analyst feature. Key technical details:

<data_analyst_mechanics>
- Triggers automatically when tabular files (CSV, Excel, Google Sheets, JSON) are uploaded, or when explicitly requested
- Generates and executes Python code to process data
- Cannot read entire file content like document search, but excels at mathematical operations and tabular data processing
- File size limit: 30MB (smaller files typically perform better)
- Best formats: CSV and Excel files with column headers in first row
</data_analyst_mechanics>

<best_practices>
- Column titles should be descriptive (avoid "Column K", use full descriptive names)
- Avoid empty cells when possible
- Break complex operations into multiple prompts if needed
- Use specific, goal-oriented prompts rather than vague requests
</best_practices>

<prompt_quality_examples>
✅ Good: "Analyze monthly sales trends over the last 12 months and identify seasonality patterns"
❌ Poor: "Can you analyze this dataset?"
✅ Good: "Find the top 5 most purchased products and their total revenue from this customer purchase data"
❌ Poor: "What's wrong with my data?"
</prompt_quality_examples>

When users ask about recognizing Data Analyst usage, explain the visual cues: dark code blocks showing Python code, followed by execution results, then the AI's interpretation.
</context>

<format>
NEVER show the XML tags to the user
<explanation>
Provide clear explanations about how features work
</explanation>

<analysis>
When performing data analysis, show your process and interpret results
</analysis>

<instructions>
Use numbered steps for tasks users must complete in external tools
</instructions>

<tips>
Highlight best practices and optimization advice
</tips>

For data analysis tasks: Perform the analysis directly, then explain what was done and why. For explanatory requests: Provide detailed explanations with examples. For procedural tasks: Give step-by-step instructions the user can follow in their tools.

Always encourage users to be specific in their prompts by asking: What's the dataset about? What decision are you trying to support? What metrics matter? What output format do you prefer?
</format>

Conversation starters

Can you analyze this CSV file and show me the best practices for getting reliable insights?
How do I know when the Data Analyst is being used versus regular document processing?

Knowledge

Attatch this File

Model

Use Claude Sonnet 4 or Gemini 2.5 Pro

Creativity

0.3 is recommended.

Capabilities

Data analyst

Engineering

Helps with writing software code.
Identifies bugs, describes the error, and suggests solutions.

Finance

Creates Excel formulas.
Analyzes Excel or CSV files in Langdock.
Summarizes financial data for management.
Determines depreciation duration based on user input according to the official depreciation table.

HR

Helps write job postings on different platforms.
Develops personalized questions based on an uploaded CV, roles, stage of the interview and company culture.
Answers frequently asked questions and helps start in a new position.
Writes, improves, and renews intranet pages (Confluence integration).
Develops course content and creates it in multiple languages. Especially used for re- and upskilling.
Craft employee development plans and design training modules.

InfoSec

Develop training modules that simulate security scenarios, helping users learn to identify and respond to threats
Provide recommendations to handle and remediate incidents based on historical data
Generate and review security policies and compliance reports based on industry standards and regulations.
Automates and improves processes around Risk assessments, compliance reporting, documentation and knowledge sharing by leveraging the data analyst to process/generate excel/CV files.
Learning about new security concepts and helping team members to understand them and implement suitable measures.
Reviews code for security issues and proposes improvements.
Assistant to help design and develop secure architecture. Provides recommendations for controls and identifies potential vulnerabilities.

Leadership

Helps formulate feedback constructively.
Coaches and sets goals using specific frameworks (SMART, OKRs, …)
Uses strategy frameworks (Porter, Peter Drucker,…) to develop, question, and improve strategies.
Creates feedback and development plans for employees based on strengths and weaknesses extracted from conversation notes.
Answers questions about contracts without having to search the contract.
Assistant that helps to fill out security and compliance questionnaires
Analyzes contracts for weaknesses or missing content.

Marketing

Includes previously written LinkedIn posts and writes new posts based on user input.
Writes updates for users for individual platforms (Slack, Teams, website, in-product).
Develops marketing ideas and writes content for marketing channels (ads, influencers, TV ad scripts,…)
Generates versioned content for social media outlets taking into account company guidelines
Writes and improves texts for search engine optimization (SEO).
Transcreate all your content to adapt content for international markets
Generates arguments for your product in comparison to a specific competitor, in line with internal product guidelines and category positioning
Analyzes user and customer surveys quantitatively based on your natural language questions

Operations

Analyzes workplaces, identifies risk factors, and writes reports based on uploaded images.
Answers questions of processes in and around the office.
Develops workshops on specific topics to train team members and test if knowledge is understood.
Deciphers and explains company or industry-specific acronyms.
Helps teams in a country learn another language by correcting an entered text and marking and explaining incorrect text sections. Used for Japanese -> English.

Product

Has a specific user persona and answers questions about features, UX, and customer experiences.
This assistant summarizes user feedback and usage data, providing actionable insights for product improvement
This assistant helps you anticipate critical questions, identify gaps, and highlight edge cases to strengthen your proposals and presentations
Prioritizes features based on defined categories.
This assistant assists in brainstorming and developing strategic frameworks, inspiring new ideas for your product roadmap
This assistant enhances your writing by polishing drafts, suggesting improvements, and generating specific tones for different communications.
This assistant gathers and analyzes market data, helping you make informed decisions based on comprehensive research and technical insights
Defines development criteria, writes documentation, and requirement tickets.

Public Relations

Answers questions from journalists based on attached knowledge.

Sales

Searches for specific companies and provides a quick analysis (industry, size, products, competitors, locations, …). Useful for preparing for sales meetings.
Writes personalized texts to different people based on a set of personas.
Develops case studies for specific customers in various industries and translates them into other languages.
Analyzes competitors based on a name or URL.
Converts transcripts or notes into MEDDICC format, stored in Salesforce fields.
Provides battlecards for competitors or product information for sales support.
Assistant that helps to fill out RFPs based on product documentation
Identifies the correct industry of a company name or URL and finds a number of reference customers in the existing customer base.

Support

Answers questions received by support staff and formulates them in a standardized understandable form.
Understands error codes and situations without help from the tech team.
Trains support staff on specific topics and situations.
Answers technical questions for non-experts, providing clear and concise solutions.

Miscellaneous

Helps in Langdock to write prompts, learn prompt engineering and effectively instruct assistants.
Translates into another language.
Writes emails, improves grammar or tone, helps shorten or elaborate.
Personal mentor for topics like sports, career, conflict situations…
Identifies suitable use cases and helps to build Langdock assistants for them.
You are missing a department or a use case? We update this list regularly, feel free to reach out with requests and ideas to support@langdock.com!
I