AI automations for costing and Power BI
10 AI automations for costing work, and AI-assisted Power BI development that cut one report build from two weeks to three days.
The problem
Costing work was manual.
One Power BI report build took two weeks.
What I did
Turned manual costing work into 10 AI automations. They pull live ERP data, build Excel workbooks anyone can audit, and flag anything a person must confirm.
Introduced AI-assisted Power BI development. Tested the toolchain on live production models and cleared open questions with the tool’s author.
Handed the toolchain to IT, which now runs it.
Set up AI use for a non-technical team: account setup, use cases and data-handling rules.
Kept AI use inside company security rules: approved connectors, tools that run locally, and a person signing off every change.
The result
One report build went from two weeks to three days.
IT now runs the toolchain.
Every automation flags what a person must confirm.
Tools
- Claude Code
- Claude Cowork
- Custom agent skills
- Model Context Protocol (MCP)
- Excel