📅 2025-03-10 — Session: Data Analysis and Visualization Exercises Development
🕒 11:00–11:30
🏷️ Labels: Data Analysis, Visualization, Education, SQL, Python
📂 Project: Teaching
⭐ Priority: MEDIUM
Session Goal
The session focused on developing and refining exercises for data analysis and visualization, primarily aimed at educational purposes.
Key Activities
- Gestión de Reservas en una Base de Datos de Aerolínea: Developed a guide for managing airline reservations using SQL, focusing on data integrity and reservation updates.
- Identification of Foreign Keys in Relational Databases: Created exercises to help students identify foreign keys and propose integrity constraints.
- SQL Queries and Updates Exercise: Designed exercises for advanced SQL queries and updates in relational databases.
- Data Analysis and Visualization with Python: Developed exercises using Python, Pandas, and Plotnine for data processing and visualization, specifically analyzing datasets on serial killers.
- Code Review and Data Analysis: Assisted in reviewing duplicated code for data visualization using Plotnine, focusing on normalization and polynomial fitting.
Achievements
- Created comprehensive educational exercises covering SQL database management and Python data analysis.
- Provided structured templates and guides for students to explore, transform, and visualize data.
Pending Tasks
- Further refinement of exercises to include more diverse datasets and scenarios.
- Additional code reviews for optimization and error handling.