The iterative Data Analysis Process is comprised of the following phases:

• Specification of Data Requirements

• Data Gathering

• Data Processing

• Data Cleaning

• Data Analysis

• Data Communication

data analysis excel process

 

Comments

Post a Comment

Popular posts from this blog

Image
  8.  Counta() COUNTA determines whether a cell is empty or not. You’ll come across incomplete data sets daily as a data analyst. Without needing to restructure the data, COUNTA will allow you to examine any gaps in the dataset. SYNTAX = COUNTA (value1, [value2], …) 9. Vlookup() The acronym VLOOKUP stands for ‘Vertical Lookup.’ It’s a function that tells Excel to look for a specific value in a column (the so-called ‘table array’) to return a value from another column in the same row. SYNTAX = VLOOKUP (lookup_value, table_array, column_index_num, [range_lookup]) 10.  Hlookup() “Horizontal” is represented by the letter H in HLOOKUP. It looks for a value in the top row of a table or an array of values, then returns a value from a row you specify in the table or array in the same column. When your comparison values are in a row across the top of a data table and you wish to look down a specific number of rows, use HLOOKUP. When your comparison values are in a column to the le...
Read more
Image
  Data analysis is a valuable skill that can help you make better judgments. Microsoft Excel is one of the most used data analysis programs, with the built-in pivot tables being the most popular analytic tool. Microsoft Excel allows you to examine and interpret data in a variety of ways. The information could come from several different places. A variety of formats and conversions are available for the data. Conditional Formatting, Ranges, Tables, Text functions, Date functions, Time functions, financial functions, Subtotals, Quick Analysis, Formula Auditing, Inquire Tool, What-if Analysis, Solvers, Data Model, PowerPivot, PowerView, PowerMap, and other Excel commands, functions, and tools can all be used to analyse it.
Read more