Quick Look: Example Prompt Repository

The following list the various prompting examples that showcase different data analysis techniques discussed above. Below are sample prompts that combine use case categories to give a quick overview of how Lumi can be prompted.

The output quality is correlated to the quality of the prompt. Learn more about prompting best practices.

Performance Metrics Analysis: Evaluate various business metrics across dimensions.

Example Prompt: Show me total purchase quantity and total purchase cost for every item in 2023. Also, list the number of distinct suppliers we bought from. Output: item_id, description, Total Purchase Quantity, Total Purchase Cost, Currency Code, Distinct Supplier Count. Sort by total purchase cost.

Bad Prompt Example: Show me purchases for 2023.

Time Series Analysis: Analyze and track trends over time.

Example Prompt: Can you show me gross profit for every month over the past 12 months for customer C000322?

Bad Prompt Example: Tell me how much money xyz customer paid every month.

Comparative Analysis: Compare metrics across different time periods.

Example Prompt: Which customers have experienced the largest decline in gross profit when comparing the last 3 months to the previous 3 months? Output: Customer, Customer Name, Currency Code, Last 3 Months, Previous 3 Months.

Bad Prompt Example: Which customers lost money?

Cumulative Analysis: Calculate cumulative totals or running sums.

Example Prompt: Calculate gross profit in 2024 YTD for each customer.

Bad Prompt Example: What are the profits this year?

Segmentation: Divide data into meaningful segments based on common characteristics.

Example Prompt: What are the top purchased items in April 2024 that were bought from multiple suppliers? Include relevant details

Bad Prompt Example: What were the top items in April?

Correlations: Explore relationships between two variables.

Example Prompt: What is the marketing spend and sales revenue, by month in 2023. Include relevant details.

Bad Prompt Example: Show me marketing and sales numbers.

Anomaly Detection: Detect unusual data patterns or outliers.

Example Prompt: What are the top 5 orders with the lowest margin percentage.

Bad Prompt Example: Are there any weird orders?

Market Basket Analysis: Analyze purchasing patterns.

Example Prompt: What are the finished goods with the highest average sales volume in July (across all years) that are currently out of stock?

Bad Prompt Example: What sold the most in July that's out of stock?