Ayush Singh

Data Analyst

[email protected] +91 7880562304

Resume

Hello, I am

Ayush Singh.

1

Excel
Project

1

PowerBI
Project

About Me

Welcome to my portfolio website!
I'm Ayush, and I'm excited to share my journey with data with you. I hold a Bachelor's degree in Information Technology from PSIT Kanpur (Pranveer Singh Institute of Technology).

My passion for data analysis began in my childhood, particularly through my love for cricket. I spent countless hours analyzing sports statistics, which eventually led me to pursue a career in data analysis. I see data everywhere and thrive on finding insights that help solve complex problems.

I take pride in my data-driven approach to problem-solving, meticulously analyzing datasets to extract valuable intelligence. Whether it's identifying key performance indicators, refining sales strategies, or forecasting future trends, my goal is to unlock the full potential of data to drive business growth.

Key Skills

SQL

Python

Problem Solving

Data Visualization

My Projects

Excel Analytics: Extracting Business Insights for AtliQ Hardware

Domain/Function: Brick & Mortar Business

Business Insights 360

Domain/Function: Brick & Mortar & e-commerce

My Experience

PwC Switzerland Power BI Job Simulation - May 2024

I completed a job simulation where I strengthened my PowerBI skills to understand clients and their data visualization needs better.
Demonstrated expertise in data visualization by creating Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions.
Strong communication skills reflected in concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.
Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making.

Awards & Certificate

Google : Data 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/ayush-singh1203/

Call Me

+91 7880562304

GitHub

https://github.com/Ash0999

Excel Project

Excel Analytics: Extracting Business Insights for AtliQ Hardware

Domain/Function: Brick & Mortar Business

The project aimed to uncover valuable insights into sales trends, customer behavior, and product performance. I employed a range of advanced Excel tools and techniques to transform raw data into actionable insights.

View Project
Engagement

View Project
on GitHUB

I have prepared a report of sales performance of market.

i made a report of target vs market to show the performance of companies.

Project Details

🎯 Key Skills Demonstrated:
Data Cleaning & ETL: Cleaned and transformed the raw data, ensuring it was ready for analysis. Streamlined the data extraction, transformation, and loading (ETL) processes to maintain data integrity.
Data Modeling: Structured the data effectively for analysis, ensuring accuracy and efficiency in deriving insights.
Pivot Tables: Created dynamic pivot tables to explore different dimensions of the data, including product categories, sales regions, and time periods.
Advanced Excel Functions & DAX: Utilized functions such as VLOOKUP, INDEX-MATCH, SUMIFS, and DAX formulas to perform complex calculations and data lookups.
Data Visualization: Designed charts and graphs to visually represent key findings, making the insights easy to interpret and share.

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar & e-commerce

AtliQ Hardware aims for a competitive edge through Power BI analytics. This dashboard covers Finance, Sales, Marketing, Supply Chain and Executive view throughout globally.

Other Tools

MySQL

DAX Studio

excel

Home Page of the BI 360 Dashboard

Finance View of the BI 360 Dashboard

Project Details

Curated an interactive Power BI dashboard for AtliQ hardware's business using tools like - MySQL Database, CSV files, Microsoft Power BI Desktop, and Microsoft Power BI Service with five different views for five different departments in a business organisation.

1. Executive View: Top 5 Customer / Product insights and Key Performance Indicators (KPIs) for comparative analysis.

2. Marketing View: Key Performance Indicators (KPIs) for product / customer and scattered plot chart showing Net Profit (NP%) performance with Gross Margin (GM%) & Net Sales (Net Sales%).

3. Sales View: Customer / Product performance analysis and Performance Metrics tracking.

4. Finance View: P&L statement. Top / Bottom products by Net Sales and Net sales performance over time.

5. Supply Chain View: Key metrics analysis for customers / products and Measures such as Forecast Accuracy %, Net Error %, Risk.