Picqer Power BI dashboard

Through Picqer’s API: a REST API using JSON, hosted on your Picqer account’s own subdomain. According to Picqer, you can read all data in Picqer through the API, which is included in every subscription at no extra cost. We set up a data loading step and build the model on top of it.

To see how a dashboard starts with the decision it needs to support, read about Power BI dashboards.

An administrator creates an API key under Settings in Picqer. The key is sent as the username via HTTP Basic Auth. Picqer recommends a separate key for each application so you can revoke it independently.

Picqer sets a per-minute limit for each key and returns an error code if you exceed it. Lists are paginated; the loading step works through the pages and retrieves only new data on each run.

A pick list in Picqer has a creation time and a closing time. For each product, it records the quantity needed and the quantity picked. We call the time between order creation and pick list closure the lead time.

We show that time by warehouse, by day and by the hour the order was created, so you can see where orders are being held up.

Yes. Picqer shows physical stock, reserved stock and available stock for each product and warehouse, as well as the stock at each location. An order can be fulfilled from multiple warehouses.

If you load stock data every day, you build up a history that you can compare with quantities sold and purchase orders.

Yes. Picqer knows what has been picked and dispatched; the webshop knows what was sold and at what price. A single model lets you see both side by side. You can read how we make Lightspeed eCom data accessible in Lightspeed eCom Power BI dashboard.

It works the same way for other webshops or marketplaces: only the loading step differs.

Typically, they report on orders and pick lists by day and warehouse, the time from order to dispatch, stock alongside sales, backorders, returns by reason and product, and, for fulfilment, everything by client.

For revenue, margin and cash flow at management level, see the financial dashboard in Power BI.

In Power BI, row-level security limits what each person can see. For example, a fulfilment client might see only their own orders, or a team leader only their own warehouse.

For how we set up workspaces, apps and refreshes, see Power BI consultant.

If you mainly want to know what’s currently open, Picqer has its own reports for that, and its API has a stats section covering open orders and open pick lists, among other things. Or if product and location data in Picqer needs sorting out: in that case, start with data quality.

If one export a week is enough, we’ll tell you that too.