Running AI models locally is no longer experimental.

Today, businesses can build fully functional AI-assisted analytics workflows directly inside their own infrastructure using open-source models and local runtimes.

One of the simplest ways to achieve this is by combining:

This setup allows teams to:

  • run AI models locally
  • generate dashboards using natural language
  • analyze operational data interactively
  • reduce dependency on external AI services
  • build self-hosted analytics workflows

In this guide, we will walk through the full setup process step by step.

What You Need Before Starting

Before installation, make sure you have:

  • Windows, Linux, or macOS
  • internet connection for model downloads
  • at least 16 GB RAM recommended
  • terminal access
  • LivChart installed or accessible

For larger models and faster response times, a dedicated GPU is highly recommended.

Step 1 — Install Ollama

Ollama provides one of the easiest ways to run large language models locally.

Installation is straightforward.

macOS Installation

Using Homebrew:

brew install ollama

Linux Installation

Run the official installation script:

curl -fsSL https://ollama.com/install.sh | sh

Windows Installation

Download the installer directly from the official Ollama website and complete the setup.

After installation, verify everything works:

ollama --version

Step 2 — Download a Local AI Model

Once Ollama is installed, you can download and run your first model.

Example:

ollama run qwen2.5

This command:

  • downloads the model
  • installs it locally
  • starts an interactive AI session

The first download may take several minutes depending on model size and internet speed.

Recommended Models for Analytics

Different models behave differently for analytics workflows.

Here are practical starting points.

Model Speed Analytics Quality Turkish Support Hardware Need
Qwen2.5 High Very Good Excellent Medium
Gemma 3 Medium Good Good Medium
Llama 3 Medium Good Medium Medium
Mistral Fast Moderate Medium Low

For multilingual analytics workflows, Qwen models often perform particularly well.

LivChart-Optimized Models for Analytics

While you can use any Ollama model with LivChart, we recommend trying our custom-optimized models. These are configured with specialized system prompts and analytics-focused behavior to deliver better results for dashboard generation, structured output, and Turkish business analytics.

Model Command Size Best For VRAM
livchart/qwen3.5-9b-q6 ollama run livchart/qwen3.5-9b-q6 7.4 GB Fast analytics, Turkish support, chart generation ~8 GB
livchart/mistral-nemo-12b-q6 ollama run livchart/mistral-nemo-12b-q6 10 GB Advanced reasoning, dashboard-focused responses, BI workflows ~16 GB

To install a LivChart-optimized model, simply run:

ollama run livchart/qwen3.5-9b-q6

or for more powerful hardware:

ollama run livchart/mistral-nemo-12b-q6

These models are not fine-tuned — they use custom Modelfile configurations with analytics-optimized system prompts. This means you get better structured output and chart-focused responses without sacrificing the base model's capabilities.

Learn more about our optimized models on the LivChart Ollama page.

 

Step 3 — Start the Ollama API Service

LivChart communicates with Ollama through its local API.

Start the service:

ollama serve

By default, Ollama runs on:

http://localhost:11434

You can verify the service using:

curl http://localhost:11434/api/tags

If the setup works correctly, Ollama returns the list of installed models.

Step 4 — Open LivChart

Open LivChart and navigate to the AI configuration section.

You will typically configure:

  • AI provider
  • local endpoint
  • model selection
  • inference settings

Use the Ollama endpoint:

http://localhost:11434

Then select your installed model.

Example:

  • qwen2.5
  • llama3
  • gemma3

Save the configuration and test the connection.

Step 5 — Connect Your Data

Once the AI connection works, connect your business data.

LivChart supports sources such as:

  • Excel files
  • CSV datasets
  • SQL Server
  • PostgreSQL
  • MySQL
  • ODBC sources

The platform automatically detects:

  • tables
  • columns
  • metrics
  • dimensions
  • date fields

This allows teams to begin analysis quickly without heavy modeling work.

Step 6 — Generate Your First AI Dashboard

Now you can start using natural language analytics.

Example prompts:

Sales Analysis

Show monthly sales trends for the last 12 months

Inventory Monitoring

Which products are approaching low stock levels?

Production Analytics

Visualize production downtime by machine

Financial Reporting

Compare quarterly revenue and operational expenses

The AI generates charts and analysis dynamically.

Because the model runs locally through Ollama, the workflow remains self-hosted.

Why Businesses Are Interested in Local AI Dashboards

The interest in local AI is growing rapidly for several reasons.

Faster Experimentation

Teams can test workflows without relying on external APIs.

Infrastructure Flexibility

Organizations decide where models run and how systems scale.

Reduced Cloud Dependency

Operational analytics workflows become less dependent on external AI platforms.

Self-Hosted Analytics

Companies can build internal AI environments around existing operational systems.

Common Setup Problems

Local AI deployment is becoming easier, but several common issues still appear.

Ollama API Not Responding

Make sure the service is running:

ollama serve

Also verify that port 11434 is not blocked.

Model Not Found

Check installed models:

ollama list

Download missing models again if necessary.

Slow Performance

Large models may require:

  • GPU acceleration
  • additional RAM
  • smaller quantized models

Trying lighter models can improve dashboard response speed significantly.

Firewall Issues

Some operating systems may block local API access.

Verify:

  • localhost access
  • firewall permissions
  • security software settings

Recommended Hardware

Hardware significantly affects local AI performance.

Entry-Level Setup

Suitable for smaller analytics workloads:

  • modern CPU
  • 16 GB RAM

Recommended Business Setup

Better for operational analytics:

  • NVIDIA GPU
  • 32 GB RAM
  • SSD storage

Larger Deployments

Enterprise environments may use:

  • multi-GPU servers
  • centralized inference systems
  • dedicated AI infrastructure

Example End-to-End Workflow

A typical local AI analytics workflow may look like this:

  1. Business data enters LivChart
  2. Ollama processes prompts locally
  3. AI generates charts and summaries
  4. Teams continue analysis conversationally
  5. Dashboards remain inside internal infrastructure

This combines conversational analytics with self-hosted AI deployment.

Why This Setup Matters

The most important change is flexibility.

Businesses no longer need to choose between:

  • modern AI workflows
  • infrastructure control

Local AI systems allow organizations to build analytics environments around their own operational requirements.

As open-source AI ecosystems continue improving, these workflows are becoming increasingly practical for real business usage.

Final Thoughts

Combining Ollama with LivChart provides a practical way to build local AI-powered analytics systems.

Instead of relying entirely on cloud AI platforms, organizations can deploy AI models locally and integrate them directly into dashboards, reporting workflows, and operational analytics environments.

As AI becomes part of everyday business infrastructure, flexible deployment models will become increasingly important.

Local AI dashboards are no longer experimental.

They are quickly becoming part of modern analytics workflows.