Welcome to FP20 Analytics Data Challenges

The gateway to unlocking your full potential! - Embrace the power of collaboration! Showcase your talent, skills, and achievements!

woman standing on food counter
woman standing on food counter

FP20 Analytics > Challenge 16 >World Roasters Review > About

Did you start with a cup of coffee this morning? Let us dive into a World Roaster Review dataset to have an analysis. Now's your chance to show insights into the global roaster market. With personalized feedback and informative workshops, you can take your report-building skills to the next level, build your professional portfolio, and network with like-minded people.

Throughout this challenge, we'll delve into identifying some business questions within a World Roaster Review dataset.

The FP20 Analytics Challenge 16 is brought to you in collaboration with ZoomCharts. Thanks to this partnership, we are integrating ZoomCharts' exceptional Power BI solutions into this competition. You will gain skills to create Pro reports that help business users explore data faster and more intuitively.

To participate in the challenge with ZoomCharts, register here and create a Power BI report including at least 2 ZoomCharts Drill Down Visuals on one report page.

About

WORLD ROASTER REVIEW ANALYSIS

Why participate in the ZoomCharts Challenge?

1. Personalized Feedback ️
The ZoomCharts team provides personalized feedback to EVERY report entry that meets the requirements. This gives all participants the chance to hone their skills and adjust their report before deadline, giving you an extra competitive edge in the challenge.

2. Receive a Free License
Upon signing up for the challenge, you will receive a FREE Drill Down Visuals Developers License that lets you access the full Drill Down Visuals PRO library. This license remains active for a year after the last challenge you take part in. Meaning, you can access the latest advanced data visualization tools to enhance your projects for a full year.

3. Learning Resources
Participants receive all the latest information on upcoming workshops and events, demonstrating how our team of proven professionals approaches visualizing the given dataset for the challenge.
You also have the chance to book 1:1 calls with a Power BI mentor who will analyse and give specific suggestions to improve your report.

4. The Main Prize
Last but not least, entering the challenge with ZoomCharts puts you in the running for an additional $300 Amazon gift card!

FP20 Analytics > Challenge 16 >World Roasters Review > Introduction

Introduction

Timeline

Start: Tuesday the 14th of May 2024, at 3:00 pm UK time

Submission Deadline: Thursday the 13th of June, at 11:59 pm UK time

Winners’ announcement: Thursday the 20th of June

Tools

All tools are permitted.

ZoomCharts entries:
Create a Power BI report including at least 2 ZoomCharts Drill Down Visuals in one report page!

Access to the LinkedIn Group and Forum

https://www.linkedin.com/groups/12751070/

NovyPro:
https://www.novypro.com/

Instructions Video:
https://www.youtube.com/watch?v=jkcAYgFGWUY

Below is your show time. Read me carefully!

FP20 Analytics > Challenge 16 >World Roasters Review > The Brief

The Brief


1. What is the most expensive coffee per 100g, and what features distinguish it?

2. Which country of origin has the highest average rating for coffee?

3. Which coffee brand has the best/worst average rating every year?

4. Which roaster has received the best reviews in terms of average rating?

5. How many coffees have a rating above 90?

6. Which coffee has a “light” roast?

7. Which country contributes the most to the dataset in terms of coffee production?

8. Is there any relationship between the price of coffee and its rating, considering different origins and roast?

9. In North America (Roaster location), show a word cloud visual of their coffee’s Aroma.

10. Top 5 high average rating coffee brands in Asia, do they have a common Mouthfeel? Provide any recommendations for future Asian markets.

Questions

FP20 Analytics > Challenge 16 >World Roasters Review > Special Requirements & Judging Criteria > Submission of entries

Special Requirements & Judging Criteria
Zoomcharts Participants

All tools are permitted for the challenge.

For ZoomCharts Challenge: create a Power BI report including at least 2 ZoomCharts Drill Down Visuals in one report page.

Reports are restricted to a maximum of two pages.

Canvas size is 16:9 (Default Power BI size) or Full HD size = w:1920 - h:1080.

Technical Requirements
ZoomCharts Participants Judging Criteria

Business users use reports to make data-driven decisions. That’s why reports are called effective if they enable users to drill down and filter data quickly and intuitively to find answers to any question they might have and analyse data in all possible directions and dimensions. We will evaluate:

1) How easy is it to understand the data? (max 10 points)

  • Is too much text used for explanation?

  • Are the indicative colors in charts instinctually understandable?

  • Does it tell a story?

2) How easy-to-use is the report? (max 14 points)

  • Cross-chart filtering implementation across the report. Can other visuals provide relevant data as the user explores the rep

  • Response time

  • Drill Down: multi-layer data exploration. Can the user drill down and gain additional insights within the report?

  • Use of tutorial overlays and other elements to assist new users. Can a new user start using this report straight away with just the guidance provided within the report itself?

3) How good is the report design and is it suitable for its purpose? (max 10 points)

  • Visual design: is the overall look consistent, no empty spaces, no overcrowding?

  • Interface design: are there unnecessary visualisations/buttons/complexity in use?

  • UX design: is the produced report usable?

  • Report design: is the main challenge answered?

  • Technical: are all the fonts used the same, are the sizes readable?

You are encouraged to use various techniques at your disposal, such as tooltips, drill-throughs, drill-downs, cross-chart filtering and page navigation features, to enhance your analysis.

The Resources.

There is 1 Excel dataset.

1. An Excel spreadsheet with 1 tab.

2. PDF with the Intro and Brief in English.

3. PDF with the Intro and Brief in Spanish.

Zoomcharts Resources.

Resources that will inspire you to master Power BI reports that end-users will love:

Submissions of Entries.

*IMPORTANT*

To submit your two-page report, please follow these steps, if you want to be considered for the Zoomcharts' prize, otherwise post your entry in the challenges group.

1. Submit your entry .pbix file here. Your report will undergo validation to ensure it meets all the technical requirements. If the report is validated, you will receive a 'Publish to Web' link. If it does not meet the requirements, you will receive a rejection reason and will have the opportunity to resubmit your report.

2. Post your submission on LinkedIn:

1. Upload the report as a PDF document on your LinkedIn feed.

2. Use the caption "I am participating in FP20 Analytics Challenge 16”, along with screenshots from your report.

3. Include a summary of your report's key insights and publish it to the web or NovyPro link.

4. Use the hashtags #FP20Analytics, #FP20World RoastersReview, #builtwithzoomcharts, tag @Federico Pastor and @Zoomcharts.

5. Additionally, post your report in the FP20 Analytics LinkedIn Community Group.

Dataset.

Click on the link below to get your dataset: The files contain all the necessary data and information to create your report.


Dataset English

Dataset Spanish

*If you have any questions, please post them in the challenges group; a team member will get back to you ASAP. Please do not send challenge questions via private messages to the members of the team, these will not be answered.