Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
eyJrIjoiNWQ2YjY2NzUtZjRmNi00MTdlLTg1MGMtNzFhNzQ3YzY1MTFkIiwidCI6IjQ5MzkwMzQ4LTk2ZGMtNDZhZC05YTYyLWMxMDQzMDIwZmQ2MyJ9&pageName=ReportSectionfabb495778030d2a31e2
This is great @Ali_India ! I didn't know you could get the exchange rates so easily in google sheets, I'll admit my method was much more brute force :).
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/