
Closed
Posted
Paid on delivery
Design and develop a Power BI Dashboard to monitor and evaluate the daily performance of IT Team employees based on their task commits and work output. Core Requirements: 1. Daily Task Commit Tracking Each employee's daily commits should be logged and visualized. The dashboard should reflect task completion status on a daily refresh cycle. 2. Performance Ranking Identify and highlight the Top 3 Best Performing Employees and the Worst Performing Employees based on defined KPIs. 3. Multi-Dimensional Filters The dashboard must support the following interactive filters: Number of Tasks Completed per employee (within a selected time period) Bug Rate – Whether tasks completed by an employee resulted in bugs or issues within the next 3 months post-delivery Time Taken to Complete Tasks – Filter by average or total time spent per task per employee Additional performance metrics as applicable (e.g., task complexity, on-time delivery rate, reopen rate, etc.) 4. Key Performance Metrics (KPIs) to Cover: Total tasks assigned vs. completed Bug count and bug rate per employee Average task completion time Minimum and maximum task completion time per employee Time efficiency score (estimated time vs. actual time taken) Task quality score (based on post-delivery bugs) Commit frequency (daily/weekly trends) Employee performance score (composite metric) Dataset Requirements: The candidate may use any sample dataset of their choice (self-generated, publicly available, or mock data) The dataset must contain a minimum of 100,000 entries/rows The dataset should include, at minimum, the following fields: Field NameDescriptionEmployee_IDUnique identifier for each employeeEmployee_NameName of the employeeTask_IDUnique identifier for each taskTask_TypeCategory/type of the taskTask_Assigned_DateDate the task was assignedTask_Completion_DateDate the task was completedEstimated_HoursHours estimated for the taskActual_Hours_TakenActual hours spent to complete the taskCommit_DateDate of the daily commitTask_StatusCompleted / In Progress / ReopenedBug_ReportedYes / No – whether a bug was reportedBug_Reported_DateDate when the bug was reported (if applicable)Bug_Within_3_MonthsYes / No – whether bug appeared within 3 months of task completionSeverity_LevelLow / Medium / High – severity of the reported bug Deliverables: A fully functional multi-page Power BI Dashboard Clean, interactive visuals with slicers and filters The sample dataset (minimum 100,000 rows) used for building the dashboard Brief documentation explaining the metrics, DAX formulas used, and design decisions Evaluation Criteria: Data modeling and DAX proficiency Dashboard design and UX clarity Logical KPI definition and accuracy Filter interactivity and drill-through capability Handling of large datasets (100,000+ rows) efficiently in Power BI
Project ID: 40419799
9 proposals
Remote project
Active 19 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average ₹1,861 INR for this job

As an experienced Power BI Specialist and Data Analyst, I've successfully developed interactive and visually-engaging dashboards that provide actionable insights. I understand the key aspects of your project: task commit tracking, employee performance ranking, multi-dimensional filters, and defining comprehensive KPIs - all of which align with my area of expertise. In terms of handling large datasets efficiently, I recently worked on a similar project for a global call center where I analyzed daily calls volume across multiple regions. The dataset involved over 500,000+ rows initially and I adeptly used Power BI to sample the dataset without compromising its integrity. My proficiency in DAX allowed me to create calculated measures for different hierarchy levels to gauge team performance effectively. To underscore my capability further, I've also used Python extensively for data manipulation, automation, and even predictive modeling. While this may not be directly applicable to the task at hand; it showcases my willingness to use any tool necessary to achieve insights and solve problems. My ability to utilize Tableau along with Power BI can also come in handy if required in any phase or aspect of the project.
₹1,500 INR in 5 days
5.7
5.7

Hi, I can build a professional multi-page Power BI dashboard to track IT team performance using a 100,000+ row sample dataset. I’ll create a clean data model with DAX KPIs for tasks assigned vs completed, bug rate, completion time, time efficiency, quality score, commit frequency, and composite employee performance ranking. The dashboard will include interactive slicers, drill-through pages, Top 3 / Bottom performers, daily trends, and employee-level analysis. I’ll also provide the sample dataset and brief documentation explaining the metrics, DAX logic, and design decisions. I have strong experience in Power BI, DAX, data modeling, and performance dashboards, and can deliver a scalable, client-ready solution. Thanks Shivani
₹8,000 INR in 7 days
4.0
4.0

Hello, I’m a Power BI Analyst with strong experience in performance analytics, large-scale dataset modelling, and KPI dashboard development. I can design and deliver a fully interactive multi-page Microsoft Power BI dashboard that monitors IT employee productivity using task commits, completion performance, and quality metrics. For this project, I will build a structured dataset of 100,000+ rows (mock or simulated as required), model it efficiently for high performance, and create robust DAX measures for all required KPIs including task completion ratio, bug rate, average completion time, time efficiency score, task quality score, and employee performance score. The dashboard will include dynamic slicers for task volume, bug occurrence within 3 months, time spent, and other performance dimensions, with ranking visuals highlighting top and low-performing employees. I will also implement drill-through analysis for employee-level investigation. Deliverables will include the .pbix file, source dataset, and concise documentation covering data model, DAX formulas, and dashboard logic. Chijioke
₹1,050 INR in 4 days
0.6
0.6

Hi, My name is Ali and I can build this performance dashboard for you. I have extensive experience managing large-scale data systems, including building complex star-schema models in Power BI that handle over 100,000 rows efficiently while maintaining fast refresh cycles. I’ll create a composite performance score using DAX to rank your team, incorporating the bug rate and time-efficiency metrics you’ve specified. I will ensure the final report features the multi-dimensional filters and drill-through capabilities needed to track everything from daily commit frequency to long-term task quality.
₹1,050 INR in 7 days
0.8
0.8

I'm Ed, an expert in data management with extensive experience building robust, scalable, and user-friendly systems. Your project aligns perfectly with my skill set and past achievements. For instance, using my AI automation skills, I've built complex tools like your Power BI Dashboard from ideation to production for various clients. Additionally, I have excellent proficiency in Data Analysis Expressions (DAX), which is a fundamental requirement for this project. Many of the projects I've worked on leverage large datasets similar to what you're seeking; hence I am equipped with the necessary knowledge of structuring and cleaning messy AI codes that come with handling such datasets efficiently. You've also emphasized Multi-Dimensional Filters; I assure you of delivering clean, interactive visuals complemented with slicers and filters that will allow for easy interactivity and drill-through capability on your Dashboard resulting in significant UX clarity. Moreover, with my ability to automate workflows right from data ingestion to decision making using AI-powered tools such as GPT and Claude; your requirement for daily task tracking, performance ranking (based on KPIs), and efficient filtering will be expertly met. My ultimate goal is to ensure that the dashboard I deliver is not only informative but also designed for real-world usage and this encompasses producing brief yet comprehensive documentation explaining every element of the dashboard as per your requirements.
₹1,500 INR in 1 day
0.0
0.0

This isn’t just a dashboard—it’s a full performance analytics system. Most Power BI builds fail here because they overload visuals without defining strong KPIs or efficient data models. I focus on both. How I’ll approach this: 1. Data Layer (100K+ rows) Generate realistic dataset with task lifecycle, bugs, commits, and time metrics Optimize model using star schema (fact + dimension tables) for performance 2. KPI & DAX Design Task completion rate, bug rate (3-month logic), time efficiency score Employee performance score (weighted composite KPI) Min/max/avg completion time, reopen rate, commit trends Ranking logic for Top 3 / Bottom performers 3. Dashboard Structure (Multi-page) Overview: KPIs + Top/Bottom performers Employee Analysis: Drill-down by individual performance Quality & Bugs: Bug trends, severity, post-delivery impact Time Efficiency: Estimated vs actual analysis 4. Interactivity Advanced slicers (time, employee, task type, bug metrics) Drill-through + tooltips for deep insights Deliverables: Fully interactive Power BI (.pbix) 100,000+ row dataset Documentation (DAX + design logic) Quick question: Do you want the performance score weighted more toward speed, quality, or a balance of both? I can build this fast, but more importantly—make it decision-ready, not just visually impressive.
₹1,050 INR in 7 days
0.0
0.0

hello, I have experience developing advanced Power BI dashboards with large datasets, relational modeling, and DAX metrics focused on operational performance and productivity analysis. For this project, I will create a realistic simulated dataset with more than 100,000 records, including task tracking, completion times, bugs, and daily commitments, optimized for scalable analysis in Power BI. The dashboard will include multiple interactive pages with employee performance KPIs, ranking analysis, efficiency and quality metrics, as well as dynamic filters for detailed exploration by time, complexity, error rate, and productivity. I will also provide documentation covering the DAX formulas, data model, and design decisions to ensure future maintenance and scalability. I can deliver a fully functional, optimized, and user-friendly dashboard focused on performance, clarity, and actionable insights.
₹600 INR in 5 days
0.0
0.0

Gurugram, India
Member since Apr 12, 2025
$15-25 USD / hour
₹1500-12500 INR
min $50 AUD / hour
min €36 EUR / hour
₹750-1250 INR / hour
$8-15 USD / hour
€8-30 EUR
$250-750 USD
$750-1500 CAD
₹1500-12500 INR
$250-750 USD
£1500-3000 GBP
₹600-1500 INR
min €36 EUR / hour
₹750-1250 INR / hour
₹12500-37500 INR
₹12500-37500 INR
£1500-3000 GBP
£18-36 GBP / hour
$250-750 USD