Freelancer profile translated to English.
Back to original languageAbout Julien
I help companies progress through Data Analysis, Data Visualization.
> SERVICES:
My latest Data Analyst missions involved:
- Extracting data: Hubspot, Shopify, gSheet, etc.
- Storing it in a Data Warehouse: Bigquery, Redshift, etc.
- Transforming data (SQL), automating (scheduled queries)
- Creating dashboards using Business Intelligence tools: Google Looker Studio, Power BI, etc.
> TRAINING:
I work as a professional trainer for digital schools and training centers in the fields of Business Intelligence, Data Analysis
I've also had the opportunity to design automation scripts:
- Google Cloud Function, Cloud Run, Cloud Scheduler
- Python Pandas for accessing data provided by an API
- Google Apps Script for automating certain processes (Creating PDFs, Mail Merging, sending emails, automating meeting creation, etc.)
- Visual Basic for Application VBA
- NoCode: Integromat/Make, Zapier, etc.
I place great importance on communication.
I love learning, sharing knowledge, and taking on challenges.
And you? What challenge will you propose to me?
Julien
Data Analysis - Business Intelligence:
- Google Data Studio
- Microsoft PowerBI
- Microsoft Excel, Power Query, Power Pivot
Data Warehouse:
- Google BigQuery SQL
- Google Cloud Platform, Cloud Run, Cloud Scheduler
- Amazon Redshift
Code:
- Google Apps Script
- Visual Basic for Application, VBA
- Google Cloud Function, Cloud Run, Cloud Scheduler
- Python
Web:
- Webflow
- Wordpress
Automation:
- Zapier
- Make
- NoCode
Of Course:
- Google Workspace: Google Sheet + Apps Script
- Microsoft Office: MS Excel + VBA
Excel:
- Pivot Tables
- Power Query
- Power Pivot
- Power BI
NDA: Training activity declaration registered with the prefect of the Ile-de-France region
da 100 pl 300
French
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- MOBSUCCESS
On Malt
Data Extraction, Transformation, Analysis and Visualization of HubSpot Data on DataStudioJanuary 2024 - Today (2 years and 5 months)Paris, FranceData Analysis service:- Data source: HubSpot- Data extraction via a Google Apps Script that queries the HubSpot API- Additional data in gSheets- Script scheduling 7 times/dayData Transformation with BigQuery:- Raw tables connected to gSheets- Writing SQL queries for data transformation- Query scheduling: 1 time/hourData Visualization:- Creation of a Looker Studio Dashboard- Connected to a BigQuery table- Refresh every 15 minutesTraining, documentation, project management - RepossiSales Dashboard Creation with PowerBI + TrainingLUXURY GOODSMay 2025 - May 2025 (1 month)Paris, France> Extraction:- Source: Excel, CSV files> Transformation with Power Query:- Creation of the Sales table (combination, merging)- Calculation of custom columns- Creation of Product and Date table queries> Data Modeling with PowerBI Desktop:- Generation of queries in Power M- Connection of Sales, Products, Dates tables- Creation of Year N, Year N-1, 12-month rolling measures (time intelligence) in DAX- Multi-editor management> Data Visualization:- Visuals, Filters, Slicers- Publication on PowerBI services and sharing with readers> Documentation:- IA prompt book for Power Query / Dax- Data transformation architecture- Data model architecture
- Truffaut (SiĂšge social)Supply Chain Purchasing Management - Excel PowerQuery VBA macroLOGISTICS AND SUPPLY CHAINJune 2024 - Today (2 years)Lisses, FranceData Sources:- CSV files- Loading data into Excel via PowerQuery- Creation of the data model with PowerPivot and Dax- Automation with VBA macros- Creation of Pivot Tables and DashboardsDecision-making support
Reviews
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Data Analyst - ScientistOpenclassroom - Udemy2019Parcours Data : - SQL - Python, Pandas - Data Studio, PowerBI
- EngineerArts et MĂ©tiers ParisTech2007GĂ©nie MĂ©canique et GĂ©nie Industriel
Certifications
- DA-100: Analyzing Data with Microsoft Power BIMicrosoft