Gaetan Verbaere

■ Brainstorming client data issues to design dashboards that meet their needs.

■ Creation and customization of dashboards according to client expectations (company graphic charter, content refinement, facilitation of information interpretation and readability ..)

■ Study of possibilities related to client data:

○ Connecting multiple sources (Adservers, DSP, site-centric, CRM, retail ...)

○ Data cleaning and cross-referencing

○ Creation of new measures/dimensions from sources

■ Client data verification:

○ Source/dashboard comparison

○ Automation of data retrieval and reporting

■ Maintenance, debugging, and continuous improvement of dashboards

■ Tools used: Powerbi, Datorama, Datastudio, Funnel, Business Manager, Adobe creative, Excel, BigQuery, Snowflake, skills=[SkillTranslatableContent(id=Microsoft Power BI, type=GLOBAL, name=Microsoft Power BI), SkillTranslatableContent(id=Looker Studio, type=GLOBAL, name=Looker Studio), SkillTranslatableContent(id=DATORAMA, type=GLOBAL, name=DATORAMA), SkillTranslatableContent(id=Adobe Creative Suite, type=GLOBAL, name=Adobe Creative Suite)])

The need is for a data visualization tool for retail data (customers, sales, margins, stock, and remaining to deliver). The tool would be consulted by various departments for reporting, partly replacing reports generated by teams using Excel, for analysis purposes.

• Listing all sources and KPIs to track

• In-depth work with data engineering teams for data preparation

• Scoping and project management with business managers

• Design and creation of the dashboard per entity

• Significant work on table relationships (star schema)

• Continuous maintenance with business and data engineering teams

• Configuration of Power BI service (scheduling, authorization, advice for internal use)

• Technical and user documentation

The dashboards are automated and consulted daily. They replace extracts from various tools (time saving, data reliability, and simplified analysis). Operational teams make faster decisions on their campaigns and optimize their spending.

Track the evolution of the Bluelink activation rate over time.

Action Plan:Creation of a dashboard to automate the data transformation and historization phase.

Result:Operational teams simply need to export their data and upload it to an SFTP, and the dashboard updates automatically.

----

Redesign of the dashboard to manage the Optin rate. The dashboard needs to be more readable, understandable, and automated than V1.

Action Plan:Optimization of the existing process (reworking the source file, defining roles for each stakeholder, file compatibility with the dashboard) and dashboard redesign (UX/UI and data storytelling).

Result:Dashboard that makes data interpretation much clearer and more understandable for operational teams.

----

The CRM team needed to track the evolution of the "Privilege" program within their customer database.

Action Plan:It was necessary to understand the nature of the data and how to interpret and extract it. The Infographic format was chosen for the dashboard (illustrated on one page). The dashboard was created using a dummy database due to internal difficulties in extracting and automating the database.

Result:Fun and explicit interpretation of the data.