Overview

As a global player in the education industry, Santillana’s reputation thrives on its ability to innovate and adapt to market trends. To that end, their team in Santillana was seeking a relevant, in-depth and effective professional solution to know the behavior of their workforce within its intranet.

Client:
Santillana
Industry:
Education Industry
Services:
IT Consultancy, Frontend and Webservice Coding, Database Design, and Reports.

Challenge

Have Microsoft Office 365 apps available within their intranet, track the employee’s use of the Office apps, store the information and visualize the metrics, to know which Office 365 apps do their employees use the most and which ones they hardly use or don’t use at all.

Solution

Development of a frontend section that displays all Microsoft Office 365 apps to the intranet users. Track their behavior through users’ session data and classes, using a PHP web service to write to a SQL database. Design of the SQL database that receives employee behavior data. Data visualization on Google’s Data Studio.