I understand you are looking for someone to create a VBA macro that can automate advanced data analysis. As a professional with 15 years of industry experience in various technologies like Power BI, SQL Server, Excel, VBA and macros, I am confident that I can help you create the perfect macro fit for your needs. My extensive experience has taught me how to work effectively with a wide array of data sets, which makes me well-suited to tackle this project.
I have worked extensively in Excel VBA and macros. This makes me well-versed in the intricacies of the software and enables me to deliver high quality results quickly. Additionally, I have experience working on multiple automation projects which can come in handy if you do not have the data sets needed for the project at hand but would like suggestions on how to improve your workflow without compromising on confidentiality requirements.