eBitTronic a medium$-$sized company, has experienced a surge in demand for its electronic products, including earbuds, smartphones, and printers. However, the company has not been as innovative as it would like to be in addressing this increased demand. Despite its strong market position, eBitTronic recognizes the need to enhance its approach to product innovation and development to meet the evolving needs of its customers and stay ahead of the competition. eBitTronic has been undergoing a period of substantial growth in recent years, which has presented the company with a set of complex challenges related to the integration of its information systems. One of the key factors contributing to this complexity is the significant increase in the number of employees. As the workforce has expanded, eBitTronic has faced difficulties in identifying and retaining skilled personnel, posing a critical concern for the company's sustained success.

Dealing with outdated technology within its production plant, which is incompatible with the modern IT infrastructure it aims to implement, is another issue that the company is facing, leading to inefficiencies and hindering the seamless integration of its information systems across different departments. Furthermore, the company is encountering challenges in effectively tracking interactions with potential clients and understanding customer perceptions about its products. As a result, eBitTronic is in need of a more robust and integrated approach to managing its clients.

Recently, the company has observed market shifts towards more design$-$based electronic devices and seasonal demand, which may require changes in its product line, impacting its suppliers. Operational challenges, including delayed production, transportation issues, and global supply chain disruptions, have further affected the company's efficiency and potentially affected customer satisfaction. To address these issues, eBitTronic is seeking to enhance its operational efficiency, inventory management, and overall production and delivery processes.

FIND THE FOLLOWING INFORMATION

$1.$ Create three charts, a line chart, a bar chart and a pie chart, showing relevant information about the sales representatives of the company.

$2.$ Create three charts, a line chart, a bar chart and a pie chart, showing relevant information about the products sold.

$3.$ Create three charts, a line chart, a bar chart and a pie chart, showing relevant information about the sales channels.

$4.$ Identify the most lucrative country.

$5.$ Identify sales rep with the best performance.

$6.$ Identify the most profitable product.

$7.$ Propose a set of solutions eBitTronic could implement to overcome its challenges.