Portfolio / Case study 03
Financial reporting pulled straight from source data with SQL and Python, then presented in Power BI for the monthly review.

Project walkthrough

$ start project "Financial BI dashboard"
✓ Brief agreed with Intellifyx
✓ Wrote SQL queries to pull ledger and billing data
✓ Cleaned and joined the data with Python
✓ Built Power BI pages for revenue, costs and margins
→ Review with the client…
● Delivered and handed over
The project
Monthly reports were rebuilt by hand from exports, which took days and made it easy for small errors to slip through.
The monthly report refreshed from the source data, and review meetings started from the same numbers for everyone.
The monthly report used to be rebuilt by hand from exports, which meant the same copy and paste steps every month and a real chance of a small error slipping through. My goal was to take people out of that loop. Instead of rebuilding the report, the team would open one that already knew where the data lived and refreshed itself from the source.
Getting there meant separating the work into clear stages: pull the data, clean it, then present it. Keeping those stages apart also makes the report easier to check, because if a figure looks wrong you can see which stage it came from.
Power BI is excellent at presenting numbers, but it works best when the data arrives clean. I wrote SQL queries to pull the ledger and billing data directly from the source, then used Python to clean and join it. That step handles the problems that cause most reporting errors:
With the report refreshing from the source, review meetings started from the same numbers for everyone, and the discussion moved from whether a figure was right to what it meant. The pages for revenue, costs and margins were designed to be read in a few minutes before a meeting.
This kind of setup suits any business that closes its books monthly and still builds the report by hand. If that sounds familiar, I can look at what your reporting process involves and suggest where automation would save the most time.
Gallery and links
Figures are anonymised. Click an image to enlarge it.



Services used
Let's connect
Book a free 30-minute call on Google Meet, or reach me directly.
We use cookies to improve your experience on our site. By using our site, you consent to cookies.
Manage your cookie preferences below:
Essential cookies enable basic functions and are necessary for the proper function of the website.
You can find more information in our Privacy Policy and .