DEVANSH CHOPRA

Data Aspirant

[email protected] +91 8860608241

Resume

Hello, I am

DEVANSH CHOPRA.

1

PowerBI
Project

1

Excel
Project

About Me

I am Devansh Chopra, an Economics Honours undergraduate with a keen interest in data analytics. Proficient
in Microsoft Excel, Tableau, PowerBI, and SQL for data manipulation, visualization, and statistical modelling. Strong problem-solving abilities and analytical mindset for deriving insights from complex datasets. Effective communicator with experience
presenting research findings. Seeking opportunities to contribute to a data-driven organization, leveraging economics knowledge and passion for data analytics.

Key Skills

Excel

SQL

Power Bi

Data Analysis

Data Visualization

Data Modelling

My Projects

Business Insights 360 for Finance, Sales, Marketing and Supply Chain

Domain/Function: Business Insights 360 for Finance, Sales, Marketing and Supply Chain

Sales and Finance Analytics for AtliQ Hardwares

Domain/Function: Consumer Goods Domain

My Experience

During my 6-month tenure in the BPO industry, I leveraged both my analytical and communication skills to drive process improvements and deliver measurable results. I developed and implemented a standardized process that successfully reduced a 15% variance in issue resolution times, training 20 team members and decreasing resolution time variability by 10%. Additionally, I created and managed an Excel-based database to streamline data management for key accounts, tracking over 30 escalations per month and reducing data entry errors by 15%. By conducting a thorough root cause analysis of customer feedback data, I identified the underlying factors contributing to a 5% drop in customer satisfaction scores. Addressing these issues led to a 4% improvement in overall satisfaction, further highlighting my ability to apply data-driven insights to resolve challenges and enhance performance.

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/devansh-chopra-b7a8771b3/

Call Me

+91 8860608241

PowerBI Project

Business Insights 360 for Finance, Sales, Marketing and Supply Chain

Domain/Function: Business Insights 360 for Finance, Sales, Marketing and Supply Chain

AtliQ Hardware, a growing consumer electronics firm, struggles to compete in the data-driven landscape due to reliance on Excel. My objective is to propel the company forward by implementing a Power BI advanced analytics solution, empowering data-driven decision-making for strategic insights.

Other Tools

Excel

SQL

Power Query

DAX

Designed a user-centric landing page as part of the dashboard, ensuring intuitive navigation and an engaging experience as per user needs.

A comprehensive data model with 10+ tables, establishing precise relationships and efficient data flow to support in-depth analysis across all areas.

Project Details

In this project, the goal was to create a comprehensive report for stakeholders in sales, marketing, finance, supply chain, and executive teams.
1. Finance View: Displays P&L statements to assess financial performance across markets, products, and customers.
2. Sales View: Highlights top/bottom customers with key performance metrics.
3. Marketing View: Showcases top/bottom products and their performance metrics.
4. Supply Chain: Evaluate reliability and forecast accuracy to assess supply chain performance.
5. Executive View: Provides an integrated overview with key insights for executive decision-making.
Learnings:
1. Power Query (basic and advanced operations) and complex DAX formulas.
2. Key metrics in sales, marketing, finance, and supply chain.
3. Data modeling with 10+ tables.
4. Visual selection and effective formatting.
5. Dashboard design principles and using bookmarks.
6. Deploying reports on Power BI service.
7. Implementing stakeholder feedback for refinement.

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics for AtliQ Hardwares

Domain/Function: Consumer Goods Domain

This project aims to deliver a detailed analysis of the company's financial health and market standing. By utilizing advanced Excel techniques, it generates key reports like "Customer Net Sales Performance" and "Market Performance vs. Target," offering valuable insights for informed decision-making.

View Project
on

Other Tools

Power Query

DAX

PivotTable

PowerPivot

The Customer Performance Report presents each customer's annual net sales performance, providing clear insights into individual customers.

The "Market Performance vs. Target" report enables stakeholders to evaluate multi-year country performance, comparing results to targets.

Project Details

In this project, I developed a Sales Report using Excel pivot tables to help businesses optimize customer discounts, streamline negotiations, and identify high-potential markets, resulting in improved sales strategies and a 10% increase in revenue generation.
I leveraged tools such as Pivot Tables, Power Query, and basic DAX for advanced analysis, applying conditional formatting and report beautification to enhance clarity and presentation. By analyzing key sales metrics, the project provided actionable insights that enabled businesses to make data-driven decisions, uncover growth opportunities, and refine strategies for sustainable growth and market expansion.