Advanced SQL for Data Analysis

-


On [30/11/2024], the Department of Data Science and Economics had the privilege of hosting Mr. Saranyan Srikanth, System Architect at Clever Insight, for an engaging guest lecture on "Advanced SQL for Data Analysis." This insightful session was attended by students from the third year of B.Sc. Data Science and B.Sc. Economics programs. Over the course of an hour, Mr. Srikanth shared his expertise in advanced SQL techniques, providing the students with a practical understanding of contemporary data analysis methods using SQL.

The session commenced with a brief introduction to advanced SQL concepts, highlighting the importance of efficient querying techniques in handling large datasets. Mr. Srikanth emphasized the relevance of SQL in professional data analysis, especially in domains like finance, marketing, and sports analytics, setting the tone for a session filled with practical insights.

A major highlight of the lecture was an introduction to the Snowflake platform. Mr. Srikanth provided a step-by-step guide on how to register and set up a Snowflake account. Snowflake, being a cloud-based data warehousing platform, offers scalability and high-performance querying, making it a preferred choice for modern businesses. Students were guided through the interface, giving them a hands-on experience in a cutting-edge data analysis environment.

The primary focus of the session revolved around advanced SQL concepts, specifically Common Table Expressions (CTEs), partitioning, and ranking functions. Using a cricket dataset, Mr. Srikanth demonstrated how CTEs can simplify complex queries by breaking them into manageable components. He illustrated their use in scenarios such as filtering players by performance metrics and identifying trends in match statistics. The clarity of his explanation helped students understand how CTEs enhance readability and maintainability in SQL scripts.

Partitioning and ranking were introduced as powerful tools for data organization and analysis. Mr. Srikanth showcased their applications by segmenting cricket players based on team and calculating rankings for players based on performance metrics like runs scored or wickets taken. The demonstration highlighted how partitioning facilitates analyzing subsets of data independently, while ranking functions enable insightful comparisons within these partitions.

The session was designed to be highly interactive, with students actively participating by executing the queries on their devices. This hands-on approach reinforced theoretical concepts and provided a real-world perspective on SQL's capabilities. Mr. Srikanth patiently addressed students' queries, ensuring that everyone had a clear understanding of the topics discussed.

The session concluded with an engaging Q&A round, where Mr. Srikanth shared industry insights and career tips, particularly emphasizing the importance of mastering SQL for aspiring data analysts and economists. He also provided valuable advice on staying updated with evolving technologies like Snowflake and exploring its potential in various domains.

Overall, the guest lecture was a resounding success. It not only enhanced the students’ technical knowledge but also gave them exposure to industry-standard tools and techniques. Mr. Srikanth’s approachable demeanor, combined with his expertise, made the session both educational and inspiring. The students left with a deeper appreciation of advanced SQL and its role in deriving meaningful insights from data.

The department extends its gratitude to Mr. Saranyan Srikanth and Clever Insight for this enriching experience and looks forward to similar collaborations in the future.

Comments

Post a Comment

Popular posts from this blog

WHAT'S IT LIKE TO LIVE IN THE HOSTELS OF CHRIST LAVASA?

-
Image
“From holding the keys for the first time and being nervous to stepping into a doorway of comfort, the hostel rooms are home here.” Life at CHRIST Hostel, Lavasa is beyond the norms of what people perceive as the regular hostel experience. With a unique setup, the Lavasa hostels offer a new-age lifestyle along with security. Students who live in the hostel experience a life less ordinary for several reasons: A diverse community The rooms here are not of the dormitory nature but are in the form of apartments and villas. Students get to interact with people of multiple ethnicities and varied cultural backgrounds while availing themselves of personal space. This not only widens their cultural horizon but helps everyone accept each other, get exposure to different traditions, and have a chance to find their true tribe in this city. “ Truly, North meets South and East meets West here at home. ” Form of independence For most students, the college hostel is the first experience of being alone...
Read more

PANEL DISCUSSION ON LEADERSHIP & ENTREPRENEURSHIP DEVELOPMENT SKILLS

-
Image
The School of Commerce, Finance and Accountancy organized a "Panel Discussion on Leadership and Entrepreneurship Development Skill " on 4th March 2022 at 1:30 PM at CHRIST (Deemed to be University), Pune Lavasa Campus.   Ms Ayushi Chandna student of 6 BCom (Financial Analytics) commenced the session with silent prayer & briefed about the Panel Discussion. This was followed by an introduction about the resource persons by Ms Pretty Rose Sebastian & Mr Shreeyash Goel, Students of 6 BCom (Financial Analytics). The Head of the Department, Dr Vandana Bhagat addressed the session and welcomed the Resource persons. The Session Moderator Dr Jayant Mahajan started with setting the context about the Panel Discussion with his collective years of experience and expertise in the field, Then the First Resource Person Mr Rajiv Chelladurai discussed the Leading Self, Emotional Intelligence, Relationship Builder, Continuous learner and the Problem Solver. The students were asked quest...
Read more

WEBINAR ON ROLE OF DIGITAL MARKETING IN THE PHARMACEUTICAL SECTOR

-
Image
The webinar on “Role of Digital Marketing in the Pharmaceutical Sector” by Dr Manoj Kumar, Senior Vice President and Strategic Business Unit Head with INTAS/Accord Pharmaceuticals was organized by the School of Business and Management (BBA) at CHRIST (Deemed to be University), Pune Lavasa Campus on 16th December 2021.  The guest speaker, Dr Manoj Kumar, endorsed the impact and relevance of digital marketing in the Indian pharmaceutical industry with specific relevance to super-specialists. As doctors may not be available everywhere due to infrastructure and geographical constraints, digital consultancy showed a new way of a career in the pharmaceutical sector during COVID times The pandemic was the time when healthcare workers were praised and called superheroes. We realized how pharmaceutical companies had a big role in this too. From the production of life-saving medicines to covid vaccines, they did it all. But what we do not realize is that marketing had a big role to play in a...
Read more