Examples of what can be achieved
Portfolio
Report using live data from Switzerland Tourism
Switzerland Tourism is an organisation promoting tourism in Switzerland. They show current offers, information about hikes, tourist destinations etc. on their website. The Power BI report below presents an up-to-date view of what are the available offers and also data around tours (hiking, biking etc.) that exist in Switzerland.
Tourists can use it to get faster overview of prices and hotels might use it to see what competitors are doing at the moment. For example, if many other hotels in my village have an ongoing deal, why is that and should we have one too?
The strength of Power BI is that it is very dynamic. So you are encouraged to click around on the bars, on the map and use the filters. If using a mobile device, please rotate to landscape view and note that there are two pages.
Report using live currency & bond data from the Swedish central bank – the Riksbank
Sweden’s central bank – the Riksbank – publishes Swedish krona (SEK) exchange rates, as well as bond rates for common currencies such as US Dollar, Euro, Pound sterling (GBP) etc. The data goes back to 2010 and is updated each bank day. The data is read to Power BI by utilising the Riksbank’s REST API, which was released by the Riksbank during Q4 2023.
The report below can be used to get an overview of the SEK performance towards an array of currencies. The user can get an easy way to overlay the SEK performance vs US Dollar and SEK performance vs Euro as an example. The report also compares the bond spreads, that is the difference in yields that bonds with different duration (2 – 10 years) have. It also relates the bond spreads with the exchange rate development for selected currencies.
For more information on the source data, please visit the Riksbank’s website
Report using live currency & bond data from the Norwegian central bank – Norges Bank
Similarly to the report listed above using data from the Riksbank’s REST API, the Norwegian central bank also publishes their data using a REST API. They publish Norwegian krone (NOK) exchange rates, as well as bond yields for NOK government bonds, with duration from 3 months to 10 years. The data goes back to 2010 and 2019 for exchange rates and bond yields, respectively. The data is updated each bank day.
The report below can be used to get an overview of the NOK performance towards an array of currencies. The report also lists the current bond yields and its development during the last years. The design of the Power BI report is following the one created for the Swedish krona (SEK) report.
For more information on the source data, please visit Norges Bank’s website.
Report using live data from Google Analytics 4
Google Analytics is a common tool for measuring how visitors engage with your website. You can then learn how much traffic the site gets, where the visitors are located, which pages they interact the most with etc. All of this could be very useful to understand how to promote your content and understand your marketing performance. The Power BI report below provides an up-to-date view of a website’s performance. It measures common KPIs such as number of sessions, bounce rate, hits per session etc.
For more information about Google Analytics, please visit Google’s website.
Report using live data from the Swedish central bank – the Riksbank
Sweden’s central bank – the Riksbank – calculates and publishes a reference rate called SWESTR. It can be used as a guideline for pricing financial contracts between financial actors, such as banks. It is a transaction based rate, meaning the Riksbank calculates the rate based on actuals transactions happening in the market. The report below provides an up-to-date view of the reference rate. The volume in the market using the rate can also be seen, as well as year-over-year changes. To see the trend over time, a few averages are presented.
For more information about the reference rate, please visit the Riksbank’s website.
