I will automate your data reporting workflow using python
AI Data Automation Specialist I Dashboards, Python, SQL, Streamlit, R
About this Gig
I will automate repetitive data tasks using Python so you can save time and reduce manual work.
I can build scripts that clean files, merge datasets, calculate metrics, generate charts, export reports, or prepare data for dashboards. I can also help structure simple ETL workflows for CSV, Excel, SQL, and JSON data.
This gig is best for recurring reports, business metrics, operational data, research workflows, and dashboard preparation.
Technology:
Apache Spark
•
Excel
•
MATLAB
•
Python
•
RStudio
•
VBA
My Portfolio
FAQ
What kind of data tasks can you automate?
I can automate repetitive tasks such as cleaning files, merging datasets, calculating metrics, generating charts, creating reports, exporting results, preparing dashboard-ready data, and processing CSV, Excel, SQL, or JSON files.
What do I need to provide before you start?
Please provide the files or data source, a clear description of the manual process you want automated, the desired output format, and any examples of the final report or file you currently use.
Can you automate Excel or CSV reports?
Yes. I can create Python scripts that clean, transform, combine, and summarize Excel or CSV files. I can also generate updated output files, charts, or summary reports.
Can you work with databases?
Yes. I can work with SQL databases such as PostgreSQL, MySQL, and SQLite. I can write queries, join tables, aggregate metrics, and prepare outputs for reporting or dashboards.
Will I be able to run the automation myself?
Yes. I can provide clear setup instructions and organize the script so you can rerun it with new files. For larger projects, I can also include documentation explaining the workflow.
Can the script generate charts or reports automatically?
Yes. The automation can generate charts, summary tables, cleaned files, PDF/HTML reports, or dashboard-ready outputs depending on your package and requirements.
Can you fix or improve an existing Python script?
Yes. I can debug, clean up, optimize, or extend an existing Python automation script. Please send the current script, sample input files, the error message if applicable, and the expected output.
What file formats can you work with?
I can work with CSV, Excel, JSON, TXT, SQL exports, and structured datasets. For unusual formats, please message me first so I can confirm compatibility.
Do you provide source code?
Yes. I can provide the Python script or notebook, cleaned output files, generated reports, and setup instructions depending on the selected package
Can you create a full ETL pipeline?
Yes. I can build simple ETL workflows that extract data from files or databases, clean and transform it, calculate metrics, and export the final results for reporting, dashboards, or analysis.

