A portfolio of small projects to show usage of analytics and databases on Google Cloud Platform (GCP), Amazon Web Services (AWS) and Microsoft Azure.

This will invariably include HTML, javascript, CSS, Python and custom programming tools.

These are the end results. Parts of the full end-to end process are unseen running in the background: 

• Google Big Query (GBQ),

• Google Cloud Functions (GCF),

• Amazon EC2 Linux Servers and Python routines to read APIs to retrieve certain data to then be passed into Google Big Query.

• API calls to the International Space Station

There is also a version of this site (8ballanalytics.co.uk) which is being served using Google App Engine (GAE) sitting in a Python Flask instance.

Theory Generator (random theories)

Utilising a project containing Firestore Document Database, Firebase Authentication and Firebase Hosting, the Theory Generator reads one row at a time based on a value passed from a button. Either a media value (Television, Unexplained etc) or a group value (Stranger Things, Star Wars) to return a pseudo-random row from a Firestore collection.

The buttons displayed are populated based on values in another Firestore collection.

Uses Material Design and Javascript, building the CSS and Javascript into bundles. 

Iss Tracker (globe version)

Utilising the Big Query data and Cloud Function https trigger, this is using the WebGL Globe project to display the current position of the International Space station. It updates the data once every three second and matches that with the refresh rate on the webpage.

MarsScan (tongue in cheek)

A follow on from the above project. Still utilising Big Query data and a slightly modified Cloud Function https trigger, this is using the WebGL Globe project to display the current position of anomalous alien communication from Mars. It updates the data once every half a second and matches that with the refresh rate on the webpage.

GalaxyScan (tongue in cheek)

A follow on from the above project. Still utilising Big Query data and a slightly modified Cloud Function https trigger, this is using the WebGL Globe project to display the overall effect of a Galactic Midnight. It updates the data once every half a second and matches that with the refresh rate on the webpage.

8-Ball Analytics (tongue in cheek)

The internet of everything applied to IOT pool cue and ball technology. Every time an 8-Ball is played, physical information is relayed through an API and streamed directly into Big Query data and a slightly modified Cloud Function https trigger, this is using the WebGL Globe project to display the physical characteristics of each pool shot on the black ball. It updates approximately every three seconds and matches that with the refresh rate on the webpage.

Iss Tracker (2D Google Maps)

A project revolving around learning Google Cloud Platform. It uses the Google Maps API to read a Google Cloud Function which reads a Big Query database which is loaded from BQ APIs running on an AWS Ubuntu EC2 image, which is read from the space station positioning API. 

The Fragments

Running on Google App Engine, an intentionally retro-looking text adventure, harking back to the 80s. Major influences were the Twilight Zone, the 80s and 90s and old text adventures which ran on the Sinclair ZX Spectrum and Commodore 64 from the likes of Level 9 and Infocom. Written in Adventuron, an easy to use modern text adventure and interactive fiction creation tool. It runs fully in a browser and is designed for both desktop and mobile browsers.