-By Our Team Members
Flipkart is an e-commerce platform that sells a wide range of mobile phones. In order to identify the highest selling brand, most popular color, highest rated brand, highest profit brand, and most popular storage size, a data analysis was conducted using Flipkart's mobile phone sales data.
The Flipkart mobile sales data is a dataset that contains information about the sale of mobile phones on the Flipkart platform. The dataset has 3115 rows and 9 columns. Each row represents a mobile phone sale, and the columns provide information about the brand, model, color, memory, storage, rating, original price, selling price, and year of the mobile phone.
This dataset can be useful for various purposes, such as analyzing the trends in the sale of mobile phones on Flipkart, identifying popular mobile phone brands and models, and predicting the future demand for mobile phones based on the features and pricing.
(It's a filpkart's mobile data which we have take from the website 'Kaggle'. )
Firstly, we analyze the data and filter it. This involves sorting the data and analyzing any blank cells, which we fill in as needed.
Secondly, after clearing and sorting the data, we create a calculation sheet and formulate 5 questions based on our analysis of the data.
Thirdly, we move on to the dashboard part, where we attach a combo button to regulate the Excel sheet. Using the combo button, we also attach a graph of all the questions we formulated.
To find unique brand, color, storage, etc, we use the advanced filter option. To find the total amount of sales of a particular brand, we use the SUMIFS formula.
To create the graphs, we select the question data, go to the insert menu, and select the appropriate graph based on the data analysis. For example, we use the INDEX formula to select a specific year.
To answer questions such as "Which brand has the highest selling?", we use the SUMIFS formula. For questions like "Which color sells the most?", we use the COUNTIFS formula. To find the total ratings or profit of a particular brand, we use the SUMIFS formula as well.
For questions like "Which storage sells the most?", we use the COUNTIFS formula. Other formulas we use include MAX and MATCH.
Based on these findings, it can be recommended that Flipkart should focus on promoting Apple mobile phones, especially those that are Crystal blue and have 64GB of storage, as these are the most popular options among customers. In addition, Flipkart should consider partnering with Samsung to increase its profit margins, and promoting Samsung phones for their high ratings. By leveraging these insights, Flipkart can improve its mobile phone sales and better meet the needs of its customers.