Contents
1. 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 questionsAnalytics 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.

1. Where the window is and who sees it
- In the dock's Management group, next to the Owner Dashboard: Analytics Studio. It has three tabs: Designer, Dashboards, Targets.
- Viewing requires system administrator or the General Reports permission. Human resources data also requires the Personnel permission; without it the HR cube does not appear in the list at all.
- Chart types require the Graphical Reports permission; without it the same data is shown as a table.
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.
- Sales — net sales, returns, VAT, withholding, document/customer counts, gross profit; customer, product, group, field rep, city, region. The measure is identical to the Sales analysis report.
- Purchasing, Expense (purchases of expense/service/labour cards), Stock movements (receipts/issues, movement type, warehouse).
- Stock status and value — period-end quantity and value; the same calculation as the Stock valuation report. This cube is a "snapshot": it looks at the period's end date.
- Working capital — trade receivables, trade payables and stock value at period end, with DSO, DIO, DPO and the cash conversion cycle; the same calculation as the Working capital indicators report (last 3 months window). This cube is also a "snapshot"; you can enter targets for indicators such as DSO in Targets.
- Shipment trips, Delivery stops and Warehouse picking — trips, load, vehicle utilisation, on-time in-full delivery (OTIF), order → dispatch time and picker productivity; load and utilisation are the same calculation as the shipment card. Details: 7b. Logistics dashboard.
- Workforce and labor cost — employee × month: headcount at the start and end of the period, hires, exits and employee turnover rate, absence and overtime rates, labor cost and its ratio to net sales. Details: 7c. HR dashboard.
- Production (confirmations, cost, scrap, working and downtime), Collections and payments (cash and bank receipts), Cheques and notes (portfolio by due date), Human resources (timesheets, leave, hires and exits).
3. Designer: drag, drop, see
- Choose the data source (cube) on the left.
- 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.
- 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.
- 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.
- 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
- KPI card (one big number), table, column, stacked column, line, area, pie, horizontal bar and heat map. If the Columns box holds a dimension, each of its values becomes a separate series (the largest eight + "Other").
- Percentage: "Share of total %" adds each row's share of the total, "Cumulative" adds a running total. It is not applied to ratio and count measures (return rate, number of documents).
- Conditional colour: up to six rules such as "red if net sales < 100,000". Colours carry only three meanings: green good, yellow attention, red action needed.
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
- Under the designer, type a Card title, choose a dashboard (or give a new dashboard name) and choose Add to dashboard. The ✎ button of a card on the dashboard opens it in the designer; Update card writes it back.
- A dashboard has one period: when you change it, all cards are recalculated for the same range. "Save period to dashboard" makes it the dashboard's default.
- With Edit move and widen cards with the arrows, then Save layout. A dashboard is a 12-column grid; on a phone the cards are listed top to bottom in one column.
- Sharing: a personal dashboard is visible only to its owner. The system administrator can open a dashboard to everyone or by permission (to users holding any of the chosen permissions); only the administrator changes a shared dashboard.
- TV mode puts the dashboard in full screen, enlarges the text and refreshes every 10 minutes; press Esc to leave. A dashboard can also have its own automatic refresh interval.
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
- In the Targets tab the system administrator gives a measure a monthly, quarterly or yearly target (e.g. monthly net sales 15,000,000). A target is measured from the start of the period to today: for additive measures such as amounts, half the target is expected in the middle of the month; for ratios such as the return rate, the target itself is expected.
- Colour thresholds: for a "higher is better" measure 100% and above is green, 80–100% yellow, below red; for a "lower is better" measure 100% and below is green, 100–120% yellow, above red. The thresholds can be changed per target.
- If the daily task is enabled (server setting
ANALITIK_GOREV=1; off by default), a target that turns red sends an HNROS message to the "Users to be alerted", not twice on the same day. The task also stores the cards' daily values (for trends).
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
- Why is the total of the group rows larger than the company total? A product can belong to several groups; each group row shows that group's full amount. The total row is company-wide and is not duplicated.
- Why does gross profit look much smaller than net sales? Profit is calculated only from products with a known unit cost; the "Net sales with known cost" measure shows this base. The number of products without cost is stated in the warning.
- How do sales with a price of 0 affect profit? They do not. The cost of free-of-charge issues (sales lines with a price of 0) is shown separately in the "Cost of free-of-charge issues" measure and their quantity in "Free-of-charge issue quantity (base unit)"; gross profit stays equal to the Profitability ranking report.
- Can I add up quantities? Quantities are in each product's base unit; adding different products may mix kilograms with pieces. Use quantity measures together with the product dimension.
- A card says "No data yet". There are no records in the selected period, or the related module (e.g. production, HR) is not used in this company; zero is not printed.
Related guides: Reports — company reports · Owner Dashboard · Mobile.
Related guides
- Reports — Where the Numbers Start to Mean SomethingLists answer "which record"; reports answer "how much, to whom, when". This window holds seven ready-made reports plus the company-wide Company reports.
- HNR on the Phone — PulseHNR can be used on a phone (a screen under 7 inches) with three different interfaces. This guide introduces all three and explains the newest, Pulse.
- Report GuidesStock card → Reports (Stok kartı → Raporlar). For a group, use Stock → main group/subgroup → group reports. · 34 report/view sections.
- Cockpit — A Guide from Scratch for ManagersThis guide is for the person who has to look at numbers and decide. Its purpose is not to teach you how to read a report but to show where every number on the.
- The Profit Panel — "How Much Did We Really Earn?"Revenue is easy: you add up the invoices. Profit is hard, because first you must subtract cost, expenses and the part of the tax that was never yours.
- Financial Control and Planning GuideAmounts, quantities, percentages and days are different measures. Use the currency and unit printed beside the value; do not assume that every number is TRY.