XYZ Company is a renowned technology firm that excels in the smart home automation solutions sector. With a highly skilled team and an innovative vision, XYZ aims to simplify people's lives through the integration of connected devices and the delivery of personalized and convenient home experiences. 

XYZ Company was founded by a group of technology enthusiasts with a shared vision to make homes smarter and more efficient. Believing in the power of home automation to streamline daily tasks, they combined their skills and knowledge to create a company that offered innovative and customized solutions to enhance people's comfort and security.

Over the years, XYZ has established a solid reputation in the market by providing advanced and intuitive home automation systems. Their customer-centric approach, focus on quality, and commitment to innovation have allowed them to become market leaders and trusted partners in the smart home industry.

To further enhance their offerings and better meet customer needs, XYZ has decided to invest in a customized dashboard that provides valuable insights into sales and business performance. The key business requirements for the dashboard are as follows:

1. Total Sales:

   • View the total sales value of the company, highlighting overall performance and growth over time.

2. Sales by Date:

   • Present a graph or table displaying sales by date, allowing for the identification of sales peaks, seasonality, and trends over time.

3. Quantity of Units Sold:

   • Provide a clear visualization of the quantity of units sold, enabling the evaluation of demand and identification of consumption patterns.

4. Sales by Product:

   • Show sales segmented by product, allowing for the analysis of the performance of each solution offered by XYZ and identification of popular products.

5. Sales by Client:

   • Display sales disaggregated by client, providing insights into key customers, identifying purchasing patterns, and offering customization opportunities.

6. Sales by Salesperson:

   • Track sales attributed to each salesperson, evaluating individual performance and identifying training and motivation opportunities.

7. Percentage Profit by Product:

   • Calculate and present the percentage profit for each product, allowing for a detailed analysis of profitability and aiding in pricing decisions and sales strategies.

With these requirements, XYZ aims to gain a comprehensive view of their sales performance and identify growth opportunities and areas for improvement.

Telmo Santos was hired and came up with below solution: