Data and BI analyst · Power BI and Excel
Power BI reports that answer real business questions
I build data models, dashboards and automated reports for production, sales, finance and HR. In my day job I coordinate production, so I know where the numbers in systems like SAP come from.
Hiring? LinkedIn
- Production · OEE 68.8% +2.3 pp y/y
- Sales · revenue [value] [change y/y]
- Finance · gross margin [value] [change y/y]
- HR · employee turnover [value] [change y/y]
- Figures for 2025 compared with 2024. More will appear once the remaining reports are published. All data is synthetic.
Projects
Four reports for one fictional company: a manufacturer that also sells through its own online store. They share one data model, so production, sales and costs reconcile.
- Production and operations Machine utilisation, downtime and plan attainment. Where the plant loses time and output. OEE · downtime · plan vs. actual Ready
- Sales and e-commerce Revenue, sales channels and online store customer behaviour. What sells well and why. revenue · conversion rate · average order value In preparation
- Finance and controlling Margin, costs and results against budget. Which products and channels make money, and which only move it around. margin · costs · budget vs. actual In preparation
- HR Headcount, turnover, absence and overtime. How staffing affects production and costs. turnover · absence · overtime In preparation
Work with me
BIRaptors is the name I use for BI projects with companies. I work directly with the people who use the reports.
-
Power BI dashboards and reports
I start with the decisions the report should support, then build the data model and a dashboard for management or the team.
-
AI-ready data models
Clear business names, descriptions, synonyms and a clean star schema, so Copilot and other AI tools answer questions about your data accurately.
-
Reporting automation
Reports you now put together by hand in Excel refresh on their own with Power Query and Power BI.
-
Excel training
Hands-on sessions for teams: formulas, pivot tables and Power Query, using examples from your own work.
Tell me what you need: sokolowskij@biraptors.com
Skills
Power BI
Data modelling, DAX, Power Query, models prepared for AI.
Excel
Advanced formulas, Power Pivot, automated reports and schedules.
Business knowledge
Production and SAP (PP-DS, MRP, PM) from the shop floor: shift and staffing planning, OEE.
Contact
Looking for an analyst to join your team, or want to commission a BI project? Email me: sokolowskij@biraptors.com