Data Analysis – An Introduction

Home/Data Analysis/Data Analysis – An Introduction

Data Analysis is important to every organization to survive in this competitive world. In recent years every one wants to make use of the data, understanding their business and to take effective decisions. I spent around 10 years in analyzing the data. And played different roles to help my clients to take effective decisions. In this topic I am going to discuss the basics of data analysis to give an overall idea about Data Analysis.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Business Presentations Templates Pack
PowerPoint Slides

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


Data Analysis

Data Analysis Helps Executives to take effective Business Decisions.START LEARNING…

Data Analysis – Learning Path

Data Analysis – Learning Outcomes

  • You will understand – What is data analysis? And why do we need to analyze the data?
  • Different kinds of requests and the uses of outputs in Data Analysis
  • And Steps and approach to follow to analyse the data

What is Data Analysis

“It is a process of understanding and analyzing the data to draw hidden facts to aid decision making.”

We need to answer many questions to sustain in this competitive world. To do this we use the historical or primary data. And we analyze it to draw the conclusions. We describe the facts and detect patterns to solve the business problems. Data Analysis is not a tool or a software. It is a practice and a way to understand and interpret the data. It helps to derive the value out of your data.

Why do we need Data Analysis?

“The quick answer is derive the insights to drive the business successfully.”

Every day we are (humans) generating billions of records of data. Companies can make use of this data to gain more profits (ROI). We can’t understand any thing from a million record data set. We can only understand after summarizing and studying the patterns in the data. Many organizations use their own data (Sales data in Retail, Transaction data in Banking). And derive the insights to increase their revenue, efficiency, or to do some promotions.

Approach to do Data Analysis

Generally we follow the below approach while analyzing the data:
Data Analysis Steps
Understanding the Problem and Data: It is important to understand the business questions or requirement. And also we need to understand the data. And we find important variable to use in our analysis.

Data Collection: If you have historical data, then we can go for the next step. In other cases we collect the data before proceeding for the next step. For example, If you want to analyse how a particular Super market is performing from the last 2 two years. We can study the historical data. i.e; sales data to draw the conclusions. In the second case, If you want to study how your customers are satisfying with your service. You have to collect the data (By asking the questions face to face, or by launching the surveys) to analyse the data.

Cleansing and Formatting the Data:
Once our data is ready, the next step is cleaning and formatting the data. We can not use the raw data which we have received as a input data. We have to study the data to find if there are any missing or wrong data points. And we also format the data in the required format for Analysis. We follow many approaches to clean the data. For examples, we can generate simple frequency tables and see how the data is. Or we can plot the charts (generally scatter chart) to see if there are any outliers.

Tabulation and Statistical Modelling: Once we are completed with the data cleansing, we go for tabulating the variables. We can study the data to draw the basic observations. And based on the requirement we can apply statistical techniques to understand and interpret the data. We will see these techniques later in-detail.

Interpreting or Recommendations: Based on the outputs generated in the above step, we will analyse the data.And we will write our recommendations (generally it is in Presentation or Dashboard) by following the assumptions. And we send it to the executives to take the decisions to solve the business problem.

Different kinds of Data Analysis – By Request/ Reports

  • Trackers: These are the standard reporting requests to see how the different metrics are performing in a particular time period. Generally trackers are generated Weekly, Monthly, Quarterly and Yearly basis.
  • Ad-hoc Requests:These requests help to quickly understand particular patterns in the data. These are mostly based on a category. These reports will be straight answers for the Ad-hoc requests.
  • Drill-down Analysis: It helps to deeply understanding the data to answer a particular problem. These are summary reports based on the combinations of the variables or they can be a simulation tools.
  • STATISTICAL Modeling: This will helps understanding the customer groups and their behaviors. Generally we use large amount of the data and draw the conclusions by applying the statistical techniques.

Different kinds of Analytics – By Domain

We can classify analytics as follwing types based on the domain it is applied. We will discuss more on this in later topics…

  • Marketing Analytics.
  • Customer Analytics.
  • Risk Analytics.
  • Web Analytics.
  • Human Resource Analytics.
  • Fraud Analytics.
  • HealthCare Analytics.
  • Financial Modelling.

Useful Links

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template
LIMITED TIME OFFER - Get it Now!
Business PowerPoint Presentations Templates Pack
 
 
Related Resource External VBA Reference
By |June 27th, 2013|Data Analysis|5 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

5 Comments

  1. george A January 14, 2015 at 11:45 AM - Reply

    Hey good job PNRao…very concise information. Thanks!

    • PNRao January 15, 2015 at 1:22 PM - Reply

      Thanks you George A.
      Regards-PNRao!

  2. Pratik April 3, 2015 at 3:52 PM - Reply

    Hi,

    Thanks for the article.

  3. Pradeep March 21, 2016 at 4:29 PM - Reply

    Great article Mr. PN Rao..

  4. Rohit August 10, 2016 at 7:53 PM - Reply

    Hi P N Rao,

    How would Data Analyst answer the question “Why?” using data analysis and present it with data/chart.
    e.g why customers are less or why there is slow growth in market or low sales.

Leave A Comment