Power BI Challenge 9 - Currency Conversion and More from Alexander

Here’s Alexander’s entry for Power BI Challenge 9. @AFetisov, feel free to add other details of your work.

Here’s how Alexander described it:

Few notes:

  • Connected to exchange rate extraction file with daily rates from the Reserve Bank of Australia Site. Then done some manipulation using the AUD rate to be able to switch between various currencies (in out case EUR, USD, and GBP)

  • With the daily exchange rates the totals will be more accurate than applying the latest rate to historical transaction values.

  • Experimented with report design - neomorphic and minimalistic approach.

Being reporting an analytics manager in a major construction company found that most executives prefer minimum navigation and a few filters. So followed the rule “less is more”. If aiming at more operational lower level dashboards, then would create detailed analytics.

Started doing this yesterday evening and continued today after main work, therefore completed only the high level.

Looking forward to your feedback.

This post is part of the Enterprise DNA platform improvements, through the Data Challenge our members can now share how they built their dashboard and what their inspiration is in building it. We hope all members can utilize it efficiently.