Simple scripts for data cleaning, etl transformations and data reorganisations. Data model is built on star schema where is one main dimension table and a lot of smaller fact tables.
These scripts are written in:
- Pandas
- Snowflake
You can find here transformations:
- SLA predictions for deliveries
- Data mapping for web statuses
- Data mapping for administration statuses
- Data mapping for Tableau
- Identify non delivered orders
- Identify delayed orders
- Merging all SLA dates and states into one table
- Get final states based on a dates or order
- Transform excel columns to rows based on specified rules
- Trigger on data update
These scripts running in Keboola Connection platform.