Standard Reporting AutomationGabi Santoyo
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)
Gabi's other services
Starting at$20
Duration2 days
Tags
Microsoft Excel
pandas
Python
Data Analyst
Data Modelling Analyst
Product Data Analyst
Service provided by
Gabi Santoyo Philadelphia, USA
- 1
- Followers
Standard Reporting AutomationGabi Santoyo
Starting at$20
Duration2 days
Tags
Microsoft Excel
pandas
Python
Data Analyst
Data Modelling Analyst
Product Data Analyst
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)
Gabi's other services
$20