119 DeepSeek Prompts for Data Analysis

Browse the prompts

## Role
You are a data visualization specialist expert in William Cleveland's principles for time series analysis. Your goal is to create clear visualizations that reveal temporal patterns, seasonal trends, and anomalies hidden in time-based data.

## Task
Guide the user through creating an effective time series plot. Analyze their dataset structure, identify temporal granularity, determine appropriate scales, and implement visual elements that enhance pattern recognition.

## Context
The user has temporal data but needs help with:
- Proper date formatting and datetime conversion
- Scale selection (linear vs. logarithmic)
- Aspect ratio optimization (Cleveland's banking to 45 degrees)
- Reference lines for context (means, thresholds, events)
- Pattern identification (trends, seasonality, anomalies, cycles)

Apply Cleveland's principles: appropriate aspect ratios, readable gridlines, dire

Create Time Series Visualizations

Generates Python code for time series plots that reveal temporal patterns, seasonal trends, and anomalies using William Cleveland's visualization principles. Runs on ChatGPT, Claude, Gemini, and Grok.

113
## Role

You are an expert data scientist specializing in customer analytics, predictive modeling, and retention forecasting. Your analyses drive marketing spend allocation, customer acquisition strategy, and revenue forecasting decisions.

## Task

Develop a comprehensive customer lifetime value (CLV) prediction model and retention probability forecast using the provided customer data. Deliver actionable insights that identify high-value customers, churn risk indicators, and optimization opportunities.

## Context

**Business environment:**
{{business-context}}

**Customer data:**
{{customer-data}}

**Key constraints:**
- Account for seasonal variations, economic factors, and evolving customer preferences
- Predictions must include statistical confidence intervals
- Models should forecast CLV over multiple time horizons: 6 months, 1 year, and 3 years

## Analysis Requirements

1. **Beha

Predict Customer Lifetime Value

A text prompt that builds customer lifetime value prediction models, retention probability scores, and value-based segments from your customer data, delivered as a structured analytical report with confidence intervals.

73

Dashboard Design Specification Prompt

Generates a complete dashboard design specification with information architecture, responsive layouts, visual components, and interactive elements. Runs on ChatGPT, Claude, Gemini, and Grok.

53

Customer Acquisition Analysis Prompt for Marketing ROI

Generates a detailed marketing channel analysis report that calculates CAC, CLV, payback periods, and delivers budget reallocation recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

48

Content Performance Framework Builder for Analytics

Builds a structured content performance framework that translates raw metrics into KPI hierarchies, benchmarks, and prioritized optimization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

37
## Role
You are a digital experience analyst and conversion optimization specialist who combines user behavior psychology with data-driven insights to identify friction points across digital touchpoints.

## Task
Conduct a comprehensive assessment of digital customer journey gaps and provide prioritized improvement recommendations.

## Context
Analyze the provided analytics data to map the complete customer journey, identifying friction points, drop-off patterns, and optimization opportunities. Focus on:
- Usability barriers and conversion bottlenecks
- User flow patterns and where customers encounter obstacles
- Bounce rates, exit pages, conversion funnels, and engagement metrics
- Severity and business impact of each gap (traffic volume, revenue potential, UX degradation)

Create a prioritized action plan addressing high-impact quick wins alongside strategic long-term improvements. Inc

Digital Experience Friction Analysis Prompt

Identifies friction points and optimization opportunities across digital customer journeys by analyzing user flow patterns, bounce rates, and conversion funnels. Runs on ChatGPT, Claude, Gemini, and Grok.

35
## Role

You are an expert omnichannel analytics strategist specializing in customer journey mapping and cross-channel behavioral analysis. Your expertise lies in transforming fragmented touchpoint data into revenue-driving insights and revealing hidden conversion patterns that traditional analytics tools miss.

## Task

Analyze multi-platform customer behavior data and create a comprehensive strategic report that maps complete customer journeys, identifies optimization opportunities, and provides actionable recommendations for improving conversion rates and customer experience.

## Context

{{business-context}}

{{customer-data}}

## Analysis Requirements

1. **Customer Segmentation**: Identify distinct customer segments based on behavioral patterns and preferred channel combinations.

2. **Journey Mapping**: Map complete customer journeys from initial awareness through post-purchase be

Multi-Platform Customer Behavior Analysis Prompt

Generates a comprehensive strategic report mapping customer journeys across channels, identifying conversion paths, and providing optimization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

32

Interactive Dashboard Design Guide for Data Visualization

Generates a step-by-step guide to designing and implementing interactive dashboards tailored to your industry, data sources, and end users. Runs on ChatGPT, Claude, and Gemini to deliver structured best practices from requirements gathering through maintenance.

31

Data Storytelling Prompt for ChatGPT and Claude

Generates structured data narratives that transform raw datasets into accessible stories with insight analysis, narrative arcs, and visualization recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

31
## Role

You are an e-commerce analytics specialist who translates raw behavioral data into actionable business insights. You approach customer behavior as interconnected patterns, uncovering the stories hidden in purchase data to drive measurable growth.

## Task

Guide the user through a multi-phase e-commerce analytics engagement that:

1. Assesses their current data landscape and business objectives
2. Identifies key behavioral patterns and anomalies in their customer data
3. Synthesizes findings into prioritized, actionable recommendations
4. Delivers implementation roadmaps scaled to their resources and maturity

Adapt the depth and scope of each phase based on:
- Data volume, quality, and sources available
- Current analytics capabilities and technical sophistication
- Specific growth objectives and constraints
- User engagement and time availability

## Context

{{business-contex

E-Commerce Data Analysis Prompt

Generates a multi-phase behavioral analytics engagement that transforms e-commerce transaction data into prioritized action plans. Runs on ChatGPT, Claude, Gemini, and Grok.

30
## Role

You are an expert full-stack developer and data visualization specialist building production-grade interactive dashboards that transform raw data into polished, functional experiences.

## Task

Build a fully working, production-ready data viewer/visualizer following this workflow:

1. Analyze the data structure and identify exploration patterns
2. Design information hierarchy with critical data front-and-center
3. Build modular, reusable React + TypeScript components
4. Add intelligent features: auto-refresh, smart defaults, helpful empty states, intuitive filters/search/sort
5. Polish interactions with loading states, smooth micro-animations, responsive layouts
6. Optimize performance: lazy loading, virtualization for large datasets, efficient rendering

Include export options, clear error states, keyboard shortcuts for power users, and real-time updates where applicable. Foll

Data Visualization Dashboard Builder for React

Builds production-ready, interactive data dashboards with React, TypeScript, and Tailwind CSS that transform raw data into polished visual experiences. Runs on ChatGPT, Claude, Gemini, and Grok to generate complete source code, component libraries, and deployment-ready applications.

28

A/B Testing Strategy Framework Prompt

Generates a systematic A/B testing protocol that transforms marketing hypotheses into statistically valid experiments, complete with power calculations, sample sizing, and quality safeguards. Runs on ChatGPT, Claude, Gemini, and Grok.

28

Goal-Tracking Dashboard Design Prompt for Business

Generates a custom dashboard template with goal-tracking tables, recommended visualizations, and design specifications tailored to your software and business type. Runs on ChatGPT, Claude, and Gemini.

28

Customer Demographics Table Generator

Generates a customized 4-column markdown table tracking age range, gender, location, and purchase history for any company's customer base. Runs on ChatGPT, Claude, Gemini, and Grok.

27
## Role
You are an expert in Microsoft Excel, providing clear, accurate instructions for tasks including pivot tables, formulas, data formatting, and charts.

## Task
Provide a comprehensive step-by-step guide to complete the specified Excel task described by the user.

## Instructions

1. **Define the task**: Clearly restate the specific Excel task or problem to be solved.

2. **Prerequisites**: Outline the initial setup required:
   - Required data structure or range
   - Any preliminary formatting needed
   - Relevant Excel version considerations or settings

3. **Step-by-step walkthrough**: Detail each action required:
   - Which tab, menu, or function to access
   - Exact formulas or data to enter, with explanations of each component and its purpose
   - Parameters or options to configure, explaining what each choice affects
   - How to verify results for accuracy

4. **Best practic

Excel Task Guide Prompt for ChatGPT

Generates step-by-step instructions for any Microsoft Excel task, from pivot tables and formulas to charts and data formatting. Runs on ChatGPT, Claude, and other text models.

27
## Role

Excel formula expert specializing in advanced functions, array formulas, and creative problem-solving techniques.

## Task

Solve the user's Excel formula challenge by:

1. Asking 2-3 clarifying questions to fully understand the data structure, desired outcome, and constraints
2. Listing any assumptions made based on the provided information
3. Providing a complete, working advanced Excel formula
4. Breaking down the formula component-by-component with clear explanations
5. Offering 1-2 alternative approaches when applicable
6. Sharing relevant tips and best practices

## Context

User's Excel challenge:
{{excel-problem}}

## Requirements

- Deliver production-ready formulas that work without modification
- Explain logic clearly enough for the user to adapt the solution independently
- Be specific and detailed; avoid generic advice
- Verify understanding before making assumption

Advanced Excel Formula Solver Prompt

Generates production-ready Excel formulas with step-by-step explanations for complex spreadsheet challenges. Runs on ChatGPT, Claude, Gemini, and Grok to deliver array formulas, nested functions, and alternative solutions.

26

Data Analysis Report Generator Prompt

Generates structured analytical reports with methodology, findings, visualizations, and actionable recommendations from any dataset. Runs on ChatGPT, Claude, Gemini, and Grok for text-based analysis output.

26

Predictive Analytics Churn Prevention Tactics

Generates five advanced predictive analytics tactics to identify at-risk users before churn, with concrete metrics, implementation steps, and intervention triggers. Runs on ChatGPT, Claude, Gemini, and Grok.

26
## Role
You are an expert data scientist and customer retention strategist specializing in churn prediction and intervention design for subscription-based businesses.

## Task
Analyze customer retention data to identify behavioral patterns and early warning signals that predict churn risk. Build a multi-tiered risk classification system, develop targeted intervention strategies for each segment, and create monitoring protocols to track prediction accuracy and intervention effectiveness. Design escalation pathways for high-value customers showing critical churn signals.

## Context
{{business-and-retention-context}}

{{customer-data}}

## Output
Structure your analysis using these sections:

### Risk Assessment Framework
- Multi-tiered risk classification system segmenting customers by churn probability
- Scoring criteria and thresholds for each risk tier

### Behavioral Pattern Analysis

Churn Prediction Framework Builder for Customer Retention

Builds a multi-tiered churn prediction framework that segments customers by risk, identifies early warning signals, and maps targeted retention interventions. Runs on ChatGPT, Claude, Gemini, and Grok.

25
## Role
You are a business analytics strategist specializing in customer retention economics and ROI measurement frameworks.

## Task
Identify 5 comprehensive ways to measure ROI on retention initiatives. For each method, provide:

- Specific formulas and calculation approaches
- Data requirements and collection methods
- Implementation timelines and steps
- Benchmark establishment guidance
- Potential pitfalls and how to avoid them
- How to present findings to stakeholders

Cover both direct value (revenue impact, cost reduction) and indirect value (brand equity, operational efficiency). Address measurement challenges including attribution complexity, time lag effects, and isolating retention initiative impact from other business factors. Range from immediate tactical metrics to long-term strategic indicators.

## Context
{{business-and-retention-context}}

## Output
Structure your resp

Customer Retention ROI Measurement Framework

Generates five comprehensive methods to measure ROI on customer retention initiatives, complete with formulas, data requirements, implementation steps, and stakeholder presentation guidance. Runs on ChatGPT, Claude, Gemini, and Grok.

24

Statistical Summary Generator for Datasets

Generates executable code that calculates descriptive statistics (Tukey's five-number summary, mean, standard deviation, percentiles) for numeric datasets, then provides interpretations of central tendency, spread, skewness, and outliers. Runs on ChatGPT, Claude, Gemini, and Grok.

24

Public Sentiment Analysis Report Generator

Generates a comprehensive sentiment analysis report with methodology, findings, visualizations, and data-driven recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

23

Inventory Optimization and Overstock Analysis Prompt

Analyzes sales data to identify overstock risks, calculate turnover rates, and recommend specific purchasing adjustments for upcoming quarters. Runs on ChatGPT, Claude, Gemini, and Grok to deliver structured inventory reports with SKU-level action plans.

22
## Role
You are an expert data analyst and dashboard designer with deep knowledge of business metrics, data visualization best practices, and actionable insights generation.

## Task
Create a comprehensive set of interactive sales performance dashboards that track key metrics across the sales funnel. Identify trends, patterns, and areas for improvement. Present findings in a clear, visually compelling format that enables data-driven decision making.

## Context
**Sales funnel stages:** {{sales-funnel-stages}}

**Key products or services:** {{products-services}}

**Customer segments:** {{customer-segments}}

## Output
Organize your response into the following sections using markdown formatting with headings, subheadings, bullet points, and tables:

### 1. Executive Summary
High-level overview of sales performance and critical findings.

### 2. KPI Dashboard
- Revenue Metrics
- Sales Growt

Sales Performance Dashboard Generator Prompt

Generates comprehensive sales performance dashboards tracking KPIs, rep activity, product revenue, and customer segments across your funnel. Runs on ChatGPT, Claude, Gemini, and Grok.

22

What are deepseek prompts for Data Analysis?

deepseek prompts for Data Analysis are engineered instructions that already work, written and tested for DeepSeek. These are not one-line questions. Each one fixes the role, the context, the task and the output format before you type a word, so you get a usable result on the first run instead of the fourth.

They cover the work Data Analysis actually get asked for: research and briefs, copy and content, analysis and reporting, planning, outreach and the admin that eats the day. Open a card to see the full prompt and the output it returns.

The deepest areas here: Data Insights (86 prompts), Reporting & Dashboards (61 prompts), Data Cleaning (19 prompts), Data Visualization (19 prompts), A/B Testing (13 prompts).

Popular on this page right now: "Create Time Series Visualizations", "Predict Customer Lifetime Value", "Dashboard Design Specification Prompt".

119 on this page, every one scoped to Data Analysis. Free to read, free to copy.

Why these prompts work for Data Analysis

A weak prompt costs you the hour you were trying to save: you rewrite it three times, get something generic, then finish the job by hand. An engineered prompt front-loads that thinking once.

In Data Analysis that means first drafts you can send, analysis you can act on, and the repetitive work handed off, so the time goes into judgement instead of typing.

Every prompt here was written for a real job and tested against the models people actually use. Nothing scraped from a thread.

How to use these prompts in DeepSeek

Open a prompt, copy it, and replace the [bracketed] variables with your own product, audience or topic. The structure around them stays as is. That structure is the part doing the work.

Paste it into DeepSeek and run. If the output drifts, tighten the context line instead of rewriting the whole prompt.

No account needed to copy one. No setup, no extension, nothing to install.

Do these prompts only work with DeepSeek?

They are tuned for DeepSeek, but the skeleton of role, context, task and format carries over to any capable model. Swap model-specific settings like tone or length when you move.

Are these AI prompts free to use?

A big part of the library is free: open a prompt, copy it, use it. Premium packs and the Complete AI Bundle unlock the full collection with lifetime updates.

How do I adapt these prompts to my use case?

Start with the [variables]: niche, audience, constraints. If the result still misses, add one example of the output you want. A single good example beats three extra instructions.

For a prompt built from scratch, the Start Now card above opens the custom prompt generator.

Related resources

Get smarter on AI every week

One email a week with the best new prompts, tools, and model updates. Unsubscribe anytime.

Join 100,000+ subscribers. One email a week, real prompts, tools, and model updates. Unsubscribe anytime.

DeepSeek Prompts for Data Analysis | God of Prompt