Inventory Consolidation & Dashboard Creation

₹600-1500 INR

Closed

Posted 9 days ago

₹600-1500 INR

Paid on delivery

Need Excel + Power Query Expert for Inventory Dashboard (Pen Drive Based System) Project Overview: I run a manufacturing business and maintain stock in multiple Excel files (7–10 files), each for different categories like motors, inverters, pumps, etc. These files are stored in a folder on a pen drive. I need a simple, reliable system to view consolidated stock in one place without manually opening multiple files. Constraints (VERY IMPORTANT): * All files will remain on a pen drive (no cloud solutions like OneDrive or Google Drive) * Folder path will remain fixed (example: E:\Stock_Files) * I will only open ONE master Excel file (no need to open individual files) * System must work offline * Must be simple to use (non-technical staff) Requirements: 1. Use Power Query (“From Folder”) to automatically combine all Excel files in the folder 2. Standardize data into columns: * Item Type * Item Name * Size, Brand, * Stock Quantity . Clean and transform inconsistent formats across files . Replace blank/null stock values with 0 . Create a clear dashboard view: * Table or Pivot Table * Filters for Item Type and Size . Enable auto-refresh: * Data refresh when file is opened * Optional: refresh every 1–5 minutes 8. File should NOT break if: * New files are added to folder * Existing files are updated 9. Keep solution lightweight (no macros unless absolutely necessary) Deliverables: * Final Excel file ([login to view URL]) – ready to use * Power Query properly configured * 1-page instruction guide (very simple) * Optional: basic color indicators (low stock, zero stock) Nice to Have (optional, if easy): * Simple QR code or shortcut method to open master file quickly on system * Clean, professional layout What I will provide: * All sample Excel files * List of all item categories * Example of sizes Goal: A plug-and-play system where I just insert pen drive, open one Excel file, and see latest stock instantly. Can get on a call for clarity. Timeline: Prefer quick turnaround (2-5 days)

Project ID: 40368967

About the project

7 proposals

Remote project

Active 3 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,171 INR for this job

@ShivaniGoyalsai

Hi I have 15+ years of experience in Excel VBA and business intelligence including working in power query , power pivot and building interactive dashboards. I can consolidate all your files data in to one master file . I will develop a centralized Excel-based system that will: Automatically fetch data from all category files in your folder Consolidate stock into one master dashboard Provide real-time updates when source files are updated Work directly from your pen drive (no installation required) Thanks Shivani

₹1,500 INR in 7 days

4.8

(51 reviews)

4.7

@PetrusLubbe

‼️ONLY PAY WHEN YOU’RE 100% HAPPY‼️ I see you need a seamless, offline Power Query solution that consolidates multiple category files from a fixed pen drive folder into one master Excel file—key for fast, reliable stock visibility without manual file handling. I’ll set up a robust “From Folder” query that cleans data inconsistencies, fills blanks with zeros, and builds a lightweight dashboard with filters and auto-refresh on open. The system will auto-adapt when files are added or updated, keeping things simple for non-technical users. While I’m new to Freelancer, I’ve done similar offline inventory dashboards that deliver exactly this plug-and-play ease and clarity. Let’s chat! Worst case, you get a free consultation and real insight. Pietie Lubbe

₹1,150 INR in 14 days

0.0

(0 reviews)

0.0

@yogeshs124

I have extracted transformed data with the help of power query, I have done append and merge in power query I am the right guy to execute above task

₹1,050 INR in 7 days

0.0

(0 reviews)

0.0

@sergiyb56

Hello! I have read your requirements carefully, and I can build this consolidated stock system using Power Query as the core engine. Since your files are on a Pen Drive, I will implement a dynamic file path solution so the system won't break if the drive letter (E:, F:, G:) changes on different computers. My plan for your project: Robust Data Cleaning: I will set up Power Query to automatically handle nulls, standardize columns (Item Type, Size, Brand), and merge all 7–10 files instantly. Zero-Maintenance: You only need to add new files to the folder or update existing ones—the Master file will handle the rest upon opening. Non-Technical Dashboard: I will create a clean UI with visual Slicers (filters) and Conditional Formatting to highlight low/zero stock.

₹1,050 INR in 2 days