Business Insights from Electronic Dept.Walmart USA,2024

 Business insights from

electronic dept.walmart
usa,2024

 

introduction:

We have provided Walmart USA dataset having 28 rows & 7 columns containing customer id, product name, category, salesperson, quantity, sales amount ($), date sold.
           Customer id contains customer unique id, product name contains name of various product , electronics items in category, name of salesperson in salesperson, quantity contains number of electronic items sold by each salesperson, sales amount contains sales amount of all electronic items sold by each salesperson, and date and time in date sold column.

objective:

We need to see the business report card of 2024 year of Electronic Dept. in Walmart.

            I.          Total sales for each product in year 2024.

          II.          Average of total sales for each product in year 2024.

         III.          Each salesperson total sales for each product in year 2024.

        IV.          Salesperson had the highest total sales in the year 2024.

          V.          Top 10% products by sales amount.

        VI.          Line chart to show the trend of total sales overtime in year 2024.  

      VII.          Total sales of headphones by each salesperson.       

business insights:

       I.          Data analysis shows me that total sales of laptop sold by salesperson name: Jamie Fox has highest total sales in year 2024.

     II.          Average total sales of every product in year 2024 is 1755.56.

   III.          Total sales of each product sold by salesperson: Jamie Fox has the highest total sales and salesperson: Riley Smith has the lowest total sales in year 2024.

  IV.          Salesperson: Jamie fox has the highest total sales in the year 2024.

    V.          Laptop and tablet are the top 10% products by sales amount.

  VI.          In the year 2024 between January to February there was highest total sales.

VII.          Salesperson: Jamie fox has the highest total sales of headphones in year 2024.

technical stacks:

v Microsoft Excel:

·       Multiplication used for total sales.

·       Average Function is used for finding Average of total sales.

·       Maximum and Minimum Functions are used.

·       Filter Function used to find out total sales of each salesperson.

·       Pivot table.

·       Charts- line charts used for product and total sales.

feedback:

             In Walmart USA most sold electronic product in year 2024 is laptop. And tablets are sold in less quantity.
            Salesperson: Jamie fox has the highest total sales for each product.

summary:

            Data of Electronic Dept. Walmart USA of year 2024: It contains all information about the customers and the electronic products. The highest total sales are 8000 of laptop and average of total sales of every product by each salesperson is 1755.56. In between January to February there was highest total sales. Microsoft excel functions, pivot table, and charts are used as technical stacks.