LehrPuls

Live polling in the lecture hall — local, no cloud.

← hollomey.com Deutsch

Guides › Connecting your own analyses

Connecting your own analyses

The analytics of LehrPuls are enough for most questions. If you want to go further — in Excel, R, Python or Power BI —, you get the data out in two ways: as a raw data file or continuously through the read-only interface, which a program queries directly. Both deliver the same columns.

Export raw data

A file for Excel, R or Python — with all answers of the selected range.

  1. 1

    Export raw data

    Step 1 of 2

    Under Analytics, the Raw data button opens this dialog. It exports all completed sessions that the filter at the top currently shows — period, course, topic. Excel delivers three sheets (answers, questions, sessions), CSV only the answers. For passing data on, turn on Participants anonymized; names then become “Participant 1, 2, …”, consistently across all sessions in the file.

    Screenshot Cockpit 11Format22Participants anonymized33omit small groups44round times55Export
    Cockpit
  2. 2

    What the columns contain

    Step 2 of 2

    Each row of the raw data is one answer — the “long format” that statistics programs expect. Which columns there are and what they mean is described in the manual in the section on raw data. The column names stay the same across versions, so that your analysis scripts keep working.

    Screenshot Cockpit 11Raw data section
    Cockpit

The read-only interface

Programs fetch the data directly from LehrPuls — without a file, always up to date.

  1. 1

    The read-only interface

    Step 1 of 5

    Under Settings → Read-only interface for analytics you make your data available to other programs — Power BI, Excel, R, Python. It delivers six tables: sessions, questions and answers as in the raw data export, plus ready-made figures per question, per topic and the score of the participants. It can only read and is off until you turn it on.

    Screenshot Cockpit 11Turn on the interface
    Cockpit
  2. 2

    Turn on and issue a key

    Step 2 of 5

    Turn on the interface and issue an access key; choose how long it is valid (at most 90 days). The key appears only this once — copy it into your program. Below that you set what may be fetched: names anonymized, with or without the supplied samples.

    Screenshot Cockpit 11turned on22Validity33Access key (shown only once)
    Cockpit
  3. 3

    Address and first request

    Step 3 of 5

    The interface answers at the Address shown, on this computer. A program sends the key in the header of every request, as you can see in the command for the terminal. The examples below show how to narrow it down: the most recent session, today, a course, a topic, the last seven days.

    Screenshot Cockpit 11Address22Sample requests33Request with key
    Cockpit
  4. 4

    The data in the browser

    Step 4 of 5

    To try it out, lehrpuls.com offers a demo page in the section Tools for your own analyses: enter the address and the key, click Fetch answers — and the answers of the most recent session appear as a table, refreshed every 15 seconds if you like. There you also find a ready-made query for Power BI and a Python notebook.

    Screenshot Browser 11Address22Key33Fetch answers44the session at a glance55Answers per question
    Browser
  5. 5

    Power BI, Excel, Python, R

    Step 5 of 5

    How to query the interface from Power BI and Excel (Get data → Web), from Python and R is described step by step in the manual — with examples to copy. AI assistants that speak the Model Context Protocol can query LehrPuls directly, too.

    Screenshot Cockpit 11Read-only interface section
    Cockpit