How to Create Data Stories with LLMs Simply and Professionally

Introduction: why data storytelling with LLMs is essential today

In 2026, the ability to transform raw numbers into engaging narratives has become an essential requirement for analysts, data scientists, and business professionals. Large language models (LLMs) have reached a context capacity of 1 million tokens and can generate multimodal content, making data storytelling richer and more interactive than ever. In this article, you’ll learn how to use the latest LLMs, such as Step 5 Preview and Muse Spark Open, to automate the data storytelling process, create compelling reports, and engage audiences with just a few simple prompts.

Which approach to follow: a step-by-step framework for data storytelling with LLMs

1. Define the goal and audience

Before feeding data into an LLM, clarify the questions you want to answer and who will read the story. This will help you choose the tone, level of detail, and analytical depth.

2. Prepare your data in a structured format

Upload the dataset in a readable format (CSV, JSON, or a database table). Ensure column names are clear and any missing values are handled.

3. Write a prompt that guides the LLM toward a narrative

Use a detailed, goal-oriented prompt that specifies:

  • The target audience (e.g., executives, technical teams)
  • The desired length (short summary, extended report, presentation)
  • Elements to include (key trends, anomalies, implications)
  • The style (formal, conversational, with emphasis on visual data)

4. Generate and review the story

Run the prompt through an LLM-compatible API, a notebook, or a sandbox tool like Perplexity SPACE. Verify logical consistency, data accuracy, and alignment with the target audience.

5. Add visual elements (optional)

Use the new LLMs’ multimodal capabilities to generate charts, tables, or flowcharts directly within the narrative.

Practical example: from a spreadsheet to a story in 5 minutes

Assume we have a CSV dataset containing monthly sales by product:

data = {
"data": [
{"product": "A", "month": "2026-01", "sales": 12000},
{"product": "A", "month": "2026-02", "sales": 13500},
{"product": "B", "month": "2026-01", "sales": 8000},
{"product": "B", "month": "2026-02", "sales": 9200}
]
}

The following prompt works well with Step 5 Preview or Muse Spark Open:

Generate a short data story highlighting sales trends, anomalies, and implications for the next quarter. Use a formal tone and include a summary paragraph. Also list any charts you should create (e.g., a line chart of sales over time). Data: {data}

The LLM will return a complete narrative with a summary paragraph and a list of recommended visualizations, ready to be created with tools like Tableau or the new integrated chart generation APIs.

Tools and sandboxes that simplify the process

Perplexity SPACE

Perplexity has open-sourced SPACE, a microVM sandbox that provides a secure, isolated environment for running LLM agents. SPACE allows you to:

  • Run prompts that access local datasets
  • Test different models (Step 5 Preview, Muse Spark Open) safely
  • Record every interaction for compliance and audit

Step 5 Preview and Muse Spark Open

Both models support a context of up to 1 million tokens, ideal for large datasets. Their multimodal capabilities let you generate tables, charts, and even code for visualizations directly from the model’s response.

Common pitfalls and how to avoid them

  • Overfitting the prompt:Providing too many constraints can limit creativity. Use flexible prompts that leave room for model interpretation.
  • Unstructured data:Ensure datasets are cleaned and normalized before input.
  • Citation reliability:Always verify factual claims with the original data source.
  • Audience personalization:A generic audience often leads to generic stories. Tailor language to the audience’s knowledge level.

Conclusion: transform data into impactful narratives

Modern LLMs have made data storytelling accessible to anyone with a dataset and a clear goal. By following the step-by-step framework, using advanced models like Step 5 Preview and Muse Spark Open, and leveraging secure sandboxes like Perplexity SPACE, you can create engaging, high-impact data stories in a fraction of the time it once took. Start with a well-structured prompt, test different variations, and watch LLMs transform raw numbers into compelling narratives that drive decision-making and capture your audience’s imagination.

Next steps

  • Try a prompt with one of the new open-weight LLMs.
  • Set up a sandbox environment with Perplexity SPACE for safe experimentation.
  • Connect the generated story to a dashboard for real-time updates.

With these resources at your disposal, the future of data storytelling is in your hands.

💼 Vuoi ottimizzare i tuoi processi con l'AI?

Scopri come possiamo aiutarti a creare prompt personalizzati e strategie AI su misura per il tuo business.

Richiedi Consulenza Gratuita