Read Before Bidding – Excel + Power BI Internal Audit Gantt Dashboard (Budget Fixed )

$10-30 USD

In Progress

Posted 6 days ago

$10-30 USD

Paid on delivery

Title: Read Before Bidding – Excel + Power BI Internal Audit Gantt Dashboard (Budget Fixed at 0-30 USD) Please read carefully before bidding. I will not be able to increase the budget beyond 30. I need a lightweight Excel + Power BI audit planning system. The Excel file must act as the main planning engine, while Power BI is used only for visualization and dashboard reporting. Main requirements: 1. Excel Structure The workbook should contain: * Audit Master * Governance Dates * Staff Master * Audit Plan The Audit Plan sheet is the core engine and must drive all visuals and timelines. 2. Audit Plan Requirements The Audit Plan must allow: * Audit selection * Staff assignment * Start and end dates * Planning, Fieldwork and Reporting phases * Audit completion percentage (0–100%) * Audit status dropdown (Not Started / Ongoing / Completed etc.) Using: * dropdown selections * expandable tables (no hardcoded ranges) Governance milestones should also use dropdown selections. Most of the system does not require heavy calculations. The key requirement is setting up the relationships and logic properly so the Excel and Power BI visuals update dynamically. Any changes made in the Audit Plan should automatically update the Gantt and Power BI visuals. 3. Governance Milestones Governance dates (SMC-GRC, SMC, GBAC and BAC) must appear clearly in the timeline as milestone/checkpoint markers because audits need to work around these dates. 4. Power BI Dashboard Only 2 pages required: * Page 1: Dynamic Gantt / timeline view * Page 2: Workload summary by auditor, audit type or month Power BI must refresh directly from Excel without manual remapping. 5. Deliverables * Excel workbook * Power BI (.pbix) file * Short guide/video on how to add new audits, staff and governance dates safely Key expectation: The system must remain scalable and continue working properly when new audits, staff or rows are added.

Project ID: 40475498

About the project

8 proposals

Remote project

Active 6 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

Awarded to:

@patricko098

IF YOU'RE NOT HAPPY, DON'T PAY. Recently, I completed a project delivering a fully automated workflow that significantly reduced load times. I’m new to Freelancer but bring extensive experience from large-scale projects, including work alongside tech giants like Microsoft and Google. Your need for a clean, scalable Excel + Power BI audit planning system is clear. I focus on structuring projects right from the start, ensuring simplicity, reliability, and long-term success. Ready to kick off this project. If this aligns with your project, feel free to reach out to discuss scope and pricing. Regards, patricko098

$22 USD in 7 days

5.0

(1 review)

1.1

8 freelancers are bidding on average $23 USD for this job

@sareheshak

AVAILABLE TO START IMMEDIATELY..,,. I will deliver the structured Excel planning engine with expandable tables and the 2-page Power BI dashboard featuring the dynamic Gantt view and workload summary, plus the requested handover guide. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.

$19 USD in 1 day

5.0

(161 reviews)

6.6

@mobimubasir

Hello there, I can build a lightweight Excel + Power BI audit planning system within your fixed $30 budget, with Audit Master, Governance Dates, Staff Master, and a dynamic Audit Plan using dropdowns and expandable tables. I’ll connect the Excel file to a simple 2-page Power BI report with a Gantt/timeline view and workload summary, making sure new audits, staff, and governance milestones refresh without manual remapping. I can also include a short guide showing how to safely add new audits, staff, and dates later.

$30 USD in 1 day

5.0

(49 reviews)

5.3

@rosscarter1011

Hi, I'll set up a dynamic Power Query bridge so your dashboard updates instantly without manual remapping or errors. Having built automated data pipelines for financial projects, I know exactly how to structure the Excel and Power BI architecture to ensure your audits stay perfectly synced and scalable. I'll handle the logic from A to Z, making sure the Gantt and workload views are clean and intuitive. NOTE: To keep this stress-free, you'll get 4 months of free bug-fixing support. I can start on this today and have it ready for you quickly. Let's chat to get this moving.

$20 USD in 3 days

4.9

(18 reviews)

5.0

@InoovativeThink

Hi, I read through your project for Read Before Bidding – Excel + Power BI Internal Audit Gantt Dashboard (Budget Fixed ). You need help with read before bidding – excel + power bi internal audit gantt dashboard (budget fixed ). I can build and deliver this efficiently based on the job requirements. This fits well with my experience in Data Visualization. I can take what you outlined and turn it into a clean final delivery, with attention to Data Visualization and the details in your brief. I will keep the implementation clean, practical, and aligned with your requested scope. Send me the details and I can start immediately.

$10 USD in 1 day

4.3

(6 reviews)

3.9

@codeandcommand

The Gantt tracking piece for internal audits is the part that usually breaks in Excel because audit phases overlap and status changes mid-cycle. I would build the dynamic Gantt in Excel with VBA, then connect it to Power BI so the dashboard updates automatically as audit data changes. Can start today and have a working version ready in 2 days. The bid reflects what is in the description. Want me to send a quick scope doc so we can get moving?

$30 USD in 3 days