INTRODUCTION
INTRODUCTION
As a data analyst intern at Abhyaz, I embarked on an exhilarating journey through the realm of data analysis. During my tenure, I encountered two significant tasks that provided me with invaluable insights into the practical applications of data manipulation and precision.
INTERNSHIP EXPERIENCE
My time as a data analyst intern at Abhyaz was a transformative journey that offered me valuable insights into the practical applications of data analysis. Over the course of a month, I engaged in two impactful tasks that not only honed my technical skills but also deepened my understanding of effective communication and problem-solving in a business context.
PROJECTS:
PROJECTS:
Project 1 : Mastering Customer Interactions with Zoho CRM: Navigating Query Status
Project 1 : Mastering Customer Interactions with Zoho CRM: Navigating Query Status
1. The Data Ensemble
1. The Data Ensemble
Within the expansive expanse of Zoho CRM, filters act as the spotlight, illuminating potentials beneath an owner's purview.
2. The Call and Query
2. The Call and Query
Here we had to call each customer under the owner in the potential section of CRM.
3. Query Status Chronicles
3. Query Status Chronicles
The note section becomes the canvas for recounting the call's essence. When query gates remain ajar from the customer's side, the notes echo, "Contacted Ms. xyz on dd-mm-yyyy, and they stated that the enquiry is still open, anticipating a response in a few weeks." In contrast, the same parchment whispers, "Contacted Ms. xyz on dd-mm-yyyy, and they affirmed that the enquiry is not open," when the query finds its gate closed.
Project 2: Untangling Excel's Enigma: Navigating Discrepancies in Vendor Payment Management
Project 2: Untangling Excel's Enigma: Navigating Discrepancies in Vendor Payment Management
1. Deciphering Data Validation Dynamics
1. Deciphering Data Validation Dynamics
The journey commences with unravelling the intricacies of data validation. The team scrutinizes each manual entry against its digital counterpart, ensuring a harmonious alignment between the two.
2. Harmonizing the 60:40 Ratio
2. Harmonizing the 60:40 Ratio
The narrative then shifts to the symphony of ratios. Armed with Excel's calculating finesse, the team delves into the equations that dictate the 60:40 distribution.
3. Diverging Sheets, Converging Realities
3. Diverging Sheets, Converging Realities
The scene transitions to the individual sheets for two people. An intricate comparison unfolds, mirroring a detective analysing two seemingly unrelated clues.
4. Embracing Manual Interventions
4. Embracing Manual Interventions
In the world of numbers, values change when brought together from separate sheets. Human eyes and insights bridge the gap between digital precision and real-world complexities.
Conclusion
Conclusion
In the realm of CRM optimization and data manipulation, from enhancing customer interactions through Zoho CRM to meticulously refining datasets in Excel, these tasks underscored the power of precision, targeted communication, and data integrity. Armed with insights into efficient customer engagement and the art of data manipulation, I'm equipped to navigate the dynamic landscape of data-driven business success.
