Sales Currency Conversion Analysis
Originally published: 05/11/2021 13:57
Last version published: 17/11/2021 14:50
Publication number: ELQ-56615-2
View all versions & Certificate
certified

Sales Currency Conversion Analysis

Sales Currency Conversion Analysis in Excel and Power BI

Description
This is Sales Currency Conversion Analysis.
Currency Conversion:
The rule of thumb is to apply the currency exchange conversion upfront. Therefore, it is a good idea to solve all the scenarios requiring a single currency in the report by converting all amounts at the time of data import into the data model. When you need to create a report in multiple currencies, computing data in advance could be challenging and expensive. Therefore, a dynamic solution based on DAX measures and a properly designed data model makes more sense.
In this dashboard, you will see currency convert in the following three currencies.
1.US
2.Pound
3.Euro
In which you see the following things.These are measures /KPI's.
1.Total Supplier
2.Total Buyers
3.Total Cost
4.Total Sales
5.Haulage Cost
6.Profit Margin

Process:
In which the data source is an Excel file. First I have uploaded excel data into the Power BI file.
Then I did transformation in the power query. Then created DAX measures for all above define KPIs. Then created visuals as shown in the attached images.

Deliverable :
I will provide you Excel dataset files and a power bi file in which all KPIs and visualization are present.

Usage:
You can use this report for learning purposes or entering into a competition or commercial use.
if you want to create any other domain reports then you can also let me know.
God Bless you.
Thanks and Regards
Muhammad Umair Shahid

This Best Practice includes
2 Excel file and 1 power bi file .

Muhammad Umair Shahid offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

You can use this report for learning purposes or entering into a competition or commercial use.

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Michael Xu52(last updated: 15/11/2021 02:22)
    sales
    currency

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Muhammad Umair Shahid


See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Sales Currency Conversion Analysis?

The user community and author are here to help. Go ahead!


5.0 / 5 (1 votes)

please wait...