Powered by
Codebasics DA Bootcamp

Yash Nigam

Data Aspirant

+91 7020829143 [email protected]

Resume

Hello, I am

Yash Nigam.

2

Excel Projects

2

PowerBI Projects

1

SQL Project

1

Python Project

About Me

I'm Yash,
A Data Analyst specialized in SQL, Power BI and Excel.I turn complex data into actionable business insights and solve problems with innovative data solution.

Current focus and Expertise :

𝐒𝐐𝐋 : Expert in crafting powerful queries to extract meaningful insights from data.
𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 : Skilled in creating interactive dashboards and reports that provide clear insights, empowering stakeholders to make informed decisions. I've applied Power BI
to visualize complex data sets and identify key trends.
𝐄𝐱𝐜𝐞𝐥 : Proficient in using advanced formulas and pivot tables to deliver clear and impactful data analysis.
𝐃𝐚𝐭𝐚 𝐌𝐨𝐝𝐞𝐥𝐢𝐧𝐠 : Experienced in designing robust data models that enhance reporting accuracy and efficiency.
𝐃𝐚𝐭𝐚 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧 : Transformed complex data into easy-to-understand visualizations that highlight key business trends. I've created visualizations that have facilitated understanding and decision-making.

Key Skills

sql

dax

business acumen

pivot table

stake holder managment

power BI

Excel

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

HackerRank : SQL (Advanced)

HackerRank : SQL (Advanced)

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.

[email protected]

https://www.linkedin.com/in/yash-nigam-7b69361b3/

+ 91 7020829143

https://github.com/yashnigam25

Excel Project

Sales and Finance Analytics Reports

Domain/Function: FMCG

I analyzed sales data to assess market performance and track progress against targets. By examining data across different time periods and key metrics, I identified trends and highlighted top-performing markets, offering actionable insights for strategic growth.

Sales and Finance Analytics Reports

Customer Net sales performance over the years

Sales and Finance Analytics Reports

Market performance over the years

Project Details

In this project, I mastered the use of pivot tables to analyze sales data by market and year, gaining deeper insights into business performance and key metrics. This approach allowed me to identify potential growth areas. I leveraged DAX, Power Query, and data modeling to design a dynamic and insightful report, demonstrating my skill in turning data into strategic business solutions.

Python Project

DIWALI SALES ANALYSIS

Domain/Function: Sales Analysis

Performed data cleaning, exploratory data analysis (EDA) using python libraries for Diwali Sales. Improved sales by identifying most selling product categories and products, which can help to plan inventory and hence meet the demands.

View Project
on GitHUB

DIWALI SALES ANALYSIS

python data visualization

DIWALI SALES ANALYSIS

python data visualization

Project Details

𝟏)𝗗𝗮𝘁𝗮 𝗘𝘅𝗽𝗹𝗼𝗿𝗮𝘁𝗶𝗼𝗻: Delved deep into sales data to uncover trends, patterns, and key insights.
𝟐)𝗣𝘆𝘁𝗵𝗼𝗻 𝗠𝗮𝘀𝘁𝗲𝗿𝘆: Leveraged Python and essential libraries for efficient data manipulation and analysis.
𝟑)𝗩𝗶𝘀𝘂𝗮𝗹 𝗦𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴: Crafted compelling visualizations to communicate findings effectively.
𝟒)𝗦𝗮𝗹𝗲𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: Explored how Diwali promotions influenced sales, identifying growth opportunities.
𝟓)𝗦𝘁𝗮𝘁𝗶𝘀𝘁𝗶𝗰𝗮𝗹 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Applied statistical techniques to validate trends and draw meaningful conclusions.

𝙏𝙚𝙘𝙝 𝙎𝙩𝙖𝙘𝙠: •𝖯𝗒𝗍𝗁𝗈𝗇 •𝖯𝖺𝗇𝖽𝖺𝗌 •𝖬𝖺𝗍𝗉𝗅𝗈𝗍𝗅𝗂𝖻 •𝖲𝖾𝖺𝖻𝗈𝗋𝗇

PowerBI Project

Business Insights 360

Domain/Function: Brick and Mortar

In the "Business Insights 360" project, I used Power BI to build an interactive dashboard that delivers a comprehensive view of business performance, highlighting key metrics and trends to aid in strategic decision-making.

View Project
Engagement

Business Insights 360

An area chart, KPIs, and a P&L statement, offering a clear visual representation of financial performance and key business metrics.

Business Insights 360

The executive view is the most essential and pivotal section of our dashboard, tailored specifically for top-level executives, including CEOs.

Project Details

In the "Business Insights 360" project, I designed a comprehensive Power BI dashboard that delivers an in-depth analysis of business performance. By data modeling, data visualization and integrating multiple data sources, the dashboard effectively highlights key metrics, uncovers trends, and provides actionable insights.

What's inside ?
Finance view : Analysing revenue, expenses and profits.
Sales view : Evaluate Product & Customer Performance
Marketing view : Evaluated Product performance by Net sales, Gross Margin % and Net Profit %
Supply Chain view : Identify cost-saving opportunities, analyzed KPIs for Net Error, Absolute error and Forecast accuracy
Executive view : Pinpoint high value customers and products by revenue

Live Interactive Dashboard

PowerBI Project

SuperStore-Sales-Dashboard

Domain/Function: FMCG

Incorporated Data Analysis techniques, specializing in the Time Series Analysis, to deliver valuable Insights, accurate Sales Forecasting, And Interactive Dashboard creation, driving business success.

View Project
Engagement

View Project
on GitHUB

SuperStore-Sales-Dashboard

_

SuperStore-Sales-Dashboard

_

Project Details

- Dashboard Creation: Identify the KPI's, design and intuitive and visually appealing dashboard, add interactive visualizations and filtering capabilities to allow users to
explore the data at various levels of granularity.
- Data Analysis: Provide valuable insights to business entities regarding the effectiveness of their sales strategies through visualization and charts.
- Sales Forecasting: Leverage historic data and apply time series analysis to generate sales forecasts for the next 15 days.
- Actionable Insights and Recommendations: End goal is to share valuable insights and actionable information that can drive strategic decision-making and support
the supermarket's goals for growth, efficiency and customer satisfaction.

Live Interactive Dashboard

Excel Project

EXCEL PROJECT : VRINDA STORES DASHBOARD

Domain/Function: FMCG

EXCEL PROJECT : VRINDA STORES DASHBOARD The main objective is to create annual sales report for 2022. So that, Vrinda store can understand their customers and grow more sales in 2023.

View Project
on GitHUB

EXCEL PROJECT : VRINDA STORES DASHBOARD

_

EXCEL PROJECT : VRINDA STORES DASHBOARD

_

Project Details

- 𝘋𝘢𝘵𝘢 𝘊𝘭𝘦𝘢𝘯𝘪𝘯𝘨: Cleaned the inconsistent and wrongly spelt values.
- 𝘋𝘢𝘵𝘢 𝘗𝘳𝘰𝘤𝘦𝘴𝘴𝘪𝘯𝘨: Added two new columns "Age Group" and extracted "Month" values from existing
date column.
- 𝘋𝘢𝘵𝘢 𝘈𝘯𝘢𝘭𝘺𝘴𝘪𝘴: Created Pivot Tables for uncovering required trends and patterns.
- 𝘋𝘢𝘵𝘢 𝘝𝘪𝘴𝘶𝘢𝘭𝘪𝘻𝘢𝘵𝘪𝘰𝘯: Inserted slicers and created various charts like Column charts, Bar charts, Pie
charts.
- 𝘙𝘦𝘱𝘰𝘳𝘵 𝘊𝘳𝘦𝘢𝘵𝘪𝘰𝘯: Finally created a report for Vrinda store.

SQL Project

Music-Store-Data-Analysis-SQL

Domain/Function: Music Store Sales Analysis

Music-Store-Data-Analysis-SQL This project implements a MySQL database for a music store. The database stores information about customers, employees, products (including albums, tracks, and instruments), purchases, and more.

View Project
on GitHUB

Music-Store-Data-Analysis-SQL

Queries

Music-Store-Data-Analysis-SQL

Schema diagram

Project Details

Database Structure
The database consists of the following tables:

- customers: Stores customer information (ID, name, address, email, phone).
- employees: Stores employee information (ID, name, job title, hire date, salary).
- products: Stores product information (ID, name, price, description, category).
- albums: Stores album information (ID, title, artist, release year, genre, label, price).
- tracks: Stores track information (ID, album_id, name, length, price).
- instruments: Stores instrument information (ID, name, brand, price, type).
- orders: Stores order information (ID, customer_id, order_date, total_amount).
- order_details: Stores order details (order_id, product_id, quantity, price).
- inventories: Stores inventory information (product_id, quantity_in_stock).
- payments: Stores payment information (order_id, payment_method, payment_date, amount).