Project Name
Torrens University
Project Abstract:
Project involved daily analysis of International and domestic students with courses.
Responsibilities (Role : Team Member)
· Developed interactive dashboards, reports, and visualizations using Power BI Desktop, meeting client requirements and enabling data-driven decision-making.
· Collaborated with cross-functional teams, including business analysts and data engineers, to gather data requirements and design appropriate data models.
· Built a Power BI solution for a university to analyze and visualize various aspects of student data.
· Integrated data from multiple sources, including student enrollment, academic performance, and demographic information.
· Designed interactive dashboards to monitor student retention, track program effectiveness, and identify areas for improvement.
· Created calculated columns, measures, and complex calculations using DAX to enable advanced data analysis.
· Optimized data models and queries to improve performance and enhance user experience.
· Implemented drill-through capabilities to enable detailed analysis of student performance at the individual level.
· The project contributed to data-driven decision-making in the university, leading to improved student outcomes and resource allocation.
· Created Stored procedures, Views using sql writing/implementing SQL queries to execute data cleanups.