Overview
Analyst is ALK’s data analysis feature. It allows you to upload Excel or CSV files and perform deep analysis using AI, such as summarising data, finding trends, and generating charts, without needing to write formulas or use separate analytics tools.What you can do in Analyst
There are three core actions:- Summarise my data: Get a comprehensive overview of all sheets and columns in your uploaded file.
- Find trends & patterns: Discover correlations and trends across your data automatically.
- Create a visualisation: Generate charts and graphs from your data.
Getting started with Analyst
1
Open Analyst
Click the chart icon in the ALK navigation bar to open Analyst.
2
Upload your file
Analyst accepts Excel files in the following formats:
.xlsx, .xls, .xlsm, and .csv. Maximum file size is 50MB per file. You can add multiple files to the same session and switch the active file from the file list.To upload, click the attachment icon at the bottom left of the screen and select either:- From computer — upload directly from your device
- Knowledge map — select a file already connected through your Knowledge sources
3
Start analysing
Once your file is uploaded, select one of the three analysis options or type your own question directly into the chat input at the bottom of the screen. To reference a specific sheet in your question, type
@ followed by the sheet name.4
Switch views
Use the Chat and Sheet tabs in the top right to toggle between the AI conversation view and a spreadsheet view of your uploaded data. To view history of all previously uploaded sheets or Analyst conversations, click the clock icon.
Working with spreadsheets
Analyst is designed to handle many legacy and complex Excel workbooks. In Sheet view, hidden worksheets are marked as hidden, and chart-only sheets are not available as spreadsheet tabs. Analyst profiles each sheet before answering so it can identify the header row and the available columns. This helps when a spreadsheet has title rows or other content above its column headers. You can ask questions across multiple uploaded files and switch the active file from the file list; Analyst keeps each question tied to the file you selected. Analyst citations can point to the relevant cell, row, or column range. If the header row is not the first row, the cited range reflects the actual header position rather than assuming row one.Important notes
- Analyst is in Early Preview. Verify results against your source data before using outputs for reporting or decision-making.
- ALK can make mistakes. The footer reminder “ALK can make mistakes. Please check important info” applies especially here. Always validate analytical outputs.