11-16-2020 21:53 PM - last edited 11-16-2020 22:24 PM
This is my submission to EDNA Powerbi Challenge 9.
The main challenge is to create a conversion model with 3 reporting currencies. I used Google sheets to get the daily fx rates with
=GOOGLEFINANCE("Currency:USDGBP", "price", DATE(YYYY,MM,DD), DATE(YYYY,MM,DD).
This dashboard displays key metrics like Sales, Cost and Profit of a fictional recyle company. My main goal is to find loss making attributes in the dataset.
Main requirement is to produce a report from the data to give the user the ability to select a currency and see the associated sales and cost. I also used tooltips to provide additional insight. Hardest part is to calculate the profitability, Sales & Cost as we have multiple currencies involved in the business.
I have also attached the working PBIX file. Please let me know your view, feedbacks and suggestions in the comments below.
If you liked my DASHBOARD please give it a thumbs up and share it. #CURRENCY_CONVERSION_DASHBOARD.