Power BI PSU Patching Dashboard Creation

₹750-1250 INR / hour

Closed

Posted about 1 month ago

₹750-1250 INR / hour

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

Excel

Business Intelligence

Project ID: 40370512

About the project

7 proposals

Remote project

Active 30 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

7 freelancers are bidding on average ₹1,093 INR/hour for this job

@Appworldz

Hi, Sahanaj here. I’ve built similar enterprise ops dashboards on Power BI + SharePoint/Teams with automated refresh. Your hourly range works; I estimate 35–45 hours (₹30K–₹45K) for full build, including data model optimization, 5 pages, color logic, and 30-min refresh via Power Automate. I’ll ensure <3 sec performance, clean UX, and seamless Teams embedding with proper access control. One question: is your SharePoint Excel structured as proper tables (not ranges) across all sheets for stable refresh?

₹2,500 INR in 40 days

5.0

(6 reviews)

4.6

@JeyamSurace333

Hi ji, I have carefully reviewed your Power BI PSU Patching Dashboard requirement and fully understand the scope of work. I am a Indian 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

₹750 INR in 20 days

5.0

(5 reviews)

2.7

@sudhir0112

Hello, I’ve built Power BI dashboards with KPI tracking, multi-page layouts, and SharePoint-based data, so this project aligns well with my experience. I can connect your SharePoint Excel file, implement the provided DAX measures, and build all 5 dashboard pages with clear KPIs, filters, and status-based visuals. I will ensure clean conditional formatting, fast performance, and a user-friendly design for easy navigation. I’m also comfortable publishing to Power BI Service, setting up scheduled refresh, and embedding the dashboard in MS Teams. Quick question: is the data already clean, or will some transformation be required? I can deliver this within 4–5 days. Best regards, Sudhir

₹750 INR in 40 days

5.0

(2 reviews)

2.0

@nainsis08

I build enterprise-grade Power BI dashboards with automated SharePoint integration—connecting your Excel data, implementing pre-written DAX, and delivering fully interactive, color-coded dashboards with seamless 30-minute auto-refresh via Power Automate. I’ll handle end-to-end setup, publishing to Power BI Service, and embedding in Teams with proper access control. Let’s get your PSU dashboard live—share access and I’ll deliver a working first version quickly ??

₹800 INR in 25 days

0.0

(0 reviews)

0.0

@Sadiyasyeda24

Hello, I understand the task and will ensure your expectations are me. I am a skilled freelancer with 4 years of experience in Data Visualization, Automation. See my profile for recent work. Let's connect in chat to discuss more. Thanks, Syeda Tahreem

₹750 INR in 40 days

0.0

(0 reviews)

0.0

@deepak59

Hello, I’m Suman, a Power BI Developer with 7+ years of experience in building end-to-end BI dashboards and integrating data from SharePoint, Excel, and Microsoft 365 environments. I have carefully reviewed your PSU Patching Dashboard requirements and can confidently deliver all 5 pages with accurate data modeling, slicers, KPI cards, and conditional formatting as specified. I have strong experience in connecting Power BI to SharePoint-hosted Excel files, implementing pre-written DAX measures, and setting up automated refresh using Power Automate to ensure real-time updates without manual intervention. I will also handle publishing to Power BI Service and embedding the dashboard into Microsoft Teams for seamless team access. ✅ Skills: ✔ Data Analysis ✔ Data Modeling ✔ Dashboard Development ✔ Data Visualization ✔ Business Intelligence ✔ ETL & Data Transformation ✅ Tools & Technologies: ✔ Power BI Desktop ✔ Power Query ✔ DAX (Implementation) ✔ SQL ✔ Power Automate ✔ Microsoft 365 / SharePoint / Teams Integration I am confident in delivering a clean, scalable, and fully automated dashboard solution aligned with your requirements, including .pbix delivery for future use. I would be happy to discuss your project in detail and start immediately. Let’s connect and bring your dashboard to life. Thanks & Regards, Suman

₹1,000 INR in 40 days

0.0

(0 reviews)

0.0

@Smarty613

I've built Power BI dashboards connected to SharePoint-hosted Excel files before, so this workflow is familiar. Your spec is detailed and well-organised — the fact that the 19 DAX measures are already written makes this straightforward to implement cleanly. I'll connect Power BI Desktop to your SharePoint source, build all 5 pages per your spec with the required conditional colour coding, configure the 30-minute refresh via Power Automate, publish to the Power BI Service, and pin it as a Teams channel tab. You'll get the .pbix file too. Two days is enough. Can you confirm the SharePoint site URL and whether the team is on a Power BI Pro or Premium Per User licence?

₹1,100 INR in 2 days