The Arena

You have reached the final stage of the Analyst Challenge. Over the past few days, you have learned how to understand a business problem, connect and clean data, build a relational data model, create a Date table, and develop measures using DAX. Your final challenge brings everything together. The Olist dataset was intentionally anonymised, which means the customer and seller datasets do not contain actual names. Your first task is to enrich the dataset by generating realistic dummy names and full state names, then integrate them into Power BI using Power Query. You will also create additional business measures focused on delivery performance before continuing the development of your management dashboard. This is your opportunity to demonstrate ownership of the entire analytical process. We are excited to see the different dashboards and insights you create. HINT: Work on one Power BI file throughout this activity and submit it once when you are finished.

During Day 2 of the Analyst Challenge, you moved from prepared data to an analytical model. You explored relationships and cardinality, created a dedicated date table using DAX, and created your first measures. Now it is your turn to rebuild and extend that work independently. You will work from your Day 1 Olist Power BI file and progressively strengthen it. You will experiment with different approaches to creating a date table, complete the date attributes needed for analysis, establish the appropriate relationship between your Date table and the model, create and explain business measures, and use the model to answer a simple business question. There is no expectation that you will get everything right on your first attempt. Investigate, test, correct and document what you discover. Work on one Power BI file throughout the activity. You will submit the completed file once, at the end.

You are working as a junior data analyst supporting management at Olist, a Brazilian marketplace that connects sellers with customers and provides logistics support. Management wants better visibility into marketplace performance and has asked the analytics team to investigate five questions: - How is the marketplace performing? - What is driving sales performance? - How well is Olist delivering orders? - What is happening to customer satisfaction? - Where should management focus its attention? During Day 1, you connected to the nine Olist datasets, explored their contents, transformed and cleaned the data in Power Query, and loaded the prepared data into Power BI. Your work does not end with loading the data. In this activity, you will take ownership of the analysis by revisiting the business problem, investigating the structure of the data, attempting to build the data model, creating your first analytical measures, and exploring the data for meaningful patterns. You are not expected to get everything right. You are expected to make a genuine attempt, explain your reasoning, investigate problems, and document what you discover. Your goal is to move from simply having data to being able to use that data to answer a business question.

The African Union has launched an initiative to strengthen workforce development across the continent and better prepare young people for the future of work. Your multidisciplinary team has been selected to propose a digital platform that helps governments, universities, employers, and learners identify emerging skills, understand labour market trends, and connect education with meaningful employment opportunities. Working collaboratively, you'll conduct research, analyse evidence, engage stakeholders, and design a solution that is practical, inclusive, and scalable across Africa's diverse contexts. Your final submission should include a platform concept, user journeys, implementation roadmap, and an executive presentation demonstrating strategic thinking, collaboration, and evidence-based decision-making.

Imagine you're part of an AIESEC project team. Your team has been asked to propose a youth-led community project that addresses one of the UN Sustainable Development Goals in your local community. Your objective is to produce a proposal convincing enough to receive funding.

This is a test challenge hosted by the Innoson you don't know