Blog
Practical Excel, Power Query and Power BI solutions
Useful articles on Excel, Power Query, Power BI and Report Automation – from simple formulas to fully automated reports.
Learn to join Excel tables with XLOOKUP
A clear, practical example of how to use XLOOKUP quickly and without errors.
-
Empty running, fuel norm and repairs: three numbers that explain the loss
When a report shows that a truck runs at a loss, that is not yet an answer – it is…
-
Three systems that name the same truck differently
A carrier’s data about the same truck lives in three places. In the TMS it is V-104. On the fuel-card…
-
Why overall fleet margin says nothing
A carrier running 24 trucks opens the report and sees one number: fleet margin – 2.4 %. The number is…
-
Case study: an Etsy sales dashboard from CSV in one Refresh
Etsy sellers get a lot of data – but usually as a CSV export, not a clear picture. How much…
-
Case study: 12 Excel files → one Power BI model (sales analysis)
Yearly sales analysis often lives in twelve separate Excel files – one per month. While you’re looking at a single…
-
Case study: a monthly solar report in one minute
Monthly solar power reports are a good example of how repetitive work quietly eats up time. Every month, CSV files…
-
Excel or Power BI? When It’s Time to Grow
„Excel or Power BI?” is one of the most common questions once reports start to grow. And it’s usually asked…
-
Why Power Query Beats Copy/Paste
Copy/Paste is the most natural way to move data into a report – everyone starts there. And while the report…
-
How to Automate Monthly Excel Reports
Monthly reports are probably the biggest source of repetitive work in the office. At the start of every month, the…