Home❧Software & Data
Software & Data
Excel, Power BI, planning software and data warehouses: which tool fits which task – and how do you get the most out of what you already have?
Good controlling rarely fails because of methods, but often because of tools: files nobody understands any more, data copied by hand every month, reports that arrive too late. The right software – or simply the right use of what you have – saves hours every week.
This section is about practical tool knowledge: the Excel functions you really need, getting started with Power BI, choosing planning software and the basics of a data warehouse – always from a controlling perspective, not an IT one.
Excel
The most important functions and Power Query for everyday work.
Analysis
Power BI and data warehouses for reliable reports.
Read and apply
Excel for controllers: the 30 most important functions
Excel is and remains the Swiss army knife of controlling. These 30 functions cover almost everything that comes up in daily work – sorted by task, with examples.
Read more · 16 min →Pivot tables: the 30 most important features for controllers
Pivot tables summarise thousands of postings with a few clicks. These 30 features turn a quick overview into a report that grows with you every month.
Read more · 14 min →Power Query: the 30 most important features for controllers
Power Query does the monthly copying, cleaning and joining of exports for you. Set it up once, and from then on one click on “Refresh” is enough.
Read more · 15 min →Goal Seek, data tables and more: Excel's what-if tools
Which price gives a result of zero? How strongly does profit react to volume and price? Excel has dedicated tools for this – only ten, but they save a lot of trial and error.
Read more · 10 min →Conditional formatting: the 30 most important rules for controllers
Used well, the one critical variance jumps out immediately. Used badly, everything lights up. These 30 rules show how to do it right.
Read more · 12 min →Power BI for controllers: getting started, DAX and your first dashboard
From Excel report to interactive dashboard: what DAX is, which 15 functions you really need and how to build your first controlling dashboard in a few steps.
Read more · 15 min →Planning software compared
When is dedicated planning software worth it – and which one fits? An overview of categories, criteria and the path to the right decision.
Read more · 8 min →Data warehouse explained simply
One truth instead of five exports: what a data warehouse is, how it works and when it is worth it for mid-sized companies too.
Read more · 7 min →