Vinicius Silva
Hello! I'm Vinicius, a Production Engineer, graduated from the Universidade Federal do Oeste da Bahia. Since 2020, I have been carving my path in the world of data. My journey combines my strong background in Production Engineering with my deep-rooted passion for technology. Over the years, I have focused my efforts on the field of Data Science, exploring various areas, from data analysis to the world of Business Intelligence. I have dedicated a significant amount of time to studying and improving my skills in this fascinating field.
My Personal Projects
These are my personal projects, where I used my creative potential and public data. Click below for details or view in Power BI. I hope you like it! 😄
Violins Scrapy
▸ Web scraping automation to track violin prices daily from an online store. Data is cleaned, stored, and visualized to analyze trends, price fluctuations, and seasonal patterns.
Tools used: Python, Scrapy, Pandas, SQL, PostgreSQL, Docker, Power BI, Figma, Git, GitHub
View in Power BI
Brazil's Import and Export
▸ Analyzing Brazil's imports and exports to identify trends, key trading partners, and the most impacted sectors over the years.
Tools used: Python, SQL, Docker, M, DAX, Figma, Power BI.
Project Management
▸ I created this Power BI dashboard to track study tasks, projects, deadlines, statuses, and Gantt charts.
Tools used: Google Sheets, DAX, Power BI.
Usage Metrics
▸ Dashboard for monitoring daily Power BI report usage via Power BI API data.
Tools used: REST APIs, Azure Portal, M, DAX, Power BI.
Personnel Allocation Indicators
▸ I created this dashboard using public data to analyze personnel allocation in Brazil’s federal public education system.
Tools used: Excel, DAX, Power BI.
PNP`s Challenge
▸ Won a hackathon by creating the best visualization for teacher and technician workload in Brazil's federal education network.
Tools used: Pentaho, PostgreSQL, SQL, Excel, DAX, Power BI.
Personal project portfolio
▸ I used a template but decided to create my own portfolio, giving me freedom to explore new development technologies, like web development.
Tools used: HTML, CSS, Git.
Explore the repository on Github
Projects I worked on
Here is a summary of the projects I participated in while being a research scholar at university! The project is called Rede Data Science BR, and its main client, to this day, is the Ministry of Education (MEC). I was a Data Science research student and was always collaborating with other researchers from all over Brazil.
🔔 All the projects I participated in at private companies cannot be listed here due to data protection laws and compliance regulations.
PNP - Plataforma Nilo Peçanha
▸ The Nilo Peçanha Platform (PNP) is a virtual environment for collecting, validating, and disseminating official statistics of Brazil's Federal Network of Vocational Education. It includes data on faculty, students, staff, and financial expenses.
What I did: I helped build the visuals, validate the data, and obtain the necessary information. I also contributed to constructing the pipelines and participated in meetings with stakeholders to understand the insights that could be derived.
Release date: 7th June 2022
Universidade 360°
▸ Universidade 360° provides data transparency through integrated information from Brazil's Federal Higher Education Institutions, offering academic, budget, and management indicators.
What I did: As a Data Science Researcher, I contributed to the project through data validation and creating impactful visuals. I gained valuable experience, developed new skills, and was actively involved in monitoring the project’s progress.
Achievements: In addition, we received the Computer Program Registration Certificate from the National Institute of Industrial Property, marking this project as part of our intellectual property.
Release date: 1st September 2021
Coronavírus Monitoramento da Rede Federal de Educação
▸ The Ministry of Education developed guidelines for safely resuming classes, aiming to mitigate pandemic impacts. The Coronavirus Dashboard provides transparent information on these actions.
What I did: This was my first project, where I learned the most. I focused on understanding platforms, assisting with less responsible tasks, and observing the work being done.
Release date: 7th May 2021
Skills
-
POWER BI
-
DAX STUDIO
-
TABULAR EDITOR
-
POSTGRESQL
-
MYSQL
-
PENTAHO
-
APACHE HOP
-
DOCKER
-
GIT
-
APIs
-
PYTHON
-
SQL
-
UBUNTU SERVER
-
LINUX
-
WINDOWS
-
FIGMA
-
COREL DRAW
-
ILLUSTRATOR
-
PHOTOSHOP
- Proficient in exploratory data analysis, data manipulation, cleaning, and transformation using tools like Power Query (M language), Python, Pandas, and SQL;
- Database creation and management, including modeling, implementation, and optimization. Experience in schema design and normalization;
- ETL and Data Pipelines with Python;
- Process automation and web scraping using Python;
- Version control using Git/GitHub;
- Use of VPS, knowledge of APIs, and micro-management of services using Docker;
- UX and Storytelling.
