Welcome to my Analytics Portfolio!
This repository gathers a collection of my projects in the data analytics and data engineering fields β including dashboards π, scripts π§ , automations π€, and end-to-end data solutions ποΈ.
The main goal is to showcase my work, share knowledge, and demonstrate how I use data to generate insights and support decision-making. π
Iβm Marco AurΓ©lio Alencastro, a Data Analyst / Data Engineer with experience in:
- π Building analytical dashboards (Power BI, Spotfire, Grafana)
- π οΈ Developing ETL pipelines with Python, SQL, Databricks, and Azure
- π Automating workflows (Power Automate, N8N)
- ποΈ Structuring Data Lakes and data governance processes
- π― Supporting business decision-making through data
π Iβve worked on projects for Petrobras, UHG, Mondelez, Banco do Brasil, and others.
This repository includes:
Interactive visualizations developed in Power BI, Spotfire, and more.
Python, SQL, and automation flows used for ingestion, transformation, and modeling.
Data ingestion β transformation β delivery β visualization.
- π Portfolio: https://allen87.com
- πΌ LinkedIn: https://www.linkedin.com/in/marco-alencastro
- π Resume: Available on my portfolio website
Visualization:
π Power BI β’ π TIBCO Spotfire β’ π Grafana
Programming & Data:
π Python β’ π§ͺ SQL β’ π· Databricks β’ πΉ Azure Data Factory β’ π§± Azure Synapse
Automation & Orchestration:
π€ Power Automate β’ π N8N
Modeling & Governance:
ποΈ Data Governance β’ ποΈ Data Modeling
DevOps & Tools:
π Git β’ π³ Docker β’ π¦ GitLab
If you want to collaborate, ask questions, or discuss any project:
- βοΈ Email: marcoalencastro@yahoo.com.br
- π Location: Rio de Janeiro, Brazil
β Feel free to explore the repository and reach out if you'd like to build something together!