Portfolio - Chinmaya Nayak

Chinmaya Nayak

Data Analyst

Resume

1

Excel Project

2

PowerBI Projects

1

SQL Project

1

Python Project

About Me

As a passionate and ambitious data analytics enthusiast with a strong foundation in physics, I am eager to leverage my skills to drive impactful insights and solutions. My background in physics has honed my analytical thinking and problem-solving abilities, providing a solid base for my career in data analytics.
I have developed expertise in machine learning, SQL, Power BI, advanced Excel, Python, and NLP. My deep understanding of statistics and probability further enhances my analytical capabilities. Driven by a passion for data analysis, I am dedicated to utilizing my diverse skill set to uncover valuable insights and contribute to meaningful solutions in the field of data analytics.

Key Skills

SQL

Machine Learning

Statistics

Python

Effective Communication

My Projects

Sales Analytics

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

Domain/Function: Business Intelligence (BI) and Data Analytics

Finance Analytics

Domain/Function: Finance/Sales

Comprehensive Web Scraping of Amazon Products and Ambition Box Reviews

Domain/Function: Data Collection and Extraction

Data Science Job Salaries Analysis and Predict

Domain/Function: Data Analysis and Visualization

Hospitality Analysis

Domain/Function: Business Intelligence and Data Analytics

Awards & Certificate

Machine Learning with Python

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/chinmay-nayak-93b527261/

Call Me

+91 +917855954363

GitHub

https://github.com/chinmayiitian1

Excel Project

Sales Analytics

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect 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

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

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

Domain/Function: Business Intelligence (BI) and Data Analytics

AtliQ Hardwares 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 and make i

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the objective was to create a comprehensive report usable by stakeholders in sales, marketing, finance, and the executive team. The emphasis was placed on:

Robust Data Modeling
User-Centric Report Design
Drillable Insights
Throughout this project, I gained experience in:

Power Query (Basic and Advanced Operations)
Basic and Complex DAX Formulas
Data Modeling with over 10 tables
Selecting appropriate visuals and formatting
Dashboard Design Principles
Using Bookmarks
Deploying in Power BI Service
Implementing Stakeholder Feedback
Metrics in Sales, Marketing, Finance, and Supply Chain
The project aimed to provide a single, versatile report for diverse stakeholders, focusing on robust data modeling, user-friendly design, and in-depth insights.

Live Interactive Dashboard

SQL Project

Finance Analytics

Domain/Function: Finance/Sales

Fetching the most important information using SQL queries, such as identifying the top markets, top products, and top customers according to the fiscal year.

View Project
on GitHUB

Showcases my SQL coding skills in MySQL Workbench, where I executed queries to retrieve critical business insights.

Demonstrating the creation of views, stored procedures, and functions. Showcases my skills in enhancing database functionality and efficiency.

Project Details

1----Advanced SQL Techniques

Subqueries, CTEs, Views, Temporary Tables: Proficient in writing complex queries using subqueries and Common Table Expressions (CTEs). Skilled in creating and using views and temporary tables for efficient data management.

2---Data Integration and Storage
ETL, Data Warehousing, OLAP/OLTP: Thorough understanding of Extract, Transform, Load (ETL) processes, data warehousing concepts, and the distinctions between Online Analytical Processing (OLAP) and Online Transactional Processing (OLTP).

3---SQL Code Optimization
User-Defined Functions, Stored Procedures: Experienced in creating user-defined functions and stored procedures to enhance code reusability and performance.

4---Advanced Analytical Functions
Window Functions: Proficient with advanced analytical functions like OVER, ROW_NUMBER, RANK, and DENSE_RANK for complex calculations and analysis within result sets.

Python Project

Comprehensive Web Scraping of Amazon Products and Ambition Box Reviews

Domain/Function: Data Collection and Extraction

In this project, I utilized Python's BeautifulSoup to scrape product data from Amazon and employee reviews from Ambition Box. The extracted data was then cleaned, analyzed, and visualized to uncover valuable insights and trends.

View Project
on GitHUB

This section showcases the Python BeautifulSoup code used to scrape product details from Amazon, highlighting the process of making HTTP requests and

This table shows the product information scraped from Amazon, including details such as product names, prices, and ratings.

Project Details

1-Introduction: What is Web Scraping?
Web scraping is a technique to automatically access and extract large amounts of information from a website, which can save a huge amount of time and effort.
2-Prerequisites
2.1-install BeautifulSoup pip install beautifulsoup4
2.2-install Requests pip install requests
2.3-install Pandas pip install pandas
2.4-the user-agent of your browser. To get the user-agent, just search for "my user agent" on Google and copy the user-agent string.
2.5-product search url from amazon.
3-Process of Web Scraping
3.1-Importing the required libraries
3.2-Specifying the URL containing the dataset and passing it to requests.get() to get the HTML content of the page.
3.3-Using BeautifulSoup to parse the HTML content
3.4-Extracting the required information from the data
3.5-Saving the pandas dataframe as a CSV file called Amazon Data.csv

Data Science Job Salaries Analysis and Predict

Domain/Function: Data Analysis and Visualization

Emphasized an exploratory data analysis project on data science job salaries, focusing on data cleaning and visualization of compensation dimensions using pandas, seaborn, and matplotlib.

View Project
on GitHUB

Visualization of salary distributions across various job titles in the data science field, highlighting compensation trends and insights.

Salaries Vs Experience Label based on Companies

Project Details

In my project on data science job salaries, I conducted extensive exploratory data analysis to uncover insights into various aspects of job compensation:

Data Cleaning and Visualization:

I cleaned and prepared the dataset using pandas to ensure data accuracy and consistency, which involved handling missing values and formatting data for analysis. I visualized the distribution of company sizes using seaborn and matplotlib to explore how salary varies across different company scales.

Key Analytical Areas Included such as :

1-Exploring Experience Levels.
2-Analysis by Employee Type.
3-Distribution Visualization.
4-Top Paid Professionals.
5-Salary Comparisons Across Tech Companies.

PowerBI Project

Hospitality Analysis

Domain/Function: Business Intelligence and Data Analytics

This project aims to address the decline in market share and revenue at AtliQ Grands by identifying and improving the least profitable property and tracking weekly booking trends.

View Project
Engagement

View Project
on GitHUB

User empathetic landing page as a part of dashboard design

Data Modelling involving 6 tables

Project Details

Problem Statement:
AtliQ Grands, a premier luxury hotel chain in India, is experiencing a decline in market share and revenue due to competitive pressures and internal decision-making challenges.

Goals:
Optimize Property Performance: Identify and improve the least profitable property.
Operational Insights: Track weekly booking trends to refine operational strategies.

KPIs Created Using DAX:

1-Total Bookings
2-Total Revenue
3-Average Rating
4-Total Capacity
5-Total Successful Bookings
6-Occupancy %
7-Total Cancelled Bookings
8-Cancellation Rate
9-Revenue Loss
10-Total Stay