Unit 3.4: Data Visualization & Reporting

--:-- --
↓ Scroll for more

Unit 3.4

Data Visualization & Reporting

PRC 110: Software Skills Practicum

Learning Objectives

  • Choose and build Charts.
  • Summarize with Pivot Tables and Slicers.
  • Link sheets into a dashboard.

Charts

  • Column/Bar: Compare values.
  • Pie: Parts of a whole.
  • Line: Trend over time.
  • Add title, axis labels, legend.
  • Design tab for styles.

Check: Chart Choice

Ask a student or group first — then click to check.

Pivot Tables & Slicers

Insert → PivotTable — drag fields to Rows / Columns / Values / Filters.

  • Example: Rows = Region, Values = Sum of Sales Amount.
  • Slicer: interactive filter buttons (lab test Set B).
  • Refresh after source data changes.

Linking Worksheets

  • Dashboard cell: `=Pivot!B4` or `=Employees!G12`.
  • Keep source + dashboard in one workbook for class submissions.

Check: Pivot & Links

Ask a student or group first — then click to check.

Practicum 3.4

Sales dashboard

Use sales_data_large.csv:

  1. Column chart by Product.
  2. Pivot by Region + Pivot Chart + Slicer.
  3. Dashboard sheet with linked totals.

Unit 3 Full Assignment