
Open
Posted
•
Ends in 2 hours
I need a repeatable Python workflow that connects to my external databases, gathers the required tables, and pushes the refreshed data into Excel while immediately producing data visualisation sheets. The script must: • Open a secure connection to the databases using supplied credentials • Query the specific tables I outline and perform any light cleaning with pandas • Write the results to a new or existing workbook through openpyxl / xlsxwriter • Generate the visualisations right inside the file—charts and graphs that update every time the script is run I will supply a small sample of the database structure and an Excel template so you can mirror my formatting. The end-to-end run should complete with a single command or scheduled task, with all libraries clearly documented in a [login to view URL] file. Acceptance is straightforward: if I can point the script at my database, run it without manual edits, and receive an updated Excel workbook containing the refreshed data plus the visualisations in their assigned sheets, the job is done.
Project ID: 40463310
26 proposals
Open for bidding
Remote project
Active 15 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
26 freelancers are bidding on average ₹1,868 INR/hour for this job

Hello, I trust you're doing well. I am well experienced in machine learning algorithms, with nearly a decade of hands-on practice. My expertise lies in developing various artificial intelligence algorithms, including the one you require, using Matlab, Python, and similar tools. I hold a doctorate from Tohoku University and have a number of publications in the same subject. My portfolio, which showcases my past work, is available for your review. Your project piqued my interest, and I would be delighted to be part of it. Let's connect to discuss in detail. Warm regards. please check my portfolio link: https://www.freelancer.com/u/sajjadtaghvaeifr
₹2,875 INR in 40 days
7.2
7.2

With over 7 years of experience, I am well-versed in Python and its various libraries like Pandas, openpyxl, and xlsxwriter. I have a deep understanding of data processing and analytics, specializing in applying AI algorithms to derive actionable insights. Your project aligns perfectly with my skill set and there's no doubt that I can deliver exactly what you need. Finally, in terms of collaboration, your satisfaction is my utmost priority. We will work together to ensure that this automated workflow achieves everything you require. Plus, your single-command or scheduled-task requirement won't be an issue as I'm adept at creating user-friendly systems which are easy to implement and run. Let's connect the dots between your databases and Excel visualizations; hire me now and I promise excellent results!
₹1,250 INR in 40 days
6.2
6.2

Hi, we are a team of 20+ AI/ML Engineers based in Delhi - have completed 300+ projects with 100% client satisfaction & long term association. As a seasoned AI specialist, I possess an in-depth understanding of Python and its applications in automation. In addition, my expertise in Machine Learning perfectly aligns with the task at hand, as it emphasizes data management, transformation, and visualization – key components for this project. My comprehensive knowledge and experience in using libraries like Pandas to extract data from various sources, including databases, and Openpyxl for writing data into Excel workbooks will be greatly beneficial. Moreover, I have successfully built automated workflows that cater to similar needs as yours- efficient data extraction processes connected to external databases. One such triumph is developing an AI-based inventory management system for a major retail client to automate their entire supply chain process. This project allowed me to strengthen my skills and familiarity with coordinating secure database connections while effectively cleansing data for analysis.
₹1,800 INR in 40 days
3.8
3.8

@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,500 INR in 40 days
3.3
3.3

Hi! I'm Sudhir Jain — MIT graduate, Data Analyst & Python specialist with strong Excel skills. I can automate your data visualization workflows using Python (matplotlib, seaborn, plotly) + Excel/openpyxl to generate beautiful, automated reports and charts. My Computer Vision Nano Degree and ML expertise make me proficient in Python data pipelines. 100% on-time!
₹1,875 INR in 40 days
3.2
3.2

Hello, I hope you are doing well. I have carefully reviewed your project description and I'm confident that I can deliver high quality work that meets your expectations. I have experience in this field and pay close attention to detail, accuracy and timely delivery What I offer: High quality and original work. Strict adherence to instructions Timely delivery Clear and professional communication Willingness to revise until you are satisfied I understand the importance of this project and will ensure it is handled with professionalism and care. I'm ready to start immediately and can provide samples of my previous work if needed. Let's discuss more about your project, so I can get started right away. Thank you for your time and consideration.
₹1,250 INR in 1 day
3.1
3.1

Hi, I see the challenge here—you need a reliable, repeatable workflow that pulls data from your databases and surfaces it directly in Excel with visualization. The "-- 2" tells me you're iterating on something that already exists, which means I should understand what's working and what needs adjustment. I'll build this with openpyxl and pandas for Excel output, connecting via SQLAlchemy to abstract your database layer so the workflow adapts to schema changes without constant rewrites. For the visualization piece, I'll use Excel's native pivot tables and conditional formatting—no heavy external libraries—to keep your reports lightweight and maintainable. The workflow will be parameterized so you can trigger it with different date ranges or database queries without touching code. First 24 hours: I'll need your database schema (or a sample query), the specific Excel tabs you need populated, and the visualization requirements. Once I confirm scope, I can have a working prototype of the full pipeline ready by day 3. Should we lock down those database details first? Best regards, Val
₹1,250 INR in 7 days
2.3
2.3

Hi, Drop me a message — I'll share a quick prototype based on what I understood. If it matches your expectations, we can move forward. Thanks!
₹1,875 INR in 40 days
0.8
0.8

Hi, I can help with a repeatable Python workflow that refreshes your database tables and outputs an Excel workbook with charts/graphs updated automatically each run. I’ll start by using your sample schema and Excel template to map table queries, light pandas cleaning, and exact sheet/format targets, then implement the connection, Excel writing, and chart generation. To reduce risk, I’ll make the run a single command or scheduled task and keep all steps configurable and easy to review. Which external database type should I connect to, and which tables do you want mirrored into which Excel sheets? If you share your template and table list, we can confirm the mapping and get the script ready.
₹1,650 INR in 3 days
0.0
0.0

Lalitpur, India
Member since Jul 31, 2023
₹750-1250 INR / hour
$800-900 USD
$2-8 USD / hour
$60-100 USD / hour
₹400-750 INR / hour
₹1250-2500 INR / hour
₹750-1250 INR / hour
₹400-750 INR / hour
$15-25 CAD / hour
$10-30 USD
$10-30 USD
$2-5 USD / hour
$500-1500 USD
₹750-1250 INR / hour
₹1250-2500 INR / hour
₹400-750 INR / hour
$10-30 USD
₹400-750 INR / hour
$250-750 USD
₹750-1250 INR / hour