Building your own KPI dashboard

Let's imagine we are working for a company called FantasticFutureTec. This company manufactures and sells products such as Hoverboards, Lightsabers, Neuralizers, and all the cool stuff from the future, which we would like to have right now. FantasticFutureTec is a pure online business, which means people can buy their products on the company website only.

We get a job to build a central company dashboard with all the relevant key performance indicators. Of course, we create this dashboard with R, RStudio, the Shiny framework, and the shinydashboard package.

Creating our data architecture

First of all, we need to bring the expressed requirements and their feasibility under one roof. FantasticFutureTec uses Google Analytics as a website analytics tool, and furthermore, writes all customer details automatically from the website into a MySQL database. The current product inventory gets manually written into a Google Sheets file. The company is also very active on...