Tidy data
Cleaning and a data model with Power Query: one version of every figure, even when it comes from several places.
Power BI consultant in Alicante for SMEs
If your company’s numbers live in several Excel files and someone spends hours every month pulling them together, a Power BI dashboard does it on its own. I connect it to your ERP, your spreadsheets or your database, reconcile the figures with accounting and hand it over documented. I work from Alicante with companies in Alicante, Elche and the surrounding area, and remotely with the rest of Spain and Europe.
What’s included
DAX measures
Sales, margins, collections, stock or production, compared with last year and with your targets.
Clear design
Pages built for decisions: the important things first, simple filters and a mobile layout.
Automatic refresh
The report refreshes every morning through the gateway, with nobody copying anything.
Documentation
What each figure measures and where it comes from, so your team trusts it and can maintain it.
Power BI, DAX, Power Query, Microsoft Fabric, SQL Server, A3 ERP, SharePoint
Analysis packs
Reports already designed for each area, adapted to your ERP and your own names. Start with the pack that hurts most and add the others whenever you like. Try them with made-up data in the lab (the demos are in Spanish).
For management and sales teams
Sales
Are we selling more than last year, who owes us money and what needs reordering?
- Sales by month, customer and product family against last year
- Receivables by age and average collection days
- Stock below minimum and turnover
For the plant manager
Manufacturing and OEE
Where do the machines lose time, and why?
- OEE with availability, performance and quality, by machine and line
- Minor and major stoppages by day, cause and machine, with mean time between stoppages
- Hours lost by product
For logistics and customer service
Orders and deliveries
How many orders arrive on time, and why are the others late?
- On-time % by week, warehouse and carrier
- Delays by reason and by customer
- Open orders with their status
For quality and production
Quality and scrap
How many parts do we scrap, what does it cost and why?
- Scrap % by month and work centre
- Rejected parts by defect and cost of scrap
- Actual against expected by part number, and the orders with most scrap
On video: a date table in Power Query
The date table I use in every report, with the code to copy. It is the base for comparing with last year. The video is in Spanish.
How we work
- Free review45 minutes on a video call to look at your data, your tasks and what really takes up your time.
- Written proposalWhat gets built, how many rounds of changes, the fixed price and the deadline, set once I have seen the data.
- BuildI show you progress along the way. You pay 50% to start and 50% on delivery, always with an invoice.
- Delivery and trainingI leave it working, documented and explained to your team. If you like, I carry on with monthly maintenance.
Why work with me?
What changes compared with hiring an agency or off-the-shelf software
- You talk to the person who builds itWhoever listens to you in the review is who designs, codes and delivers the work. No sales reps, no middlemen.
- I know how a company works day to dayI have worked with data since 2019, first in consulting and now inside industry, with ERPs such as A3, SAP or Clavei.
- A fixed price, in writingBefore we start you know what gets built, how many rounds of changes there are and what it costs. No surprises at the end.
- Your data, looked afterI work read-only whenever possible and the applications live on EU servers with nightly backups.
- No lock-inI hand the work over documented, and much of what I do is open source: you can see how I work before you call me.
- I measure what you gainI note how long the task takes today and how long afterwards, so you know whether it was worth it.
Related projects
- Sales, collections and stock reporting · For a company
- Operational report without Power BI · For a company
- Sales priorities without overload · Open source
- Graph map of your Power BI project · Open source
- powerbi-report-reader · Open source
- Power BI Theme Lab · Open source
- CALCULATE live · Open source
Frequently asked questions
- How much does a Power BI dashboard cost?
- It depends on the data sources, the number of pages and the calculations. Tell me about your case and I’ll send you a fixed quote in writing, with no obligation.
- What is an analysis pack?
- A set of Power BI pages designed for one area (sales, plant, logistics or quality) with its indicators already defined. I connect it to your data and adjust it to the way you work, so you don’t start from scratch. Tell me which packs interest you and I’ll send you a fixed quote.
- Do I need a Power BI licence?
- To build and view the report on your computer, Power BI Desktop is enough and it is free. To share it online with your team you need Power BI Pro, which is paid to Microsoft per user.
- Does it work with my ERP?
- I have worked with A3 ERP, SAP, Clavei, Cybermax and SQL Server. If your ERP stores its data in a database or exports it to Excel, it can be connected.
- Can I change it myself later?
- Yes. I hand it over documented and explain how it is built. If you would rather not touch it, there is monthly maintenance.
- My Power BI report isn’t refreshing. Can you help?
- Yes. Here are the most common causes and how to fix them. If you can’t sort it out, I’ll go through it with you.
- My Power BI report is slow. What can I do?
- Start with the six most common causes and how to speed it up. If it is still slow, I’ll measure it with you and tell you what to change.
- I’m getting a gateway error. What can I do?
- Here are the six most common causes and how to fix them. If it still fails, I’ll go through it with you.
Other services
Power BI for factoriesPower BI not refreshingSlow Power BIPower BI gateway errorAutomation with n8nEmail orders into the ERPAI assistant for your ERPWebsites and appsServices