About the FP20 Challenge category

FP20 Challenge
1

!IMPORTANT! - !IMPORTANTE!

Hey Data Family!

:fireworks:We wish you a prosperous 2023 and a Happy New Year​:fireworks:
It has been such an enjoyable journey engaging in data challenges with everyone as we have learnt, developed, and fallen in love with it.

With this sentiment, Federico Pastor is pleased to introduce FP20 Analytics Data Challenges. We Love our Data Community. All participants in the challenges become part of the community, any question will be replied by one of our resolute Ambassadors Team. Our Ambassador Team will work hard to spread their knowledge and experience for the betterment of the community, participants, and challenges.

We have managed to get the largest and most generous group of sponsors backing this project. They deserve our upmost respect.

Thus, a new year brimming with joy, and passion for Data awaits us all as we begin a new era together!!

Our first challenge launches on 9th January 2023, in the interim make sure to join our new challenges group at

What are you waiting for? Quick join the group

2

On behalf of the FP20 Team and the “King of challenges” AKA Federico Pastor:

Update: 09/01/2023

WELCOME TO FP20 ANALYTICS CHALLENGES GROUP

Hi Data Family,
Finally, we all sorted out and in place FP20 Analytics Challenge 1 “San Martins Stores January Sales 2021” is here.

Timeline
The challenge will run from 09/01/2023 to 29/01/2023, closing time is 11:59pm UK time on 29/01/2023.

Tools
Reports can be presented in Excel and or Power BI only.

Access to the Group
Link to our challenges group can be found here.

THE BRIEF

IMPORTANT
Requirement - Report Developer Role
San Martins’ CEO Mr. Kevin Pastor-Franco is expecting a report with no more than 2 pages with a simple navigation menu.

  1. Page1 should be an Executive overview of the January 2021 Sales with weekly KPI on Sales, Cost and Profit accompanied with other relevant visuals.

  2. Page 2 should be dedicated to a Geographical view of San Martins Store operations; a Json Map of Spain is included in the datasets. You, as a report developer, must highly his 2 best performing Sales Agents and information about what product these Sales Agents sell more and where (Location). San Martins CEO would also like to know his worth performing Sale Agent.

*Reports is limited to 2 pages and no other restrictions, or techniques are imposed. Feel free to use all the techniques at your disposal – tooltips, drill throughs, page navigations, etc.

The Resources
There are 2 Datasets, one in the English Language and one in the Spanish Language. Both datasets contain the same information.

  1. A Power BI File – modeled.
  2. An Excel spreadsheet
  3. A Json Map of Spain including the Canary Islands.
  4. PDF with the Intro and Brief.

:bar_chart:Dataset:bar_chart:
English Dataset

Spanish Dataset

Submission of entries

IMPORTANT
Please enter the 2 pages of your report as screenshots in a LinkedIn post with the following wording.

“I am participating in FP20 Analytics Challenge 1” please see screenshots of my report pages.

Enter a small summary of your report.
Use the hashtag #FP20Analytics and #FP20SanMartinsStoresReporting and tag @Federico Pastor.

Do the same in the Community Group on LinkedIn.

*If you want to post your report in novyPro – only PBI Files - , please see the link to the video of how to do it.

novyPro:

Instruction Video:

PRIZES TO BE ANNOUNCED VERY SOON – YOU WILL BE SURPRISED!!