Welcome to my repository for the Mentorness Internship! This repository showcases the tasks I completed as part of Batch MIP-DA-10, where I honed my data analysis and visualization skills using SQL and Power BI.
Topic: Indexing Overview: Introduction to indexes and their role in improving query performance by speeding up data retrieval.
In this task, I created with Canva an engaging reel to explain the concept of indexing in SQL. The reel covers:
- โ๏ธ ๐พ๐๐๐ ๐๐๐ ๐๐๐๐ ๐๐๐: A brief introduction to indexes in SQL and their purpose.
- โ๏ธ ๐ฏ๐๐ ๐๐๐๐ ๐๐๐๐: An overview of how indexes speed up data retrieval by organizing data in a way that allows faster searches.
- โ๏ธ ๐ท๐๐๐๐๐๐๐๐๐๐ ๐ฐ๐๐๐๐๐: How indexes can significantly improve query performance but may come with trade-offs.
Objective: Analyze hotel reservation data to extract meaningful insights and trends.
In this task, I utilized SQL to perform a detailed analysis of hotel reservation data. The analysis includes:
- โ๏ธ ๐บ๐๐๐๐๐๐๐ ๐ฉ๐๐๐๐๐๐ ๐ป๐๐๐๐ ๐: Unraveled peak seasons, shoulder months, and low-demand periods to help hotels prepare accordingly.
- โ๏ธ ๐ฎ๐๐๐๐ ๐ฉ๐๐๐๐๐๐๐ ๐จ๐๐๐๐๐๐๐: Identified patterns in lead time, cancellation rates, and market segments, allowing hotels to tailor their strategies.
- โ๏ธ ๐จ๐๐๐๐๐๐๐๐๐ ๐บ๐๐๐๐๐๐๐๐๐: Formulated data-driven recommendations to improve room occupancy, revenue, and guest experience.
Objective: Visualize and analyze song data using Power BI/Tableau.
For this task, I leveraged Power BI to create interactive visualizations that uncover patterns and insights in song data. Key aspects of the analysis include:
- โ๏ธ ๐ป๐๐ ๐บ๐๐๐๐ ๐๐ ๐ฝ๐๐๐๐: Identifying the most popular songs based on view counts.
- โ๏ธ ๐ณ๐๐๐-๐๐-๐ฝ๐๐๐ ๐น๐๐๐๐: Analyzing songs with the highest engagement through likes.
- โ๏ธ ๐ซ๐๐๐๐๐๐๐ ๐๐. ๐ท๐๐๐๐๐๐๐๐๐: Exploring the relationship between song duration and popularity.
- โ๏ธ ๐ป๐๐ ๐จ๐๐๐๐๐๐๐: Understanding the impact of tags on song discovery and views.
Iโve also created a presentation video summarizing my work and insights from the project. Watch it to get a comprehensive overview of my journey.
The Mentorness Internship provided a platform to enhance my data analysis skills and gain practical experience in SQL and data visualization tools like Power BI. Through these tasks, I developed a deeper understanding of database management, data retrieval, and the power of visual storytelling in data analysis.
Thank you for visiting my repository! Feel free to explore the tasks and reach out if you have any questions or suggestions.