Portfolio - Nikhil Mathur | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Nikhil Mathur

Data Aspirant

Resume

2

PowerBI
Projects

1

Python
Project

1

Excel
Project

About

Me

As a B.Tech CSE graduate, I possess a solid foundation in computer science. I also excel in managerial and communication skills. I am actively seeking opportunities to apply my expertise and contribute to a company's success. Currently, I am on a learning journey as a budding data analyst, where I thrive in the dynamic world of data. My goal is to make a positive impact by optimizing systems, driving innovation, and delivering data-driven insights. Let's connect and explore how I can be a valuable asset to your team

Key

Skills

SQL

Machine Learning

Python

My

Projects

HR Analytics

Leveraged Power BI for a comprehensive HR analysis, revealing gender distribution, salary trends, and leave balance insights. Unlocking data-driven HR decisions.

Credit card fraud Detection

Credit card fraud Detection

I have used classification algorithms to predict is it a fraud transaction or not and created a streamlit app for it . I used local tunnel for the streamlit.

IPL insights

I have created a dashboard for IPL Which Shows different winners' man of the match and other details. Using this dashboard, we can conclude decision like winning percentage and bowl first won or bat first won etc.

Sales Dashboard

Sales Dashboard

Transform eCommerce strategy with Power BI Profit Analysis Dashboard. Elevate profitability and drive results. The Dashboard says a lot about the Business of store

Awards

& Certificate

Intell Hackathon Participation

Intell Hackathon Participation

Python

ML basics

Contact Me

Email

[email protected]

Github

https://github.com/Mathurshab2210

Linkedin

https://www.linkedin.com/in/nikhil-mathur-4600661a8/

Call

+91 6377882275

Nikhil Mathur

Data Aspirant

Download Resume

Resume

PowerBI Project

HR Analytics

Leveraged Power BI for a comprehensive HR analysis, revealing gender distribution, salary trends, and leave balance insights. Unlocking data-driven HR decisions.

View Project
Engagement

Here are all the questions that are solved in this project

A view of Dashboard

Project Details

Utilizing Power BI, an intricate HR dashboard was crafted, providing an in-depth view of our workforce's composition. This analytical tool offers a comprehensive overview of staff demographics, salary structures, and leave balances. Gender distribution and top earners in each role are visualized, yielding invaluable insights for HR decision-making. The dashboard's interactive features facilitate easy data filtering and exploration. It serves as a vital resource for resource management, ensuring an informed HR approach. This project signifies a pivotal stride toward data-driven HR excellence in an ever-evolving landscape.

Project video

Live Interactive Dashboard

Python Project

Credit card fraud Detection

I have used classification algorithms to predict is it a fraud transaction or not and created a streamlit app for it . I used local tunnel for the streamlit.

View Project
Engagement

View Project
on GitHUB

Credit card fraud Detection

Classification report for algorithms

Credit card fraud Detection

Comparision between different algorithms

Project Details

Credit Card Fraud Detection Project:
Our Credit Card Fraud Detection project is a testament to our data analytics expertise. Using a sophisticated blend of Machine Learning models, including Logistic Regression, Random Forest, and Decision Trees, we've developed a robust solution to safeguard financial transactions.
One of the key challenges in fraud detection is dealing with imbalanced datasets, and we've tackled it effectively by employing advanced undersampling techniques. Leveraging Python, Pandas, NumPy, Scikit-Learn, Matplotlib, and Seaborn, we've meticulously analyzed and visualized data.
To enhance accessibility and user interaction, we've created an interactive Streamlit web application for real-time fraud detection visualization. Our commitment to precision and data-driven decision-making is evident in every aspect of this project.

Project video

Excel Project

IPL insights

I have created a dashboard for IPL Which Shows different winners' man of the match and other details. Using this dashboard, we can conclude decision like winning percentage and bowl first won or bat first won etc.

View Project
Engagement

View Project
on GitHUB

These are pivot tables created to get the insight over the winning team

Glimpse of the dashboard shoeing different KPI

Project Details

In this project I have used excel to gain valuable insight from the dataset of IPL and draw conclusions. I have done Data preprocessing also means performed ETL here. I have designed different Pivot tables related to data to get hold of the insights. I have also advanced concepts like Index-Match to fetch data and create KPI also fetched data dynamically from Pivot tables.

Project video

PowerBI Project

Sales Dashboard

Transform eCommerce strategy with Power BI Profit Analysis Dashboard. Elevate profitability and drive results. The Dashboard says a lot about the Business of store

View Project
Engagement

View Project
on GitHUB

Sales Dashboard

Valuable Insights drawn from Report

Sales Dashboard

Detailed analysis of the dataset

Project Details

Project Title: eCommerce Profit Analysis Dashboard
Overview
Unlock the potential of your eCommerce business with our dynamic Profit Analysis Dashboard. Powered by Power BI, it offers crucial insights into profit centers, customer behavior, seasonal trends, and more. Optimize strategies, drive profitability, and stay ahead of the competition.
Key Insights:
- Profit Centers
- Superstar Customers
- Seasonal Trends
- Preferred Payments
- Product Profitability
- Category Dominance
- Quarterly Performance

Impact:
Empower your team to make data-driven decisions, enhance customer experiences, and boost eCommerce success.

Tech: Power BI, Data Visualization, Business Intelligence, Data Analytics

Project video

Live Interactive Dashboard