basedosdados/queries-basedosdados
Oct 2024 – Oct 2024
1 Month active
Languages Used
PythonSQLYAML
Technical Skills
Data AnalysisData EngineeringData ModelingDatabase ManagementETLPandas
vilelaluiza
PROFILE
Vilelaluiza
Luiza worked on the queries-basedosdados repository, delivering new granular educational data features and improving data quality for national and state-level metrics. She refactored the Br_inep_educacao_especial schema, updating model definitions and clarifying field scopes to enhance data modeling consistency. Using Python, SQL, and Pandas, Luiza developed processing notebooks for age-grade distortion and performance rates, ensuring robust ETL workflows and accurate data representation. She addressed data type inconsistencies by casting numeric fields appropriately and removed obsolete SQL table definitions to streamline the codebase. Her work demonstrated depth in data engineering, schema definition, and database management within a collaborative environment.
Overall Statistics
Feature vs Bugs
80%Features
Repository Contributions
6Total
Bugs
1
Commits
6
Features
4
Lines of code
7,205
Activity Months1
Your Network
9 people
Work History
October 2024
6 Commits • 4 Features
Oct 1, 2024Month 2024-10 focused on expanding granular education metrics and tightening data quality for the queries-basedosdados project. Key features delivered include new granular educational data: age-grade distortion and performance rates with notebooks for processing and cleaning data at national and state levels; Br_inep_educacao_especial schema refactor with updated models and clarified fields; removal of obsolete SQL table definitions to simplify the codebase; and code quality improvements with linting across SQL files.
6 Commits • 4 Features
Oct 1, 2024Month 2024-10 focused on expanding granular education metrics and tightening data quality for the queries-basedosdados project. Key features delivered include new granular educational data: age-grade distortion and performance rates with notebooks for processing and cleaning data at national and state levels; Br_inep_educacao_especial schema refactor with updated models and clarified fields; removal of obsolete SQL table definitions to simplify the codebase; and code quality improvements with linting across SQL files.
October 2024
Activity
Loading activity data...
Quality Metrics
Correctness96.6%
Maintainability96.6%
Architecture96.6%
Performance93.4%
AI Usage20.0%
Skills & Technologies
Programming Languages
PythonSQLYAML
Technical Skills
Data AnalysisData EngineeringData ModelingDatabase ManagementETLPandasPythonSQLSchema Definition
Repositories Contributed To
Overview of all repositories you've contributed to across your timeline