Date of Graduation


Document Type


Degree Name

Bachelor of Science in Business Administration

Degree Level





Sharma, Ashish


From June 2021 to May 2022, I had the privilege of being the Customer Development Intern in the home care department at Colgate-Palmolive. In this thesis I will unpack the experience of working with Colgate Palmolive, specifically as it pertains to my largest project for the company.

The genesis of the project was informed by observations of the company over the course of the internship. The company had a noticeable gap in the data collection tools it was utilizing. I, along with the manager and analyst of the home care team, identified a solution by using Walnut in Google Data Studios to curate and sift through all the data stored across platforms into one. Doing this would increase productivity in communication and cut out the extra steps in the data storage process. This was a far-reaching project with even broader advantages once completed. During the process of setting up a Walnut in Google Data Studios, I had to become familiar with software like Atlas, Retail Link, and Nielsen IQ, and learned that businesses need a central location for their data storage and analysis to increase efficiency and ensure that data is up-to-date and filed properly. The advantages of relocating the company’s data to a central and all-encompassing software like Walnut in Google Data Studios include increasing efficiency in communication team-wide, centralizing data for easy analysis, and eliminating unnecessary resources that waste company time, money, and energy. Far-reaching software, like Walnut in Google Data Studios, is essential for any company and worth the necessary time it takes to set up as a tool. It was imperative I take on this project to better support the home care team and show initiative as a young professional, and I succeeded in transforming the way the team operates and communicates daily.


Google Data Studios, Data-Analytics, Colgate-Palmolive, Internship, Walmart, Service Learning