Power BI IPR Dashboard Development

Project Title:

Power BI Interactive Dashboard for Institutional IPR (Patent, Design, Copyright) Data Analysis

Project Overview

We have a detailed IPR database in Excel format that includes all Patents, Designs, and Copyrights filed by our institution’s faculty and students (Mailam Engineering College, India).
We are looking for a Power BI expert to design a dynamic, interactive dashboard that visualizes, analyzes, and reports IPR data in a visually compelling and automated way.

The dashboard will help our R&D and IPR Cell track institution-wide intellectual property progress, trends, and performance

Objective

To convert our institutional IPR Excel data into an insightful Power BI dashboard with real-time analytics, departmental comparisons, and performance KPIs.

Key Requirements
Data Model & Source

Data will be provided in a cleaned Excel format (IPR_Master_for_PowerBI.xlsx) containing fields:

Application Number

Title

Inventor / Applicant

Department

Filed Date, Published Date, Grant Date

Year, IPR Type (Patent, Design, Copyright)

Status (Filed, Published, Granted)

Dashboard Features

KPIs (cards):

Total IPRs

Filed, Published, Granted Counts

Grant Rate (%)

Avg Days to Publication / Grant

Trend Analysis:

Year-wise filing and publication trends

Department-wise growth visualization

Breakdowns:

Department-wise IPRs by Type (Patent / Design / Copyright)

Faculty-wise or Applicant-wise summary

Filters/Slicers: Department, Year, IPR Type, Status

Charts:

Line & Bar charts for trends

Funnel for IP process stages

Pie chart for IPR Type distribution

Table for detailed record view

Deliverables

.pbix file (Power BI Dashboard ready to publish)

Theme customization (Institution colors/logo)

Documentation on data refresh and DAX measures

Timeline

Prototype: within 3–5 days

Final Dashboard: within 7–8 days


Preferred Skills

Power BI (Advanced DAX & Data Modeling)

Excel data cleaning and transformation

Familiarity with institutional research / IPR / innovation data

Report design & interactive visualization experience

Provided Resources

Institutional IPR Excel file (already cleaned and merged)

Theme JSON (institutional color scheme)

DAX measures file for KPIs

Calendar and Power Query script

Outcome

A professional, automated Power BI IPR Dashboard that enables the institution to:

Track and visualize all IP filings, publications, and grants

Generate one-click insights for IIC, R&D Cell, and Accreditation Reports

Improve decision-making for patent strategy and institutional innovation performance