Conducted a detailed exploration of global university success utilizing Power BI, Excel, EDA, and SQL, integrating data from diverse ranking systems and criteria.
Applied a Mutually Exclusive, Collectively Exhaustive (MECE) methodology, outlined in a detailed document, to systematically analyze datasets and uncover valuable insights and patterns.
Utilized Power BI to construct four detailed dashboards, providing clear visual representations of university rankings based on countries, individual universities, ranking systems, and temporal changes.
Developed an Entity-Relationship (ER) Diagram, illustrating interconnected data entities and relationships between countries, universities, ranking systems, criteria, and their dynamic interactions in global higher education.
Produced a comprehensive report guiding through every stage of the project, from data gathering to systematic breakdown, integration of tools, and implementation of solutions using Power BI, supporting informed decision-making in higher education.
Movie Rental Analytics Capstone with SQL, Excel, and Power BI
Employed a Mutually Exclusive, Collectively Exhaustive (MECE) methodology, meticulously outlined in a detailed document, to systematically analyze datasets, ensuring thorough exploration and uncovering valuable insights and patterns.
Examined customer behavior patterns to discern preferences, rental trends, and demographic insights, facilitating personalized marketing strategies and enhancing customer satisfaction and loyalty.
Utilized rigorous analysis and visualization techniques to optimize film inventory management, identifying top-performing rentals and guiding decisions on content acquisition, resulting in improved revenue streams and operational efficiency.
Employed SQL queries and EDA techniques to delve into customer behavior patterns, film inventory dynamics, and revenue trends, providing a solid foundation for strategic decision-making.
Evaluated staff productivity metrics and streamlined store operations through optimized workforce management strategies, leading to cost savings, improved resource allocation, and elevated customer experiences.
Offered rental store proprietors a strategic roadmap based on data-driven insights, enabling informed decisions aligned with business goals, risk mitigation, and capitalization on growth opportunities in a dynamic market landscape.
Leveraged Power BI to create intuitive dashboards showcasing film performance analysis, geographic insights, entity-relationship diagrams, actor influence assessments, customer behavior patterns, revenue trends, and top rental identification, empowering stakeholders with actionable insights for strategic decision-making.