I’ve created a Power BI report using the Tiller Spreadsheet (Google Sheets) to get quick insights on my Net Worth, Balances, Expenses, Bill Payments, etc.,
Been using this for quite sometime now. And I can say it works like a charm and helps me analyze my spending pattern a bit better.
Interesting, @ppraju12. When you’re ready to share more, I’m sure many users are curious about the technologies used, the challenges you’ve faced, and the possibilities you foresee with this Power BI integration. Let us know…
I guess converting the raw data in a format that we can use for reporting is the key to building these kind of dashboards.
Luckily, I have fair amount of experience in creating reports using Power BI. And with the well structured data that we already have with the Tiller templates, it makes it easy to build dashboards.
Obviously, these can be built even within Google Sheets itself, but the ability to cross-filter the data , slice & dice data and most importantly the AI capabilities to ask questions about the data… These are what makes Power BI more useful for understanding the data better.
Since some of the users are interested, I will setup a separate sheet for sharing along with all the custom tables that I had created and create a report based on that as template. Will share it along with the documentation in a couple of weeks perhaps.