We are going to analyze this dataset with Microsoft Excel. The given dataset shows the historical sales of a Supermarket Company which has recorded data for 3 months in 3 different branches of the Supermarket. The growth of supermarkets is increasing and market competition is also high. Ctrl + Shift + ) or Alt + O + C + U : To Unhide columnsĭownload Supermarket sales data set from Kaggle using the below link: Ctrl + Shift + Down/Right : Select till the last non-empty cell in column/rowĨ. Ctrl + Pg Up/Pg Dn : Shift between sheetsĤ. Alt + A + T or Alt + D+ F +F : To add or remove FiltersĢ. Essential keyboard Shortcuts for Excel Data Analysisġ. It can be analyzed with the relevant Excel commands, statistical functions, and tools – Sort, Filter, Ranges, Tables, Conditional Formatting, Date functions, Time functions, Subtotals, Quick Analysis, What-if Analysis, Solvers, Pivot Tables, Charts, and Analysis ToolPak, etc. Then that data can be converted and formatted in several ways according to user need. The data can be collected from various sources. Microsoft Excel provides powerful features and ways to interpret and analyze data. There are many other techniques available like Statistical analysis, Text analysis, Diagnostic analysis, Predictive analysis, Prescriptive Analysis, etc. There are two main methods of Data Analysis: qualitative analysis and quantitative analysis.
it is mandatory to clean data before uses for analysis), Data Analysis (In this step we uses data analysis software’s and other tools to interpret the data and get insights on data), Data Interpretation (We need to interpret them and give the best findings from that) and data visualization (Display your data using graph and charts so that people can read and understand it easily).