
Closed
Posted
Paid on delivery
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: 40367681
12 proposals
Remote project
Active 4 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
12 freelancers are bidding on average ₹25,958 INR for this job

Hello, I will connect Power BI to your SharePoint hosted Excel files to build the five required dashboard pages. I will implement the summary view with the six specific KPIs and the individual technology pages for Oracle, PostgreSQL, and YugabyteDB as described. I will apply the mandatory color coding for each status and integrate the nineteen pre written DAX measures into the model. To meet the refresh requirement I will set up a cloud flow to trigger updates every thirty minutes. Finally I will publish the report to your workspace and embed it as a tab in your Microsoft Teams channel for easy access. 1) Do you have the specific cloud automation environment ready for the refresh flow? 2) Are there any custom icons or logos I should include on the summary page? 3) Do you have the workspace permissions set up for publishing and Teams embedding? Thanks, Bharat
₹35,000 INR in 12 days
4.5
4.5

Hi, I reviewed your PSU patching dashboard requirement and the structure you’ve already prepared. Since your data model, DAX measures, and sheet separation are already in place, this can be implemented into a clean, automated Power BI solution efficiently. Here’s how I would approach it: Connect Power BI directly to your SharePoint Excel (auto-sync with DBA updates) Build all 5 pages with structured layouts (summary → technology drilldowns → issues tracking) Implement your existing DAX measures and ensure accuracy across all views Apply strict status-based color coding for consistency and readability Configure scheduled/automated refresh (aligned with your 30-min requirement) Publish to Power BI Service and embed in Teams for seamless team access Why I’m a strong fit: Strong experience with Power BI dashboards and KPI-driven reporting Hands-on with SharePoint/Excel data integration Focus on clean layouts + real-world usability (not just visuals) Practical approach to automation and deployment A couple of quick clarifications: Do you have Power BI Pro or Premium (for refresh frequency)? Is the SharePoint file structure finalized or still evolving? Should access control be role-based or simple read/edit split? I can deliver a clean, production-ready dashboard that your DBAs can rely on daily. — Deepanshu
₹25,000 INR in 7 days
3.9
3.9

Hi, This is a well-structured project, and I can confidently support you in building a clean, fully functional Power BI dashboard aligned with your specifications. I can help you with: * Connecting Power BI to your SharePoint Excel and structuring the data model correctly * Building all 5 dashboard pages with clear layout, slicers, and KPI tracking * Implementing your existing DAX measures and validating results * Applying consistent conditional formatting and status color coding * Publishing to Power BI Service and embedding in Microsoft Teams I’m experienced in building structured, multi-page dashboards and ensuring they are clear, reliable, and easy for teams to use daily. For the refresh setup, I will configure the best possible approach based on your environment (Power BI Service / Power Automate) to ensure smooth and consistent updates. Happy to start immediately and support you through the full setup and handover. PS: Please feel free to review my portfolio for similar Power BI work samples. Regards, Maya
₹18,000 INR in 6 days
1.4
1.4

Hi! I noticed your project 'Power BI PSU Patching Dashboard Creation -- 2' and believe I'm the right person for it. I have relevant experience and can start immediately. My focus is always on understanding your exact needs first, then executing efficiently. Feel free to review my profile and let's discuss!
₹22,500 INR in 7 days
0.0
0.0

Hi, I have read your project details and I get what you need. I am a skilled freelancer with 4 years of experience in Data Visualization, Automation. Check my profile for portfolio and reviews. Looking forward to your reply. Thanks, Syeda Tahreem
₹25,000 INR in 7 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
₹25,000 INR in 7 days
0.0
0.0

Hello, I can build your complete Power BI PSU Patching Dashboard exactly as per your specifications, ensuring accuracy, automation, and a clean, user-friendly design. I will: Connect Power BI Desktop to your SharePoint-hosted Excel data Create all 5 dashboard pages with KPIs, charts, slicers, and detailed views Implement the provided DAX measures correctly Apply required color coding using conditional formatting across all visuals Set up 30-minute auto-refresh using Power Automate or scheduled refresh Publish to Power BI Service and embed it into your MS Teams channel Deliver the final .pbix file for future use I focus on building structured, easy-to-understand dashboards that are reliable and ready for daily use without manual effort. I am ready to start immediately and can deliver within your timeline. Regards, Nainsi
₹25,000 INR in 7 days
0.0
0.0

Dear Hiring Manager, Hi! I am Gabriella Siska with 14 years of professional experience specializing in Business Intelligence. I have quite similar implementation when I spent 8 years at Sinarmas Pulp & Paper (the leading manufacturing industry in Indonesia), where I implemented end-to-end data pipeline including integrating data from SharePoint and SAP into SSIS, feeding the output into SQL view, creating comprehensive Power BI dashboards, and maintaining data integrity. I hope I will be a good fit to this project. I am open any opportunities to discuss how my background align with this role. Best Regards, Gabriella Siska
₹35,000 INR in 14 days
0.0
0.0

Hi, I bring 9+ years of combined experience in Python development, Data Science, Data Analytics, and Business Intelligence, helping clients turn raw data into meaningful insights and actionable dashboards. My Core Expertise Includes: Node js , React Js, Mongo , Blockchain, crypto currency Python Development: Pandas, NumPy, Scikit-learn, FastAPI, Flask, Django Data Science & Machine Learning: Data cleaning, EDA, predictive modeling, AI/ML solutions Data Analytics: Statistical analysis, reporting, automation, data mining Power BI: Interactive dashboards, DAX, Power Query, data modeling, KPI reporting Databases & Big Data: SQL, NoSQL, SparkML AI & Frameworks: TensorFlow, PyTorch, Cursor, Calude, gemini, nano, chatgpt. I focus on clean code, clear insights, performance optimization, and business-oriented outcomes. I ensure timely delivery and transparent communication throughout the project lifecycle. Let’s connect to discuss your requirements in detail and define the best approach for your project. Looking forward to working with you. Regards, Anju Logical Soft Tech Pvt Ltd, Indore(M.P)
₹25,000 INR in 7 days
0.0
0.0

Hey! I saw your project brief and this is right in my wheelhouse — Power BI with a SharePoint-connected Excel source, scheduled refresh, and DAX measures already set up. Quick plan: connect to your MS Teams SharePoint workbook, build the patching dashboards for Oracle, PostgreSQL, and YugabyteDB using the Master Footprint as the source, configure the 30-minute auto-refresh via Power BI Service, and deliver a clean, filterable dashboard your team can actually use day-to-day. Can turn this around in 2 days. One question — do you need Row-Level Security (RLS) on the dashboard, or is it open access for all viewers?
₹14,000 INR in 2 days
0.0
0.0

Alipurduar, India
Member since Jan 9, 2024
₹37500-75000 INR
$2-8 CAD / hour
$3000-5000 USD
$30-250 USD
$10-30 USD
€750-1500 EUR
$10-30 USD
$250-750 USD
$10-30 USD
₹400-750 INR / hour
₹600-1500 INR
$1500-3000 USD
₹750-1250 INR / hour
€8-30 EUR
$10-30 USD
$250-750 USD
£10-15 GBP / hour
₹1500-12500 INR
₹600-1500 INR
$30-250 USD