Tracey Van Puyvelde

End-to-end data solutions architect, covering the entire data lifecycle: from ingestion to modeling, visualization, advanced insight generation, and business process automation.

Over 8 years of experience in Power BI tenant administration, with in-depth expertise in PowerShell modules and REST APIs.

Pernod Ricard: Microsoft Fabric capacity administration at the tenant level, supporting Power BI analysts within the organization in reviewing their data models and reports.

Recommending best practices, identifying performance optimization areas, and reducing the impact on capacity resources, while improving user experience and overall BI environment governance.

Conducting training sessions on Power BI and Microsoft Fabric, in person and remotely, to support teams in upskilling, facilitate migrations to Fabric, and enhance user autonomy and expertise.

Digitall

Deployment of Digitall's first POC support version for AI chat on PDF documents using Azure OpenAI.

Design of technical data solutions using Azure for the support of several pre-sales offerings.

GGW

Development of Azure Data Factory pipelines in the migration of Dynamics CRM data.

Daimler - Mercedes Benz Group

Design of a solution to automate file flows from managers to respective systems, including approval management. The implemented design used Synapse and Logic Apps. I led the project, including resource management in Bulgaria, and provided direct support when tasks were escalated and required a higher level of knowledge and expertise.

Kelvion

Implementation of desired changes for Power BI reports using Synapse data. Massive cleaning and improvement of DAX and Power Query formulas in reports to increase efficiency for an enhanced experience.

Aquila

Tenant management support, including best practices and cleanup.

Assistance with the use of Fabric within the organization, including developing a scheduled Power Automate to collect data from the Microsoft Fabric Capacity metrics app to create reports on capacity utilization and costs by department.

Vetter

Addition of Google Analytics and LinkedIn data to the Power BI report for marketing data. Development of a custom connector for LinkedIn in Power BI updated using the LinkedIn API.

BPCE-IT (Aix-en-Provence, Banking and Insurance): Within the BPCE Infrastructure team, my roles include but are not limited to:

- Allocation of Pro licenses and Premium capacities

- Advice on Power BI offerings and best practices

- Retrieval of PowerBI and user data in Azure / O365 and Active Directory (AD) using the PowerBI API and various PowerShell modules

- Monitoring of licenses, user activity, capacity, data consumption, desktop installations, etc.

- Creation of PowerShell scripts to clean, organize, and collect data (Azure group synchronization, automatic allocation of free and Pro licenses, automatic placement of users in groups, etc.)

EDF-ENR (Lyon, renewable energy): Transformation of SSRS reports into Power BI dashboards with queries on the Microsoft Dynamics CRM API

SOMEI (Paris, water, energy, and waste management): Performance improvement of queries on Big Data (several million lines) using Power BI aggregations for interactive and fast analysis. Cost estimation for migrating data to an Azure database.

Paris Airport (Paris, Paris airport management): Optimization and performance of reports for human resources (HR) as well as delivery of desired visualizations.

Total (Paris, oil & gas): Training on Power BI and creation of a Power BI report to track their budgets.