
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: 40367591
5 proposals
Remote project
Active 1 mo ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average ₹1,070 INR/hour for this job

As an experienced IT consultant with a profound understanding of data management and automation, I am well-equipped to handle your Power BI PSU Patching Dashboard project. Having worked on countless similar projects, I am highly conversant with Power BI Desktop, Power Query, DAX and Power Automate, skills that are at the core of this project. My aim is not just to deliver a functional dashboard, but to build a practical solution that meets your needs with minimal strain. With regard to Microsoft 365 / Teams integration, your dashboards will be readily accessible by all team members and they will require only read-only access unless they are DBAs responsible for updating the individual sheets. Keep in mind that what differentiates me from other developers is my commitment to clean, maintainable code and future-ready architecture. This will ensure that you retain the ability to republish the generated .pbix file whenever needed without hitches. Moreover, I bring a unique blend of technical competence and excellent communication skills to the table. I am proud of my track record of clearly articulating technical directions to clients and consistently delivering above expectations. I invite you to leverage my expertise in transforming ideas into effective web and app solutions for a smooth yet mighty execution of your project. I look forward eagerly to hearing from you so we can further discuss how best I can help turn your vision into reality.
₹1,000 INR in 40 days
1.5
1.5

Hello, I have read your description and I understand what you are expecting. I am an expert with 4 years of experience in Data Visualization, Automation. See my profile for recent work. Looking forward to your reply. Best regards, Syeda Tahreem
₹750 INR in 40 days
0.0
0.0

Hi there, I have read your project requirement. You need a complete Power BI PSU Patching Dashboard built from your SharePoint Excel data, with 5 structured pages, proper KPI visuals, status-based color coding, and automated 30-minute refresh integrated with Microsoft Teams. We will connect Power BI to your SharePoint Excel, implement all 5 dashboard pages as specified, apply accurate DAX measures, and ensure clean, interactive visuals with slicers. We will configure auto-refresh (Power BI Service + Power Automate if needed), set up proper access control, and embed the dashboard into your Teams channel. Final delivery will include a fully functional .pbix file with documentation. Questions: ========= Is your SharePoint Excel structured in a single file or multiple files per technology? Do you already have a Power BI workspace set up for publishing? Should row-level security (RLS) be applied for different DBA teams? Any branding/theme guidelines to follow for the dashboard? Best Regards, Srashtasoft Team
₹1,500 INR in 40 days
0.0
0.0

Hello, My name is Suman, and I have 7+ years of experience in Power BI, SQL, and Excel, specializing in building end-to-end business intelligence dashboards. I have hands-on experience working with SharePoint-based data sources, Power Query transformations, and implementing automated reporting solutions. I can efficiently connect your SharePoint-hosted Excel workbook to Power BI, utilize the provided DAX measures, and design all 5 dashboard pages as per your specifications—including KPI cards, slicers, and detailed technology-wise views with proper status tracking and conditional formatting. I will also configure the 30-minute auto-refresh using Power Automate, publish the dashboard to Power BI Service, and embed it into your Microsoft Teams channel with appropriate access controls. I ensure clean design, accurate data representation, and seamless integration so your DBAs and stakeholders can easily monitor patching status in real time. 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
₹1,000 INR in 40 days
0.0
0.0

Hello, I can build your complete Power BI PSU Patching Dashboard with all required pages, visuals, and automation as per your specifications. For your project, I will: Connect Power BI to your SharePoint-hosted Excel data source Create all 5 dashboard pages with proper layout, KPIs, charts, and slicers Implement your provided DAX measures accurately Apply conditional formatting with the required color coding for all statuses Design clean, user-friendly visuals for easy monitoring across technologies Set up auto-refresh (30-minute interval) using Power Automate Publish the dashboard to Power BI Service and embed it into your MS Teams channel I focus on building structured, easy-to-use dashboards that are visually clear and reliable for daily tracking. I am ready to start immediately and can deliver a complete, fully functional dashboard within your timeline. Regards, Nainsi
₹1,100 INR in 20 days
0.0
0.0

Greater Noida, India
Member since Feb 9, 2025
$15-25 USD / hour
₹12500-37500 INR
$10-60 USD
₹400-750 INR / hour
$10-30 USD
₹600-1000 INR
£20-250 GBP
₹750-1250 INR / hour
₹12500-37500 INR
₹600-1500 INR
₹12500-37500 INR
$250-750 USD
£250-750 GBP
$30-250 NZD
₹600-1500 INR
₹600-1500 INR
₹750-1250 INR / hour
$3000-5000 USD
£250-750 GBP
$10-30 USD