Case Study

Asset tracking and complaint management system using Power Apps

Client: Global Industrial Automation Campany

Our Expertise: Business Intelligence

Technology Used: Power Apps, SQL

 

 

 

PROBLEM STATEMENT

Tracking company assets for a company with 3000+ employees is always a challenge for the admin department. It is a tedious task to manually take the asset details and maintain them in the excel sheet. Due to this, even managing complaints became hard for our client as there was no centralized complaint management system.

Employees with managerial level and above were having company assets such as laptops, mobile phones, SIM cards, other peripheral devices, and software subscriptions. Our client was looking for a solution to track:

1. Department-wide assets distributed

2. Maintenance/complaint management

3. Tracing of software subscriptions and renewal

4. Tracking of total investments done in assets and upcoming renewal expenses and maintenance costs

SOLUTION

We developed a Tracking System using Power App for employees where they can fill in the details of all the company assets they are currently using, including software installed.

It helped organizations to streamline their asset management process:

– Employees can now put asset information in the tracking system without having to rely on admins 

– They can now use the same application to raise a service request through the App. It has now become easy for the admin department to track and resolve the issues seamlessly.

– Admin and Operations department users can now see the details of assets distributed, subscription due dates, upcoming renewal costs, and maintenance details.

– Notification triggers were created for subscription renewals, new complaints, complaints with no actions for a certain time, etc.

BENEFITS

Insights generated through the App helped in budgeting and planning for the admin department

No more manual efforts required in tracking the assets

Seamless complaint management reduced turn around time to solve them

Power App saved resources, time, and costs in managing such tasks which are now completely automated

Read More Success Stories

Power BI solution for a leading manufacturing company

Microsoft BI solution for leading African Bank

Web Application for a leading LPO

Walk with intellify

For Your Data-To-ROI Journey