Achal Yadav

Data Aspirant, Data Analyst

[email protected] +91 7987847684

Resume

Hello, I am

Achal Yadav.

1

Excel
Project

1

PowerBI
Project

About Me

Hello! I’m an aspiring Data Analyst with a knack for transforming complex data into clear, actionable insights. Armed with a Bachelor’s degree in Information Technology, I’ve discovered my true passion in data analysis. My expertise spans Excel, PowerBI, SQL, and Python, allowing me to uncover hidden patterns and drive informed decisions.

While I may be new to the corporate world, my portfolio is a testament to my capabilities. Through various business projects, I've demonstrated my ability to convert raw data into compelling narratives that inform strategy and decision-making. Each project reflects my commitment to precision, creativity, and impactful analysis.

I’m excited to bring my unique perspective and technical skills to your team, and I’m confident that my fresh approach to data will add significant value.

Key Skills

Effective Communication

Stakeholder Management

My Projects

Sales Insight Report

Domain/Function: Sales Analytics

All-in-One Business Metrics Dashboard-Business 360 Insights

Domain/Function: Business Analytics

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/achalyadav007/

Call Me

+91 7987847684

GitHub

https://github.com/AchalHub001

Excel Project

Sales Insight Report

Domain/Function: Sales Analytics

Developed two comprehensive reports for the sales team to assess customer performance and evaluate market performance relative to targets. These reports enable a deeper understanding of sales dynamics and facilitate strategic decision-making.

View Project
Engagement

View Project
on GitHUB

Tracks and analyzes net sales performance for each customer over multiple years, offering insights into long-term sales trends and customer value.

Analyzes annual market performance in relation to targets, allowing stakeholders to assess and compare each country’s performance against its goal.

Project Details

In this project, I designed a comprehensive sales report using Excel pivot tables to assist businesses in strategizing customer discounts, streamlining negotiations, and pinpointing growth opportunities in emerging markets. The resulting reports deliver actionable insights that help businesses refine their sales tactics, boost customer satisfaction, and optimize revenue streams.

Key Learnings:

- Advanced Pivot Table Techniques
- Power Query for Data Transformation
- Fundamentals of DAX
- Applying Conditional Formatting
- Enhancing Report Aesthetics
- Understanding Sales Metrics

Project Objective:

The goal of this project is to equip businesses with powerful analytical tools to better track, assess, and improve their sales performance. By utilizing detailed sales data analysis, companies can discover new avenues for expansion, foster growth, and maintain a competitive edge in today’s fast-paced market environment.

PowerBI Project

All-in-One Business Metrics Dashboard-Business 360 Insights

Domain/Function: Business Analytics

AtliQ Hardwares, a rapidly expanding consumer electronics company, is struggling to compete with data-driven competitors due to their reliance on Excel for reporting. My objective is to deploy a sophisticated analytics solution using Power BI, empowering the company to derive actionable insights.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

I developed a data model utilizing a "SNOWFLAKE" schema.

Project Details

AtliQ Hardware, a global leader in computers and accessories, has encountered unexpected losses. To gain a competitive edge, they have implemented Power BI analytics, integrating 1.8 million records from Excel, CSV, and MySQL. The Power BI Dashboard encompasses:

Home Page: Central navigation hub.
Finance: Enhances financial planning and analysis.
Sales: Drives revenue growth and market share.
Marketing: Boosts brand visibility and engagement.
Supply Chain: Optimizes inventory and logistics.
Executive: Offers a comprehensive overview for top management.

Key Learnings:

-Mastery of Power Query (Basic and Advanced Operations)
-Proficiency in Basic and Complex DAX Formulas
-Expertise in Data Modelling with 10+ Tables
-Selection of Appropriate Visuals and Formatting Techniques
-Principles of Effective Dashboard Design
-Utilization of Bookmarks for Navigation
-Deployment in Power BI Service
-Incorporation of Stakeholder Feedback