Standard Reporting Automation
Gabi Santoyo
(0)
Starting at
$
20
About this service
Summary
Automates the data processing and analysis workflow related to comparing and tracking changes in 2 excel workbooks. Then storing the calculated differences in a new workbook, automating the process to analyze data that changes over time.
Key Features of the SheetChange Automator:
Automated Comparisons: Manually in excel this process took me on average 30 minutes and the tool accelerates this to under 2 minutes to run the tool!
Customizable Rules: With this script, there’s room to add criteria when comparing by adding the appropriate clause for the respective columns in the new data frame.
Detailed Reports: In the differences worksheet, the calculated differences for some columns are available to understand in a glance.
What's included
Automation Script
Python Script of running the automation at the frequency of the client (yearly, quarterly, monthly, etc)
Finalized Excel
Tab 1: Dataset 1 Tab 2: Dataset 2 Tab 3: Differences Tab (with any custom calculations)
Duration
2 days
Skills and tools
Data Modelling Analyst
Data Analyst
Product Data Analyst
Data Analysis
Microsoft Excel
pandas
Python
Industries
Analytics
Work with me