Gourav Arora

Motivated and detail-oriented aspiring Data Analyst with a strong foundation in SQL, Microsoft SQL Server, Python, Excel, and Power BI. Skilled in data cleaning, exploratory data analysis, dashboard creation, and transforming raw data into actionable insights. Passionate about solving business problems through data-driven decision-making and eager to contribute to a dynamic organization.

Tools: Microsoft Excel (Pivot Tables, Power Query, Charts, Slicers)

Description

• Developed an interactive Coffee Sales Dashboard in Microsoft Excel to analyze sales performance across products, regions, and time periods.
• Cleaned and transformed raw sales data using Power Query to ensure accurate reporting.
• Created Pivot Tables, Pivot Charts, and Slicers to provide dynamic insights into revenue trends and customer purchasing behavior.
• Designed KPI-driven visualizations to support data-driven business decisions.

Tools: Microsoft SQL Server, SQL Server Management Studio (SSMS), T-SQL

Description

• Designed and implemented a data warehouse using Microsoft SQL Server to consolidate data from multiple sources.
• Developed ETL processes using T-SQL to extract, transform, and load data into fact and dimension tables.
• Created an optimized star schema to improve reporting and analytical performance.
• Wrote SQL queries to validate data integrity and generate business reports for decision-making.

These are both strong projects for a Data Analyst resume:

• Coffee Sales Dashboard showcases Excel, data visualization, and reporting skills.
• Data Warehousing Project demonstrates SQL Server, database design, ETL, and data modeling skills.