Blog posts on Data Science, Machine Learning, Data Mining, Artificial Intelligence, Spark Machine Learning

Monday, February 3, 2014

Data Analysis Steps

After going through the overview of tools & technologies needed to become a Data scientist in my previous blog post, in this post, we shall understand how to tackle a data analysis problem.
Any data analysis project starts with identifying a business problem where historical data exists. A business problem can be anything which can include prediction problems, analyzing customer behavior, identifying new patterns from past events, building recommendation engines etc.

The steps for solving a data analysis problem can be shown as below:

Identify Business Problem:
 “Define Problem statement”
This is the first step of analysis. Business identifies a problem and a problem statement with desired outcome is defined. In this stage, a Data Scientist should understand the problem statement, the domain knowledge of the problem. After thorough understanding of the problem statement, a Hypothesis will be proposed.

 Data Acquisition:
“Identify data sources”
As a second step, all the data sources related to the problem statement will be identified and pulled into a central repository. The data sources can vary from SQL databases to text files to csv files to online data. If the data size is large we may use Hadoop to pull, store & pre-process the data.

Process/Clean Data:
 “The accuracy of the results of analysis depends on the quality of data” 
Data Clean step is considered to be one of the very important phases in Data analysis. The accuracy of the analysis depends on the quality of data.
Few approaches:
  • Formatting the data as per the data analytical tools we use.
  • Missing data handling
  • Data Transformations like normalizing the data Identifying outliers & handling etc.
Exploratory Analysis:
 “Embrace the data visually before diving further”
The objective of this step is to understand the main characteristics of the data. This analysis is generally done using visualizing tools. Performing an Exploratory analysis helps us:
  • to understand causes of an observed event
  • to understand the nature of the data we are dealing with
  • assess assumptions on which our analysis will be based
  • to identify the key features in the data needed for the analysis
Graphical Techniques:Scatter plots, box plots, histograms
Quantitative techniques: Mean, median, Mode, Standard deviation
Model Generation & Validation:
This step involves extracting features from the data and feeding them into the machine learning algorithms to build a model. Model is the solution proposed for the problem statement. This step involves: Model selection, model training and model evaluation.
Model selection: Based on the type of business problem we are dealing, a model will be built. For example,if the objective of the analysis is to predict a future event, we need to build a Regression model for prediction.
Model Training: After selecting the Model for the analysis, the entire dataset is divided into 2 parts – Training data & Test Data. 3/4th of the entire data will be fed as input to the Model Algorithms.
Model Evaluation: Once the model is built. The next step is to test the model & validate it. The data used for testing the model is the remaining 1/3rd of the dataset in the previous step.
Visualize Results:
 "Show the results visually" 
This is the final step of Data analysis where the results of the model & problem solved will be presented generally in visual plots/graphs.
Few visualizing tools: d3.js, ggplot2, tableau.

Please go through the tools/technologies , skill set required to learn Data Analysis here


  1. With the base of endeavors however limit of conceptualizing, the reality of the business is changed. It goes with the assessment of the on-going tasks and science course in pune

  2. Nice blog Thank you very much for the information you shared.
    data science

  3. I was blown out after viewing the article which you have shared over here. So I just wanted to express my opinion on Data Analytics, as this is best trending medium to promote or to circulate the updates, happenings, knowledge sharing.. Aspirants & professionals are keeping a close eye on Data Analytics Course in Mumbaito equip it as their primary skill.

  4. Such a very useful Blog. Very interesting to read this article. I have learn some new information.thanks for sharing. know more about

  5. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    Click here

  6. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    ExcelR data analytics

  7. I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.
    data analytics course mumbai
    data science interview questions

  8. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.

    Invisalign specialist

  9. The information provided on the site is informative. Looking forward more such blogs. Thanks for sharing .
    Artificial Inteligence course in Patna
    AI Course in Patna

  10. Join ExcelR and get data science certification to get your dream data science job. data science course syllabus

  11. Very nice blog and articles. I am realy very happy to visit your blog. Now I am found which I actually want. I check your blog everyday and try to learn something from your blog. Thank you and waiting for your new post.

    data science course in India

  12. I like your post. I appreciate your blogs because they are really good. Please go to this website for Data analyst course in Bangalore. These courses are wonderful for professionals.

  13. Your article acts as a valuable resource for both beginners and individuals looking to improve their data analysis skills. The integration of practical considerations, like the tools and technologies used throughout the process, adds a tangible dimension to your guidance. Thank you.
    Data Analytics Courses in Pune

  14. "Great breakdown of the data analysis steps! This clear and concise guide is a valuable resource for anyone starting in the field of data science. Thanks for sharing!"
    Data Analytics Courses In Bangalore

  15. This blog post provides a comprehensive and structured guide to the essential steps of data analysis. It's a valuable resource for aspiring data scientists, offering clear explanations and practical insights. Well-done.
    Data Analytics Courses In Dubai