Khushboo Malviya | Data Analyst

Khushboo Malviya

Data Analyst

Based in Indore, MP

About

As an aspiring Data Analyst, I have a strong foundation in data analysis and a passion for turning data into actionable insights. I am proficient in key tools and databases, with hands-on experience in various technical skills. I am eager to contribute to data-driven decision-making and continuously grow in the field of data analytics.

Skills

Projects

UPI Transactions Analysis

• Built SQL queries and Power BI dashboards to analyze and visualize transaction data for better decision-making. • Applied DAX formulas to create interactive reports, simplifying data extraction and improving accessibility for stakeholders.

AirAsia Bookings Analysis

• Analyzed passenger data using Python (pandas, numpy) to identify patterns and trends in bookings and flight durations. • Visualized data using Seaborn and Matplotlib to create insightful charts and graphs for deeper analysis of booking trends and durations.

Road Accidents Analysis

• Created interactive dashboards using Advance Excel to visualize accident data and identify high-risk areas, providing critical insights for safety initiatives. • Utilized pivot tables and advanced Excel formulas to segment data by region, time, and accident type for deeper analysis

Amazon Prime Users Report

• Developed SQL-based analysis to uncover user behavior and trends, then created detailed visualizations using Power BI to inform strategic decisions. • Created detailed visualizations in Power BI to inform strategic decisions.

Experience

Data Analyst Intern (Intellgus)

• Utilized Python and BeautifulSoup for web scraping to extract, clean, and format data from various online sources, ensuring comprehensive and accurate data collection. • Cleaned and sorted data using Excel, ensuring accuracy and consistency before conducting detailed analysis and visualizations.

Data Analyst Intern (Atliq Technologies)

• Gathered and documented requirements from stakeholders to build comprehensive data-driven solutions for reporting and analysis on the platform. • Designed and optimized SQL queries for data extraction, reducing data retrieval time, and developed custom reports for strategic decisions.

Education

2018 - 2022

B.Tech (Electronics and Communication)