
Closed
Posted
Project Brief — Power BI PSU Patching Dashboard What I Have Excel workbook with 8 pre-built sheets already uploaded to MS Teams SharePoint 3 technology data sheets: Oracle Patching, PostgreSQL Patching, YugabyteDB Patching 1 combined sheet: Master Footprint (all technologies in one flat table) Issues Log, Summary Stats, DAX Measures reference, Setup Guide sheets Data Source & Refresh Data lives in SharePoint-hosted Excel file (MS Teams) Dashboard must auto-refresh every 30 minutes using Power Automate or scheduled refresh DBAs update their individual sheets → dashboard updates automatically — no manual intervention Dashboard Pages Required Page 1 — Overall Summary (all technologies at one glance) 6 KPI Cards: Total Footprint, Completed , Scheduled , Pending , Not Started , Issues Stacked bar chart: Technology vs Status count Slicers: Technology, Environment, Quarter Page 2 — Oracle Detail Clusters + Servers count by category: Exa_Prod, Exa_NonProd, NonExa_Prod, NonExa_NonProd DB PSU patching status per cluster JDK activity per cluster — servers done vs pending Color-coded status table with CHG# and INC# Page 3 — PostgreSQL Detail No cluster names — server-level tracking only Two version streams: 14.x Non-Patroni and 17.x Patroni shown separately Servers patched, scheduled, pending, not started per stream Page 4 — YugabyteDB Detail Universe-level tracking — no DB count needed Total Nodes, Nodes Upgraded, Nodes Pending per universe Prod vs Non-Prod split Page 5 — Issues Log All open/in-progress issues across Oracle, PostgreSQL, YugabyteDB P1 (Red), P2 (Orange) severity badges INC#, CHG#, DBA Owner, description visible Status Color Coding (Mandatory) Completed — Green #D4EDDA Scheduled — Yellow #FFF3CD Pending — Orange #FFE5CC Not Started — Gray #E2E3E5 Issue — Red #F8D7DA Sharing & Access Publish to Power BI Service workspace Embed as a tab inside Microsoft Teams channel All team members must view without needing Power BI Desktop Read-only for most team members, edit access for DBAs only DAX Measures Already Provided 19 DAX measures are pre-written in the Excel file (DAX Measures sheet) Freelancer just needs to paste them one by one — no DAX writing needed from scratch What I Need From Freelancer Connect Power BI Desktop to the SharePoint Excel file Build all 5 dashboard pages per the spec above Apply conditional formatting for status color coding on all tables Configure 30-minute auto-refresh via Power Automate Publish to Power BI Service and pin to MS Teams channel tab Deliver the .pbix file so I can republish if needed later Skills Required Power BI Desktop (visuals, slicers, conditional formatting) Power Query (connecting to SharePoint/OneDrive Excel) DAX (measures already written — just needs implementation) Power Automate (scheduled refresh trigger) Microsoft 365 / Teams integration
Project ID: 40369942
17 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average ₹750 INR/hour for this job

Hi, I have carefully reviewed your Power BI PSU Patching Dashboard requirement and fully understand the scope of work. I am a Power Platform developer with hands-on experience in Power BI, SharePoint, and Power Automate. I have successfully delivered similar automation and dashboard solutions for enterprise clients, ensuring accuracy, performance, and user-friendly design. I can help you: ✔ Connect Power BI to your SharePoint-hosted Excel file ✔ Build all 5 dashboard pages as per your requirement ✔ Implement KPI cards, charts, slicers, and technology-specific views ✔ Apply proper status-based color coding across all visuals ✔ Integrate your pre-defined DAX measures correctly ✔ Configure automatic refresh (every 30 minutes) ✔ Publish to Power BI Service and embed in Microsoft Teams I will ensure the solution is clean, scalable, and easy to maintain. I also provide support after delivery if any adjustments are required. Estimated delivery: 5–7 working days I am ready to start immediately and would be happy to discuss further details. Looking forward to working with you. Thanks & Regards, Suresh Kumar K
₹400 INR in 20 days
2.7
2.7

Hey! I can help you fast with symbolic price while building my review base here. The main challenge isn't just connecting SharePoint data, it's designing clean drill-through logic so your Master Footprint stays synced with tech-specific patching sheets without manual reconciliation. In the last 2 years I've built 28+ React dashboards and data visualization tools. I work extremely fast with Power BI + SharePoint connectors and can deliver your interactive dashboard with auto-refresh in hours, not days. Offering ₹600/hour for quality work + fast turnaround. Check my portfolio for similar BI projects. Ready to start immediately. Artur
₹2,797.20 INR in 40 days
0.0
0.0

Hello, I can assist in creating a basic Power BI dashboard using your Excel data and provide clear visuals for patching status and reports. I am ready to start and deliver on time. My rate is $10.
₹575 INR in 40 days
0.0
0.0

As an experienced full-stack developer with over 13 years of solid background in creating and maintaining robust backend systems, I offer you an unmatched perspective for your project. I have sound expertise in using Power BI Desktop, Power Query, DAX as well as data integration tools like Power Automate, which align perfectly with the skills required for this task. Having handled multiple large-scale projects, I am confident in my ability to deliver a pristine, efficient Power BI PSU Patching Dashboard that exceeds your expectations high. My competence in Microsoft 365 & Teams integration coupled with a firm grasp of Power Automate's scheduled refresh trigger will ensure that your newly created dashboard auto-refreshes every 30 minutes without any manual intervention, giving you live updates at all times. With attention to detail and a disciplined coding approach, I will quickly connect Power Bi Desktop to your SharePoint Excel file, implement the provided DAX measures wisely and build all five specific pages designed for. Thanking You Chandan Kandar
₹575 INR in 40 days
0.0
0.0

As a seasoned data specialist with over 15 years of expertise in Power BI and Tableau, I have honed my skills and technique to deliver analytics solutions that are directly aligned with the needs of diverse sectors. My extensive experience of developing complex Power BI reports, including the application of advanced DAX functions for operational analytics, perfectly aligns with your project requirements. I'm particularly skilled in integrating Microsoft 365 and Teams to enhance collaboration and accessibility. With this project, I would be able to connect Power BI Desktop to SharePoint Excel seamlessly and embed the resulting dashboards as a tab within Microsoft Teams Channels making these updates accessible to all team members without needing Power BI Desktop. In addition to being well-versed in data modeling and dashboard creation functionalities, I have substantial knowledge of Power Query and Power Automate which will ensure smooth connectivity between your data sources on SharePoint/OneDrive and continuous auto-refreshes every 30 minutes. By utilizing my skills set efficiently, I can easily build all 5 dashboard pages based on your specifications while incorporating the conditional formatting criteria for status color-coding across tables accurately. I assure timely delivery of all project elements along with the .pbix file for any future republishing needs - making me an ideal fit for this role.
₹1,732 INR in 25 days
0.0
0.0

With a robust blend of analytical reasoning and profound technical know-how, I am highly skilled in Power BI, making me an ideal choice for this PSU Patching Dashboard project. My wide range of competencies includes Power Query, DAX, and Power Automate, which are all crucial elements for the successful implementation of your comprehensive dashboard. Moreover, my track record as an adept analyst has attuned me to prioritize data accuracy and reliability. With an MBA in Data Science & Analytics enriched by fervent learning backed by my strong mathematical foundation, I am adept at utilizing statistical models and automation techniques effectively for robust business solutions. Therefore, I am confident in my ability to meet your project's needs while delivering above-expectation results that will accelerate your organization's productivity and amplify team collaboration through Microsoft 365/Teams integration.
₹575 INR in 40 days
0.0
0.0

Hi, I can connect your SharePoint Excel data to Power BI and build a clean Overall Summary dashboard with KPIs, slicers, and status visuals. I’ll ensure accurate data and a user-friendly layout. Full multi-page dashboard, automation, and Teams integration can be delivered in the next phase if required.
₹500 INR in 12 days
0.0
0.0

Hello, My name is Suman, and I have 7+ years of experience working with Power BI, Excel, SQL, and end-to-end Business Intelligence solutions. I have strong expertise in connecting Power BI with SharePoint/OneDrive data sources, building automated dashboards, and delivering real-time insights for business teams. I have previously worked on complex dashboards involving multiple data sources, KPI tracking, and status-based reporting, which aligns well with your PSU patching dashboard requirements. For your project, I can efficiently connect Power BI Desktop to your SharePoint-hosted Excel file, implement the provided DAX measures, and build all 5 dashboard pages as per your specifications. I will ensure proper data modeling, create intuitive visuals, apply accurate status-based color coding, and design a clean, user-friendly layout. Additionally, I can configure automated data refresh (every 30 minutes) using Power Automate or scheduled refresh, ensuring seamless updates as DBAs modify the data. I also have experience publishing dashboards to Power BI Service and embedding them into Microsoft Teams with proper access control. I will deliver a fully functional solution along with the .pbix file for future use. I am confident in delivering high-quality results and would be happy to discuss your requirements in detail. Let’s connect and bring your idea to life. Thanks & Regards, Suman
₹575 INR in 40 days
0.0
0.0

I specialize in transforming existing Power BI dashboards into clean, high-impact, and insight-driven experiences. I can restructure your dashboard for better information flow, standardize visuals (colors, typography, spacing), and replace basic charts with more effective, modern visuals. My focus is on improving UX and applying strong data storytelling so users can quickly understand and act on the data. I’ll also review and fine-tune key metrics to ensure clarity, accuracy, and relevance. If you’re looking to elevate your dashboard from functional to truly compelling, I’d be glad to help.
₹600 INR in 40 days
0.0
0.0

I an professional power bi developer with7 years of experience, and i have hands on the provided requirement of dashboard creation
₹575 INR in 40 days
0.0
0.0

I am a Data Science graduate with strong experience in Power BI, Excel, and data visualization. I have worked with multiple datasets and created interactive dashboards using DAX, Power Query, and automated refresh setups. I understand your requirement for building a Power BI PSU Patching Dashboard using SharePoint-hosted Excel data. I can efficiently connect your existing Excel sheets, clean and transform the data, and create a well-structured dashboard with clear insights, summary statistics, and issue tracking. I also have experience in handling data from multiple sources like Oracle, PostgreSQL, and other systems, and combining them into a single master table for analysis. I can ensure the dashboard auto-refreshes every 30 minutes using Power Automate or scheduled refresh. I will deliver a clean, user-friendly, and fully functional dashboard as per your requirements. I am confident I can complete this project on time with high quality. Looking forward to working with you.
₹400 INR in 40 days
0.0
0.0

Hello, I can help you with Power BI dashboard creation, data analysis, and data visualization. I have experience working with Excel, SQL, and Power BI to clean data, create reports, and build interactive dashboards. I can also assist with data integration and basic automation tasks. I focus on clear insights, structured data, and easy-to-understand dashboards for better decision-making. I am available to start immediately and can work within your requirements. Thank you.
₹400 INR in 40 days
0.0
0.0

Hello, I can build your Power BI PSU patching dashboard exactly as described with full automation and clean design. My approach: - Connect Power BI to your SharePoint Excel data - Use your existing sheets and DAX measures to build a structured data model - Create all 5 dashboard pages with KPIs, charts, slicers, and drill-down - Apply accurate color coding for all statuses - Configure automatic refresh every 30 minutes - Publish to Power BI Service and integrate with Microsoft Teams I can complete this project within 3 days and start immediately. Best regards, Tarek
₹450 INR in 40 days
0.0
0.0

Hi, This requirement is clear, and with your data and DAX ready, I will focus on effective modeling, precise visuals, and dependable auto-refresh. I can deliver this promptly and as requested. Here’s how I’ll handle it: • Data connection & model * Connect Power BI to SharePoint-hosted Excel (Teams) * Use Master Footprint as base model and relate tech sheets where needed * Validate all 19 DAX measures and implement correctly • Dashboard build (5 pages) * Page 1: KPI cards + stacked bar + slicers (Technology, Environment, Quarter) * Page 2: Oracle clusters, PSU + JDK tracking, CHG#/INC# table with color states * Page 3: PostgreSQL split (14.x Non-Patroni vs 17.x Patroni) with server-level KPIs * Page 4: YugabyteDB universe-level nodes (Upgraded vs Pending, Prod/Non-Prod) * Page 5: Issues log with severity badges (P1/P2), full visibility fields • Status color coding (strict) * Apply exact hex codes across all tables and visuals * Consistent conditional formatting logic across pages • Auto-refresh setup * Configure scheduled refresh (30 min) in Power BI Service * If needed, add Power Automate flow for trigger-based refresh • Publishing & access * Publish to Power BI workspace * Embed in Microsoft Teams channel tab * Set permissions: read-only for users, edit for DBAs • Final delivery * Clean .pbix file * Short handover notes (refresh, editing, republishing) Regards, Rajat Trivedi
₹575 INR in 40 days
0.0
0.0

I bring 5 years of experience as a Business and Data Analyst. My background includes working as a B2 Consultant at Capgemini. Connecting Power BI to your SharePoint Excel file is the first step. I will build the five dashboard pages to track Oracle, PostgreSQL, and YugabyteDB. Implementing your 19 provided DAX measures and applying the mandatory hex color codes will follow. I will then configure the 30-minute auto-refresh via Power Automate. I will publish the PBIX file and embed the dashboard inside your Microsoft Teams channel. Message me to begin this project.
₹650 INR in 20 days
0.0
0.0

Hello, I’m interested in building your Power BI PSU Patching Dashboard and can take full ownership of the end-to-end implementation—from SharePoint data integration to Teams deployment. With hands-on experience in Power BI, Power Query, and Microsoft integrations, I can deliver a clean, fully automated dashboard aligned precisely with your specifications. ### ? Approach & Execution Plan **1. Data Connection & Preparation** - Connect Power BI Desktop to your SharePoint-hosted Excel file - Load and validate all sheets - Perform data cleaning and normalization using Power Query **2. Data Modeling & DAX** - Establish relationships using Master Footprint as the central table - Implement all 19 pre-defined DAX measures accurately **3. Dashboard Development ** - Build all required pages - Create KPI cards, stacked charts, tables, and slicers as per your specification - Ensure clarity, usability, and performance optimization **4. Conditional Formatting** - Apply strict status-based color coding across all visuals: - Completed (Green), Scheduled (Yellow), Pending (Orange), Not Started (Gray), Issues (Red) **5. Automation & Deployment** - Configure 30-minute auto-refresh using Power Automate / scheduled refresh - Publish to Power BI Service workspace - Embed dashboard into Microsoft Teams channel with proper access control
₹575 INR in 40 days
0.0
0.0

Surat, India
Member since Apr 9, 2026
₹1500-12500 INR
$10-30 USD
₹12500-37500 INR
₹100-400 INR / hour
$10-30 USD
$10-30 USD
$30-250 USD
$20000-50000 USD
₹1500-12500 INR
₹12500-37500 INR
$30-250 USD
$10-15 USD
₹12500-37500 INR
₹600-1500 INR
$30-250 USD
$30-250 USD
₹100-400 INR / hour
₹400-750 INR / hour
$3-10 SGD / hour
₹12500-37500 INR