Currency Conversion and More
Challenge your data skills by producing a report that gives the user the ability to select a currency and see the associated sales and cost
The objective is to build a report that allows the user to select a specific currency and visualize its associated sales and costs. The report should also provide information about the conversion rate used, which can be an average value.
Additionally, it's essential to analyze the data and identify any issues that might affect the accuracy of the report. This includes detecting missing data, outliers, or discrepancies that can affect the user's ability to make informed decisions.