Technical skills

My days go by BI dev projects and It's data ecosystem. My goals always will be automation and effective decision-making.

Within a project, I can get different roles:

1. Relationships with key business users to understand processes and business questions, and build strategies, usually as Project Manager.

2. Data analysis and transformation: understand sources, data type, etc.

3. Data modelling.

4. DataViz and reporting in general. 💛

In every Project I work as developer and usually I act also as PM. Requirement gathering and architecture, and relationship with IT or BI departments. Interaction with clients is one of the key elements of my journey.

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.