Manas AyyalarajuMANAS AYYALARAJU
Back to Experience

IT Asset Visibility Dashboards

Interstate Batteries

Data Analytics Consultant (Capstone Project) · Spring 2026 · Capstone Project

Power BIData ConsolidationData CleaningDashboards
Illustration of a Power BI style dashboard showing 5,500+ IT assets, device categories, and a 70% faster lookup stat

Overview

Interstate Batteries tracked its IT equipment across several separate enterprise systems, so no one place showed what devices the company had. For my capstone project, I worked as a Data Analytics Consultant to bring 5,500+ IT assets, including mobile devices, laptops, desktops, and handheld devices, into one view for IT leadership and employees.

Challenge

Asset records lived in fragmented systems, with duplicates and inconsistencies between them. Finding a specific device or employee's equipment meant checking multiple places, and the data couldn't be fully trusted.

Solution

I cleaned, standardized, and consolidated asset records from 7+ data sources, removed duplicates, and resolved inconsistencies. I then built 4 interactive Power BI dashboards with employee-level filters, and met weekly with IT leadership and the data team so the reporting matched what the business needed.

Key Features

4 interactive Power BI dashboards

One view of mobile devices, laptops, desktops, and handhelds

Employee-level filters for fast asset lookup

Cleaned and de-duplicated records from 7+ data sources

Built with weekly input from IT leadership and the data team

Work Done

  1. 1

    Data consolidation

    Pulled asset records from 7+ disparate data sources into a single consolidated dataset covering 5,500+ IT assets.

  2. 2

    Cleaning and standardizing

    Standardized fields across systems, eliminated duplicate records, and resolved data inconsistencies to improve inventory accuracy and reliability.

  3. 3

    Dashboard development

    Built 4 interactive Power BI dashboards giving centralized visibility into mobile devices, laptops, desktops, and handheld inventory.

  4. 4

    Employee-level filters

    Added filters so users can look up assets by employee, which reduced estimated asset lookup time by 70%.

  5. 5

    Stakeholder alignment

    Met weekly with IT leadership and the data team to align the reporting with business requirements.

Impact

Consolidated 5,500+ IT assets into one centralized view

Reduced estimated asset lookup time by 70%

Eliminated duplicate records and resolved data inconsistencies, improving inventory accuracy and reliability

Gave IT leadership centralized visibility into mobile devices, laptops, desktops, and handheld inventory

Aligned reporting with business requirements through weekly stakeholder meetings

Technology Stack

Frontend

Power BI

Database

7+ enterprise data sources

Tools

Data cleaningData consolidation
Back to All Projects