Skip to main content
Alberto Ortiz logo Alberto Ortiz Data · BI · Automation
ES

Sector · Laboratories, chemicals and pharma

Data and automation for laboratories, from someone who has stood at the bench

I am a chemist, I have worked in the laboratory and I have contributed to scientific publications. Today I help laboratories and chemical and pharmaceutical companies turn results, records and sensors into reports that generate themselves and dashboards that stand up to an audit.

  • I understand batches, samples, calibrations and traceability without needing them explained
  • Test and quality-control reports that generate and validate themselves
  • Laboratory dashboards: turnaround times, load per instrument, consumption

30 minutes · no obligation · reply within 24–48h · or take the guided quick assessment

Illustration of laboratory data turned into a dashboard

Timeline

2–4 weeks

Price

Fixed

Support

30 days

Does any of this sound familiar?

These are the situations people call me about. If you recognise one, there are hours to be won back.

Results live in one spreadsheet per instrument or per analyst

Every instrument exports its own format and every person keeps their own sheet. Consolidating a test report or a quality control means copy, paste and hope nobody slipped.

Traceability is reconstructed before every audit

Who did what, with which reagent batch and under which calibration should come out on its own. Today it is dug out of notebooks, emails and folders the week before the visit.

Nobody sees the lab’s workload in time

Turnaround times, pending samples, saturated instruments: you find out when a customer is already waiting, not when the backlog starts to build.

Sensors and instruments produce data nobody uses

Temperatures, consumption, signals from a pilot plant: logged because they have to be, and looked at only after something has failed.

What you get

No slide decks: concrete deliverables your team uses from day one.

Instrument and LIMS integration

Automatic reading of instrument exports, analyst sheets and whatever LIMS or database you use. Data is captured once and never retyped.

Automated test and quality reports

The report in the format you already deliver, generated on its own, with range and consistency checks before it is issued. No figure goes out unvalidated.

Searchable traceability

Who, when, with which batch and which calibration, recorded at the time and retrievable in seconds. It does not replace your quality system: it feeds it and makes it demonstrable.

Laboratory dashboard

Load per instrument and analyst, turnaround times, pending samples, repeats and consumption, in a self-updating dashboard that management understands.

Sensor and plant data

Time series of temperature, humidity, consumption or IoT signals turned into alerts and into reports you can share with customers or partners.

Training and handover

Documentation, a session with the team and 30 days of support. When the project ends, the lab maintains it without depending on me.

A real case

The pattern repeats in almost every project: the process stays the same, it just stops being done by hand.

CETENMA · Technology research centre

Scientific and sensor data shared with the whole consortium

Before

European research projects with IoT sensing and test data spread across partners. Every progress report meant collecting and consolidating by hand what each partner measured.

After

Power BI dashboards for the sensing and the analysis of the scientific data, accessible to every partner in the consortium, plus automatic processing of energy invoices with Python for the efficiency projects.

More cases by sector on the home page.

How I work

No six-figure projects or long commitments: we start small and measurable.

Step 1

Free diagnostic call

A 30-minute video call: you walk me through the process and I tell you whether it makes sense, how I would approach it and what it would cost.

Step 2

Fixed-price pilot

A first, well-scoped project with a fixed price agreed up front and a result you can measure.

Step 3

Delivery, training and support

Everything documented and your team trained to maintain it. 30 days of support for questions and adjustments.

See the full method: phases, timeline and deliverables →

Calculator

What does assembling that test report by hand cost today?

Think of the report or quality control someone in the lab consolidates every week from the instruments and the analysts’ sheets. Move the sliders and see what it costs per year. No sign-up.

4

1 = monthly · 4 = weekly · 20 = every working day

3 h

Include checking, fixing and sending. It is usually more than it seems.

€30

Cost to the company, not net salary. An admin role is around €18–25; a manager, €40–60.

What it costs you today

Hours per month
0 h
Hours per year
0 h
Working days per year
0
Estimated annual cost
€0

Conservative estimate: it leaves out typing errors, delays and review time.

Get the breakdown by email

I’ll send you this detailed calculation plus the checklist “10 signs your Excel has outgrown itself” as a PDF.

No spam. One email with the report and, a few days later, one more. That’s all.

Frequently asked questions

Do you know the sector’s quality requirements, such as ISO 17025 or GMP?
I have worked in a laboratory and I know what an audit asks for: a record of who, when, with what and why. What I build leaves that trail and never modifies data without validation. I do not replace your quality manager or certify systems: I work with that person so the automation fits your management system.
Do you work with our LIMS or our instruments?
With whatever they export: instrument files, CSV, Excel, databases or the LIMS API. If the data comes out somewhere, it can be integrated. If it does not, I will tell you on the diagnostic call and we will find the cheapest way to capture it.
What about the confidentiality of methods and results?
I work on your own systems and access; nothing is copied to external services. Confidentiality terms are agreed in writing before we start, and the diagnostic call needs no real data: an example with masked figures is enough.
Is this for a small pharmaceutical company or only for testing laboratories?
Both. The pattern is the same: data coming out of instruments and people that has to be consolidated, validated and presented to whoever decides or audits. The vocabulary changes, the method does not.
How long does it take and how much does it cost?
A first automated report or a first useful dashboard is usually ready in 2–4 weeks. The price is fixed and agreed after the free diagnostic call, normally as a pilot on the report that eats the most hours. No hidden hours.

The next step is a conversation

Which of your lab’s reports is still assembled by hand?

Tell me on the free 30-minute diagnostic call. I will tell you what can be automated as is, what needs tidying first and what it would cost. No obligation.

Where should I start?Guided quick assessment · 2 min