Solutions · Retail

Every branch, product and campaign, answered while the decision is still open

A retail leadership team may ask which branches are slowing, which products carry the margin and whether a campaign paid for itself — in Thai or English, from the organization’s own database, with the basis of each figure stated.

The problem

Where retail decisions are usually delayed

01

The report arrives after the week has closed

Branch figures are assembled by hand from several systems, so the meeting discusses last week’s position rather than today’s.

02

Each department reports a different total

Sales, finance and merchandising each define net sales in their own way, and the meeting is spent reconciling figures rather than deciding.

03

A follow-up question means a new request

A dashboard answers the question it was built for. The next question — by product, by hour, by campaign — returns to the data team’s queue.

Sample questions

Questions a retail leader can ask today

Typed in Thai or English, with no SQL and no dashboard prepared beforehand.

›Which branches fell short of last month’s sales, and by how much?›What are the ten best-selling products this quarter?›How did same-store sales change against the same period last year?›Which product categories carry the highest gross margin?›Did the mid-year campaign increase the average basket size?
›Which products have had no sales in the past ninety days?›How does weekend revenue compare with weekdays, by branch?›Which branches hold the most stock relative to their sales?›How many members made a repeat purchase within thirty days?›What share of revenue came from the online channel this year?
By role

The same data, asked from each seat

Executive leadership

The position of the business as a whole, with the evidence required to defend a figure in the boardroom.

What were total sales this month against target?
Which regions grew and which declined this quarter?
What are the three branches that require attention?

Operations and merchandising

Branches, products and stock, at the level of detail at which action is taken.

Which products are below their reorder level at each branch?
Which branches sell the least per square metre?
What sold best during the evening hours last week?

Finance and marketing

Margin, discount and the return on each campaign, on definitions the organization has certified.

How much discount was given under each campaign?
What was the gross margin by category after discount?
Which campaign brought in the most new members?
Your vocabulary

The platform learns the words your stores use

A glossary maintained per organization maps your own vocabulary to the right tables, so a question is understood as your team means it.

GLOSSARY · RETAIL
branch→retail.store_branches
net sales→retail.sales_orders
basket→retail.order_items
member→retail.loyalty_members
Data connected

Data a retail deployment typically connects

01

Sales and orders

Transactions by branch, channel, date and hour, with returns and discounts.

02

Products and categories

The product master, categories, brands, cost and price.

03

Stock and replenishment

Stock on hand by branch and warehouse, movements and reorder levels.

04

Campaigns and promotions

Campaign periods, the items they cover and the discounts they granted.

05

Members and loyalty

Membership, purchase history and points, with personal data columns masked.

Questions

Questions from retail teams

Must our data be moved into a new warehouse first?

No. The platform connects read-only to the database you already operate, directly or through a gateway, and answers from the data where it resides.

How does the platform know what “net sales” means in our organization?

Key measures are defined once and certified by your organization, and your own terms are recorded in a glossary. The same question therefore returns the same figure for every user.

May branch managers see only what concerns them?

An administrator decides which groups of users may see which tables. Filtering at the level of individual rows, such as a manager’s own branch, is enabled per plan.

Can questions be asked in Thai, with Thai product names?

Yes. Questions and answers may be in Thai or English, and product, branch and category names are read as they are stored in your data.

Answer your most demanding question

Request a 30-minute session. We will connect a sample of your data and put genuine decision questions to it, in Thai or English.