Create data visualization (pivot tables, charts)

Pivot Tables 📑

Think of a pivot table as a super‑power sorting machine. It takes a big list of data and lets you rearrange it instantly, like sorting a deck of cards by suit and rank, but for numbers and categories.

Key steps:

1. Highlight the data range.
2. Insert a pivot table (Excel: Insert → PivotTable).
3. Drag fields to Rows, Columns, Values, and optionally Filters.
4. Choose the calculation (Sum, Count, Average, etc.).

Example data:

Pivot table result (Total sales by region):

Formula for average sales: $\\text{Average} = \\frac{\\sum \\text{Sales}}{n}$

Charts 📈

Charts turn numbers into pictures, making patterns easier to spot. Pick the right chart type:

• Bar/Column – compare categories (e.g., sales by month).
• Line – show trends over time.
• Pie – display parts of a whole.
• Scatter – explore relationships between two variables.

Creating a bar chart in Excel:

1. Select the data range.
2. Insert → Chart → Column or Bar.
3. Choose a style and add titles.
4. Format axes and legend.

Example: Bar chart of monthly sales (same data as above).

Remember to label the x‑axis (Month) and y‑axis (Units Sold) and give the chart a clear title.

Exam Tips for Data Analysis and Visualization

• Show your work: include intermediate calculations and explain your choice of chart type.
• Check data ranges: ensure you’re summarising the correct cells.
• Label everything: axes, titles, legends, and data labels help the examiner understand your chart.
• Use colour wisely: consistent colours make charts easier to read.
• Practice pivot tables: try different arrangements (rows vs columns) to see how the data changes.

Key Terms

• Pivot Table – a dynamic summary table that can be rearranged.
• Chart Type – the visual representation chosen (bar, line, pie, etc.).
• Axis – the horizontal (x) and vertical (y) lines on a chart.
• Data Range – the set of cells used for analysis.

Practical Exercise

Take the sample data table above. Create a pivot table that shows:

1. Total sales per month.
2. Average sales per region.

Then, build a chart that visualises the monthly totals. Be sure to:

• Choose the correct chart type.
• Label all elements clearly.
• Explain why you chose that chart in a short paragraph.

Good luck, and remember: a clear visual story is worth a thousand numbers! 🚀