EMPLOYEE PRODUCTIVITY

Transforming business operations using a data-driven approach to create solutions

ActivTrak

ActivTrak is a cloud based user activity monitoring software.
It has features like, Productivity tracking, Real-time monitoring feed, Application monitoring, etc.

Goal

Logging tracks for web browsers and applications for all the users across, along with a date and timestamp, and it can be an incredibly useful for tracking accurate user activity.

Working

Built a pipleline on Azure Data Factory to get data from ActivTrak for calculating the productivity of all the active employee. POSTMAN was used to get the Access token using OAuth 2.0 and additional headers. Azure Web Activity was used to pull data from ActivTrak. Writing a Big query to calculate productivity of employee. The copy activity was used to map the tables into sink side i.e. Azure Blob Storage. It gets all your employee details Azure Blob Storage. Dashboards were created using Visualization tool (POWER BI).

Pipeline in Azure Data Factory

GCP to Azure Blob storage

ULTIPRO

UltiPro is a Human capital management solution. It provides records of HR, Payroll and Talent Management.

Goal

To connect it with ActivTrak employee logs and build a proper hierarchy of employees to track user productivity at different levels in an organization.

Working

A pipeline was built on Azure Data Factory to get data from UltiPro REST API. POSTMAN was used to get the additional headers. Azure Web Activity was used to pull data from UltiPro web API. Then a copy activity was used to map it Azure Synapse Analytics. It gets all your employee details into Azure Synapse.

WEBEX

Goal

There is an increasing need to pull employee data from various sources into one platform so that this data is then used later for analyzing performance, keeping track of operations and for necessary documentation. Here, we pulled employee data from Webex using REST API into Azure Data Factory.

Working

Web Activity:
Performs an authentication task and get access token. Copy Activity:
Fetches data from API and load it to a destination linked service.

In the above picture two linked services created: REST and Azure Storage They act just like connection managers in SSIS. The next abstraction is a Dataset. The Dataset is a named view of data that simply points or references the data that has to bed used in activities as inputs and outputs. SSIS has analogs in its dataflow – various sources and destinations. And the final piece – Copy activity. It is a generic task that copies data among various data stores located on-premises and in the cloud.
A pipeline was built on Azure Data Factory to get data from Webex. REST API was used to get the authorization (Bearer Token). Azure Web Activity was used to pull data from Webex. Then a copy activity was used to map it Azure Synapse Analytics. Hence the pipeline gets all the employee details into Azure Synapse.

ENTERPRISE DATA PLATFORM

Track all employee activities from their logs and meetings based on hierarchy within the organization.

Contact us for a quote, help, or to join the team.

email

service@iSmileTechnologies.com

phone

(732) 347-6245

About Us

iSmile Technologies is a global technology services company.

service@iSmileTechnologies.com
(732) 347-6245

USA

+1 (732) 347-6245
241 Jonathan Way
Bolingbrook, IL 60490

INDIA

2-3-285, Secunderabad Hyderabad 500003

CANADA

3190 Stocksbridge Ave
Oakville, ON L6M 0A7