richardgourley
Linux, SQL, Python. Currently using Snowflake and dbt core to deliver analytics solutions.
Barcelona
Pinned Repositories
docs.getdbt.com
The code behind docs.getdbt.com
charity-organization-event-website
A membership website for charities written in Django. Charities can create a profile and events.
data-analysis-report-with-sql
A simplified introdocutory data analysis report to show how using SQL queries can answer questions from a data warehouse with a star schema. The report answers why server downtime happens and how it can be fixed.
fortune-global-2000-in-2021
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.
mini-quiz-app
A quiz app created with Django and Wagtail.
pandas-one-pagers
A set of one page guides for Pandas for Data Analysis. From transforming, cleaning and profiling the data through to visualizing the data with plotly.
property-manager-django-project
A Django built property management system with a front end property website. Good for Django learners.
sql-one-pagers
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.
sql-staging-database-and-data-warehouse
Staging and de-normalized data warehouse tables, in a star schema, with a date table, dimension and fact tables designed for data analysis.
video-project-manager
Video production company portfolio website in Django. Category pages are dynamically added to the website menu.
richardgourley's Repositories
richardgourley/Video-projects-showcase-plugin-with-bespoke-dashboard-page
Bespoke Wordpress plugin for saving custom post type instances of 'video projects' with post meta and categories.
richardgourley/bookdatabaseapplication
Basic MVC application for storing information on books. Written in PHP, no framework.
richardgourley/closure-arrow-functions-and-rest-parameters
An example of closure, arrow functions and rest parameters in Javascript. This is a nice simple example for Javascript students to follow.
richardgourley/factory-inventory-app
PHP web app for managing factory inventory.
richardgourley/factory-inventory-app-v2
A web based MVC app written in PHP without a framework. Utilizes sessions with a login and logout system.
richardgourley/guitar-chord-sequence-plugin
A Wordpress plugin that allows the user to select a pre-saved set of guitar chords from a drop down menu and generates a guitar chord sequence.
richardgourley/hello_world
Trying out Github
richardgourley/interactive-team-slider
HTML, CSS and JS interactive staff member buttons. Displays employee information on click.
richardgourley/json-rest-api-call-with-closure
Javascript - simple example of making a get request via a rest api.
richardgourley/premiership-winners-filter-plugin
Wordpress plugin - displays and filters past Premier League tables.
richardgourley/savings-target-application
User enters a savings target, hits the button and finds out how much they would need to save over different time frames.
richardgourley/WP-localize-script-example
Examples of using wp_localize_script to access Wordpress database results in Javascript.
richardgourley/WP-post-details-admin-page-plugin
Wordpress plugin - creates an admin page that displays the last 5 posts, number of posts per category and length of time between posts.
richardgourley/WP-prepared-statements-get-post-metadata
Wordpress prepared statements and retrieving post meta examples.