Internship Description
This semi-tech internship at our organization offers an unparalleled opportunity for students pursuing non-technical courses such as BBA, BCA, MBA, MCA, BCOM, MCOM, and others. Through a series of engaging projects, interns delve into the realm of data analysis using powerful tools like Excel and SQL.
- Project 1 provide interns explore various facets of customer card transactions, including churn rates, profitability, losses, and retention strategies. Leveraging Excel and SQL, interns dissect transactional data to uncover insights such as the city with the highest spend-to-transaction ratio on weekends and the city with the fastest accumulation of transactions.
- Project 2 delves into the spending patterns of credit card customers, identifying the most profitable segments, highest paying customers, and analyzing spending and repayment behaviors. By harnessing Excel and SQL, interns gain hands-on experience in segmenting customers based on their acquisition details and conducting in-depth analyses to drive strategic decision-making.
- Project 3 focuses on analyzing spending and return details of customers from an online portal, supplemented with demographic information. Interns utilize Excel and SQL to discern spending patterns, identify profitable customer segments, and offer insights into return categories based on factors such as state, age group, product condition, and discount relevance. Additionally, interns create profiles for high-value and low-value items, correlating them with order frequencies to optimize inventory management.
Through these projects, interns not only sharpen their analytical skills but also become proficient in utilizing Excel and SQL for real-world data analysis tasks. They gain valuable experience in interpreting data, drawing actionable insights, and presenting findings, setting them on a path towards success in the analytics domain. Join us for an immersive Analytics internship and unlock the power of Excel and SQL in driving data-driven decision-making.