Portfolio - Piyush Khadatkar

PowerBI Project

Employee Insights Dashboard for AtliQ Hardware

Unlock the power of data with the "Employee Insights Dashboard for atliQ Hardware." This dynamic Power BI project provides a comprehensive overview of the company's workforce, offering valuable insights into employee demographics, tenure, promotions, retirement projections, and job satisfaction.

View Project
on GitHUB

This report gives insights into the employee's promotion, retirement status, and count.

This report gives insights into employee's job satisfaction status, their overtime status, and the % of highly and poorly rated employees

Project Details

Key Features:
Demographic Distribution: Gain a quick understanding of the company's gender diversity with a visual breakdown of male and female employees.
Tenure Analysis: Explore the collective experience within the organization by analyzing the distribution of employees based on the number of years they have been with atliQ Hardware.
Promotion Tracking: Stay informed about recent promotions within the company. Identify employees who have recently climbed the career ladder and track the progression of talent.
Upcoming Promotions: Anticipate future advancements by identifying employees who are due for promotion. Plan succession strategies and ensure a seamless transition of responsibilities.
Job Satisfaction Metrics: Understand the pulse of your workforce by gauging job satisfaction levels.

Live Interactive Dashboard

PowerBI Project

AtliQ's Hardware Business Insights 360

"Explore the dynamic world of business insights with my Power BI project, showcasing the AtliQ hardware business data. This interactive dashboard provides a comprehensive view of the company's financial health, marketing performance, supply chain efficiency, and overall profit and loss status.

This report gives an insight into the finance of AtliQ's hardware, its net sales, gross margin, and net profit in a particular fiscal year.

This report gives an insight into the supply chain of AtliQ's hardware, its net sales overtime, and profit and loss over the years.

Project Details

Dive into key metrics such as total profit and loss, gross margin, cost of goods sold, and forecast accuracy. The user-friendly interface allows you to filter data by region, customer, and product, offering a granular understanding of the company's performance. The report is designed to align with fiscal years, providing a temporal perspective, and includes insightful KPIs with a comparative analysis to the previous year. Uncover valuable insights and make data-driven decisions by exploring this powerful visualization tool, now featured in my portfolio."

Live Interactive Dashboard

PowerBI Project

Sprocket Central Sales Insights

Explore the dynamic world of sales insights with my Power BI project, showcasing the Sprocket Central sales data. This interactive dashboard provides a comprehensive view of the company's sales and overall profit and loss status.

View Project
on GitHUB

This report gives insights into sales of Sprocket Central, on how the purchase were made in the last 3 years by customers of different categories.

This report gives insights into the profit of Sprocket Central, on how the profit was made in the last 3 years by different products and states.

Project Details

Dive into key metrics such as total profit and loss, purchases made by different age groups, sex, and different industries. The user-friendly interface allows you to filter data by region, customer, and product, offering a granular understanding of the company's sales performance. The report is designed to align with the last 3 years, providing a temporal perspective, and includes insightful KPIs with a comparative analysis of the last 3 years. Uncover valuable insights and make data-driven decisions by exploring this powerful visualization tool, now featured in my portfolio."

Live Interactive Dashboard

Python Project

Stock Market Data Analysis

Dive into the dynamic world of finance with my latest portfolio addition—an ETL-powered analysis of the stock performance of industry giants Apple, Amazon, Google, and Microsoft. Through meticulous ETL processes, I've harnessed the power of Python and various libraries to unveil key insights.

View Project
on GitHUB

This image shows the changes in price of the 4 major(Apple, Microsoft, Google, Amazon) stocks over time.

This image shows the moving average price of the 4 major(Apple, Microsoft, Google, Amazon) stocks over time.

Project Details

Explore the moving averages, and changes in stock prices over the last six months, and discover the intricate correlations between these major players in the market. The portfolio showcases my proficiency in leveraging Python for financial analysis, presenting the findings through an array of visually engaging charts and graphs. Immerse yourself in a user-friendly experience that enhances your understanding of these stock dynamics and empowers you to make informed investment decisions. Uncover the nuances of the stock market with this compelling exploration of financial data.

PowerBI Project

Mitron Bank Customer Analysis

Giving you an Analysis of a sample dataset of 4000 customers across five cities on their online spend and other details, along with their credit card usage and average income utilization.

View Project
Engagement

View Project
on GitHUB

This gives a complete overview on customer d on available demography such as age group, gender, occupation etc. and provide insights.

This gives us an overview of the income utilization of the customers, as on how and where the customers spend their income.

Project Details

Mitron Bank is a legacy financial institution headquartered in Hyderabad. They
want to introduce a new line of credit cards, aiming to broaden its product
offerings and reach in the financial market.
AtliQ Data Services came to know about this through an internal link and
approached Mitron Bank with a proposal to implement this project. However,
strategy director of Mitron Bank, Mr.Bashnir Rover is skeptical and asked them
to do apilot project with the sample data before handing them the full project.
They provided a sample dataset of 4000 customers across five cities on their
online spend and other details.
My role is to analyse the provided sample data and
report key findings to the strategy team of Mitron Bank. This analysis is
expected to guide them in tailoring the credit cards to customer needs and
market trends.

Hello, I am

Piyush Khadatkar

4

1

About

Key

My

Employee Insights Dashboard for AtliQ Hardware

AtliQ's Hardware Business Insights 360

Sprocket Central Sales Insights

Stock Market Data Analysis

Mitron Bank Customer Analysis

Awards

Contact Me

Email

Github

Linkedin

Call

Piyush Khadatkar

Download Resume