Mehdi Hammami

Administration

• Deployment and management of Power BI Premium capacities.

• Installation, update, and management of Power BI Data Gateway.

• Monitoring and measuring the adoption of visualization tools. Expertise

• Definition of Power BI project architecture.

• Design and optimization of composite models.

• Offering in-depth technical expertise.

• Implementation of a Self-Service solution for Power Users.

• Regular technological watch and implementation of Proof of Concept (PoC).

Management

• Integration of new developers into the team.

• Development and sharing of development best practices with Data-Viz team members.

• Project leadership using adapted methodologies (Scrum, Agile, Waterfall).

• Project monitoring, ensuring proper execution of tasks, regular check-ins with stakeholders. Environment #

• Service NOW, Teams, Power BI Desktop, Power BI Services, Power BI Admin Portal, Power Platform, PowerShell, Power BI REST API, VM, PBI Gateway, SAP HANA, SCP, BW, Data Flow, SharePoint, Excel, Google Cloud Platform (GCP)

Data Quality Assessment:

• Analyze the quality and relevance of existing data.

• Identify data sources and assess their reliability. BI Systems Analysis:

• Evaluate existing BI solutions and identify weaknesses.

• Analyze difficulties encountered by the Data Factory team.

• Prepare reports detailing observations and potential areas for improvement. Action Plan:

• Develop and implement action plans to optimize decision-making tools.

• Automate report refreshing using tools like Power Automate. Training and Support:

• Train teams on development best practices (design, modeling, Data VIZ).

• Provide in-depth technical support. Data Modeling and Enrichment:

• Model and enrich datamarts dedicated to the "Parions sport" activity.

• Improve queries and build new views for reporting needs. Power BI Dashboard and Report Creation

• Participate in the creation of dashboards, reports, and applications to meet KPI requirements. Environment:

• Service NOW, Teams, PBI Gateway, Power BI desktop, Power BI services, PBI applications, Power Automate (Microsoft Flow), SharePoint, Excel, Teradata

Actions taken:

• Facilitating business workshops: Conducting collaborative workshops with L'Oréal's business teams (Supply Chain, Demand & Supply, Customer Care) to analyze their specific needs, challenge their expectations, and identify priorities to ensure a BI solution adapted to strategic challenges.

• Managing the BI roadmap: Translating business needs into concrete tasks and managing the Backlog in Agile mode, with sprint monitoring.

• Designing and developing data processing: Developing extraction, transformation, and loading (ETL) processes in Power BI, with detailed specifications written from SFGs.

• Creating advanced calculation formulas: Developing complex DAX measures to meet the specific reporting and performance monitoring needs of L'Oréal's various divisions.

• Modeling Power BI reports: Designing and modeling interactive and customized reports, with tailor-made visualizations for each business user, enabling informed decision-making.

• Managing Workspaces: Creating and managing V2 Workspaces on Power BI, ensuring secure report sharing and smooth collaboration between business teams.

• Configuring the data gateway: Setting up the Power BI gateway to ensure real-time report updates from SAP HANA data.

• Testing and data validation: Conducting test reports to allow Key Users (KUs) to verify the consistency and accuracy of data extracted from SAP HANA before production.

Technical Environment:

Service NOW, Teams, PBI Gateway, Power BI desktop, PBI V2 workspaces, PBI applications, SAP HANA, Data Flow, SharePoint