About Me
Data Analyst
Hey there, I'm Deepanshu, a passionate data enthusiast with expertise in ETL, Data Analysis, and Visualization.
Coming from a quantitative background, I have tuned myself to be a data analyst with a diverse skill set including Data Preparation & Visualization, Data Analysis & Reporting, Data Quality Management, Business Intelligence and Statistical Analysis. I have proficiency in Power BI, MySQL, Python and Statistics, Linear Algebra, Calculus with a hands on experience in Numpy, Pandas and Matplotlib.
I am seeking new challenges & opportunities to develop and implement my diverse skills to extract impactful results for the organizations.
Technical Skills
Power BI: Data Modelling, Visualization, Parameters, Table Calculations, Geospatial Analysis, LODs, Dynamic Zone Visibility, and Power BI x Figma
MySQL: DDL, DML, DQL, Stored Procedures, Window Functions, Data Analysis
Python: Data Structures, OOP, NumPy, Pandas, Matplotlib, Data Analysis, Statistical Analysis, and Predictive Analysis
Work Experience & Education
Professional Experience
Data Analyst Intern
July 2024 - Present
Remote
- Documented problem statements using the 5W1H Framework.
- Cleaned and standardized data for 14,2980 GenZ respondents using Excel.
- Analyzed data using SQL and Excel pivot charts and visualized data using Excel.
Education
Master of Science - Mathematics
2021 - 2023
Central University of Himachal Pradesh
CGPA: 8.25/10
- LaTeX
- Operations Research
- Statistical Modeling
Bachelor of Science
2018 - 2021
Himachal Pradesh University, Shimla
CGPA: 8.38/10
Projects
I invite you to go through my projects in various domains using different tools.
Hover and click the associated link icon to explore more about a particular project.
Interactive Power BI Dashboard
- All
- Power BI
- Python
- SQL
- Excel
