Home › Tutorials › Tools

Analyze data

Open a CSV, build a chart and a pivot table, and query the data in SQL.

Step by step

Select a step to jump to that moment in the video.

  1. 00:01Open the CSV as a table, from the toolbar
  2. 00:05Analysis holds charts and pivot tables
  3. 00:13For a database, the .lnc keeps the connection
  4. 00:17Run executes the query, and the result shows below

Read more in the HelpAnalysis area: pivot table and several charts·Databases (.lnc)

Tips

  • In a .sql file, Ctrl+Enter runs the statement under the cursor and Alt+X the whole script

See also

← All tutorials