Analytics Association of Faculty of Commerce and Management conducted a workshop on the topic “Data Preparation” on25th February, 2023.The workshop Expert was Dr. Sunil Kumar Verma and Faculty coordinator was Mr. Nitin Sharma. Students of Undergraduate and Post –Graduate programmes learned and practiced some important excel functions and topics like finding outliers through visual charts, splitting data, text spaces, list wise blank deletions, using pivot table, finding answers to the questionnaires, using conditional formatting and using Text-to-columns. The mentors provided the questionnaire to understand the overview of the workshop. This workshop helped students in collecting, cleaning, labelling raw data into a suitable form and exploring it. More accurate and practical knowledge of data analysis and excel was provided. Student Coordinator’s Harshit Mehta, Manvi Tyagi,Chinmaya Loomba and Shivam Dalal.
