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 based on one of my previous analyses for my clients. My client has an IT support department which receives telephone calls for support request. The team providing support is limited due to budget constraints and needs to do also onsite support as well as the aforementioned remote support. My client wants to know how many persons should be available to pickup telephone calls in certain periods (hour interval, days of the week, month) in order to properly assign the technicians to either provide remote support or go onsite....

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....

This is a mini-project dashboard build in IBM Cognos Analytics. Stack Overflow Annual Survey results - dashboard The data is based on the 2019 Stack Overflow survey.