
Closed
Posted
Paid on delivery
I have a locally stored Excel workbook that contains a financial-data Pivot Table. My goal is to move away from the static worksheet and make the figures available inside Power BI so I can build live dashboards and share them company-wide. Here’s what I need from you: • Take the existing Pivot Table and restructure the underlying data model so it works cleanly in Power BI—preferably in a star schema where possible. • Preserve every measure, calculated field, and filter currently used in the Excel view, translating them to DAX if required. • Deliver a Power BI file (.pbix) that automatically refreshes from the updated Excel source, along with concise documentation outlining the data-refresh steps. Acceptance will be based on side-by-side comparisons confirming that totals, subtotals, and calculated ratios match the original Pivot Table exactly. If you have experience migrating Excel financial models into Power BI and are comfortable writing DAX, this should be straightforward. I’m ready to share the workbook as soon as we agree on timing, so let me know how quickly you can turn it around.
Project ID: 40440079
14 proposals
Remote project
Active 6 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average ₹3,421 INR for this job

Hello, my name is Osama. I specialize in Power BI and Excel data modeling. For your project, I can restructure the existing Pivot Table into a clean star‑schema model that works seamlessly in Power BI. All measures, calculated fields, and filters currently used in Excel will be preserved and translated into DAX where required, ensuring the results match your original view exactly. Deliverables will include a Power BI (.pbix) file connected to your Excel source with automatic refresh, plus concise documentation outlining the refresh steps. Acceptance will be confirmed through side‑by‑side comparisons of totals, subtotals, and ratios against the original Pivot Table. Before starting, I’d like to review the workbook to confirm the current structure and logic. Once I have that, I can provide a clear turnaround estimate and begin promptly.
₹30,000 INR in 8 days
4.1
4.1

As a Certified Chartered Accountant with a solid background in Accounting and Financial Management, I believe I am uniquely qualified to tackle your pivot-to-Power-BI project. Meticulousness combined with an appreciation for strategy characterizes my work ethic. With every endeavor, my aim is not solely to complete a task but to also deliver peace of mind. Through years of experience in bookkeeping and invoicing, I've honed a precision that will ensure your figures remain intact throughout the migration process. Additionally, I'm already expanding into data analytics as a means of uncovering trends and strategies; empowering me with the skills needed to transform your large dataset into actionable insights for your business. In terms of technical proficiency, I am astute in Excel, Power BI, and data manipulation which are essential for successfully undertaking this task. My familiarity with DAX (Data Analysis Expressions) will enable me to preserve each measure, calculated field, filter and translate them appropriately while restructuring the underlying data model to work optimally within Power BI. If giving you clarity and strategy is what you desire from this project while avoiding costly mistakes, then it's no doubt you need my professional assistance. So let's get this started!
₹1,500 INR in 1 day
3.4
3.4

Hi, My name is Ali and I can migrate your financial model into Power BI for you. I have extensive experience refactoring complex Excel workbooks and pivot tables into structured Power BI data models, specifically for financial reporting and business analysis. My Approach Data Restructuring: I will transform your flat pivot data into a professional star schema using Power Query. This ensures your model is optimized for performance and company-wide sharing. DAX Translation: I will translate every calculated field and ratio from your current pivot table into precise DAX measures. My background in software engineering and data analysis ensures that these calculations will remain logically sound and accurate. Validation: I will perform a side-by-side reconciliation to ensure that every total and subtotal in the .pbix file matches your original Excel workbook exactly. I can complete this migration and provide the refresh documentation within 24 to 48 hours once you share the workbook.
₹1,050 INR in 7 days
3.2
3.2

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹3,000 INR in 7 days
2.4
2.4

Hi , You need an expert in Power BI, Excel VBA, Visual Basic, Financial Analysis, Excel, Business Intelligence and Excel Macros, and I have a tailor-made solution ready for you. Your project brief instantly reminded me of a recent client who faced similar challenges, and I know exactly how to execute this flawlessly for your specific needs. To ensure we hit the ground running, I have three quick questions: Are there any additional technical details or constraints not mentioned in the brief? What is the primary hurdle currently blocking your progress on this? What is your strict timeline for completion? Why trust me with your project? The Record: 250+ Projects. 6+ Years. 100+ consecutive 5-star reviews. The Standard: Zero misses. I don’t just finish the job; I guarantee flawless execution. The Availability: Full-time freelancer, online 9 AM - 9 PM EST. My biggest "heavy-hitter" projects are kept off my public portfolio to protect client confidentiality. Click 'CHAT', and I’ll immediately send over relevant, private samples so you can see the standard of my work firsthand. Best regards, Muhammad Arsalan
₹600 INR in 6 days
2.1
2.1

Hello, Yes, I’m confident I can migrate your Excel financial Pivot Table into a clean and fully functional Power BI solution. I have experience working with Excel financial models, Pivot Tables, Power Query transformations, DAX calculations, and Power BI dashboard development for reporting and business analysis. I can restructure the underlying data into an optimized model, preferably using a star schema where appropriate, while preserving all existing measures, calculated fields, filters, subtotals, and financial ratios from the original Excel setup. My focus will be on ensuring that all Power BI calculations match the existing workbook accurately through detailed validation and side-by-side comparison checks. The final delivery will include a fully functional .pbix file with automatic refresh from the Excel source, organized tables and measures, and concise documentation explaining refresh setup and workflow usage. I’m available to start immediately once the workbook is shared and look forward to working with you.
₹1,000 INR in 5 days
2.0
2.0

You want to migrate your existing Excel financial Pivot Table into Power BI while preserving all calculations, filters, subtotals, ratios, and reporting logic exactly as in the original workbook. also want a structured Power BI data model with automatic Excel refresh, DAX conversion for calculated fields, accurate financial validation, and proper documentation for future refresh management RIGHT? I have 4+ years experience in Power BI, DAX, Excel financial modeling, Power Query, SQL, and business intelligence reporting. In addition to your project needs, I'll provide you with clean source code, free bug patches, and maintenance. I am awaiting your positive response. Regards, Ritesh
₹600 INR in 7 days
0.3
0.3

I’ve worked on similar Excel-to-Power BI migration projects before, especially financial Pivot Table models that needed to be converted into scalable Power BI datasets with accurate DAX replication. The important part here is not just importing the Excel file—it’s rebuilding the logic properly so the Power BI model remains accurate, refreshable, and performant. What I’ll do: • Analyze the existing Pivot Table structure: source tables relationships calculated fields filters/slicers financial ratios • Restructure the model for Power BI: clean Power Query transformations star-schema design where appropriate optimized relationships for performance • Rebuild calculations in DAX: measures calculated ratios subtotal logic filter-context behavior matching Excel • Configure automatic refresh from the Excel source • Validate outputs: side-by-side reconciliation with the original Pivot Table totals/subtotals verification ratio consistency testing Deliverables • Fully working .pbix file • Clean data model + DAX measures • Refresh-ready Excel connection • Documentation for refresh and maintenance Focus Areas Exact calculation matching Financial-model accuracy Scalable Power BI structure Fast report performance Once I review the workbook, I can usually turn around the first working version quickly.
₹1,050 INR in 7 days
0.0
0.0

Hello, Your project is interesting because it focuses on something many businesses struggle with — moving from static Excel Pivot Tables to a structured and scalable Power BI reporting model without losing calculation accuracy. I can help you convert your existing Excel financial Pivot Table into a clean Power BI solution while preserving all measures, calculated fields, filters, and ratios from the original workbook. My approach will include: • Restructuring the Excel data into a proper reporting model (star schema where suitable) • Recreating Pivot calculations and logic using DAX • Building a refresh-ready Power BI (.pbix) file connected to the Excel source • Validating totals and subtotals through side-by-side reconciliation Deliverables: ✔ Power BI (.pbix) file ✔ DAX measures and clean data model ✔ Refresh instructions/documentation ✔ Accurate replication of Excel calculations I have experience working with Power BI, Excel financial reporting, and DAX-based modeling, with a strong focus on keeping reports reliable, organized, and easy to maintain. I have 3+ years of experience in Power BI, data modeling, and business analytics, along with Microsoft certifications including PL-300 and DP-600. Estimated timeline: • Initial working version: 2 days • Final delivery: 3 days Best regards, Usama Mehmood
₹1,200 INR in 3 days
0.0
0.0

Hi, I can migrate your Excel Pivot Table into Power BI and rebuild the model so your financial figures stay accurate and refreshable. I’ll review the workbook, structure the data cleanly in Power BI, and translate any measures, calculated fields, and filters into DAX where needed. My focus will be on matching totals, subtotals, and ratios exactly against the existing Pivot Table. I can also set up the Power BI file to refresh from the Excel source and provide concise documentation for the refresh steps and model structure. I’m comfortable working with Excel-based financial models and making them dashboard-ready in Power BI. If possible, please share the workbook and I’ll confirm the fastest turnaround after reviewing the model.
₹1,350 INR in 7 days
0.0
0.0

Hi, I am interested in assisting with your Excel to Power BI migration project. I have experience working with structured data, Excel spreadsheets, SQL, and data processing, and I am comfortable handling Pivot Table-based datasets and transforming them into organized reporting structures. I understand the importance of preserving measures, calculated fields, filters, totals, and ratios accurately while migrating the existing Excel model into Power BI. I can carefully restructure the data model for better reporting and assist with refresh configuration and documentation as required. I also have a technical background in data management and analysis, which helps me work efficiently with data validation and consistency checks. Although I am new on Freelancer, I am detail-oriented, responsive, and committed to delivering accurate work within the agreed timeline. I would be happy to review the workbook and begin as soon as it is shared. Thank you.
₹1,200 INR in 5 days
0.0
0.0

As a data expert, I will deliver a flawless master sheet with 100% accuracy. I am highly motivated to excel in this project to secure the income and build a long-term professional relationship, so I guarantee maximum attention to detail and a perfect result. My priority is providing high-quality work that exceeds your expectations.
₹3,050 INR in 4 days
0.0
0.0

Hi — I can help with Excel Pivot to Power BI. Hi, I can help complete the spreadsheet with company website, CEO first/last name, and headquarters in the exact City, Country format requested. I'll follow the first-Google-result rule strictly, use N/A where the requested data is not present, and return the completed file in the same row order. Quick question: how many companies are in the spreadsheet?Completion: With extensive knowledge and experience in data processing, I can effectively restructure your Excel Pivot Table and migrate it to Power BI, ensuring a clean layout that aligns with a star schema. My proficiency in DAX calculations guarantees that your measures, calculated fields, and filters will be accurately translated into Power BI. Additionally, I'll provide a Power BI file along with a detailed documentation highlighting the steps required for data-refresh. Apart from offering my core skills of automation, scripting and data cleanup, I bring along a deep understanding of Python scripts, Google Sheets / CSV clean-up, web scraping and more which can be valuable for your project. My goal is to provide swift and reliable results tailored specifically to your needs – let’s leverage my expertise to transform your financial-data Pivot Table into interactive dashboards in Power BI!
₹800 INR in 7 days
0.0
0.0

Delhi, United Kingdom
Member since May 13, 2026
₹12500-37500 INR
₹100-400 INR / hour
$10-30 USD
₹12500-37500 INR
₹750-1250 INR / hour
$30-250 USD
₹750-1250 INR / hour
₹600-1500 INR
$250-750 USD
₹12500-37500 INR
₹750-1250 INR / hour
$30-250 USD
$10-30 USD
₹750-1250 INR / hour
₹600-1500 INR
₹1250-2500 INR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
₹400-750 INR / hour
$8-15 USD / hour