Analyze and Share Phase in Data Analysis: Insights, Visualization, and Storytelling

Google Data Analytics Professional Certificate — Analyze and Share Phase

[embed]Google Data Analytics Professional Certificate — Overview Data Analyticsmedium.com

As mentioned in the article above, the data analysis process is composed of six phases: ask, prepare, process, analyze, share, and act.

[embed]Google Data Analytics Professional Certificate — Process Phase As mentioned in the article above, the data analysis process is composed of six phases: ask, prepare, process, analyze…medium.com

After explaining the Process phase, we will introduce the Analyze and Share phase in this article.

The Goal of Analysis

• Identify trends and relationships within data so you can accurately answer the question you’re asking
• focuses on conducting the necessary data analysis to uncover insights and solutions.

Data Validation

There are six common data validations:

1. Data Type
2. Data Range
3. Data Constraints
4. Data Consistency
5. Data Structure
6. Code Validation

Structure Query Language (SQL)

Temporary Table

• Temporary table means a database table that is created and exists temporarily on a database server
• We can use the WITH clause to fulfill this.

WITH name AS(
  SELECT
  FROM
  WHERE
)

• Temporary tables store intermediate results without affecting the main data. They’re useful for testing, complex queries, and imrpoving performance.

Subquery

A SQL query that is nested inside a larger query

Data Aggregation

The process of gathering data from multiple sources in order to combine it into a single summarized collection

The Goal of Share

• We will present our findings to decision-makers through a report, representation, or data visualization

Visualization

David McCandless provides 4 elements of Information Visualization:

1. Information: explore the metrics bring illustrated in the visualization
2. Story: The visualization reveals some overlooked treasures you may not know about previously.
3. Goal: The visualization is interested in exploring the relationship between popularity and objective data sources
4. Visual form: Communicate information about the dataset

Histogram v.s. Bar Chart

• A histogram represents continuous data, whereas a bar chart represents discrete data.
• A histogram shows the distribution of data, whereas a bar chart compares the values across categories.

Correlation v.s. Causation

Correlation: measures of the degree to which two variables move in relationship to each other

Causation: refers to the idea that an event leads to a specific outcome

Design Thinking

A process used to solve complex problems in a user-centric way

Five phases of the design process (not in any particular order)

• Empathize: Thinking about the emotions and needs of target audience
• Define: Figuring out exactly what your audience needs from the data
• Ideate: Generating ideas for data visualization
• Prototype: Putting visualizations together for testing the feedback
• Test: Showing prototype visualizations to people before stakeolders see them

Example

Scenario: City buses are often crowded, and schedules are not punctual.

Design Thinking Process:

1. Empathize: Observe passengers boarding and alighting, and interview them to understand their pain points.
2. Define: The problem is that passengers experience long waiting times and unclear schedule information.
3. Ideate: Come up with multiple solutions, such as real-time mobile schedule notifications or an intelligent scheduling system.
4. Prototype: Create a simple app prototype or an information display model.
5. Test: Let passengers use the prototype and collect feedback for further improvement.

Tableau

A business intelligence and analytics platform that helps people see, understand, and make decisions with data

Common types of icons

# Numeric data

Abc String data

Globe Geographic data

Calendar Date data

Calendar with a clock Date and time data

Three data storytelling steps

1. Engage your audience
2. Create compelling visuals
3. Tell the story in an interesting narrative

McCandless Methods

1. Introduce the graphic by name
2. Answer obvious questions before they’re asked
3. State the insight of your graphic
4. Call out data to support that insight
5. Tell your audience why it matters

Other References:

[embed]Google Data Analytics Professional Certificate — Act Phase As mentioned in the article above, the data analysis process is composed of six phases: ask, prepare, process, analyze…medium.com

[embed]Google Data Analytics Professional Certificate — Prepare Phase After completing the Ask phase, we will introduce the Prepare phase.medium.com