Portfolio - Siddhant Pardeshi | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Hello, I am

Siddhant Pardeshi

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Me

Aspiring Data Analyst with strong technical skills in SQL, Microsoft Excel, Power BI, and Python. I am proficient in writing SQL queries for data extraction and transformation, using Excel for advanced data analysis, pivot tables, and automation, and developing interactive dashboards in Power BI for insightful visual reporting. In Python, I work with libraries like Pandas, NumPy, and Matplotlib to clean, analyze, and visualize data efficiently.

My practical experience includes a virtual internship at AtliQ Technologies, where I applied these skills to real-world business problems. I contributed to building dynamic reports, identifying key performance metrics, and presenting actionable insights.

I am detail-oriented, analytical, and passionate about uncovering trends that support data-driven decision-making. Constantly upskilling through hands-on projects and self-learning, I am now looking for an entry-level opportunity to apply my skills, learn from industry professionals, and contr

Key

Skills

SQL

Microsoft Excel

PowerBI

Statistics

python

Communication

problem solving

My

Projects

360 Business Analysis

360 Business Analysis

Domain/Function: Multi Domain

Developed a Power BI dashboard for AtliQ Hardware by integrating data from Excel/CSV and SQL. Built optimized data models and visuals, improving performance by 5%. Helped drive a 10% revenue increase and reduced data costs by 20%.

Sales Analytics

Sales Analytics

Domain/Function: Sales

Created couple of reports to analyze the sales and to evaluate the company performance, And report will help to company and sales team for analyzing the YoY growth

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Complete Data Analyst bootcamp

Complete Data Analyst bootcamp

Contact Me

Email

[email protected]

Github

https://github.com/Siddhant7249

Linkedin

https://www.linkedin.com/in/siddhant-m-pardeshi

Call

+91 7249007259

Siddhant Pardeshi

Data Aspirant

Download Resume

Resume

PowerBI Project

360 Business Analysis

Domain/Function: Multi Domain

Developed a Power BI dashboard for AtliQ Hardware by integrating data from Excel/CSV and SQL. Built optimized data models and visuals, improving performance by 5%. Helped drive a 10% revenue increase and reduced data costs by 20%.

Other Tools

SQL

Excel

360 Business Analysis

AtliQ’s 360 interactive dashboard provides insights across Sales, Finance, Marketing & more, enabling data-driven decisions with real-time sales data.

360 Business Analysis

Power BI model showing linked tables used in AtliQ's dashboard to analyze sales, finance, marketing, and supply chain data across domains.

Project Details

I developed a comprehensive Power BI dashboard for AtliQ Hardware to analyze performance across key business domains—Sales, Marketing, and Finance. The goal was to provide a unified, data-driven view to support strategic decision-making.

Data was sourced from Excel/CSV files and a SQL database. I performed data cleaning and transformation, built a robust data model, and created interactive visualizations and KPIs for each domain. The dashboard revealed trends in sales, marketing campaign performance, and financial metrics.

Using DAX Studio, I optimized the report’s performance by 5%, ensuring faster load times and better responsiveness. The dashboard enabled stakeholders to monitor cross-departmental performance, uncover insights, and make timely decisions.

As a result, AtliQ projected a 10% increase in revenue and a 20% reduction in data-related costs. This project highlighted my skills in data integration, dashboard development, and performance optimization using Power BI.

Live Interactive Dashboard

Excel Project

Sales Analytics

Domain/Function: Sales

Created couple of reports to analyze the sales and to evaluate the company performance, And report will help to company and sales team for analyzing the YoY growth

View Project
Engagement

Sales Analytics

Sales report to analyze net sales and YoY growth of all the customer and their performance.

Sales Analytics

Target report represents the country and region which are achieving targets and countries which are under performing.

Project Details

This project focused on creating a detailed Profit & Loss (P&L) report to analyze sales performance, cost structure, and profitability over multiple years. The report included actual sales, cost of goods sold (COGS), gross profit, and net profit for different customers and time periods.

Power Pivot was used to handle large datasets and build relationships between multiple tables efficiently. Core Excel functions like SUMIF, VLOOKUP, and IF were used for financial calculations and variance analysis.

The final P&L report enabled clear comparison of actual figures against targets, along with year-over-year growth and profitability insights. This helped stakeholders assess financial health and make informed business decisions based on accurate and structured financial data.