🚀 Backend challenge

Welcome! This is the Google Sheets Backend Challenge!

Our main goal is to evaluate your coding and presentation skills. When you feel ready to submit your answers, use the link we sent to your e-mail to post your Github Repo! We will send you further instructions and your feedback then.

Any doubts, don't hesitate to contact us on contato.steamgroups@gmail.com Happy Hacking💙!

⚠️ Remember, your repository must be public, otherwise we won't be able to evaluate your answer

---

Table of Contents

• 🧠 Context
  • ⚔️ The Challenge
  • 🏁 Requirements
  • 🤟 You Must
  • 🚰 Ideal Flux
• ✔️ Evaluation Criteria
• 📓 To-do list
• You can

🧠 Context

Customer Personality Analysis is a detailed analysis of a company’s ideal customers. It helps a business to better understand its customers and makes it easier for them to modify products according to the specific needs, behaviors and concerns of different types of customers.

Customer personality analysis helps a business to modify its product based on its target customers from different types of customer segments. For example, instead of spending money to market a new product to every customer in the company’s database, a company can analyze which customer segment is most likely to buy the product and then market the product only on that particular segment.

This challenge aims to test your skills in analyzing and understanding spreadsheets and handling them from the Googlesheet API; as well as data interpretation and the ability to visually display for a layman end user.

---

⚔️ The Challenge

The challenge is very simple, you must access the API and get some information (mentioned below) and then display it visually in the way you see fit. It can be creating a presentation, graphs, charts or whatever else you can imagine. Do it as creatively as you can.

To get the CSV File, access here

🏁 Requirements

• API Knowlegment
• Java Knowlegment

🤟 You Must

• Code in Java;
• Find consumers born between 1957 and 1967 who have a master's degree and who are married;
• What percentage of consumers found in relation to the total;
• How many have children at home;
• How many have teenagers at home;

🚰 Ideal Flux

• Find consumers born between 1957 and 1967 through the Googlesheet API;
• Create a filter to get only consumers who have a Master's degree;
• Create a filter to get only those consumers who are married;
  • Visually represent the data obtained;
• Calculate the percentage of consumers;
  • Visually represent the data obtained;
• Find the number of consumers who have children;
• Find the number of consumers who have teenagers;
  • Visually represent the data obtained;

---

Essential Operations

• Carefully read the Googlesheet API documentation;
• Save what you find necessary in variables;
• ⚠️ Display the code output data;

✔️ Evaluation Criteria

In addition to the requirements raised above, we will look at the following criteria when correcting the challenge:

• If the challenge was fully accomplished;
• Whether the steps were successfully completed;
• If the code is clean and well documented;
• If the code is optimized;
• The form of presentation;
• Concern for the end user;

📓 To-do list

• Fully take the challenge
  • Find consumers born between 1957 and 1967;
  • Find the number of consumers who have children;
  • Find the number of consumers who have teenagers;
• Include the details of your solution in the README;
  • What was accomplished in the challenge;
  • Instructions on how to check what was fulfilled;
  • Print the images that prove your solutions;
  • README must be in English;

You can:

ℹ️ Feel free to include all the observations you may find necessary

---

Made with 💜 by SteamGroups