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).

Tables, What-If Analysis and Quick Analysisĭata analysis is the process of Data Requirement Gathering (What type of data do you want to use and how do you plan to analyze it), Data Collection (Collect the data from available sources), Data Cleaning (The data we collected are not always in ideal form so we have to remove white spaces, duplicate records, null values, and basic errors.

Sort, Filter, Conditional, Formatting, and Charts.

Essential keyboard Shortcuts for Excel Data Analysis.

Data analysis is the process of collecting, modeling, and analyzing, and exploring data to find a pattern in it. Introductionĭata analysis has emerged as an important field because it provides the ability to analyze data which helps people in making better decisions. This comprehensive guide will introduce you to the concepts of data analysis and present practical examples using Microsoft Excel. Microsoft Excel is a simple, powerful, and one of the top tools for data analysis. This article was published as a part of the Data Science Blogathon Overviewĭata analysis provides insights from raw data which is used to support decision-making.

Data analysis excel