Data analysis prompts you can use with Gemini

 

Here are some data analysis prompts you can use with Gemini, categorized by their function:

Understanding Your Data:

• Data Description: "Summarize the key statistics for the 'customer_age' column in my 'sales' table."
• Data Exploration: "Identify the top 5 most frequent product categories in my 'ecommerce' dataset."
• Data Cleaning: "Find and replace missing values in the 'price' column of my 'products' table with the median price."

Finding Trends and Patterns:

• Correlation Analysis: "Calculate the correlation coefficient between 'customer_satisfaction' and 'purchase_frequency' in my 'customer_feedback' dataset."
• Segmentation: "Segment my customer base by age and income level."
• Time Series Analysis: "Analyze sales trends over the past year for my online store."

Asking Specific Questions:

• Comparison: "Compare website traffic from mobile devices with desktop traffic for the past month."
• Filtering: "Find all customers who made a purchase over $100 in the last quarter."
• Forecasting: "Predict future sales based on historical data and current trends."

Using Gemini with Google Cloud:

• Finding Available Data: "What datasets and tables are available to me in BigQuery?"
• Optimizing Queries: "Help me optimize my BigQuery query to improve performance."
• Understanding Code: "Summarize the functionality of this SQL code snippet used for data transformation."

Additionally, remember:

• You can combine prompts for more complex analysis.
• Be specific about the data source (e.g., table name) and columns you want to analyze.
• Phrase your questions clearly and concisely.

For further reference, you can explore these resources:

• Write better prompts for Gemini in Google Cloud: https://m.youtube.com/watch?v=VqTjJubt0kE
• Gemini Prompt Engineering for Data Enthusiasts: https://leonnicholls.medium.com/mastering-gemini-debates-advanced-prompts-for-deeper-thinking-211acf8d156f

--------------------------------

Uncovering Relationships:

    Causal Inference: "Given changes in marketing campaign budget, can you identify a causal relationship with website conversion rates?" (This requires understanding limitations of observational data for causality).

    Customer Journey Analysis: "Based on website clickstream data, identify the typical journey customers take before making a purchase."

Predictive Modeling:

    Anomaly Detection: "Identify unusual patterns in sensor data that might indicate potential equipment failure."
    Churn Prediction: "Develop a model to predict which customers are at high risk of churn based on their past behavior." (Requires specifying a modeling technique like logistic regression).

Text Analysis:

    Sentiment Analysis: "Analyze customer reviews to understand their overall sentiment towards our new product launch."
    Topic Modeling: "Identify the main themes discussed in a collection of customer support tickets."

Open Ended Exploration:

    Data Visualization: "Create an interactive dashboard that allows me to explore sales data by region, product category, and time period."
    Data Storytelling: "Help me craft a data-driven narrative that highlights key insights from my customer satisfaction survey."

Remember:

    These prompts might require additional information from you depending on the complexity.
    Gemini can guide you through the process but may not directly build models or create visualizations.

Additionally, consider exploring prompts that use Gemini's capabilities beyond data analysis:

    Data Cleaning with External Knowledge: "Based on product descriptions and external knowledge sources, can you help me categorize products into more specific groups?"
    Data Bias Detection: "Analyze my dataset for potential biases that might impact my conclusions."

By combining Gemini's data analysis abilities with its understanding of the broader context, you can unlock even deeper insights from your data.

---------------------------------

 Scenario-Based Analysis:

    A/B Testing Analysis: "Analyze the results of my A/B test for a new product landing page layout and identify which version led to higher conversion rates." (Specify data on user interactions with each version).
    What-If Analysis: "Simulate the potential impact on sales figures if we increase our marketing spend by 10% in the next quarter." (Requires historical data and assumptions about marketing effectiveness).

Advanced Techniques:

    Natural Language Processing (NLP) for Text Data: "Extract key entities and relationships from customer support emails to identify common product issues."
    Image Recognition Integration: "Combine sales data with image recognition to analyze which product features are most popular based on customer purchases." (Requires access to product image data).

Collaboration and Decision Making:

    Data Sharing and Access Control: "Help me define user roles and permissions for accessing sensitive customer data in BigQuery."
    Data-Driven Discussion Prompts: "Based on our sales data, formulate talking points to discuss potential pricing strategies with the executive team."

Remember:

    These prompts might necessitate providing additional details or context-specific data for Gemini to work with.
    While Gemini can't directly control access or make decisions, it can guide you through processes and provide insights to support collaboration.

For an extra challenge, consider prompts that combine multiple functionalities:

    Storytelling with NLP: "Analyze customer reviews and identify positive sentiment towards a specific product feature. Then, craft a compelling social media post highlighting this benefit."
    Predictive Modeling with External Data: "Combine historical sales data with weather forecast information to predict potential demand fluctuations for seasonal products."

By experimenting with these advanced prompts, you can unlock the full potential of Gemini as a powerful tool for data-driven exploration, decision making, and storytelling.

 

--------------------------------

  data analysis prompts for Gemini. Here are some prompts tailored to different industries:

Finance:

    Loan Default Prediction: "Develop a model to predict loan default risk based on customer demographics, financial history, and loan characteristics."
    Market Trend Analysis: "Analyze historical stock market data and identify potential investment opportunities using technical indicators."

Healthcare:

    Patient Readmission Risk Assessment: "Identify factors that contribute to patient readmission after surgery using hospital records data."
    Drug Effectiveness Evaluation: "Analyze clinical trial data to compare the effectiveness of different treatment options for a specific disease."

Retail:

    Recommendation Engine Optimization: "Analyze customer purchase history and product attributes to improve the accuracy of product recommendations."
    Inventory Optimization: "Predict future demand for specific products based on historical sales data and seasonal trends to optimize inventory levels."

Remember:

    These prompts are specific examples, and you can adapt them to your particular industry and data.
    Ensure you have the necessary data points (e.g., patient demographics, product attributes) for Gemini to analyze.

Here are some additional prompts that focus on specific data formats:

    Time Series Data Analysis: "Analyze website traffic data over the past year to identify peak traffic hours and days of the week." (Requires data with timestamps).
    Geospatial Data Analysis: "Visualize customer purchase locations on a map and identify areas with high customer concentration." (Requires data with geographic coordinates).

Remember:

    Specify the format of your data (e.g., timestamps, geographic coordinates) when formulating prompts.

Finally, consider prompts that leverage Gemini's ability to access and process external information:

    Competitor Analysis: "Analyze publicly available data on our competitors' products and marketing strategies to identify potential opportunities and threats."
    Social Media Sentiment Analysis: "Combine sales data with social media sentiment analysis to understand customer perception of our brand." (Requires access to social media data).

By tailoring prompts to your specific industry, data format, and external information needs, you can leverage Gemini's strengths to gain deeper insights and make informed decisions.

 

-------------------------------

 
Show drafts

I can definitely give you more! Here are some additional prompts for Gemini that explore different aspects of data analysis:

Data Quality and Trustworthiness

    Data Validation: "Identify and flag any inconsistencies or outliers in my customer contact information dataset."
    Data Lineage Tracking: "Explain the origin and transformation steps applied to the data in the 'sales_report' table."

Data Privacy and Security

    Data Anonymization: "Help me anonymize customer data while preserving key insights for analysis." (Requires specifying privacy-preserving techniques).
    Data Access Control Review: "Evaluate current data access controls in BigQuery and suggest improvements to ensure data security and compliance."

Ethical Considerations in Data Analysis

    Identify Potential Biases: "Analyze my hiring data for potential biases that might disadvantage certain applicant groups."
    Explain Algorithmic Decisions: "Explain the factors considered by the model used to predict customer churn risk." (Requires understanding the model's inner workings).

Data for Social Good

    Resource Allocation Optimization: "Analyze data on community needs and resource availability to recommend efficient allocation strategies for social services."
    Public Policy Impact Assessment: "Evaluate the potential impact of a proposed policy change based on historical data and predictive modeling."

Remember:

    These prompts touch on sensitive topics like privacy and bias. Ensure you approach data analysis with ethical considerations in mind.
    Some prompts might require specifying additional details about the data or the desired outcome.

Bonus: Prompts for Fun and Exploration

    Data-Driven Game Design: "Analyze player behavior data to identify trends and suggest improvements for a mobile game."
    Historical Data Visualization: "Create a timeline visualization that showcases historical events and their impact on a specific topic (e.g., economic trends, scientific discoveries)."

By exploring these diverse prompts, you can push the boundaries of what's possible with Gemini and use data analysis to tackle a wide range of challenges and unlock new opportunities.