Apollo is an analytical platform used to provide near real-time information to the technical support team. Build by me in Python and React. The implementation of this project marked a turning point in the team’s performance and removed a lot of stress and questions from the day to day activities. This project may not be complex in the sense that it does not use ML or AI behind the scenes, but it shows the power of good data that results from a proper treatment workflow....
This is a showcase of SQL queries run on a fictious database for a record selling company called Chinook Records. I choose a SQLite 3 database as: it’s really simple to run on a simple computer, not needing to install a full solution such as MySQL, PostgreSQL etc. although there are certain functionalities not available on SQLlite, most of the SQL queries can be run on other variants The example database was downloaded from the website SQLite Sample Database and below is the diagram of the DB....