Excel Macros
- Chart Automation Macro
- Data load, reorder, and export into MS Access
This Macro was created in excel in order to update over 8 excel graphs from a separate data tab all at once instead of manually resizing and formatting axes, font colors, styles, etc.
This Macro takes data manually typed into a worksheet, restructures it into a table compatible with MS Access, then calls a function in MS Access to further transform and export into MS SQL Server
Access Macros
- String SQL ETL into SQL Server
- String SQL ETL from .txt file to MS Access, then SQL Server
This Macro takes data from an MS Access tables, performs queries, and then executes SQL statements to export this data into SQL Server
This Macro takes data from a .txt file, imports it into an MS Access database, performs queries and transformations on the data, then appends the data to an MS SQL Table.
SQL Server Automation
- Loop function allocation method
- Custom SQL View
- Table Valued Function
This code performs a loop function to allocate expenses using a variety of parameters decided by the Business Units. It contains over 5 million rows of data for every year.
This SQL View is custom built in order to look at various assumptions in the data expense allocation model.
This SQL function creates a table based on parameters given (YearMonth).