Example of Microsoft Power BI integration with PostgreSQL database
The report below presents the possibilities of using data stored in a PostgreSQL database within interactive managerial dashboards and sales analyses. Additionally, the tool enables precise verification of historical exchange rates.
Within the provided solution, you can check the average exchange rates of selected currencies in the period from 2012 to 2016. The initial report displays the EUR rate as of December 31, 2014.
To view specific data and charts, select:
- year,
- month,
- day,
- the currency of interest.
The chart shows the averaged exchange rate value for the given day, between 9:00 and 17:00.
Data is available for the following currencies:
- EUR (euro),
- USD (US dollar),
- CHF (Swiss franc),
- GBP (British pound),
- NOK (Norwegian krone),
- SEK (Swedish krona).
Below is the embedded Power BI report presenting exchange rates from 2012–2016.
Need someone who instantly understands the problem — and knows what to do with it?
Most companies have data. What’s missing is the idea of what to do with it — and someone who will actually execute it. Origami Effect delivers both.
