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
Image
  What is Data Science? Data science is the science of analyzing raw data using statistics and machine learning techniques with the purpose of drawing conclusions about that information. Why Data Science?   Data Science has become a revolutionary technology that everyone seems to talk about. Hailed as the ‘sexiest job of the 21st century’, Data Science is a buzzword with very few people knowing about the technology in its true sense. While many people wish to become Data Scientists, it is essential to weigh the pros and cons of data science and give out a real picture. In this article, we will discuss these points in detail and provide you with the necessary insights about Data Science. How to Learn Data Science? Usually, data scientists come from various educational and work experience backgrounds, most should be proficient in, or in an ideal case be masters in four key areas. Domain Knowledge Math Skills Computer Science Communication Skill 1. Domain Knowledge: Most people t...
Read more