DATA ANALYTICS

NOTES

Data analytics in everyday life

The content focuses on the importance of data analytics and the

role of data analysts in organizations.
Understanding Data Analytics
 Data analytics involves the collection, transformation, and
organization of data to draw conclusions and make
predictions.
 Analysts help businesses make informed decisions by
turning data into actionable insights.
Real-Life Applications of Data Analysis
 Individuals often analyze data in their daily lives, such as
recognizing patterns in sleep cycles or productivity.
 Businesses utilize data to improve processes, identify trends,
and enhance customer experiences.
The Demand for Data Analysts
 Organizations increasingly rely on data analysts to manage
and interpret vast amounts of data.
 Data-driven decision-making can lead to innovative products
and services, making analysts essential for business success.

Understanding Data Types

 Numerical Data: Data that consists of numbers that can be

measured, counted, or used in mathematical calculations.
o Examples: Quantity, price, height, age.
 Text Data (or String Data): Data that consists of letters,
words, sentences, or a mix of letters and numbers used as
an identifier, not for calculation.
o Examples: Product name, customer address, notes, ID
numbers (like a phone number or social security
number, which you don't perform math on).
  Date Data: Data that represents a specific point in time,
such as a date or a timestamp. This data type is crucial for
tracking trends and events over time.
o Examples: Order date, shipping date, birth date.
 Categorical Data: Data that can be divided into groups or
categories. This data often represents labels, names, or
discrete categories.
o Examples: Product colour (red, blue, green), customer
loyalty status (Gold, Silver, Bronze), or a rating that
uses words (Excellent, Good, Poor).

New data perspectives

The topic focuses on the application of data analysis in improving

workplace processes through people analytics.
Understanding People Analytics
 People analytics involves collecting and analyzing workforce
data to enhance company operations.
 It aims to create a more productive and inclusive workplace
by understanding employee experiences.
The Data Analysis Process
 The six steps of data analysis are: ask, prepare, process,
analyze, share, and act.
 These steps guide analysts in addressing business questions,
such as improving employee retention.
Case Study: Improving Employee Retention
 Analysts defined project goals and asked relevant questions
to understand new employee needs.
 They prepared by designing surveys to gather data on
employee satisfaction and established ethical data collection
practices.
 Analysis revealed that hiring processes significantly
impacted employee retention, leading to recommendations
for standardizing practices and conducting annual surveys to
track improvements.

How data analysts approach tasks

The Six Phases of Data Analysis

  Ask Phase: Understand the challenge or question to be
answered, often defined by stakeholders. This involves
asking many questions to clarify the problem.
 Prepare Phase: Collect and verify the necessary data from
various sources to ensure it is accurate and useful for
analysis.
Processing and Analyzing Data
 Process Phase: Clean and organize the data by removing
inconsistencies and formatting it for easier analysis.
 Analyze Phase: Perform data analysis to uncover answers,
which may include calculating averages or identifying trends
and patterns.
Sharing Findings and Taking Action
 Share Phase: Present findings to decision-makers using
reports, presentations, or visualizations, selecting the
appropriate medium for clarity.
 Act Phase: Implement data insights into actionable
strategies, such as developing new programs or making
changes based on the analysis.
Application Example
 A fictional company, Geo-Flow, Inc., used the six phases to
address low employee participation in a retirement program.
Analysts defined the problem, gathered data, and found that
certain employee groups lacked awareness of the program.
They shared their findings visually, leading to the creation of
an educational program that increased participation.
Iterative Nature of Data Analysis
 The data analysis process is iterative, meaning analysts may
need to revisit earlier phases based on new insights or data
quality issues. Continuous review and iteration are crucial for
achieving quality results.

Cassie: Dimensions of data analytics

Understanding Data Science and Analytics

 Decision Intelligence combines applied data science with
social and managerial sciences to harness data for impactful
business decisions.
  A data analyst is described as an explorer, detective, and
artist, emphasizing the need for creativity and curiosity in
data exploration.
Specializations in Data Science
 Data science encompasses three main disciplines: statistics,
machine learning, and analytics, each defined by the
number of decisions to be made.
 Specialization is crucial due to the vastness of data;
individuals should choose their focus based on personal
strengths and interests.
Characteristics of Each Discipline
 Statistics emphasizes rigor and careful decision-making,
suitable for those passionate about protecting against
incorrect conclusions.
 Machine learning focuses on performance and automation,
appealing to those who enjoy challenges and high accuracy.
 Analytics prioritizes speed and exploration, ideal for
individuals who thrive on ambiguity and creative projects.

Advice for Aspiring Analysts

 Embrace the unknown and let go of perfectionism; the
exploration process can be enjoyable and rewarding.
 Approach data analysis like unwrapping a gift, where the
goal is to discover valuable insights rather than seeking
immediate right answers.

Origins of the data analysis process

Origins of Data Analysis

 Curiosity Sparks Data Analysis: The journey of data
analysis began with curiosity about recording information.
 Historical Roots: Data analysis is linked to statistics, which
dates back to ancient Egypt, where data was organized for
building the pyramids.
The Data Analysis Process
 General Steps: While there are various models, most share
common steps:
1. Ask: Identify the business challenge or question.
2. Prepare: Gather and manage data.
 3. Process: Clean the data to ensure accuracy.
4. Analyze: Explore and visualize the data.
5. Share: Communicate findings.
6. Act: Use insights to solve problems.
Different Models of Data Analysis
 EMC's Process: A cyclical model with six steps focusing on
discovery and preparation before analysis.
 SAS's Iterative Process: Emphasizes repeating steps for
reliable results, including an evaluation phase.
 Project-Based Process: A simpler five-step approach
focusing on problem identification and data visualization.
 Big Data Process: A more detailed nine-step process that
breaks down preparation and processing into smaller tasks.
Key Takeaway
 The evolution of data analysis reflects a blend of historical
practices and modern techniques. Regardless of the model
used, the core ideas remain consistent.
Feel free to ask if you need more details on any specific point or if
there's another concept you'd like to explore!

What is the data ecosystem?

Data Ecosystem Overview

 A data ecosystem consists of various elements that interact
to produce, manage, store, organize, analyze, and share
data.
 Key components include hardware, software tools, and the
people who utilize them, often involving cloud storage for
data access.
Applications of Data Ecosystems
 Retail: Data analysts can predict customer purchases using
databases containing customer information and past
transactions.
 Human Resources: Analysts can leverage job postings,
labour market stats, and social media data to enhance
recruitment and employee engagement.
 Agriculture: Data ecosystems help predict crop yields by
analyzing geological and weather data.
  Environmental Monitoring: Data analysts track changes in
coral reefs to understand and protect marine ecosystems.
Common Misconceptions
 Data Analysts vs. Data Scientists: Data scientists create new
questions using raw data, while data analysts find answers
to existing questions.
 Data Analysis vs. Data Analytics: Data analysis involves
collecting and organizing data to draw conclusions, whereas
data analytics is a broader concept encompassing all aspects
of data management and usage.
Understanding these concepts prepares you for effective data-
driven decision-making in various fields.

How data informs better decisions

Understanding Data-Driven Decision-Making

 Data-driven decision-making involves using facts to guide
business strategies and improve processes.
 Organizations leverage data analysts to identify business
needs and solve problems through data analysis.
Real-World Applications
 Streaming services utilize data to analyze customer
preferences and make personalized recommendations,
enhancing user satisfaction and revenue.
 E-commerce has evolved by using data to shift from physical
stores to online shopping, reflecting changing consumer
preferences.
The Role of Data Analysts
 Data analysts play a crucial role in empowering
organizations to make informed decisions by analyzing data
and uncovering trends.
 Combining data insights with human experience and
expertise leads to more effective decision-making.
Importance of Subject Matter Experts
 Subject matter experts validate data analysis results,
identify inconsistencies, and provide context to ensure
informed decisions.
  Organizations benefit from integrating data insights with the
knowledge of their employees, creating a comprehensive
decision-making approach.

Data and gut instinct

 Similarities Between Detectives and Data Analysts:

o Both rely on facts and clues to make decisions.
o They collect and analyze evidence to understand
situations.
 Data-Driven Decision-Making Process:
1. Ask Questions: Define the problem.
2. Prepare Data: Collect and store information.
3. Process Data: Clean and check the information.
4. Analyze Data: Identify patterns, relationships, and
trends.
5. Share Data: Communicate findings with the audience.
6. Act on Data: Use analysis results to make decisions.
 Role of Gut Instinct:
o Gut instinct can help identify patterns but may lead to
biased decisions if data is ignored.
o Example: A restaurant entrepreneur relied on gut
instinct, leading to a failed business venture due to lack
of data research.
 Balancing Data and Experience:
o Combining data with business knowledge and gut
instinct is essential.
o The right mix depends on project goals and time
constraints.
Key Takeaways
 Data analysts must focus on data to make informed
decisions.
 Understanding the data related to a project helps identify
errors and gaps.
 The blend of data and knowledge improves decision-making
over time.

Key data analyst skills

 five essential analytical skills discussed in your course
material:
1. Curiosity
o Desire to learn and explore new challenges.
o Demonstrated by your engagement in the course.
2. Understanding Context
o Recognizing the conditions in which something exists.
o Example: Grouping grocery items to save time.
3. Technical Mindset
o Ability to break tasks into smaller, manageable steps.
o Example: Organizing bill payments by due date.
4. Data Design
o Organizing information logically.
o Example: Structuring contacts in your phone for easy
access.
5. Data Strategy
o Managing people, processes, and tools in data analysis.
o Example: Preparing to mow a lawn by following a clear
process.
These skills are foundational for a data analyst and can be
practiced as you progress through the course.

Use data analytics skills in a business scenario

Inherent Analytical Skills of Data Analysts

 Curiosity
o Essential for asking probing questions about data.
o Example questions:
 Is there a relationship between a movie’s budget
and its revenue?
 Which genres perform better on opening
weekends?
 Understanding of Context
o Important for meaningful data analysis.
o Factors to consider:
 Time of year for movie releases.
 Audience demographics (age, gender, income).
o Context helps identify patterns and anomalies in data.
  Technical Mindset
o Approach problems systematically and logically.
o Involves:
 Cleaning and organizing data.
 Using appropriate tools for analysis.

Data Design
o Organizes information for easier analysis.
o Example:
 Structuring data by revenue and genre to find
profitability patterns.
 Data Strategy
o Management of people, processes, and tools in data
analysis.
o Considerations:
 Choosing tools based on project needs (e.g.,
Google Sheets vs. Tableau).
 Prioritizing analyses that impact revenue.
Key Takeaways
 Analytical skills are crucial for effective data analysis.
 Combining these skills with tools and techniques enhances
decision-making in business scenarios.

All about thinking analytically

Analytical Thinking in Data Analytics

 Definition of Analytical Thinking
o Involves identifying and defining a problem.
o Solving the problem using data in an organized, step-
by-step manner.
 Five Key Aspects of Analytical Thinking
1. Visualization
 Graphical representation of information (e.g.,
graphs, maps).
 Enhances understanding and explanation of data.
 Example: A picture of the Grand Canyon is more
effective than a verbal description.
2. Strategy
  Essential for maintaining focus amidst large data
sets.
 Helps define objectives and the means to achieve
them.
 Ensures the data collected is valuable and
relevant.
3. Problem-Orientation
 Focus on identifying, describing, and solving
problems.
 Example: Addressing inventory shortages in a
warehouse.
 Involves asking questions to enhance
communication and efficiency.
4. Correlation
 Identifying relationships between two or more data
points.
 Example: Correlation between rainy seasons and
increased umbrella sales.
 Important reminder: Correlation does not equal
causation.
5. Big-Picture and Detail-Oriented Thinking
 Big-Picture Thinking
 Ability to see the overall context and
opportunities.
 Similar to viewing a completed jigsaw puzzle.
 Detail-Oriented Thinking
 Focus on the specifics that contribute to
executing a plan.
 Both skills are crucial for effective problem-
solving.

Explore core analytical skills

Analytical Thinking in Data Analysis

 Key Aspects of Analytical Thinking
o Visualization: Representing data visually to identify
patterns.
o Strategy: Developing a plan to approach data analysis.
 o Problem-Orientation: Focusing on identifying and
solving problems.
o Correlation: Understanding relationships between
different data points.
o Big-Picture and Detail-Oriented Thinking:
Balancing overall trends with specific details.
 Versatile Thinking
o Importance of developing various thinking styles
(analytical, creative, critical).
o Enhances problem-solving and idea generation.
 Critical Questions in Data Analysis
o Root Cause Analysis:
 Identify the root cause of a problem using the Five
Whys technique.
 Ask "why" five times to uncover underlying
issues.
o Gap Analysis:
 Evaluate current processes against desired
outcomes to identify gaps.
o Consideration of Missing Information:
 Reflect on what might have been overlooked in
previous analyses.
 Impact of Analytical Thinking
o Influences decision-making in businesses.
o Essential for identifying opportunities and improving
processes.

Use the five whys for root cause analysis

Five Whys Technique

 Definition: A method for identifying the root cause of a
problem by asking "Why?" repeatedly.
 Purpose:
o Helps data professionals determine the right questions
to ask.
o Aims to eliminate the root cause of problems to prevent
recurrence.

Example 1: Boosting Customer Service

  Problem: Numerous complaints about poor grocery
deliveries.
o Why #1: Customers are complaining about poor
grocery deliveries.
 Why #2: Products are arriving damaged.
 Why #3: Products are not packaged
properly.
 Why #4: Grocery packers are not
adequately trained.
 Why #5: HR has not completed
training program updates.
 Root Cause: Inadequate training for new grocery packers
due to HR's incomplete training program.
 Solution: Provide support to HR to complete training and
retrain packers.

Example 2: Advancing Quality Control

 Problem: Increase in defects in water pumps.
o Why #1: There has been an increase in defects.
 Why #2: Machines are not properly calibrated.
 Why #3: Machines were miscalibrated
during maintenance.
 Why #4: Calibration method is
inappropriate for the machines.
 Why #5: Engineers lack
information on calibrating
upgraded machines.
 Root Cause: Lack of information about calibration
procedures after a software upgrade.
 Solution: Provide engineers with necessary calibration
instructions.

Key Takeaways
 The Five Whys is a simple yet effective tool for root cause
analysis.
 It can be applied across various industries to identify and
resolve business problems.
 Encourages collaboration and learning about different areas
of the business.
Data drives successful outcomes
data-driven decision-making and the five essential
analytical skills:

Data-Driven Decision-Making
 Definition: Using facts to guide business strategy.
 Benefits:
o Provides valuable insights.
o Verifies theories or assumptions.
o Enhances understanding of opportunities and
challenges.
o Supports objective planning.
o Saves time and effort in achieving goals.
Examples of Data-Driven Decision-Making:
 Dairy Farmer:
o Instead of guessing ice cream flavors, surveys
customers for preferences.
 HR Director:
o Uses structured employee feedback (surveys) to
discover what perks employees value most.

Five Essential Analytical Skills

1. Curiosity:
o Drives the desire to learn more about data.
o Helps identify patterns and relationships in everyday
life.
2. Understanding Context:
o Enables analysts to make predictions and draw
conclusions based on data.
3. Technical Mindset:
o Builds on gut feelings with factual analysis.
o Involves seeking out facts and using insights for
informed decisions.
4. Data Design:
o Organizes data logically for easy access and
understanding.
o Applies to various real-life situations, not just
databases.
5. Data Strategy:
 o Incorporates people, processes, and tools to solve
problems.
o Ensures alignment of technology with data-driven
strategies.

Witness data magic

Case Studies in Data Analytics

1. Google’s Human Resources Analysis
 Objective: Determine the value of having managers.
 Method:
o Analyzed past performance reviews and employee
surveys.
o Used visual data representation (graphs) to understand
findings.
 Findings:
o Positive feelings about managers were noted.
o Significant differences between top and bottom
quartiles of managers.
 Conclusion:
o Teams with effective managers were happier and more
productive.
o Decision made to retain managerial roles based on data
insights.
 Further Steps:
o Launched an awards program for employee-nominated
managers.
o Conducted interviews with top and bottom quartile
managers to identify effective behaviors.
2. Nonprofit Sector Impact
 Objective: Enhance journalists' impact on nonprofits.
 Method:
o Monitored story topics, clicks, web traffic, and
engagement metrics.
 Findings:
o Effective journalism can raise awareness and motivate
action for social causes.
 Conclusion:
 o Data-driven recommendations were made to improve
journalist effectiveness in supporting nonprofits.
3. Importance of Data-Driven Decision-Making
 Key Takeaways:
o Data analytics plays a crucial role in various sectors.
o Understanding data can lead to better decision-making
and improved outcomes.
o Continuous learning and application of analytical skills
are essential for success in data analytics.