Example of Microsoft Power BI integration with a PostgreSQL database
This report demonstrates the possibilities of using data stored in a PostgreSQL database for interactive management dashboards and sales analytics. The tool also enables precise verification of historical exchange rates.
The provided solution allows users to check average exchange rates for selected currencies from 2012 to 2016. The default report displays the EUR exchange rate for December 31, 2014.
To view specific data and charts, select:
- year,
- month,
- day,
- the currency of interest.
The chart presents the average rate for a given day, between 9:00 and 17:00.
Available data for the following currencies:
- EUR (euro),
- USD (US dollar),
- CHF (Swiss franc),
- GBP (British pound),
- NOK (Norwegian krone),
- SEK (Swedish krona).