Srutha Keerthi Pinapatruni

1. Project Title : Uber Pickups in Newyork City - Python

• Utilized Python libraries, including Pandas, for comprehensive Exploratory Data Analysis (EDA).
• Applied advanced concepts such as grouping and aggregation using the group by and size functions to uncover key insights.
• Implemented advanced indexing techniques for efficient data filtering and extraction.
• Leveraged Matplotlib's pyplot module for data visualization, creating various chart types such as scatter plots, pie charts, and bar plots to effectively communicate findings.

2. Project Title: Anomaly Detection in Credit Card Transactions - Power BI

• Developed an interactive dashboard for credit card transactions using Power BI Desktop, enhancing user engagement and data comprehension.
• Created calculated columns and measures to improve data analysis, employing key DAX functions such as SUMMARIZE, SUM, and SUMX.
• Conducted thorough data exploration and transformation using Power Query Editor, ensuring data accuracy and consistency.
• Utilized Power Pivot for advanced data modeling, enabling robust analysis and insightful reporting.

3. Internet Movie Database(IMDb) - MYSQL

• Performed data analysis and derived key insights by joining multiple tables using advanced SQL joins.
• Leveraged SQL concepts such as Common Table Expressions (CTEs) and various types of joins to enhance data retrieval efficiency.
• Utilized clauses like GROUP BY, HAVING, and ORDER BY to organize, filter, and sort data effectively for comprehensive analysis.