
Fermé
Publié
I have an Excel workbook that holds all incident and service-request records on a single sheet. I need you to turn that raw data into a polished Power BI dashboard that lets me monitor the health of our ticketing operation at a glance. Core views & interactions • Status coverage – compare open versus closed tickets in real time, with slicers for assignee and ticket type. • Performance metrics – visualise MTTR and highlight whether each ticket met its SLA (these two metrics are the priority), plus secondary cards for reopened and reassigned rates. • Workload insights – surface “most tickets requested by” and “most tickets resolved by”, daily open-ticket trend lines, and ageing buckets that flag anything breaching thresholds. • Flexible time slicing – every visual must respond instantly to date-range selections (weekly, monthly, quarterly, bi-annual, annual). Deliverables 1. A .pbix file containing the complete report, all measures, and clean data model. 2. Brief setup notes so I can refresh the file when the Excel source is updated. Acceptance criteria • All visuals interact correctly with the date and assignee filters. • MTTR and SLA status calculate accurately for every ticket. • No hard-coded paths: the report refreshes from the same-structure Excel sheet dropped into the folder. If that scope is clear, let me know how long you’ll need and any clarifying questions you have.
N° de projet : 40251632
41 propositions
Projet à distance
Actif à il y a 7 jours
Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
41 freelances proposent en moyenne ₹244 INR/heure pour ce travail

Hi I will design a dynamic, high-impact ticketing dashboard in Canva that transforms complex support data into clear, executive-ready visual insights. My focus will be on creating an intuitive layout with professional data visualizations to ensure your team can monitor ticket volumes, response times, and status trends at a glance. Kundan
₹400 INR en 40 jours
2,6
2,6

Hello there, I recently built a comprehensive Power BI dashboard tracking complex metrics directly from raw Excel files—please review my profile for examples. I can transform your incident and service-request data into a polished dashboard that visualises MTTR, SLA compliance, and status coverage using robust data modelling. With flexible time slicing and intuitive filters, you can instantly monitor workload insights and aging thresholds without relying on hard-coded paths. You will receive the complete .pbix file with clean DAX measures, along with brief setup notes to ensure seamless refreshing when your Excel source is updated
₹200 INR en 40 jours
2,1
2,1

With extensive experience in data analysis, processing, and Power BI, I’m confident I’m the right fit for your Power BI Ticketing Dashboard project. I specialize in transforming raw data into clear, interactive insights using Power Query, DAX, and Power BI Service, ensuring complex ticketing data becomes easy to understand and actionable. I will deliver a clean, optimized data model along with the complete report in .pbix format. All required metrics—performance KPIs, workload insights, MTTR, SLA status, reopened and reassigned rates—will be calculated accurately and structured using best practices. I will implement dynamic date range slicers and flexible time filtering to meet your reporting needs, while ensuring there are no hard-coded paths, allowing seamless Excel updates within your Office environment. My approach focuses on both technical excellence and business clarity. I design dashboards that not only function flawlessly but also highlight the metrics that define success for your organization. Every visualization will be performance-optimized, intuitive, and aligned with your operational priorities. If you're looking for a reliable Power BI specialist who values precision, clean modeling, and strategic insight, I’m ready to help transform your ticketing data into a powerful decision-making tool. Let’s turn your Excel data into impactful, real-time insights.
₹250 INR en 40 jours
1,2
1,2

Hello, Your scope is clear, and I can deliver a clean, high-performance Power BI dashboard that gives you full visibility into your ticketing operations at a glance. I will start by structuring your Excel sheet into a robust data model using Power Query, ensuring consistent date handling and relationships that support fast filtering. From there, I’ll build the required views: • Status coverage: open vs closed with slicers for assignee and ticket type • Performance metrics: accurate MTTR and SLA compliance flags, plus reopened and reassigned rates • Workload insights: top requestors/resolvers, daily open ticket trends, and ageing buckets with threshold alerts • Flexible time slicing: all visuals fully responsive to dynamic date filters The final .pbix will include documented DAX measures, a clean model, and no hard-coded paths—so you can refresh simply by dropping in the updated Excel file. Timeline: 2–3 days after receiving your dataset Deliverables: Complete .pbix + setup/refresh guide Portfolio: https://www.freelancer.com/u/echekwa Ready to start immediately.
₹400 INR en 36 jours
0,6
0,6

With over 5 years of experience, I have honed my skills in Data Analysis and Visualization using Excel and Power BI. Your project aligns perfectly with my core competencies and I am confident that I can transform your raw data into a polished and dynamic Power BI dashboard that will give you clear insights into the health of your ticketing operation. I understand the importance of real-time monitoring for your ticketing operation and integrating meaningful metrics like MTTR, SLA status, reopened and reassigned rates is my priority. Additionally, for a better understanding of the workload, I can develop visualizations such as "most tickets requested by" and "most tickets resolved by". Also, flexible time slicing is not an issue as I am well-versed in creating visuals that dynamically respond to date-range selections. To ensure ease of use for you, I will deliver a .pbix file containing the complete report, all measures, and clean data model along with brief setup notes that will enable you to refresh the file when the Excel source is updated. In addition to my expertise, I prioritize timely communication. Let’s collaborate on this project to transform your data into actionable business insights!
₹250 INR en 40 jours
0,0
0,0

I understand you need a Power BI dashboard that transforms your Excel incident and service-request records into a clear, interactive tool for monitoring ticketing operations. The focus on real-time comparisons of open versus closed tickets
₹110 INR en 7 jours
0,0
0,0

Hello, Your goal of turning raw ticket data into a clear, real-time operational dashboard is exactly the kind of project I specialize in. I will convert your single-sheet Excel dataset into a polished, interactive Power BI report that highlights performance, workload distribution, and SLA compliance at a glance. My focus will be on building a clean data model, accurate metrics (especially MTTR and SLA status), and intuitive visuals that respond instantly to filters — giving you reliable insights for decision-making.
₹101 INR en 21 jours
0,0
0,0

With 5 years of hands-on experience as a data analyst, coupled with a robust proficiency in Power BI, SQL, and Python, I am confident in my ability to contribute effectively to your project. Throughout my career, I have honed my skills in extracting actionable insights from complex datasets, utilizing a combination of Power BI, SQL, and Python. I have a proven track record of transforming raw data into visually compelling and informative dashboards and reports, empowering stakeholders to make data-driven decisions efficiently. My specialization lies in creating impactful visualizations using Power BI, enabling stakeholders to grasp key trends and patterns at a glance. Moreover, my expertise in SQL allows me to manipulate large datasets swiftly and accurately, ensuring data integrity and reliability. I am eager to discuss how I can contribute to your project's success further. Thank you for considering my application. I look forward to the opportunity to work together.
₹250 INR en 40 jours
0,0
0,0

Hi, This is a clear and well-structured scope, and I can confidently help you turn your Excel ticket log into a clean, professional Power BI dashboard that gives you instant visibility into operational health. I have hands-on experience building end-to-end dashboards with accurate MTTR, SLA tracking, dynamic date slicing, and fully interactive filters. I will design a proper data model, create reliable DAX measures for MTTR and SLA compliance, and ensure every visual responds smoothly to assignee and date selections. The file will be built with a flexible folder-based connection so you can simply drop in the updated Excel sheet and refresh without any hard-coded paths. I can deliver the complete .pbix file along with clear refresh instructions within 2 to 3 days. Before starting, I would just like to confirm how SLA is defined in your dataset and whether MTTR should exclude weekends or non-working hours. Looking forward to working with you.
₹250 INR en 35 jours
0,0
0,0

Hello, I am Nikhil Patel. I am a hardworking and self-motivated person who believes in quality work and honesty. I like to learn new things and improve myself every day. I always try to complete my work on time and give my 100% effort in every project. I am friendly, easy to communicate with, and serious about my responsibilities. Client satisfaction is my first priority. I believe that good communication and trust are the keys to successful work. If you give me an opportunity, I will make sure you never regret choosing me.
₹100 INR en 72 jours
0,0
0,0

₹250 INR en 40 jours
0,0
0,0

Hi, I can deliver a clean, fully interactive Power BI dashboard from your Excel ticket data . The report will include accurate MTTR and SLA calculations (priority focus), open vs. closed status tracking, reopened/reassigned rates, workload insights, aging buckets, and dynamic trend analysis. All visuals will respond instantly to date, assignee, and ticket-type slicers, with proper star-schema modeling and optimized DAX. The .pbix file will use a folder-based connection (no hard-coded paths) so you can refresh easily when the Excel file is updated. I’ll also provide brief setup notes for ongoing maintenance and refresh. Please confirm if SLA is measured in calendar or business hours and share a sample structure to begin.
₹110 INR en 40 jours
0,0
0,0

Hello, I’d be happy to design a clean, executive-ready Power BI dashboard from your Excel-based incident & service-request data. I specialize in operational reporting, SLA analytics, and performance dashboards, with experience building MTTR, SLA compliance, workload, and ageing visualizations for ITSM environments. What I’ll deliver: Fully functional .pbix file Clean, optimised data model Accurate MTTR & SLA measures (priority) Interactive slicers (date, assignee, ticket type) Workload & trend insights Ageing & breach indicators Setup notes for easy refresh (no hard-coded paths) Approach: • Review & profile Excel structure • Build star-schema model • Create validated DAX measures • Design intuitive dashboard layout • Configure dynamic folder-based refresh • Test filter interactions & calculations Timeline: ~2–3 working days To ensure precision, I may clarify: • MTTR definition (calendar vs business hours) • SLA breach logic • Status field values • Reopened/Reassigned indicators I focus on dashboards that are not just visually appealing, but decision-ready and operationally reliable. Looking forward to collaborating.
₹500 INR en 40 jours
0,0
0,0

I can help you convert your Excel-based ticketing data into a clean, interactive Power BI dashboard focused on MTTR, SLA compliance, workload insights, and dynamic time slicing. I will build a structured data model, accurate DAX measures for MTTR and SLA status, aging buckets, and ensure all visuals respond correctly to date and assignee filters. The report will include a refresh-safe setup (no hard-coded paths) and organized measures for easy maintenance. I’ll also provide brief documentation so you can update the report when the Excel source changes. Before starting, I would like to confirm: How MTTR is defined in your organization Whether SLA rules vary by ticket type Estimated dataset size I can deliver a polished .pbix file within 3–4 days.
₹180 INR en 20 jours
0,0
0,0

Hello, I can help you transform your Excel incident & service-request data into a clean, interactive Power BI Ticketing Dashboard that gives real-time operational insights. ✅ **What I will deliver** • Fully interactive Power BI dashboard (.pbix) • Open vs Closed ticket monitoring with dynamic slicers (assignee, ticket type, date) • MTTR & SLA performance tracking (priority metrics) • Reopened & reassigned ticket analysis • Workload insights – most tickets requested/resolved by users • Daily open-ticket trends & ageing bucket analysis • Flexible time filtering (weekly, monthly, quarterly, annual) • Clean data model with reusable DAX measures • Auto-refresh setup using the same Excel structure (no hard-coding) ✅ **My Approach** I will first clean and model the data using Power Query, then create optimized DAX measures for MTTR, SLA status, and performance KPIs. The dashboard will be designed for quick decision-making and executive visibility. ⏱ **Estimated Timeline:** 2–3 days after dataset review. I have hands-on experience building Power BI dashboards using Excel sources, KPI cards, slicers, and advanced DAX calculations. I focus on performance, clarity, and professional visualization standards. I’m happy to discuss requirements and start immediately. Best regards, Jeswar Kalyan
₹250 INR en 40 jours
0,0
0,0

I have some experience to do this type of work and I really need this types of work.I want to start my freelancing carrier with this project. I have a habit of completing any task within the given time.
₹250 INR en 40 jours
0,0
0,0

I can help you transform your raw Excel incident and service-request data into a clean, interactive, and performance-focused Power BI dashboard that gives you complete visibility into your ticketing operations at a glance.
₹100 INR en 40 jours
0,0
0,0

I bring 15+ years of backend development experience combined with hands-on data analytics skills. In my most recent role I worked extensively with Python (pandas) and Excel for data cleaning, transformation, and pipeline building — extracting raw data from databases, structuring it, and feeding it into BI dashboards for strategic decision-making. To strengthen my analytics foundation I recently completed a Data Analyst Bootcamp with dedicated Power BI training covering data modelling, DAX measures, and interactive dashboard design. I can deliver the full scope you need: a clean .pbix report with accurate MTTR and SLA calculations, dynamic date/assignee slicers, workload visuals, and a refreshable model linked to your Excel source with no hard-coded paths. Estimated delivery: 3–5 days.
₹250 INR en 40 jours
0,0
0,0

Hello, Your scope is very clear, and this is exactly the type of operational dashboard I build. I will transform your single-sheet Excel dataset into a structured Power BI model with a proper Date dimension and clean relationships to ensure all visuals respond instantly to time slicing (weekly, monthly, quarterly, bi-annual, annual). For your priority metrics: • MTTR will be calculated dynamically using DAX based on resolution timestamps. • SLA compliance will be evaluated per ticket using threshold logic, with clear visual indicators for breached vs met cases. In addition, I will implement: • Real-time open vs closed status coverage with assignee and ticket-type slicers • Reopened and reassigned rate measures • “Most requested by” and “Most resolved by” rankings using dynamic TOPN logic • Daily open-ticket trend lines • Ageing buckets with threshold flags for SLA risk The data model will be clean and scalable — no hard-coded paths. The report will refresh automatically when a same-structure Excel file is placed in the source folder. I can deliver the complete .pbix file with documentation within 3–4 days. Before starting, I would just confirm: Do SLA thresholds vary by ticket type? Is there a dedicated reopen/reassignment flag column, or should it be derived? Looking forward to collaborating. Best regards, Qurban
₹500 INR en 40 jours
0,0
0,0

-=-♠♠♠♠-=- I recently created a Power BI dashboard from Excel data to track incident records, calculating MTTR and SLA status with slicers for assignee and date. I have 5 years experience in Power BI and I will deliver a polished .pbix file with all metrics, workload insights, and flexible time slicing as per your requirements.-=-♠♠♠♠-=- Please open the chat window so that I can share my portfolio and we can proceed further on this project. In addition to your project needs, I'll provide you with clean source code, free bug patches, and maintenance. I am awaiting your positive response. Regards, Ritesh
₹100 INR en 40 jours
0,0
0,0

Shaktinagar, India
Membre depuis févr. 10, 2025
$30-250 USD
$2-8 USD / heure
₹600-1500 INR
₹1500-12500 INR
₹1500-12500 INR
$750-1500 AUD
$30-250 USD
$250-750 USD
$15-25 USD / heure
$250-750 USD
$30-250 USD
$250-750 USD
₹10000-20000 INR
$10-30 USD
₹750-1250 INR / heure
$15-25 USD / heure
$10-30 USD
$2-8 USD / heure
£20-250 GBP
$3-10 NZD / heure