Importing & Analyzing the Brazilian Vehicle Fleet
Text sanitization pipelines, batch loading of government data, and hybrid modeling for high-performance analytical queries.
Analysis of the Brazilian Fleet
Have we forgotten that impactful phrase “data is the new oil”? Everyone talks about artificial intelligence, but the most important thing is to generate impact and results. To do that, it is necessary to know how to analyze information.
My intention is to analyze the evolution of the vehicle fleet in Brazil over the years and how the brands performed. The project is still in progress and will be presented in stages.
General plan
- Study the data made available by the open data portal of the SENATRAN / Ministry of Transport.
- Import the data in Access and CSV format.
- Import the FIPE data made available on Kaggle.
- Classify the SENATRAN data according to the FIPE data.
- Explore the dashboards.
I hope this content is useful to those who are starting to work with data and serves as inspiration for those who already work with data but have not yet had time to explore Brazil’s government data.
Access the first stage of the study.
Access the second stage on data import.
Access the stage on FIPE data.