Challenge #449: Global Sales Analysis

[JosephSerpis]

Challenge Completed

Spoiler

[alineruizcampos]

Spoiler

[lisahitch95]

The tricky part here was that the solution is veeery slightly off, probably due to rounding the results earlier in the process than I have done. The solution from Task 1 also does not include the currency conversion, which is odd to me. Task 1 and Task 2 both look for Total Sales but they use different columns to calculate it. 

Spoiler

[mapas96]

I am attaching here my solution.

[SammiJohnson]

My Solution 😁

[mgaronson]

Spoiler

 As noted by others, no currency conversion in Q1 results. Added 2nd method for Q2 to find falling sales in all regions. More fliexible as no hard coding of number of regions. Shout out to @patrick_digan for 2nd method.

[arihant_jain]

Clever use of Summarize and Cross Tab.

[Erin]

I spent way too long trying to figure out why my answers were off compared to the posted output for Task 1. If only I had seen @BS_THE_ANALYST's note on the mistake in the directions earlier. Sheesh. I solved it both ways - following the directions and matching the output. Cheers! 

Entire workflowSales and Sales in Euros

[sknman92]

Spoiler

[AaronSmatta]

After looking at the comments I realized that the output task 1 was not actually factoring in the exchange rate as such the task only needed the sales figure input. But to be a good student, I did what the task was asking for anyway lol.