Mobile Phone Sales Analysis

As a BI Analyst my task is to build a dashboard with not more than two page answering some of the following questions:

1. From 2018-2021, which country and distributor had the best sales performance?
2. What was the seasonal sales trend in each country and distributor?
3. What was the seasonal inventory cost trend in each country and distributor?
4. What was the seasonal net profit trend in each country and distributor?
5. Each year, which brand is the best seller in each country and distributor?
6. Who is each country's most successful sales rep and distributor?
7. Which country had the lowest/highest inventory cost from 2018-2021?
8. Which country had the lowest/highest net profit from 2018-2021?
9. Can we predict the 2023 sales trend based on historical data? 10.Can we make any recommendations to optimize net sales based on some best sales performance countries?