The growth of supermarkets in most populated cities are increasing and market competitions are also high. The dataset is one of the historical sales of supermarket company which has recorded in 3 different branches for 3 months data. Predictive data analytics methods are easy to apply with this dataset. please fund attachment of data set
SHEET1
Apply the concepts covered during the week( text function( Trim, left, right, clean, find, search ) to a use case with real-world data for a business or organization.
Provide a brief explanation of your data, the business or organization, and the use case.
SHEET 2
Apply the concepts covered during the week( text function( countif, countifs, count.counta and count black ) to a use case with real-world data for a business or organization.
Provide a brief explanation of your data, the business or organization, and the use case.
• Provide an overview of your data, business/organization, and use case.
• Articulate what Excel functions you have used and apply it to the dataset to demonstrate it.
SHEET3
Apply the concepts covered during the week( text function( Sumif, averageif, sumifs and averageifs) to a use case with real-world data for a business or organization.
Provide a brief explanation of your data, the business or organization, and the use case.
• Provide an overview of your data, business/organization, and use case.
• Articulate what Excel functions you have used and apply it to the dataset to demonstrate it.