On this test I practice my English, SQL, Power Query, Data Modelling, DAX and UI skills to building a dashboard.
I had 72 hours to complete all tasks wich included discovering data sources, creating measurements and arranging elements in a minimalist design.
To achieve this result I needed write a query with two subqueries and create four calculated columns, I concatenated excel files and collected the product list and client list using Faker API. Then I created the following measures: orders amount, average amount per order, average orders per client, and average time to deliver (days). Finally, I had to create a bar chart, a pie chart and a table meeting specific requirements.