Ankush Prasad

About Ankush Prasad

I’m building kaaz Savare, a hyperlocal services marketplace focused on improving how…

Experience

1. Data Analyst

   NIIT Limited

   Aug 2024 — Present

   I have worked on multiple data analysis projects, leveraging tools like Excel, SQL, Python, Tableau, and statistical methods to extract insights and drive decision-making. Below are some of the key projects I have completed:Automobile Market Analysis (Excel): Performed data preprocessing, created pivot tables, and visualized data using bar, column, pie, line, and scatter plots. Identified outliers using charts and interquartile range analysis.Data-Driven Analytics (SQL): Extracted and analyzed data using SQL queries, leveraging joins and other data manipulation techniques for effective insights.Automated Employee Engagement (Python): Developed console-based games, including arithmetic puzzles, riddles, general knowledge quizzes, rock-paper-scissors, and word-guessing games.Unlocking Automotive Trends (Python for Data Science): Conducted data preprocessing and utilized libraries like NumPy, Pandas, Seaborn, and Matplotlib for data analysis and visualization. Generated actionable insights by interpreting trends in the automotive sector.Hotel Booking Data Analysis (Python for Data Science): Performed Exploratory Data Analysis (EDA), univariate and multivariate analysis using Python libraries to uncover trends in hotel booking data.Unveiling Automobile Sales Trends (Tableau): Designed and developed dashboards in Tableau, incorporating various charts to visualize automobile sales trends.Mitigating Bird Strikes in Aviation (Tableau & Figma): Created an interactive Tableau dashboard to analyze bird strikes in aviation and designed a supporting template in Figma.Refining Computer Sales Strategy (Statistics using Python): Conducted statistical analysis using Python, applying probability concepts, Z-tests, and T-tests to optimize computer sales strategies.These projects have enhanced my proficiency in data analysis, visualization, and statistical modeling, equipping me with the skills to make data-driven decisions.

Education

• NSHM Knowledge Campus Durgapur Group of Institutions 273

  Bachelor of Technology - BTech, Mechanical Engineering

  2013 — 2017