Skip to content
HNROS Help Center
English
Start free
Contents1. Where the window is and who sees it2. Cubes: which data I can query3. Designer: drag, drop, see4. Visual types, percentage and conditional colour5. Period and comparison6. Dashboards: save, arrange, share7. Ready-made dashboards7b. Logistics dashboard7c. HR dashboard8. KPI targets and alerts9. Export10. Frequently asked questions

Analytics Studio — A Guide from Scratch

Ready-made reports answer fixed questions. The Analytics Studio lets you ask your own: "How were net sales last year by city and quarter?", "Which machine stops most?", "Where are we against this month's collection target?" You drag and drop fields and the table and chart appear at once; you save the view you like as a card on a dashboard and share the dashboard with your team. You write no SQL: the formula of every measure is defined in one place on the server and matches the company reports.

Analiz Stüdyosu — pano

1. Where the window is and who sees it

2. Cubes: which data I can query

A cube keeps the measures and dimensions of one business area together. A measure is the number being totalled (net sales, scrap quantity); a dimension is what it is broken down by (customer, month, machine). Every cube has ready day, week, month, quarter and year time dimensions.

3. Designer: drag, drop, see

  1. Choose the data source (cube) on the left.
  2. Drag the Σ-marked measures to the Values box and dimensions to the Rows or Columns box. On a phone just tap a field: a measure goes to Values, a dimension to Rows; ⇄ in the box moves it between rows and columns.
  3. Up to three dimensions and one time dimension can be chosen. When the selection changes the result is recalculated automatically; if the same query is asked again within a minute the result comes from cache, and the cache drops by itself if records have changed.
  4. In the Filters box limit a dimension to given values ("these" or "all except these"). For dimensions where a card can have several values, such as groups, the filter does not duplicate rows.
  5. Click a row or a cell: the list of documents that make up that cell opens; clicking the document number opens the invoice, clicking the account opens the account card.

4. Visual types, percentage and conditional colour

5. Period and comparison

Period presets: this month, last month, this quarter, this year, last year, last 30 days, last 12 months or a custom range. With Compare the previous equal period or the same period last year appears in an extra column; months are matched by position (January ↔ last year's January). The change arrow is coloured by the measure's good direction: a sales increase is green, a returns increase is red.

6. Dashboards: save, arrange, share

7. Ready-made dashboards

Sales, Purchasing, Stock, Production, Finance and collections, Human resources. A ready-made dashboard opens without being saved and cannot be changed; Copy to my dashboards makes your own copy, which you can edit freely. The figures are cross-checked with the company reports: sales = Sales analysis, stock value = Stock valuation, collections = cash and bank receipts.

7b. Logistics dashboard

The Logistics KPI dashboard button on the top bar of the Shipping window (on the phone, at the top of the Shipments step), or Analytics Studio › Dashboards › Logistics dashboard. The dashboard opens with the last 30 days; the period is the shipment date and cancelled shipments are excluded. Besides the General reports permission you need one of the shipping, shipment planning or proof of delivery permissions; the warehouse picking card needs the warehouse operations or shipment planning permission.

Trips and utilisation. Every shipment is one trip. Load and utilisation are exactly the shipment card calculation: for a document with packed parcels the gross parcel weight, otherwise an estimate from the weight and parcel dimensions on the stock card; utilisation is the largest of the kg, volumetric weight and pallet ratios. Average vehicle utilisation averages only trips made with our own vehicle whose capacity is entered; carrier trips and customer pick-ups are not included. Weight utilisation is total load divided by total capacity.

On-time in-full (OTIF). Every stop is one delivery stop. In full means the proof of delivery says “delivered”; partial, returned and not reached count as problem deliveries. On time means the delivery moment is before the promise. The promise is, in order: the end of the stop’s delivery window, the delivery date of the linked order, the delivery date on the delivery note, the planned shipment day (end of day); which one was used shows in the Source of the delivery promise dimension. Rates are divided by stops with a recorded outcome; stops still awaiting an outcome are left out.

Order → dispatch time is the number of days between the shipment’s departure day and the date of the order the delivery note is linked to; trips that have not left and delivery notes not linked to an order are left out. The Warehouse picking card shows, per picker, the lines picked from completed pick lists, the picking time (man-hours: from start to finish) and lines per hour. The Freight cost and Freight cost per kg measures are ready but stay empty until a freight tariff is defined; the card says so with a warning.

Utilisation and load on the dashboard come from the same function as the values on the shipment card; if they differ, the period (shipment date) or a filter is different. Clicking a cell opens the document list: trips sorted by load, delivery stops by delay, largest first.

7c. HR dashboard

The HR indicators dashboard button above the Human Resources › Dashboard tab, or Analysis Studio › Ready-made dashboards › Human resources dashboard, opens this dashboard; the HR indicators report button next to it gives the same figures month by month under Reports › Company reports. You need the General Reports and Personnel permissions to see it. On the phone the buttons are on the same tab.

Headcount and turnover. The figures come from employment periods with the same rule as the Employee turnover report: headcount at start of period is the number of active people on the first day, headcount at end of period on the last day; broken down by month, each month has its own start and end, and these figures are not found by adding months together. Employee turnover rate = exits ÷ average headcount × 100; average headcount = (start + end) ÷ 2. The Exits by seniority card shows those who left in their first year separately.

Labor cost and net sales. Labor cost is the total earnings of the payroll summary plus the employer social security share (the same calculation as the time-and-attendance labor budget); if the first or last month of the period is incomplete, that month's payroll is prorated by days, and at most the last 24 months are read. Net sales use the same measure as the Sales analysis (excluding VAT, returns deducted). The labor cost / net sales ratio uses only the sales of months that have payroll. Net sales are company-wide: they are not shown when broken down by department, seniority or employee.

Absence and overtime rates. Absence rate = absent days ÷ non-holiday timesheet days × 100; overtime rate = overtime hours ÷ normal working hours × 100. Department is the current department on the employee card. Time to hire is not on this dashboard because candidate and job posting records are not kept yet.

8. KPI targets and alerts

9. Export

Every result and every dashboard card has a CSV button; the dashboard's XLSX button downloads all cards into one Excel file as separate sheets. Numbers are written as raw values and can be calculated in Excel.

10. Frequently asked questions

Related guides: Reports — company reports · Owner Dashboard · Mobile.

Related guides