Md Sohail

Md Sohail

Passionate data analyst with a strong foundation from Great Learning. Proficient in Python, SQL, and advanced Excel f...
India
Urdu, Telugu, Hindi, English

About Me

Passionate data analyst with a strong foundation from Excel R solutions. Proficient in Power bi,Tableau, SQL, and advanced Excel for efficient data extraction, cleaning, and analysis. Skilled in Tableau and Power BI for …

Experience

Data Analyst Intern

AI VARIANT
Dec 2022 - Jun 2023 · 5 months

- Used MS Excel to organize and analyze the data by creating reports with pivot tables.
- Managing large datasets with aggregation functions, Data Validation, and conditional formatting.
- Using advanced DAX functions, I produced very interactive Power BI reports.
- Used Power Query to perform complex Data Import, Data Transformation, Data Integration, Data Cleaning, Data Loading, and Connection.
- Comfortable in writing statements using SQL commands like DDL, DML, DQL, etc.
- Used many datasets from Excel, Power BI, and Tableau to create an interactive dashboard, including those from HR Analytics, E-commerce, and Healthcare.
- Conducted statistical analysis using SQL and Excel to identify trends and patterns.

Data Analyst Intern

AI VARIANT
Dec 2022

Used MS Excel to organize and analyze the data by creating reports with pivot tables.
Managing large datasets with aggregation functions, Data Validation, and conditional formatting.
Using advanced DAX functions, I produced very interactive Power BI reports.
Used Power Query to perform complex Data Import, Data Transformation, Data Integration, Data Cleaning, Data Loading, and Connection.
Comfortable in writing statements using SQL commands like DDL, DML, DQL, etc.
Used many datasets from Excel, Power BI, and Tableau to create an interactive dashboard, including those from HR Analytics, E-commerce, and Healthcare.
Implemented Joins and subqueries.
Conducted statistical analysis using SQL and Excel to identify trends and patterns.

Skills

MySQL Python Structured Query Language (SQL) MS Excel Power BI Tableau DDL DML DQL Pivot Tables Data Validation Conditional Formatting DAX Power Query Joins Subqueries Data Analysis Data Visualization Problem Solving Critical Thinking Effective Communication Attention to detail Time management
Report this Profile?