📘 Data Technician Workbook – Excel | Just IT's Data Skills Bootcamp

---

📋 Overview

This workbook documents the hands-on tasks I completed during the Excel module of Just IT's Data Skills Bootcamp. It includes practical exercises using various datasets and focuses on foundational data skills such as data protection principles, dataset manipulation, pivot tables, Excel formulas, and basic data visualisations.

---

📅 Breakdown of Activities

Data Laws & Ethics

• Summarized and reflected on key data-related legislation:

  • Data Protection Act
  • GDPR
  • Freedom of Information Act
  • Computer Misuse Act

• Each law was broken down into:

  • What it is
  • Why it matters
  • Real-world application
  • Its impact on data handling
  • Potential consequences of breaches

---

Excel Foundations

• Task 1: Retail Sales Dataset
  • Imported data into a structured Excel table
  • Applied filters and sorting (e.g., by Age)
  • Used key functions: SUM() and AVERAGE() to analyze commissions
• Task 2: Advanced Excel
  • Further manipulation using formulas and screenshots to demonstrate results

---

Pivot Tables & Categorization

• Task 1: Bike Sales Pivot Table Lab
  • Created a pivot table to analyze market and customer insights
  • Reflected on findings by country, age group, and gender
• Task 2: Product Sales by County
  • Built pivot tables summarizing product performance
  • Used the SWITCH() function to categorize sales volumes into:
    • High
    • Medium
    • Low
• Task 3: Bike Sales Visualizations
  • Worked with charts to interpret and present data visually

---

🛠️ Tools & Techniques Used

• Data Cleaning & Filtering
• Excel Formulas: SUM, AVERAGE, SWITCH
• Pivot Tables & Pivot Charts

---

🎯 Learning Outcomes

By the end of this workbook, I was able to:

• Understand and apply data protection laws like GDPR, Data Protection Act, and the Computer Misuse Act
• Use Excel to:
  • Format and filter datasets
  • Create and analyse Pivot Tables
  • Use formulas such as SUM, AVERAGE, and SWITCH
• Interpret insights from datasets, including:
  • Identifying top-performing regions, age groups, and customer types
  • Categorising sales data based on volume
• Gain experience with data visualisation principles and tools in Excel

This workbook reflects the foundation of data handling best practices, setting the stage for more advanced tools and programming to follow in the Data Technician journey.