👨💻 Skills:
- dbt, BigQuery, Snowflake
- Cloud - AWS, GCP
- Airflow for Orchestration
- Data Warehousing, Data Modeling
- MetaBase, Tableau
👨🎓 Background:
- SQL Server, PowerBI
- Python Django, Linux, NGINX, PostgreSQL
Tools
👨💻 Skills:
👨🎓 Background:
Tools
The code behind docs.getdbt.com
A membership website for charities written in Django. Charities can create a profile and events.
Staging and de-normalized data warehouse tables, in a star schema, with a date table, dimension and fact tables designed for data analysis.
TSQL 1
A Django built property management system with a front end property website. Good for Django learners.
A detailed analysis project based on the top 2000 global companies in 2021. It focuses on countries, profit to sales and assets, The project uses Pandas, Numpy and Matplotlib.
Jupyter Notebook
All common SQL data query language and Window functions in one page with query explanations and notes. A file to test your knowledge for each included.
Jupyter Notebook