Suresh Karnati

Analytically minded and detail-oriented Data Analyst with a proven track record of transforming complex datasets into actionable insights. I am adept at utilizing tools such as SQL and advanced Excel to extract, clean, and analyze data. Known for my ability to communicate findings effectively, I excel in translating data-driven insights into actionable recommendations for informed decision-making. Committed to continuous learning and staying abreast of emerging trends in data analytics, I am ready to contribute my skills and expertise to drive meaningful outcomes for your organization.

HR Attrition Analysis using Power BI (Personal project), Data Collection: Gathered employee data from HR records, including demographics, performance metrics, and reasons for attrition. Data Transformation: Cleaned and prepared the dataset by handling missing values using power BI and categorizing reasons for attrition.

Visualization in Power BI: Created dynamic dashboards illustrating attrition trends, employee demographics, and key factors influencing attrition using Power BI visuals like slicers, charts, and cards. 

Airline Customer Satisfaction using Excel Pivot Table (Personal project), Survey Data Import: Imported and organized customer satisfaction survey data, including responses on various aspects such as flight experience, staff interaction, and amenities. 

Pivot Table Analysis: Utilized Excel's PivotTable feature to summarize and analyze customer satisfaction scores. Explored trends, identified areas for improvement, and created a comprehensive summary report. Visual Representation: Enhanced the analysis by incorporating pivot charts, graphs, and conditional formatting to present insights visually, making it easy for stakeholders to grasp key findings. 

Walmart Sales Analysis using SQL (Personal project), Data Import: Extracted sales data from Walmart’s database. Data Transformation: utilized sql functions such as alter table and update to add new column. Analysis and Insight: Conducted in-depth analysis within the sql environment, exploring patterns, identifying top performing products, and assessing sales trends.