basedosdados/queries-basedosdados
Oct 2024 – Oct 2024
1 Month active
Languages Used
PythonSQLYAML
Technical Skills
Data AnalysisData EngineeringData ModelingDatabase ManagementETLPandas
vilelaluiza
PROFILE
Vilelaluiza
Worked on the queries-basedosdados repository to expand granular educational metrics and improve data quality, delivering four new features and resolving one bug within a month. Developed new SQL tables and processing notebooks for age-grade distortion and performance rates at both national and state levels, leveraging Python, SQL, and Pandas for data analysis and ETL workflows. Refactored the Br_inep_educacao_especial schema, updating models and clarifying field definitions to enhance data modeling and schema definition. Addressed data type inconsistencies by casting numeric fields for accuracy, removed obsolete SQL table definitions, and improved code quality through comprehensive linting and formatting across SQL files.
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 peopleWork 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