I've built an integration flow between the client's database and PowerBI to enable the client to view analytical data to understand trends of their customer payments and vendor's AR aging data.

Their data consisted of rows of transactional data that required some mathematical transformations and grouping. Several of these transformed data were then merged with other tables and finally going through a validity filter before and output is generated. This output data was then sent to PowerBI via API calls, where a dashboard with multiple different views was built for the clients for them to view the trends of their customers' and vendors' AR/AP data.

SQL Transformation (Merging multiple tables via JOINS)

API Calls (For uploading of data)