Challenge #449: Global Sales Analysis

Weekly Challenge LMS Banner.png

Hello, Community Members!

A solution to last week’s challenge can be found here.

Financial analysts often need to consolidate data from various sources. This week's challenge focuses on using Alteryx functions in financial planning and analysis (FP&A) projects.

The first dataset includes sales information for various countries and business segments for the years 2022 and 2023, with the sales figures recorded in each country’s local currency. The second dataset provides the conversion rates from the countries’ currencies to euros.

Your first task is to create a final table that includes the segment, region, and total sales in euros for both 2022 and 2023. (Tip: Remove any columns where the sale price is null.)

For the second part of the challenge, calculate the year-over-year variation per segment (2022–2023 in euros) and identify the segments that experienced negative variations across all three regions: Europe, Asia Pacific (APAC), and the USA.

Need a refresher? Review the following lessons in Academy to gear up:

Happy solving!

The Academy Team

Challenge_449_solution_file.yxmd

Challenge_449_start_file.yxmd

Data Analysis

Data Preparation

Core

Basic

Accepted answers

All comments

binu_acs

Spoiler

Challenge_449_solution_BV.yxmd

BS_THE_ANALYST

@AYXAcademy

I think there's a mistake in part 1. There's been no currency conversion applied to the total sales it seems.

Spoiler

RolandSchubert

Spoiler

Challenge_449_solution_rsc.yxmd

shawn_jacob32

Spoiler

Agreed with another user as the currency conversion was not factored in the output

Challenge_449_start_file_SJ32.yxmd

Tofel

Yep, no currency conversion in example Output 1.

Spoiler

Challenge_449_Dom.yxmd

patrick_digan

Spoiler

Challenge_449_start_file.yxmd

mmontgomery

C449

Spoiler

I spent a ton of time trying to convert sales/gross sales etc to the relevant currency but realized the default sales value was what the answer was looking for.

c449.yxzp

ed_hayter

Spoiler

Challenge_449_start_file.yxzp

Hub119

Solution attached (with the currency conversion accounted for in part 1).

Challenge_449_CH Solved.yxmd

Pilsner

My solution:

Spoiler

449 (Currency Conversion and Sales).yxmd

Carolyn

Solved!

Spoiler

Challenge_449_start_file.yxmd

ggruccio

I solved for the currency conversion, but then realized the answer was in local currency so I solved for that also.

Spoiler

Challenge_449_gg_finish.yxmd

KMan_

Spoiler

Challenge_449_kman_.yxmd

Kenda

Spoiler

Challenge_449_start_file.yxmd

abbyabbypoon

Spoiler

EdenTP

Spoiler

Challenge_449_Finished.yxmd

MelGibson

I ran into the same issue as others. The conversion to EUR does not show in the OP's output. It is part of the request.

Spoiler

MG Challenge_449_Solution.yxmd

balajilolla2

Spoiler

Solution Attached

Screenshot 2024-11-04 115244.jpg

Challenge_449_start_file.yxmd

nSpire

Spoiler

Challenge_449_nSpire.yxzp

Yogesh1795

Yep, No currency Conversion in first output tool

Challenge_449 Solution.yxmd

Yoshiro_Fujimori

My solution.

Spoiler

Workflow

Challenge_449_start_file.yxmd

AkimasaKajitani

My solution!

Spoiler

Challenge_449_start_file_AK.yxzp

olga_strubbe

A fun challenge, thank you, @AYXAcademy!

See my solution attached.

The response to part 1 that was provided with the challenge seems to be missing EURO conversion - like some other folks noted as well.

I've included the conversion in my response.

Spoiler

Challenge 449_Global Sales Analysis.yxmd

Qiu

Same observation with some users that the Currency is not converted to EUR in the answer.

Spoiler

Challenge_449_start_file-qiu.yxzp

Kaustubh17

Ch 449 Gobal Sales.PNG

Challenge 449 Solution Kaustubh.yxmd

RWvanLeeuwen

here's my take

Spoiler

Challenge_449_start_file - RWvL.yxmd

messi007

My solution!

Spoiler

Challenge_449_solution_MB_file.yxmd

BSilverblatt

As mentioned by others, the provided output hasn't been adjusted for currency. Here's my solution:

Challenge_449_BS.yxmd

Bobbyt23

Straightforward challenge but like others the currency conversion didn't match in part 1. Good challenge though.

Weekly Challenge 449 05-11-24.yxzp

wdula

Spoiler

I was so confused until I read the rest of the replies, at least the second part will work regardless of how you add up the first part.

wdula_249_solution.yxmd

i-godz

My submission for the challenge with currency conversion.

Challenge_449.yxmd

auto_mate

Yes and as a beginner I kept assuming I am messing it up, lol

Goddenra

Took me an age to understand why my figures were different to the solution, but then I saw from the solution flow that the totals weren't for the converted EUR figures. Argh!

Anyway, workflow attached. Right end result!

Challenge_449_start_file.yxmd

martinson

Needs work. Is question well posed?

Challenge_449_start_file (1).yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335