This challenge consists in develop skills in Business Intelligence and put in practice all obtained knowledge in Power BI. The challenge will take 4 weeks divided in 3 different projects with different levels of complexity:
Week 01: Logistics Challenge Dashboard (AluraLog)
Week 02: Coming Soon…
Week 03 and 04: Coming Soon…
The Alura Log manager is facing some work changes due to the high demand of logistics services during the pandemic time. She wants to keep the quality of her service and she needs constantly follow up the KPI’s to take correct decisions. To help her in this analysis a logistics dashboard was created with the following information provided by the customer dataset.
An extra dashboard was created showing a Pareto table used to show accumulative gains by a rank of the most sold product to the less one. In the same page a bar chart showing the category with more sold items based on quantity.
A Card also shows the total sales and total of itens sold with a filter by year and month that the user can select when necessary.
All the ETL process was done in Power Query using the main functions such as : replace values, divide columns by delimiter, change columns type, rename columns, remove empty cells with no relevant information, cleaning spaces, deleting no relevant information. In this process 4 CSV tables was refined as shows bellow:
Some relashionships was done between tables, such as the image bellow:
