Hello all,
I recently was hired in a position where this company built all their VBA code and PowerBI analytics from the ground up with the temp that was before me.
It includes an extensive list of Excel Modules and PowerBI analytics with a lot of separate steps to clean up the data.
The person before me was gracious enough to write me a short explanation on what the modules do and walk me through a query and updating the PowerBI tool.
But I'm sitting here at a loss on what to do next to familiarize myself completely with the code.
So far, I've been writing comments on each line of VBA to make sure I know what each of the modules and code does.
For reference, the only time I used VBA before was to clean up data for Tableau (so similar in this context), but not on the level of the previous person. So I'm likely a beginner level.
Please give your advice!
I recently was hired in a position where this company built all their VBA code and PowerBI analytics from the ground up with the temp that was before me.
It includes an extensive list of Excel Modules and PowerBI analytics with a lot of separate steps to clean up the data.
The person before me was gracious enough to write me a short explanation on what the modules do and walk me through a query and updating the PowerBI tool.
But I'm sitting here at a loss on what to do next to familiarize myself completely with the code.
So far, I've been writing comments on each line of VBA to make sure I know what each of the modules and code does.
For reference, the only time I used VBA before was to clean up data for Tableau (so similar in this context), but not on the level of the previous person. So I'm likely a beginner level.
Please give your advice!
