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!