Hi, I'm Rasmus Kampmann
Power BI Developer & Data Analyst
- Power BI
- SQL
- Microsoft Fabric
- Python
From Excel chaos to Power BI clarity.
Your numbers live in files that do not agree. Excel says one thing, the system says another, and someone rebuilds the report by hand every week. I connect it all into one dashboard that updates itself.
What I Do
I do one thing. I take the numbers your business already has and put them on one screen you can trust. Five tools do the work.
Power BI
The screen you look at. Charts and numbers built around your decisions: what sold, what it cost, what is left. Semantic models, DAX, and report design underneath, so it stays fast and correct.
SQL
The order underneath. One place where every number lives, so every report shows the same figure. I connect it to what you already use: SQL Server, PostgreSQL, SharePoint, Excel, APIs.
Excel
Where your data starts, and that is fine. I keep Excel as the input and make it safe: locked tables, clear templates, no formulas that break when someone sorts a column.
Automation
The end of copy-paste. Files flow in on their own and reports update themselves. Power Query, Power Automate, and n8n do the moving. Nobody retypes anything.
Python
The heavy lifting. Forecasts, big cleanups, and checks that spreadsheets cannot do, running on a schedule instead of by hand.
My Projects
Three builds, one story: messy files in, one trusted screen out. Built with synthetic data where a client is involved. Written so you do not need to be a data person to follow them.
Invoice & Financial Dashboard
One trusted view of profit per product, profit per customer, and the money owed. Built from invoices and checked line by line against the accounts.
Operations & Production Planning
What to produce, how much, and when. A seasonal forecast built from history instead of gut feel, feeding the production plan.
From 11 Excel files to one source of truth
A folder of monthly Excel files, different formats, broken headers, totals mixed into the rows. One automated flow reads them all, cleans them, and feeds one dashboard that updates itself.
About Me
Hi, I'm Rasmus. I take the numbers your business already has and put them on one screen you can trust.
I didn't start in data. I started in marketing and operations at Veginova, my family's seed company in Odense: sourcing customers, running trade fairs, and visiting production in Costa Rica, Panama, and Mexico. I learned what the numbers meant by collecting them, years before I built a dashboard on them.
That's what makes the reporting different. When a report says a variety is running short or a customer isn't profitable, I know which process produced that number and where it breaks, because I worked in the process. The role grew into the data work, and I moved into it from there.
Does this sound like your Monday?
- Your numbers live in five places and they do not agree.
- The same report gets rebuilt by hand every week. Usually by you.
- Excel says one thing. The system says another. Nobody knows which is right.
- You sell every day but do not know what you actually earn per product, per customer, per channel.
- One wrong formula and the pricing is off. It has happened before.
- You want AI, but the data under it is a mess.
If two of these are true, that is the problem I fix.
What runs today
- A system that reads supplier invoices line by line, a person approves what it found, and the accounts stay clean. Live at Veginova.
- A seasonal sales forecast that feeds the production plan.
- A profitability dashboard checked against the accounts, line by line.
- A prediction model at a fintech firm, right about three times out of four, running in production.
Two layers of AI
AI in my work comes in two layers.
The AI I implement for the business: LLM extraction with human approval, Copilot on the semantic model, and predictive modelling as classical ML: forecasting, scoring, classification.
The AI I build with: an agentic setup where Claude Code operates in GitHub, pulls context from Supabase, runs my library of reusable skills, and connects to my tools through MCP. One person, the delivery speed of a small team.
Between the two layers, the source of truth stays deterministic. Trust is engineering, not generation.
The technical layer
Today I own BI and reporting across sales, operations, and production at Veginova. The data landscape is moving onto Azure SQL Database, and that migration is under way now. I evaluated Microsoft Fabric end to end with a working prototype before landing on Azure.
I specialise in Power BI end to end: semantic models, DAX, Power Query, report design, distribution, and access management. I connect Power BI to the sources the business already runs on: SQL Server, PostgreSQL, Azure SQL, SharePoint, Excel, APIs, and third-party platforms.
Beyond dashboards: data modelling in SQL, workflow automation with Power Automate and Python, and forecasting in Python notebooks.
Most of my experience is from small companies and my own. Close to the decisions, owning the work end to end.
Certifications: Google Data Analytics · Artificial Intelligence: Implications for Business Strategy (MIT Sloan) · Power BI Fundamentals (DataCamp) · Microsoft PL-300: Power BI Data Analyst (in preparation).
Danish, English, Spanish, with clients and partners across Europe and Latin America.
Working with me
One person, full responsibility. I scope the project, build it, document it, and hand it over. Nothing falls between chairs, because there are no chairs.
I hold the whole picture from end to end. You explain your business once. I take it from there: your files, the data model, the dashboard, the training.
No cure, no pay. Before I start, we agree in writing exactly what the dashboard must do. If it does not do that, you do not pay.
Fixed price, clear end date. And when I leave, you own everything: documentation, training, no dependency on me.
Based in Odense, Denmark. Open to on-site roles.
Experience
Roles where I built the data systems, dashboards, and automation behind real commercial decisions.
Aug 2023 to now
Veginova Seeds
Family-owned seed company · Odense, Denmark
International growers, distributors, and production partners across Europe and Latin America. (Spring 2026: role at Digi-Tal Regnskab, see below.)
Jun 2026 to now
Power BI Developer
Back at Veginova with responsibility for BI and reporting across sales, operations, and production. Driving the consolidation of the entire data landscape into one unified Microsoft ecosystem.
- Architecture: Azure SQL Database as the operational data layer, Power BI as the decision layer. Migration in progress. I evaluated Microsoft Fabric end to end with a working prototype before landing on Azure.
- Automated line-level invoice extraction with the Claude API: confidence scores and human approval via Power BI translytical task flows. Power Automate for event-driven file synchronisation. Excel inputs as locked tables on SharePoint.
- Sales and contribution margin dashboards, a seasonal sales forecast, and one unified source of truth reconciled to the accounts. Published as case studies on this site.
Stack: Azure SQL · Power BI · DAX · T-SQL · Python · Power Automate · Claude Code
May 2025 to Feb 2026
Data Analyst
Promoted to ownership of reporting and data infrastructure across sales, operations, and production, and the analyses management steered by.
- Owned the shared data foundation: Power BI dashboards, SQL data models, and automated data flows as one source of truth for sales, operations, and production.
- Standardised metric definitions across sales, operations, and production so dashboard numbers matched the systems.
- Automated recurring reporting workflows so reports stopped being rebuilt by hand each week.
Stack: SQL · Power BI · DAX · Python · Excel · Supabase · Claude Code
Aug 2023 to May 2025
Marketing & Operations
Broad commercial role in the family business. The foundation for everything I do with data today.
- B2B marketing and lead sourcing (Clay) toward international wholesale, distributor, and grower customers. Trade fairs and customer events in Denmark.
- Production visits in Costa Rica, Panama, and Mexico. In Costa Rica also company establishment and dialogue with local partners.
- Connected ERP, CRM, and operational tools into reliable data flows. The role grew into the data work: the transition to data analyst came from there.
Stack: Microsoft Office · Clay · n8n · Supabase · Apify · API sources · GitHub
Feb to May 2026
Data Analyst (Commercial)
Digi-Tal Regnskab
Built the commercial data infrastructure in four months: CRM, ad, and registry data unified into one source of truth, and the models and analyses on top. Recruited on the back of my Sira Logic data work.
- Commission and forecast model: rebuilt the commission structure to weight MRR and LTV, removing the incentive to discount subscriptions to close.
- Revenue channel analysis: close rate, conversion, and how long deals took to close across paid, cold outreach, and inbound, with revenue figures reconciled to the accounts.
- Predictive models: ICP and lead scoring with strong holdout performance, plus an ML model predicting prospects' accounting software from public registry data (holdout AUC 0.75).
- Churn and segmentation analysis: customer and prospect base segmented into active, lead, lost, and inactive cohorts. Surfaced funnel drop-off and the patterns behind closed deals.
Resigned when the family relocated back to Denmark. The role was fully remote, and I wanted to be back on-site, close to the business.
Stack: SQL · Python · PostgreSQL · n8n · Excel · Pipedrive · Clay · Claude Code
Jun 2024 to Aug 2025
Data & AI Consultant (Independent)
Sira Logic
Own consulting business: end-to-end data and automation systems for B2B companies, from data collection to operationalised scoring in the clients' CRM.
- Scraping, AI-assisted enrichment and qualification, scoring, CRM automation, and lead systems combined in one flow. Qualification accuracy up by roughly a third.
- Custom web scraping for industry-specific sources. Owned the full cycle: sales, scoping, build, deployment, handoff.
This work led directly to the Data Analyst role at Digi-Tal Regnskab.
Stack: SQL · Python · n8n · Clay · Apify · HubSpot · GoHighLevel · Excel
Jan to Aug 2023
Marketing & Digital Graduate (student job, part-time during BBA)
Damstahl Danmark
Part-time student job alongside the BBA at Aarhus BSS.
- Product and marketing data in ERP and CRM across European markets.
- Excel dashboards for campaign reporting and standardised regional data processes.
Hiring, or drowning in Excel?
I am open to on-site BI roles in Denmark. Alongside that I take on a few fixed-scope builds for small businesses: from your files to one screen your team trusts.
Get in touch →