Base django application. Create pages and django app website sections in the admin that dynamically appear in your homepage, navbars, sidebar and footer.

Staging and de-normalized data warehouse tables, in a star schema, with a date table, dimension and fact tables designed for data analysis.

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.

An example of M code used in a PowerBI Spotify data analysis project.

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.

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 i…

How to connect to SQL Server in Python and create a Pandas data frame from a SQL join query.

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.

A membership website for charities written in Django. Charities can create a profile and events.

A python program that takes data from a spreadsheet or csv file and creates a file returning all rows that have invalid dates in a date column.

One to one, one to many, many to many relationships, on delete set null and cascade examples and querying in both Django and Postgresql.

A menu based Python tool using Threading and Beautiful Soup to inspect numerous types of html elements from hundreds of files on your PC when building websites.

A Django built property management system with a front end property website. Good for Django learners.

A bespoke Django dashboard application for team members with different permissions to log in and add language translations to common company emails.

Video production company portfolio website in Django. Category pages are dynamically added to the website menu.

Django Wagtail, MySQL and Bootstrap setup. Complete step by step guide.

2019 PHP guide for validating and sanitizing strings.

A simple app that allows a user to calculate who owes money and who is owed money after a trip away.

Python app using openpyxl and docx for getting spreadsheet data and creating certificates.

Python app - stores paragraphs from multiple blog posts in one file.

A quiz app created with Django and Wagtail.

A basic Django Wagtail blog with Vue JS used to search posts.

A Django app for creating lessons with vocabulary and translations.

Examples of navbars you can create using Bootstrap 4. Shows how to modify navbar elements.