Shivam Kumar

Aspiring Data Analyst · Excel, SQL, Power BI, Python

Delhi, India

@shivam_kumar6

GitHub

0 followers

🎓 BA (Office Management and Secretary Practice + History) at University of Delhi · Graduating 2026

About

Aspiring data analyst with practical project experience in data cleaning, analysis, SQL querying, and dashboard development using Excel, PostgreSQL, and Power BI. Seeking an internship to apply analytical skills to real-world business problems across different industries.

Education

2026

BA

Dyal Singh College

Awarded by University of Delhi

Office Management and Secretary Practice + History · 2026

Office Management and Secretary Practice + History

Skills

<3 months

SQL DAX ETL Join NumPy Python Pandas Seaborn Matplotlib Subqueries Data Analysis Data Cleaning Data Modeling KPI reporting Microsoft Excel Window functions Data Visualization Dashboard Development Common Table Expressions (CTEs)

Tools / apps / platforms

<3 months

PostgreSQL Power Query Microsoft Excel Microsoft Power BI

Projects

Sales Data Analysis ↗

Python

Used Pandas and NumPy to clean and manipulate sales data. Applied Matplotlib and Seaborn to visualize patterns and explore sales performance.
Hospital Data Analytics Dashboard ↗

Power BI

Transformed hospital data using Power Query and organized it for dashboard reporting. Developed KPI measures and visualizations to explore hospital performance and departmental metrics.
Superstore Sales Dashboard ↗

Power BI

Transformed and modeled sales data to create an interactive business dashboard. Developed KPI cards, charts, and filters to explore sales, profit, and category performance.
Super Sales Analysis ↗

PostgreSQL

Wrote SQL queries using joins, aggregate functions, and filtering to retrieve and summarize sales data. Analyzed sales and profitability information to answer business-related questions.
Hospital Data Analysis Dashboard ↗

Microsoft Excel

Prepared and analyzed hospital data to summarize key metrics and department performance. Built a dashboard using Pivot Tables, charts, and filters for data-driven reporting.
Retail Sales Analysis Dashboard

Microsoft Excel

Cleaned and analyzed retail sales data using formulas, Pivot Tables, and charts to summarize sales and profit performance. Created an interactive dashboard to present key performance indicators and sales trends.

Courses & certifications

Deloitte – Data Analytics Job Simulation ↗ · Forage · 2026

🎯 Hobbies & interests

Playing Football
Learning or Knowing about new softwares
Watching Movies
Traveling

Explore the Broxer community

💬 Q&A Ask about roles, salaries and interviews — and help others. 👥 Circles Join discussions on skills, companies and industries. 📰 Feed Follow updates and insights from the community.