Habilidades Técnicas
Mi día a día se desarrolla en Productos de datos, proyectos de Business Intelligence y su ecosistema de datos. Mi enfoque está orientado a la optimización, usabilidad, automatización, la toma de decisiones efectiva basada en datos y empoderamiento de usuarias finales.
En los proyectos, desempeño diversos roles estratégicos:
-
Gestión de relaciones con usuarios clave del negocio para comprender procesos y necesidades, desarrollando estrategias como Project Manager.
-
Análisis y transformación de datos: comprensión profunda de fuentes, tipos de datos y arquitectura de información.
-
Modelado de datos y diseño de estructuras eficientes.
-
Visualización de datos y desarrollo de reportes avanzados. 💛
En cada proyecto, combino roles de desarrollador y Project Manager, liderando desde la captura de requerimientos hasta la implementación final. Mi experiencia en la gestión de relaciones con departamentos de TI/BI y la interacción directa con clientes ha sido fundamental en mi trayectoria profesional.
Business Intelligence
Reporting and distribution strategy for self-consumption.
-
Modelling with DAX and Power Query (ETL). ETL development on different sources: SQL Server, SQL Oracle, Dataverse, Azure DataLake, SAP, API REST PBI, csv and others.
-
Intensive use of Dataflows in ETL and PBI Datamarts.
-
External tools: Tabular Editor 3, DAX Studio, ALM Toolkit.
-
Reporting: dashboards and reports distributed through PBI Service, Teams, embedded and mobile, adapted to the type of end user and the type of consumption, considering best practices.
-
Experience with PRO, PPU and Premium capacity licenses.
-
PBIP: improving my deploy strategies.
-
Power BI Deployment Pipelines
-
Specialization in self-service strategies.
DataViz
When I started "drawing" reports, my priority wasn't at all to understand design fundamentals. However, as my reports became more expressive, I discovered that my limited knowledge affected my evolution. The improvised use of color or "my common sense" about the placement of objects on the canvas (Paper, Figma, Power BI) no longer served me and I had to start learning to be more organized and disciplined when mixing colors and thinking about architectures. Since then, design and experience (User journey) planning have become a fundamental part of my work. This is the part of my job that I enjoy the most. Therefore,
-
I am improving my skills and knowledge in UX and Design to create better DataViz outcomes.
-
I use Figma as a design tool (Themes, icons, prototypes, etcetera) to improve the experience of the reports and other outcomes.
-
I've experience using Zebra BI for finance projects.
​
Azure
-
Azure as data source, import and datalake management. ADL management through Azure Storage Explorer.
-
Power BI App Configuration (as developer) to use get data from Power BI 'as admin' through API Rest.
-
Crete Resource groups: BBDD SQL, Logic Apps, among others.o Querying DB on Azure through SSMS and Azure Data Studio.
-
Learning Azure Data Factory (ADF) and Azure DevOps for PBIP.
Microsoft Fabric
I am currently undergoing training on Microsoft Fabric. In my team, we are preparing to start using it with the help of a supplier.
Power Apps
-
Build apps (model-driven and canvas apps),
-
Dataflows (ETL, Analytics and standard to import data),
-
Dataverse.
-
Embedded apps in Power BI and Power BI Embedded in Apps.
Power Automate
-
Task automation and orchestration of update actions (Related to ETL, dataflows, datasets and APIs).
-
Automation related to Apps (Power Apps).
Code
-
VSCode: Diseño de queries (M Code), DAX, SQL, Markdown.
-
Git and GitHub.