Christophe Hervouet

MISSION: DATA Advisor Power BI ecosystem “BI over Bigquery” (Governance / Technos / Performance / cost management) ------------------------------------------------------------------------------------------------------------ Strategy for implementing & adopting power BI within the company (governance & center of excellence, support) Support & training (ETL, Modeling, KPIs DAX, governance, sharing, monitoring, administration....) Promotion of dim models.. single source of truth (DWH Bigquery & power B) ----

• Promotion of the Google BigQuery data source ecosystem for Power BI (Ease of implementation, promote rapid, high-quality, high-performance integration/provisioning & reduce costs)

• Member of the GCP BigQuery data team (PAAS MPP Lakehouse) - Advice on BI patterns, integration optimizations, ETL/ELT Best practices - Creation of transfo views. SQL from the DWH layer (DBT Coud)

• PO on the Injection of power BI logs/metadata APIs into bigquery

• Advisor in organization & data governance (IT/business owns BI data, IT/business build solutions, data product owner, data champions, citizen data, committee etc. ..)

• Administration of Premium capacities (activities, performance, monitoring)

• Assistance for power BI users (technical & governance training, best practices & guide line)

• Modeling assistance (patterns) & KPI power BI (supply chain, finance, ticketing)

• Writing confluence documentation on various subjects: Technical, Admin, Power BI security governance, sharing & security etc ..)

• Product owner: Integration of Bigquery & power BI APIs (security audit – activities – uses - metadata - balance sheets of dataset refreshes etc ...)

• Creation of power BI reports: Data Ops, Sec ops, Fin ops

• Various python scripts: Refreshes of PBI dataset & dataflows via PBI APIs (apache airflow orchestrator)

Data Analyst and Power BI Expert Analytics / Advanced Analytics (Machine Learning) / Augmented (Insights) - Dataviz UI & UX Gathering requirements and support in co-construction (design & validation workshops) Refine Project: Analysis of the software assets produced by the parceling cataloger / Adherence & Inventory of components Risk calculations -Integration of data transmitted by the REFINE cataloger (ETL) -Support/co-construction on the collection of needs (Kpis, reports) -Agile Management (User Stories, sprints, increments) -Mock-up according to UI & UX concepts -Modeling of the BI system & Creation of Dataviz reports -RLS & Embedded Security -Machine learning: Search for correlations between characteristics (association mining & clustering) -Risk classification -Organization for 80% remotely (Co Construction & Agile, Teams, Wiki, GitHub, Rebound VM for development) -Power BI trainer, guarantor of best practices (modeling, configuration, performance, consistency of presentations, information sharing, security, etc.)

Objectives: Gathering requirements and support in co-construction (design & validation workshops)

Refine Project: Analysis of the software assets produced by the cataloger

Parceling / Adherence & Inventory of components

Risk calculations

-Integration of data transmitted by the REFINE cataloger (ETL)

-Modeling of the BI system & Creation of Dataviz reports

-Machine learning: Search for correlations between characteristics (association mining & clustering)

-Risk classification

-Organization for 80% remotely (Co Construction & Agile, Teams, Wiki, GitHub, Rebound VM for development)

-Power BI trainer, guarantor of best practices (modeling, configuration, performance, consistency of presentations, information sharing, security, etc.)