Wednesday, October 10, 2018

I will clean, integrate, and visualize your data with excel vba

I will clean, integrate, and visualize your data with excel vba












About:

I will take multiple data sources that have a format laid out by the buyer.  The data will be cleansed by putting it in correct data type format, erasing spaces, transforming Nulls/Blanks, validation through look up tables, and other issues specific to project.  The next step would involve integration from these multiple cleaned sources into a format that the buyer requests.  Counts can be added, duplicates can be removed, as well as other metrics the buyer would like.  The final step would involve reporting via Pivot Tables or Visualizations/Charting that the user would like.  I have over 5 years of advanced excel usage under my belt and a solid education in data analytics that can be used to support a data integration project needed by an interested buyer.

Reviews


:

:

:

:

:


No comments:

Post a Comment