case study · Wholesale trade

BI dashboards for a trading company

A wholesale company moved from manual Excel reports to Power BI. Data on sales, stock, shipments and finance refreshes every morning by 7:00.

4data sources
7:00fresh numbers every morning
16 hof analyst time freed per week

Challenge

The weekly management report was assembled by hand from 1C and warehouse system exports, taking 16 person-hours a week, and figures in different reports did not match.

What we did

Agreed shared KPI definitions with finance: revenue, margin and inventory turnover
Built a MS SQL Server warehouse with SSIS loads from 4 sources including 1C: ERP
Built sales, stock, shipment and finance dashboards with drill-down to customer and item
Set up role-based access and a refresh by 7:00
Trained two client analysts to extend the reports themselves

Outcome

Figures in every management report now match. Analysts freed up 16 hours a week and spend them on analysing variances.

GovernmentSubcontractor2025
Document management upgrade for a Pavlodar Region akimat department
For a department of the Pavlodar Region akimat we set up the transfer of citizen requests into the document management system, so nobody re-types them, and updated the approval routes.
1. beforeManual re-keying
2. howEDMS integration
3. afterDeadlines under control
to transfer a request into the EDMS
15 min
manual re-keying
0
from kickoff to acceptance
6 weeks
Machine building (Russia)General contractor2024-2025
1C:ERP and MES integration for a machine-building plant in Omsk
We connected 1C:ERP with the MES of four production departments at an Omsk machine-building plant through a message bus. Orders, bills of materials and output are no longer entered twice.
1. beforeDouble data entry
2. howRabbitMQ bus
3. afterERP and MES in sync
manual data entry
-70%
to identify discrepancies
≤ 24 h
production departments in one data flow
4
Energy / industrySubcontractor2024-2025
BI energy monitoring for an industrial complex
For an industrial complex in Pavlodar Region we set up loading of power consumption data from SCADA into Power BI every 5 minutes. Engineers see usage by workshop and substation almost right away.
1. beforeMonthly roll-up
2. howTelemetry to BI
3. afterUsage visible same day
telemetry load interval
5 min
metering points
40+
workshops and substations covered
12

BI dashboards for a trading company

Challenge

What we did

Outcome

More projects in this area

Document management upgrade for a Pavlodar Region akimat department

1C:ERP and MES integration for a machine-building plant in Omsk

BI energy monitoring for an industrial complex

Need a similar result?