Menu
Enterprise Data Platform
Transforming business operations using a data-driven approach to create solutions
Goal
This report focuses on reporting a employee productivity for internal organizational use. This website is a one-stop shop to monitor employee productivity on multiple platforms like MS Teams, SharePoint, HubSpot, LinkedIn. All the Employee Details from these different platforms like Demographics, Roles, No. of meetings, Audio Time, Video Time, No. of potential clients contacted, User engagement on LinkedIn are used to assess the productivity of the employees.
Technical Video
Features of The Website
MS Teams User Activity
This report acts as a medium to check employee productivity based on MS Teams user metrics in last 90 days. It can track the engagement and productivity of each employee.
Working
Downloaded user activity data from MS team’s admin portal. Uploaded it to blob storage. Calculated productivity based on audio time, video time and meetings. Analyzed and visualized the insights in power BI
Report
Technologies Used
Previous
Next
LinkedIn Data
This report provides the user engagement of company’s LinkedIn page. Metrics such as engagement rate, impressions and clicks are assessed to give over all user interactions with the page and there by analyze its reach.
Working
Add an API through logic app, create a logic app using the suitable architecture. Upload the LinkedIn updates data to SharePoint. Now import this app through logic app API. Analyze and visualize the insights in Power BI
Report
Technologies Used
Previous
Next
HR Data Analysis
Using this dataset, we tried to find out the engagement of HR’s through the company. It gave us an insight about the teams and overall team members. We tried to give an overview of salary using glassdoor data.
Working
A Logic App was created in Microsoft Azure to pull HR RPA data from SharePoint and store it into Azure Blob Storage.
We choose HTTP request so that we can run the app on demand. Gave a link of the required folder buy using the path. Later linked it to the Azure Blob. The real time data will get stored in Azure blob. Analyzed and the visualized the data in Power BI.
Logic App Flow
Technologies Used
Previous
Next
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