Data Analysis and Analytics: Getting Started

The world is moving quickly, and we are collectively generating data every moment. These vast amounts of data hold keys to unlocking answers to many mission-critical questions that organizations and leaders face. Understanding data analytics for beginners, including how to analyze data and extract actionable insights is an essential skill for employees at every level within an organization. Let’s take a closer look at what this means for you.

How to Read and Understand Data

At the most basic level, data includes facts or statistics that count or describe something. Through analysis and contextual interpretation data provides meaningful information and insights that can support action planning, process improvement or decision-making.

When we want to learn how to read data, we often refer to the sources and systems where data resides. For example, understanding how to interpret data will help you gain insights into employee retention and morale. We would start by looking at data from a Human Resources staffing system, survey data, exit interviews, or Workplace Climate Surveys.

People define data by commonly categorizing them based on form, source, and how they are presented. Here are some common categories for recognizing and organizing data.

Data can be Structured, Unstructured, or Semi-structured. Structured data is organized in a predefined manner, often in tables with rows and columns. Examples of structured data include databases and spreadsheets.
Unstructured data lacks a predefined format or organization. Examples include text documents, emails, social media posts, images, or videos.
Semi-structured data do not conform to a rigid structure but have some organizational properties, such as XML files or HTML documents.
Data can be Quantitative (Numerical) or Quantitative (Categorical). Quantitative data include discrete data, representing countable items or events; or continuous data representing measurable quantities and can take any value within a range (e.g., height, temperature, time to completion).
Qualitative (Categorical) data include nominal data, which represent categories without a natural order or ranking (types in a category – like religions, gender, colors); ordered/ranking data (customer satisfaction ratings, educational levels); or levels (low, medium, high).
Data can be Primary or Secondary. Primary data are collected firsthand for a specific purpose (surveys, company data collection system).
Secondary data are collected by another organization for a different purpose and are often used for analysis in a new context. Examples include government reports, research papers, financial statements, and historical data.
Data can be a Snapshot or a Time Series. Data snapshots are collected at a single point in time or over a short period (like a single survey or sales data for a holiday season).
Time series data are collected over time to observe trends, patterns, and changes (like changes in price, temperature, or employee satisfaction over time).

When considering the type of data analysis you want to conduct, it’s useful to think about the potential sources of data. Common data sources in organizations:

Customer Relationship Management (CRM) systems
Financial Systems and Data
Enterprise Resource Planning (ERP) or Transaction Systems (Sales)
Inventory Systems
Sensor (Equipment) Data
Human Resources and Staffing Systems
Records and File Management Systems
Publicly Available Datasets
Customer and Employee Feedback and Interview Data
Website and App Data
Social Media Data
Online Reviews

Understanding these different types of data helps in choosing the appropriate methods for collection, analysis, and interpretation. This is essential to using analytics to deliver quality and relevant insights derived from the data.

Data Analysis and Data Analytics: What’s the Difference?

Now that you have your data, let’s turn to analysis and analytics. The terms "data analysis" and "data analytics" are often used interchangeably, but they have distinct meanings depending on the context. Here’s a breakdown of the core differences between data analysis and data analytics 101.

Data Analysis refers to the process of examining, cleaning, transforming, and modeling data. The basic goal of data analysis is to discover useful information that informs conclusions and supports decision-making.

Exploratory: Involves exploring data to identify patterns, anomalies, and initial insights.
Descriptive: Focuses on summarizing historical data to understand what happened.
Techniques: Includes descriptive statistics, data visualization, and basic statistical analysis.
Tools: Commonly uses tools like Excel, SQL, and basic visualization software.
Outcome: Produces reports, dashboards, and summaries that describe the data.

Data Analytics is a broader field that includes different techniques and processes for generating insights from data. It often includes not only data analysis, but also predictive modeling, machine learning, advanced statistical methods, and artificial intelligence, therefore it is a core aspect of any intro to data science. Analytics go beyond basic analysis to include predictive and prescriptive analytics. Current leading tools and programming languages for interpreting data include Python, R, SAS, and more specialized analytics platforms. The goal is to predict future trends, provide recommendations, and automate decision-making processes. Analytics involves multiple stages to generate actionable insights - including data collection, processing, analysis, and interpretation.

In summary, data analysis is a key component and even a starting point for the basics of data analytics. Data analysis is primarily concerned with understanding the past by examining data, while data analytics applies that understanding to predict and influence future outcomes. Learning data analysis and analytics is crucial for having a deeper understanding of all forms of data.

For Beginners: 5 Steps to Learning Data Analysis

Technologies and methods are evolving quickly. For beginners training in data analysis, it can be hard to know where to begin. Being able to work effectively with data is an important skill in the workplace, so get started whenever you are ready by using data analytics! Here are some steps to get started:

Start with a Goal. What business problem or question do you want to address that would be informed by data? Think about a process that you want to describe or improve, an outcome you want to measure, or something you want to know about your customers. Write down specific goals. Here’s an example: If you are a complaint case manager, your goal might be to understand how many cases are handled by your group at key times of the year.
Find/Collect the Data. Identify data that answers your question and where that data resides (what system it is in). This may include an existing system or database, log books, surveys, reports, or websites. As a complaint case manager, you might need case names or logs and counts, staff case assignments, and case start and end dates.
Organize or “Clean” the Data. Preparing data for analysis is often the most time-consuming step, especially when you are gathering data for analysis for the first time. The initial product can be the starting point for defining a new database or system, particularly if you want to repeat the analysis or gather data in a new way. You may need to fill in missing data, change the formatting for consistency, or combine different data sources into one place. Much of this work will be driven by what systems or data records already exist.
Explore and Analyze the Data. Exploratory data analysis (EDA) simply means playing with the data to understand its main characteristics. You might determine counts, and develop descriptive statistics (such as the average, minimum and maximum, standard deviation) and how these descriptive statistics change in different time periods. This summarizes the data and allows you to start comparing different aspects, like values for certain people or at different times. Here’s an example: Create a histogram to see the distribution of cases over time and a bar chart to compare total case counts or average completion time across different case workers. Once you have mastered this basic analysis, advance to more complex techniques, like correlations or regression analyses.
Interpret and Communicate Your Results. Show what you know! Summarize the main findings of your analysis in text or bullet points. Use visual aids like charts, graphs, and tables to make the data easily understandable. Explain what the findings mean in the context of your original goal, and what they suggest in terms of future possible actions or decision-making.

Here are some basic technology tools for beginners learning data analysis:

Microsoft Excel: Good for basic data manipulation and visualization.
Google Sheets: Similar to Excel, with cloud collaboration features.
SQL: For querying databases to retrieve and manipulate data.
Tableau or Power BI: More powerful tools for creating interactive data visualizations (your organization may have a subscription to a tool).

For greatest success, start small when learning data analysis to gain confidence and skills – pick a simple question that you have data readily available, and Go! After that, seek new questions and new data - consistent practice helps reinforce your learning. You may also want to practice your networking, by engaging with online forums, training, or professional networks.

Workplace Training on Data and Analytics

This introduction to data analytics might end here, but Pryor Learning offers several courses and resources related to data that are suitable for employees of all positions.

Microsoft Excel® Training – Check out more than 30 Pryor training offerings focused on Excel! These range from basic overviews to advanced analysis tools as you deepen your skills.
Our Data-Driven Decision Making and Analysis Course is a half-day seminar to learn how to effectively connect data and decision-making.

Our Using Business Analytics to Become a Goal-Oriented Manager is a half-day seminar that helps you grow your data literacy and transform facts and figures into actionable metrics.