Engaged in a comprehensive analysis of the Modern College Data Set, with a focus on the enrollment dataset. Utilized Excel and Tableau to craft an interactive dashboard and visuals that answer critical questions and provide key insights into student enrollment and fee payments. The project encompasses a range of data manipulations and visualizations to derive meaningful information, including the total number of enrolled students, top-paying students, and campaign performance.
Key Points:
- Enrollment Overview:
- Leveraged pivot tables and charts in Excel to determine the total number of enrolled students and gain an understanding of enrollment trends.
- Data Cleansing and Transformation:
- Replaced ‘Facebook’ with ‘Youtube’ and extracted month and day information from the date column for enhanced data accuracy.
- Optimal Enrollment Days and Months:
- Utilized Excel and Tableau to identify the day and month with the highest number of enrollments, aiding in strategic planning.
- Top 5 Campaign Types:
- Showcased the top 5 campaign types by campaign, providing insights into effective marketing strategies.
- Age Calculation and Proper Case Display:
- Calculated age from the date of birth and displayed the full name of the student in proper case, enhancing data clarity.
- Campaign Usage Analysis:
- Examined and presented the campaign usage of Instagram and Youtube, shedding light on social media effectiveness.
- Top 5 Paying Students:
- Derived the top 5 paying students and their full names, enabling the college to strategize incentives effectively.
