Portfolio - Nitin Nautiyal | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Nitin Nautiyal

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

Experienced procurement operations professional with expertise in end-to-end procure-to-pay (P2P) processes. Skilled in leveraging data analytics and visualization tools such as Power BI, SQL, and Excel to drive data-informed decision-making and optimize procurement strategies. Passionate about streamlining operations, enhancing efficiency, and delivering tangible results.

Key

Skills

SQL

Microsoft office

Google sheets & Google docs

Procurement operations

My

Projects

Sales Analytics of Atliq Hardware

Sales Analytics of Atliq Hardware

Created reports for sales and marketing team, which will help them in evaluation of customer performance and understanding the performance of the market with their respective targets.

Business Insight 360

Business Insight 360

This project focuses on Atliq Hardware, a global electronics company experiencing rapid growth. Despite its international reach, it still uses Excel for data analysis, which hinders valuable insights. This led to substantial losses in Latin America.

Supply Chain Analytics of Atliq Hardware

Supply Chain Analytics of Atliq Hardware

I this project I have analyzed the supply chain analytics of a company that sold IT peripherals to different customers like Croma, amazon ,etc. in different countries.
I have found out useful insights for finance and marketing team from raw excel data.

Contact Me

Email

[email protected]

Github

https://github.com/Nitinnautiyal07

Linkedin

https://www.linkedin.com/in/nitin-nautiyal

Call

+91 8393824244

Nitin Nautiyal

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics of Atliq Hardware

Created reports for sales and marketing team, which will help them in evaluation of customer performance and understanding the performance of the market with their respective targets.

View Project
Engagement

View Project
on GitHUB

Sales Analytics of Atliq Hardware

Sales performance report: Profit and Loss statement of Atliq hardware for each quarter across years.

Sales Analytics of Atliq Hardware

Market performance vs Target report across years: provides insights to stakeholders to asses the performance of the countries by comparing the sales w

Project Details

In this project, I used Excel to analyze the sales data of Atliq Hardware, a company that sells accessories to various stores like Croma, Best Buy, and Amazon. Utilizing Excel's advanced features like pivot tables, Power Query, DAX (basics), conditional formatting, and lookups. This project enables the business to:

* Determine effective customer discounts.
* Identify areas for improvement in sales strategies.
* Discover potential opportunities for business expansion.
* Provide valuable insights to enhance customer satisfaction.
* Maximize revenue through data-driven decision-making.

Overall this project equips the company with the tools and knowledge to optimize its sales strategy, improve customer satisfaction, and ultimately boost its revenue.

PowerBI Project

Business Insight 360

This project focuses on Atliq Hardware, a global electronics company experiencing rapid growth. Despite its international reach, it still uses Excel for data analysis, which hinders valuable insights. This led to substantial losses in Latin America.

Business Insight 360

This shows how customers and product performance change in different places as time passes.

Business Insight 360

This executive dashboard provides various insights, including Atliq' market share compared to its competitors and the company's unit economics across

Project Details

In this project, I've been on a mission to make data super useful. Here's what I've been up to:

1)Smart Columns: I learned how to create special data columns that can do clever math.
2)DAX Language: I picked up a language called DAX to create cool formulas for our data.
3)Bookmarks: I made it easy to save our favorite data views, like marking pages in a book.
5)Easy Navigation: I added buttons to help us move around our data easily.
6)Dynamic Titles: I made titles that change when we use filters, like a weather update.
7)Error Check: I made sure our data is accurate, like a chef checking ingredients.

we found some super valuable info, especially for Sales and Marketing. We can now make smart decisions, like giving discounts in certain places to sell more stuff and make our company even better. So, in a nutshell, this project is all about turning data into secret weapons to help our company do awesome things.

Live Interactive Dashboard

SQL Project

Supply Chain Analytics of Atliq Hardware

I this project I have analyzed the supply chain analytics of a company that sold IT peripherals to different customers like Croma, amazon ,etc. in different countries. I have found out useful insights for finance and marketing team from raw excel data.

View Project
Engagement

View Project
on GitHUB

Supply Chain Analytics of Atliq Hardware

Utilizing window functions to compute the distribution of each customer's market share across different regions.

Supply Chain Analytics of Atliq Hardware

Create a stored procedure that classifies markets into "gold" or "silver" categories based on their total sales, with markets exceeding 5 million cons

Project Details

In this project, I conducted an in-depth analysis of the supply chain analytics of a company that specializes in manufacturing IT accessories distributed to both online and offline retail stores. The analysis encompassed a wide array of SQL-related topics and other pertinent concepts crucial for comprehending and optimizing the company's supply chain operations.

The project covered SQL joins (INNER, OUTER, CROSS), various SQL functions (averages, sums, counts, aggregates, scalars, windows), subqueries, view creation, database normalization, CTEs, stored procedures, user-defined functions, database creation from ERD, Fact vs. Dimension tables, Star vs. Snowflake schemas, Kanban, database indexes, ETL, Data Warehouse, OLAP vs. OLTP, and data catalogs in the context of finance, supply chain, and customer analytics.