Portfolio - NOMULA SACHIN

NOMULA SACHIN

Data Science

Resume

1

Excel Project

1

PowerBI Project

1

Python Project

1

SQL Project

About Me

Welcome to my portfolio website. I'm an aspiring Data Analyst with a knack for extracting valuable insights from data using Excel, PowerBI, SQL, and Python.

My journey started with a bachelor's degree in computer science and engineering, but it was data analysis that stole my heart. I have a natural talent for it, and I can't wait to put my skills to work.

While I may not have formal work experience, I've taken on several impactful business projects, and you can see them in my portfolio. These projects showcase my abilities and dedication to data analysis.

Now, I'm eager to dive into the professional world and make a difference with my data skills. Let's team up and uncover the hidden potential in your data. Get ready for a data-driven adventure! Connect with me, and let's get started.

Key Skills

sql

python

problem solving

story telling

stakeholder management

My Projects

Sales Analytics(FMCG)

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

Hospitality Domain Data Analytics

Provide Insights to Management in Consumer Goods Domain

Awards & Certificate

Statisics for data analytics

Data Cleaning and Preprocessing with Pandas

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/sachin-nomula-b33683179/

Call Me

+91 7337477887

GitHub

https://github.com/NOMULASACHIN1998

Excel Project

Sales Analytics(FMCG)

I have generated two reports for the sales team that will aid them in assessing customer performance and gaining insights into their market performance in relation to their target

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

This project showcases my skills in the following areas:

Excel pivot tables and Power Query for efficient data analysis and report generation.
Utilizing DAX functions to extract meaningful insights from sales data.
Applying conditional formatting to highlight important trends and patterns.
Enhancing report visualizations and aesthetics through thoughtful beautification techniques.
Demonstrating expertise in sales domain metrics and their application in business decision-making.
The resulting sales reports enable businesses to effectively determine customer discounts, negotiate with consumers, and identify potential expansion opportunities in promising countries. By providing actionable insights and recommendations, this project equips businesses with the necessary tools to optimize sales strategies, enhance customer satisfaction, and maximize revenue generation. Ultimately, these skills empower businesses to stay competitive in the market landscape and capitalize on new growth

PowerBI Project

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

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights

View Project
Engagement

Dashboard design includes a landing page crafted with a user-centric approach.

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance, and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modeling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Python Project

Hospitality Domain Data Analytics

Atliq Grand Hotel is their across India for the past 20 years recently because of the strategic move made by competitors they are losing market share and revenue declining Atliq management recognize the problem and hired a data analyst who gives data-driven insights

View Project
Engagement

View Project
on GitHUB

Occupancy percentage on weekdays and weekends

the average occupancy rate in each of the room categories

Project Details

In this Project, we work on Hospitality Domain Data Analytics where we
perform Data analytics on Atliq Grand Hotel is their across India for the past 20 years recently because of the strategic move made by competitors they are losing market
share and revenue declining Atliq management recognizes the problem and
hired a data analyst who gives data-driven insights. The focus made on
following

1.Analyize the data by given datasets(Hotel,Rooms,Bookings.....)
2. Find out insights from the datasets

I learned the following things in this project

1. Understanding Datasets
2. Data Exploration
3. Data cleaning
4. Data transformation
5. Data visualization
6. Finding Outliers
7. Insights generation
8.Pandas and Matplotlib

SQL Project

Provide Insights to Management in Consumer Goods Domain

Atliq Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics tea

View Project
Engagement

View Project
on GitHUB

the segment which is most increased in unique products in 2021 vs 2020?

Get the products that have the highest and lowest manufacturing costs.

Project Details

In this project, the goal is to perform Ad-hoc requests on consumer goods. The focus is made on the following

1. Data analysis on consumer goods
2. Create a Presentation for Top-level management
3. Drillable Insights

I learned the following things in this project

1.ETL(Extract Transform Load)
2. Facts and Dimensions Tables
3. Aggregation Functions like sum, count, divide
4. Choosing the right visuals and formatting
5. Provide insights to executive management
6. About Joins, With clause in SQL
7. Windows Function in SQL
8. Case Statements for conditions statements
9. Creating visualization by Data visualization tools