Power BI · Power Apps · Power Automate · Excel · Goal: less retyping
Reports, apps and workflows in your Microsoft 365.
We build Power BI reports, small apps for phone and tablet, automated workflows and Excel workbooks that calculate instead of copying. No big IT change, inside the Microsoft 365 you already have.
01Lists by e-mailEvery department has its own Excel file, none of them is current.
02Reporting by handEvery month numbers are copied until the report is done.
03Paper at the machineStops and inspections end up on notes and are typed in later.
What the tools do
Four tools that work together in Microsoft 365
The tools come from Microsoft and run in your existing Microsoft 365. We set them up for your company, build the first solutions and show your people how to carry on themselves.
Power BI
Reports and dashboards. Numbers from Excel, ERP, machines or SQL in one report that refreshes itself. Click a machine and the whole report filters.
Downtime, scrap, availability
Revenue per customer and item
On-time delivery and open orders
Power Apps
Your own apps without programming. Forms for phone and tablet that store data where your company needs it: SharePoint, Excel or Dataverse.
Stop report at the machine
Goods receipt with photo
Inspection record and checklists
Power Automate
Workflows that run by themselves. When something happens, the next step follows automatically: a message, an approval, an entry, a reminder.
File and name mail attachments
Approvals for purchase orders
Reminder when maintenance is due
Excel
Complex workbooks that calculate. Costing, shift plan, gauge list: with Power Query, XLOOKUP and pivot tables, built cleanly so the next person understands them too.
Quote costing with price breaks
Merge data from several files
Reports at the push of a button
Demos
Try it yourself
Browser mock-ups with sample data, so you can see how the solutions feel. Report a stop in the app, the flow next to it starts and the report counts along. The report has three pages, the workbook a sheet with scenarios.
Power BIDowntime report
Production downtimeRefreshed 06:00 · Share
Month
0Downtime (h)
0Reports
0Availability · Target 95 %
Downtime by machine (h)
Downtime by month (h) · tap a column to choose the month
Reasons, sorted (Pareto) · cumulative share
Biggest lever
Matrix per machine · traffic light against target 95 %
Machine
Downtime h
Reports
Ø min
Availability
Filter
Tap a bar to filter every visual and page.
Power AppsStop report app
Stop reports
Report
New report
Power AutomateCloud flow: stop
Stop report to shift lead
L
When an item is createdList: Stop reports · waiting
?
ConditionDuration (minutes) is greater than 30 · not run yet
If yes
T
Post message in a channelTeam Production · channel Shift
✓
Start an approvalover 120 min: order spare part? · not needed
Shift lead decides:
@
Send an email (V2)to purchasing · spare part
If no
No action
X
Add a row into a tableDowntime.xlsx · table Downtime
Run history (28 days)
Start
Duration
Status
Report a stop over 120 minutes in the app: the flow then asks the shift lead.
ExcelCapacity.xlsx
HomeInsertFormulasData
B5fxTap a cell to see its formula
A
B
1
Quantity
2
Minutes per part
3
Setup time (min)
4
Shifts per day
5
Machine time (h)
6
Setup share
7
Working days
Working days per quantity (current shifts)
What-if: working days per quantity and shift model. Green up to 3 days, yellow up to 10, red above.
Pieces
1 shift
2 shifts
3 shifts
Worked example without prices. Your workbook holds your machines, rates and shift models.
Mock-ups for illustration, not Microsoft software. Microsoft, Microsoft 365, Excel, Power BI, Power Apps and Power Automate are trademarks of the Microsoft group of companies. STATECHPRINT is not a Microsoft partner.
Examples from practice
What companies solve with it
Typical solutions for manufacturing companies, the way we build them. Each one is small enough to run within a few days.
AppsAutomateBI
Stop report at the machine
The operator reports on the tablet, the shift lead gets a message, the report shows downtime per machine and reason.
AppsAutomate
Goods receipt with photo
Photograph the delivery note on the phone, pick the purchase order. The flow files the photo and tells purchasing about deviations.
Automate
Sorting supplier invoices
Attachments from the invoice mailbox land named in the right folder, accounting gets a list to approve.
AutomateExcel
Gauges and calibration
The gauge list sends a reminder 30 days before each calibration, with owner and date.
AppsAutomate
Leave and approvals
Request in the app, approval with one click in Teams or by mail, entry in the calendar.
BIExcel
Monthly report for management
Revenue, on-time delivery and open orders from ERP and Excel, current every morning instead of once a month by hand.
Ask about a Power solution
Describe your list, your report or your workflow.
Tell us what you work with today. In a first call at no cost we show you how the solution could look in your Microsoft 365.
Excel file or form you use today, feel free to attach it
Power Apps and Power Automate are made for people who know their process, not for programmers. The principle is called citizen development: the supervisor builds the checklist for her department, the buyer the approval flow.
To keep it tidy we set up the framework: separate environments for testing and production, rules on which data may go where, a list of who owns which app. We build the first solutions with you, train your people and stay your contact when it gets tricky.
No new systemRuns in your Microsoft 365, with your accounts and permissions.
Start smallOne app, one flow, one report, then the next.
Training on siteYour people learn with their own data.
Rules from the startEnvironments, data policies and clear responsibilities.
Built to Microsoft guidanceI am preparing for the Microsoft certifications for Power BI and the Power Platform and build to the principles they test.
Fits the ERPReports and flows can also read from our ERP & MES.
Process
Four steps
Power BI, Power Apps, Power Automate71 seconds, with narration and captions, sample data, footage AI-generated
30 minutes about your lists, reports and workflows.
02
Prototype
A first report or app with your data, before you decide.
03
Quote
Fixed price for the build or a block of hours, stated openly in the quote.
04
Roll-out
Training on site and support.
Questions
Frequent questions about Power BI, Power Apps, Power Automate and Excel
Do we need new licences?
Often not to begin with. Power Apps and Power Automate with standard connectors are included in many Microsoft 365 Business licences, Power BI Desktop is free. Sharing reports usually needs Power BI Pro, some connections need premium licences. What exactly you need we clarify in the first call.
What does citizen development mean?
Specialists in your company build small apps and flows themselves, without programming skills. We set up the framework, build the first solutions with them and train your people so they can carry on themselves.
Do we have to change our IT?
No. The tools run in your existing Microsoft 365. Data stays in SharePoint, Excel, Dataverse or your ERP; we only connect what belongs together.
Can you take over our existing Excel files?
Yes. We tidy up existing workbooks, merge several files with Power Query and turn them into a costing or report the next person understands too. On request it later becomes a report in Power BI.
Are you Microsoft certified?
I am preparing for the Microsoft certifications for Power BI and the Power Platform and work to the principles they test. STATECHPRINT is not a Microsoft partner.
What does it cost?
It depends on the scope. After the call and a first prototype you get a fixed price or a block of hours, shown openly in the quote. The first call costs you nothing.
