4.2 Data Visualization

Data visualization is the graphical representation of information and data using visual elements such as charts, graphs, maps, and dashboards. It transforms raw data into an accessible format that helps identify trends, outliers, and patterns quickly.

Tools used for data visualization include SQL, Python (matplotlib, seaborn, plotly), and R (ggplot2).

---

Why Data Visualization Matters

• The human brain processes visual information faster than raw numbers.
• Helps communicate findings to both technical and non-technical audiences.
• Supports hypothesis testing by visually confirming or challenging assumptions.
• Enables real-time monitoring through dashboards.

---

Common Chart Types

Bar Chart vs. Histogram

• A Bar Chart compares discrete categories (e.g., sales per product).
• A Histogram shows the frequency distribution of continuous numerical data over intervals (bins).

---

Creating Visualizations in Python

Using Matplotlib

import matplotlib.pyplot as plt

# Bar Chart
categories = ['Math', 'Science', 'English']
scores = [85, 92, 78]
plt.bar(categories, scores, color='steelblue')
plt.title('Student Scores by Subject')
plt.xlabel('Subject')
plt.ylabel('Score')
plt.show()

# Scatter Plot
import matplotlib.pyplot as plt

height = [150, 160, 170, 180, 190]
weight = [50, 60, 70, 80, 90]
plt.scatter(height, weight, color='red')
plt.title('Height vs Weight')
plt.xlabel('Height (cm)')
plt.ylabel('Weight (kg)')
plt.show()

Using Seaborn

import seaborn as sns
import pandas as pd

# Heat Map (Correlation Matrix)
df = pd.DataFrame({'A': [1,2,3], 'B': [4,5,6], 'C': [7,8,9]})
sns.heatmap(df.corr(), annot=True, cmap='coolwarm')

---

Creating Visualizations in SQL

SQL itself does not render charts, but query results can be exported to visualization tools. Some database environments (e.g., MySQL Workbench, PostgreSQL with Grafana) support basic chart generation.

-- Example: Aggregate data for visualization
SELECT department, COUNT(*) AS employee_count
FROM employees
GROUP BY department
ORDER BY employee_count DESC;

This result can then be fed into Python or R to create a bar chart.

---

Creating Visualizations in R

# Using ggplot2
library(ggplot2)

df <- data.frame(subject = c('Math','Science','English'), score = c(85,92,78))
ggplot(df, aes(x=subject, y=score, fill=subject)) +
  geom_bar(stat='identity') +
  ggtitle('Student Scores by Subject')

---

Heat Maps

A Heat Map uses color intensity to represent values across a data matrix or geographical area.

• Darker or warmer colors indicate higher values.
• Useful for spotting correlations in large datasets.
• Common in bioinformatics, web analytics, and financial analysis.

---

Dashboards

A Dashboard is an interactive information management tool that:

• Visually tracks and displays Key Performance Indicators (KPIs).
• Allows users to filter and drill down into specific data subsets.
• Provides real-time monitoring of business or system health.

Popular dashboard tools include Tableau, Power BI, and Python's Dash library.

---

Data Visualization and Hypothesis Testing

Visualizations play a key role in communicating hypothesis testing results:

• Before testing: Use exploratory plots (histograms, scatter plots) to understand data distribution.
• After testing: Use visualizations to present findings clearly — e.g., a bar chart comparing means of two groups, or a scatter plot showing a regression line.
• Advanced visuals such as confidence interval plots and residual plots help tie findings back to the original hypothesis.

---

Key Principles of Effective Visualization

1. Clarity — Choose the right chart type for the data.
2. Accuracy — Do not distort scales or omit data points.
3. Simplicity — Avoid information overload; include only relevant data.
4. Labeling — Always label axes, add titles, and include legends.
5. Color — Use color meaningfully, not decoratively.

---