Excel Data Cube Specialist

₹750-1250 INR / hour

Closed

Posted 7 days ago

₹750-1250 INR / hour

I need an Excel expert to build a data cube using financial data. The primary purpose of this data cube is for financial reporting. Key Tasks: - Data Analysis: Transform financial data into a structured data cube. - Complex Formulas: Create and implement advanced formulas to ensure accurate data representation. - Automating Tasks with Macros: Develop macros to automate repetitive tasks for efficiency. Ideal Skills & Experience: - Proficiency in Excel, especially with data cubes, complex formulas, and macros. - Strong background in financial data analysis. - Experience in financial reporting. Please provide examples of similar work done.

Visual Basic for Apps

Project ID: 40405937

About the project

5 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

5 freelancers are bidding on average ₹960 INR/hour for this job

@ShivaniGoyalsai

Hi, I specialize in building **advanced Excel-based financial reporting models, data cubes, and VBA-driven automation solutions** for business-critical reporting. With strong experience in **financial data analysis, complex formula architecture, Power Query, and macro automation**, I can develop a robust and scalable data cube that delivers accurate, audit-friendly reporting and significantly reduces manual effort. I have previously delivered finance reporting dashboards, automated MIS workbooks, and high-volume reporting models for ongoing business use. I’d be happy to share relevant examples. I’m confident in providing an expert-level solution that supports both immediate reporting needs and long-term scalability. Thanks Shivani

₹1,000 INR in 40 days

4.8

(48 reviews)

4.7

@Web1devloper

As an Excel savant with over 8 years in data analytics, I am deeply experienced in constructing advanced yet interpretive reports that align precisely with your requirements. My proficiencies lie in analyzing financial data and translating it into a structured data cube to facilitate your financial reporting efforts. Complex formulas for accurate representation? Macros to streamline repetitive tasks? I'm your guy! Moreover, my skill set extends far beyond Excel. I couple my Advanced Excel prowess with an extensive background in multiple platforms, including Power BI, Looker, SQL, Python, and big data. This comprehensive stack allows me to build end-to-end data solutions from Input to Insight. Finally, let me share some instances of my past work: I've built scalable and interactive dashboards on Power BI/Tableau/Looker for multiple clients that have streamlined both their financial reporting and strategic decision-making processes. From financial forecasting models to maintaining historical trends in real estate, these projects had a broad span but all demanded the same careful handling of data that you need. Choose me for this project, and together we'll unravel the true potential of your financial data!

₹1,000 INR in 40 days

5.0

(5 reviews)

3.8

@Sahyadri96

@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.

₹1,000 INR in 40 days

5.0

(5 reviews)

2.8

@Sarsimbek

Hello, I can build the Python automation for your PDF merge and indexing workflow. From your description, the key part is not only merging PDFs, but reliably reading the underscore-separated filename segments such as PO number, serial number, date, work order, heat number and calibration date, then writing those values into the correct fields on the existing index/cover page before creating one master PDF. My proposed approach: - Parse each filename into structured fields with validation checks - Populate the index/cover page fields using Python PDF libraries such as pypdf, PyMuPDF or reportlab depending on the structure of your PDF - Merge the updated PDFs in the required order - Save the final master PDF into the defined OneDrive/SharePoint folder - Provide clean, commented Python code, a dependency list and a README - Include a short demo showing filename → field population → merged output file I have strong experience with Python automation, structured data handling and document-style workflows. I would also make the script easy to call from Power Automate or Power Apps, for example via command-line parameters or a simple API trigger. One question: is the index/cover page an AcroForm PDF with fillable fields, or should the values be written visually onto fixed positions on the page? Best Regards Sergej W.

₹800 INR in 40 days