Every week, we run a meetup for the Investec Programmable Banking community. Developers demo cool projects they’ve been working on and everyone has the chance to ask questions. If you’ve been wondering where programmable banking is at, here’s your sneak peek!
In this demo, Lionel Chetty shares how he used programmable banking to sync transactions to budget and categorise them using AI.
The tech he worked with includes PowerBI, Cloudflare and Azure Functions.
Click here to download Lionel’s presentation slide deck.
You can access the repos here:
Transcript of the demo
I’m Lionel Chetty, and I work at Wyobi. My transactional insights demo is a PowerBI report. It’s meant to be low code in the sense that a non-dev or end-user could use it and I have a categorisation feature to provide for data mining aspects into all the transactions that are on the bank account.
So the way that it works is PowerBI calls my Cloudflare worker, which is functioning as an API gateway in a sense, which will return a cached response, or it will forward the request on to my Azure Function that will forward the request on to Investec back-end to get the balance and transactions.
I have posted the link in the chat, but this is what the visual looks like for one of their bots.
If you’re looking at the demo, you probably wouldn’t see the QA aspect but what it allows you to do is talk to your data in a sense using a natural language process. So if you want to do fan-out transactions, it will allow you to create a query. The way that PowerBI works is scoped to the data context. So, in this data context in the last seven days, we also have other partners for this month or a total overview.
This is called a decomposition chart unique to PowerBI, which is one of the new features that they came up with where it allows you to break down your spending once you categorise it. I spend a lot of money online ordering stuff, but this allows me to see at a glance what I’m spending money on.
The nice thing is if you’re not into UI and stuff like that, this is taken care of for you, but there’s a mobile app, and it’s free, so you can play with it. You get all of this for free. You just need to give it the data. The important thing is that you need to label your data so that the UI or the BI works properly.
I’ve posted the links in Slack with some of the projects that I’ve done but the important one is the API from Investec. What I’ve built into the categorisation feature is it uses Wikipedia to try and gauge what the transaction is for. If it’s for Uber Eats, it will try and pull out that UberEats is online for food delivery.
That was about it. If you need to, contact me on Slack. That’s my demo.
Awesome. Thanks, Lionel. How long did it take you to put that all together?
I think that the API from Investec came out last week and then PowerBI is pretty fast. You don’t have to do what I did with the Azure Functions – you can just plug in your own credentials to the Investec API and you can start working in PowerBI.
The way that PowerBI works is based on a feature called Power Query, so it’s available also in Excel. If you don’t use PowerBI and all the features, you can just plug this into Excel and work directly with the API.
Okay, cool. The demos are quite cool as you can actually click on the total amount and add categories and types. That’s a really interesting way of doing things.
Howzit, Lionel, just a question. I love Cloudflare– what did you say you are using the workers for sorry?
I use the workers to cache the response, but I also use the key-value store, and I use Cloudflare as an API gateway for this aggregator job.
So that your finances are just distributed around the world. It’s cool.
Is this the first time you’re working with PowerBI or have you used it a lot before?
Quite a lot before, but the AI aspects are new, and again – I’m not a UI person and building dashboards is a bit hard once you try to go to a mobile responsive design.
Are you using this with your current card, or actually using it for day-to-day purchases or are you still just playing around?
Day-to-day purchases, no – I’ll be honest, it is only online purchases. The reason I don’t swipe the Investec card is that I can’t remember the pin and I can’t set it up.
Cool. Any other questions from the audience?
Audience member [06:25]
A tip to use your Investec card a bit more – I wrote the pin on the back.
I think we have the functionality where you could change the pin. I think it was meant to go last year. I can’t remember. I’ll confirm it.
Audience member [06:43]
Could you send a screenshot to show the way it’s written or how you did it?
Yeah, firstly, the next demo is how to store your pin on the back of your card, and the next hackathon will be about fraud detection. Okay, cool.
Thanks, Lionel. It doesn’t look like anyone else has questions. But I mean, you’ll be on Slack if anyone’s got more questions to follow up with. It was really cool that you made the demo interactive so that I could actually use it while you were speaking. It’s cool to just click around.
Do you have any plans for where you want to go from here?
PowerBI works best with more data than you give it so I could integrate maybe with UberEats API or Azure and have how that spending is broken up and I can get even more insight into the data.
Okay, cool. Can you just run me through that thing, again, that you’re pulling from Wikipedia so where could I see that on the demo?
It’s the categorisation on the demo.
Okay, cool. Were those categories actually generated, or did you create them?
Some of it is generated and some of it’s overwritten in a sense so Uber will be Uber trips or UberEats – you just decide on which one you want.
Okay, awesome. Charl, did you have something you wanted to share?
I don’t know if you can see it, but I found it, and I’ll post how to get there in the chat. The way you can change your pin.
Awesome, sweet, okay. If you just send it to me, then I’ll put it in the Slack group as well.
Lionel Chetty is an integration developer who tries to get computers to do what he wants and not what he asks. He currently works on access control and security solutions at Wyobi Technologies.
Get involved in the Programmable Banking Community
If you’re not part of our community yet, sign up and join the fun. You can also see more of the demos from our meetups on our YouTube channel here.
For those of you in the community, check out our GitLab to see more of the awesome projects members of our community are working on. You can also sign up for challenges, where you can help find solutions for real life problems.
For more information, get in touch!