Mihir Raut | Data Analyst | Data portfolio

Mihir Raut

Data Analyst

Based in Nagpur

About

As a data analyst with a passion for technology and a keen eye for detail, I am driven by the pursuit of actionable insights and data-driven decision-making. With a solid foundation in data analysis, visualization, and statistical techniques, I excel in extracting meaningful information from complex datasets. My proficiency in Python, SQL, and advanced Excel enables me to analyze and manipulate data effectively, while my expertise in Tableau allows me to create visually compelling dashboards and reports. I am a proactive learner, constantly seeking opportunities to expand my knowledge and skill set.

Skills

Projects

Excel Data Analysis and Retail Insights

Experienced Excel Data Analyst proficient in employing advanced methods for comprehensive retail data analysis. Successfully developed a 2022 Sales Dashboard, unearthing valuable insights and growth opportunities for Shree Sai Stores. Expertise in facilitating data-driven decision-making.

SQL Data Exploration and Nutritional Analysis

Data Analyst proficient in Data Exploration: Counted rows, identified menu items, checked uniqueness, categorized items, and addressed missing data. Key insights include 134 menu items, 7 categories, and top nutritional findings, enhancing data-driven decision-making skills."

Netflix Titles Analysis with Tableau

Netflix Titles Analysis (2020): Explored Netflix dataset up to 2020. Visualized title distribution, ratings, genre trends, and content evolution. Insights: Movies dominate, TV-MA ratings, documentaries spotlight, 2019 release peak, US production hub.

Diwali Sales Analysis Using Python

Conducted comprehensive Diwali sales analysis: data preprocessing, library import, dataset loading, exploration, statistical analysis, EDA, and concluded that married women aged 26-35 in UP, Maharashtra, and Karnataka, working in IT, Healthcare, Aviation sectors are likely to buy Food, Clothing, Ele

Education

2018-2021

Bachelor of Science

Completed Bachelor of Science from Hislop College Affiliated to Nagpur University in Biotechnology.

2023

Data Analyst Certification at ExcelR Solutions

Successfully completedof the Data Analyst Certification program offered by EXCELR SOLUTIONS. This educational journey provided a comprehensive exploration of the field of data analytics. I have acquired proficiency in essential analytical tools including Excel, PowerBi, and Tableau. Additionally, I have honed my skills in programming languages such as SQL, Python, and R. These competencies have equipped me for a promising career in data analysis, and I am prepared to take on new challenges while contributing to data-driven decision-making processes.