Data Extraction, Cleaning and Analysis - Monday.com API
Mário Guedes
Context
A financial consulting firm needed custom analytical dashboards to track their KPIs
Challenge
Extract and treat data from Monday.com
Steps
Data modeling: define the entity-relationship model
Extract JSON data from the API
Normalize JSON and create dataframes
Data treatment: cleaning, formatting, adding calculated columns etc
Create aggregated tables using SQL
Load treated data into Google Sheets
Results
Generated 11 tables and 5 SQL views with various business metrics: CSAT, Sales, Revenue, Project Management etc
Built 3 Python notebooks
Automated weekly updates
Screen prints
Data model
Sample for one of the final tables
Data treatment for one of the tables using Pandas
Sample code for one of the SQL views
Like this project
Posted Feb 10, 2025
Automated the extraction and treatment of data from the Monday.com API and loaded it into Google Sheets to be used for analysis.
