BILLZ analytics in Power BI and SQL
Running stores on BILLZ? With an integration key ETL Sync pulls sales, stock, products, customers and stores into your warehouse — with history. Power BI then shows revenue, margin and turnover across all locations.
BILLZPower BIMS SQLPostgreSQLTelegramBefore → after
BILLZ reports show one store at a time; the network summary is assembled by hand.
All stores in one database. Network revenue and stock in one dashboard.
No year-over-year comparison: exports have no history.
The program loads history from a chosen date and keeps adding new days.
BILLZ and 1C data live apart: cost in one place, sales in another.
BILLZ and 1C go to one warehouse. Margin and profit in one report.
How it works
- 1
BILLZ key
Take the integration key in BILLZ and paste it into the program — read-only.
- 2
History
Choose the start date for sales. After that — only new days.
- 3
Warehouse
MS SQL Server or PostgreSQL — on your side or on our server.
- 4
Reports
Power BI, Tableau or our ready dashboard — on request.
What you get
Sales and receipts
Sales by product, store, seller and day — with history.
Stock
Stock by store and warehouse — for shortages and dead stock.
Customers
Buyers and their receipts — for loyalty and RFM.
Together with 1C
Cost and purchases from 1C next to BILLZ sales.
Every morning
Yesterday's data before the working day starts. Or more often.
In Telegram
A short load and error summary in Telegram.
You decide where the program and data live
Usually the program is installed on your side — data never leaves the company. Don't want to install anything? We'll run it all on our server.
In your company
- The program on your computer or Windows server
- Warehouse — your MS SQL Server or PostgreSQL
- Data never leaves the company
- Pay only for the key — there is a free plan
On our server
- The panel opens in a browser over HTTPS
- Your own PostgreSQL database — from 10 GB
- Updates and backups are on us
- Monthly billing: key and storage, auto-renew
Frequently asked questions
What is needed from BILLZ?
Can past years be loaded?
Will you build the dashboard for us?
How many stores are supported?
Related articles
How to connect Power BI to 1C: 3 ways and which one to choose
Three ways to get 1C data into Power BI: Excel exports, a direct SQL connection and a separate warehouse. Pros, cons and what to choose.
ReadWhy 1C reports are slow and how to move analytics to a separate database
A yearly sales report takes minutes and accounting complains about freezes? Here are the causes and how to move analytics out of 1C into a separate...
ReadOther solutions
Power BI on 1C data — in one day
Connect Power BI and Tableau to 1C data: ETL Sync moves catalogs, documents and registers into a SQL warehouse on schedule, with readable table...
1СPower BITableauMS SQLPostgreSQL Learn more ETL for 1C1C to SQL and PostgreSQL — automatically
ETL for 1C: catalogs, documents, tabular sections and registers are copied to MS SQL Server or PostgreSQL on schedule, changes only, with readable...
1СMS SQLPostgreSQLMySQL Learn more Google Sheets · Excel · CSVGoogle Sheets and Excel — into SQL, by themselves
Sales plans, budgets and reference lists from Google Sheets, Excel and CSV go to MS SQL Server or PostgreSQL on schedule. Column types are...
Google SheetsExcelCSVMS SQLPostgreSQL Learn more ETL Sync serverNothing to install: the program and storage run with us
Don't want to install the program and a server yourself? We run ETL Sync and a PostgreSQL warehouse on our server: the panel opens in a browser,...
1СBILLZPostgreSQLHTTPSPower BI Learn moreLeave a request
We will call you back within a business day, show the program and help you install it.