ACS
ENG ՀԱՅ
Telegram Get in touch
Home/Services

Five directions — one data model.

Each direction is a standalone service. But they're all computed from one source: inventory, sales, purchasing, marketing and finance stop arguing about the numbers, because they look at the same model.

how it's built one source of truth — read by both Excel and Power BI
sources
QuickBooks · Xero · SAP
Channels · Shopify · Amazon · Etsy
Banks · gateways · POS
Google Sheets · manual plans
→
core
Unified data model ClickHouse / Power Pivot · normalization, relationships, DAX measures
→
interface
Excel · "Refresh" button
Power BI · dashboards
Below — five cuts of this model. Not five different programs, but five views onto the same consolidated data.
01 / directionflagship

E-commerce — prices, ops summary, bidding

Who it helps Owner · category manager
fulfillment lead · marketer

Prices, the operating summary, profit, ads and stock — in one file, across every channel at once. Shopify, Amazon, Etsy, Walmart. Advertising is managed automatically — by CR, ACoS and cost per click, via API.

01Operating summary. Actual / plan / % to plan by channel, store and period — on one screen.
02Auto-prices. RRP moves from Excel into a live screen; control over slipping below RRP across every channel.
03Automated bidding. Bids by CR, ACoS and cost per click — via REST API across hundreds of SKUs at once.
04Profit by store. Net of channel fees, per-store taxes, logistics and cost of goods.
05Stock next to sales. Own warehouse + fulfillment + transit — in the same cut, no separate file.
06Plans in an online sheet. The team edits the plan together; the model pulls it in on "Refresh".
ClickHousePower PivotDAXGo + REST APIShopify · Amazon · Etsy · Walmart
case Operating summary — one screen instead of seven spreadsheets → case Prices across four channels →
02 / direction

Accounting & finance

Who it helps Owner · CFO
chief accountant · management accounting

Cash flow, balance sheet and P&L — tied to the management layer. So the numbers from your accounting system and the real operations finally reconcile with each other and with what the commercial team sees.

01Cash flow by category. Actual vs plan; cash gaps are visible in advance.
02Management P&L. Profit by business line, not "one big pot".
03Balance sheet. Assets, liabilities, equity — in management logic.
04Reconciliation. Real operations and accounting records consolidated in one model.
Cash flowBalanceP&LQuickBooks integrationManagement accounting
case in progress
03 / direction

Sales & the commercial block

Who it helps Commercial director
team lead · reps

Plan and actual, margin in any cut, incentives — all on the same data model. The same sales actual feeds both the director's report and a rep's bonus calculation.

01Plan / actual. By rep, client, product and period — in one click.
02Margin. In any cut — period, client, product, rep.
03Cohorts and ABC. Who brings the money, who churned, where revenue concentrates.
04Incentives. Bonuses and KPIs computed straight from the model — no separate "bonus" spreadsheet.
Plan · ActualMarginCohorts · ABCRep incentives
case Sales planning — a plan in any cut →
04 / direction

Purchasing — the frame approach

Who it helps Buyer · category manager
production · warehouse

A complex calculation with a simple output: what to order, how much and when. The parameters (lead time, thresholds, target stock) live in Google Sheets — not in the ERP, and work the same for hundreds of SKUs.

01Target stock. Lead time, turnover, case multiples — all in the calculation.
02Availability frame. Accounts for returns and dips automatically — zero stock isn't the same as empty.
03Supplier vs production. A split: what goes to suppliers, what to your own assembly.
04ABC · 2D. SKU prioritization by contribution and demand stability — where to look first.
Auto-replenishmentTarget stockTurnoverABC · 2DGoogle Sheets inputs
case Frame-based purchasing — zero stock isn't empty →
05 / direction

Dashboards for the owner

Who it helps Owner
top management

One file — the whole company at a glance. The same data model, but with the emphasis on what matters to the owner: headline metrics, trends, anomalies — and the ability to drill into detail.

01Headline KPIs. Revenue, profit, stock, ACoS — the whole company in one glance.
02Trends and anomalies. What's growing, what dipped, where a number breaks from the norm.
03Drill-down. From the company down to a specific SKU — no new reports, no requests to an analyst.
04For decisions, not for looks. 80/20: we highlight what actually moves the business.
Owner dashboardsKPITrendsDrill-downPower BI / Excel
case in progress
→ principle

Not five products, but five cuts of one model.

So you don't have to choose "where to start, once and for all". We begin with the most painful point — usually e-commerce or purchasing — and by the end of the second month 80% of the functionality is already working. The other directions plug into the same model as needed.

The model is built around your business and your terms. If you measure "yield per ton" rather than "revenue per square meter" — we compute around yield per ton.

next step

A data review — free.

Before the call we look at your data. On the call we show the map: where your 20% that drives 80% sits — and the most profitable direction to start with. No obligation to go further.

Book a data review Cases first
@abovyanmikequick reply on Telegram → hello@acs-data.comwe reply within a day →