The data strategy was developed with a semantic intermediate layer with snowflake in order to centralize the information of all dental clinical branches contained in Odoo and PostgressSQL. Dashboards in Tableau were developed for the operational business areas (appointment monitoring, type of diagnosis, patient waiting times, etc), commercial indicators (revenue by specialty, treatment, branch, etc) and financial dashboards to have their income statement reports at both corporate and branch levels.

A dashboard was developed in Tableau to monitor the evolution of the sales of the products of this laboratory in comparison with the sales of the competition. Key databases of the pharmaceutical sector such as IMS, medical visits, and their internal sales contained in SAP were consumed in order to create indicators such as Evolution Index, Market Share, Sales vs. objectives, at the level of brick, medical specialty, brand, laboratory, medical specialist, events, etc. Our experience in the pharmaceutical sector was key to accelerate the development of this solution.

Within the academic sector, the body that regulates academic institutions in Mexico requested the development of a Dashboard to help monitor the use of the Google Classroom platform during the pandemic which was monitored by federal entity, division and advisors level, with indicators such as number of contracts and the amount they represent. The information is extracted from different sources such as G suite, Facebook, YouTube, mailchimp for external variables, and google big query for the metadata of the use of Google Classroom.