Portfolio - Akshaya Naik | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Akshaya Naik

Data Aspirant

Resume

1

Excel
Project

1

SQL
Project

1

PowerBI
Project

About

Me

Passionate Data Analyst with a strong academic foundation in Electronics and hands-on experience gained through a CodeBasics Bootcamp. Proficient in SQL, Power BI, Excel, and Python, I thrive on transforming raw data into meaningful insights. During a purposeful learning gap year, I honed critical analysis skills and cultivated a structured approach to thinking, evident in my diverse project portfolio spanning business analytics, revenue insights, and banking domains. Excited to contribute my analytical expertise and commitment to excellence to impactful data-driven projects.

Key

Skills

SQL

Python

My

Projects

Resume Dashboard

Resume Dashboard

From pdf to visuals ,Resume showcasing my skills efforts creativity in simplest way. In era of Open AI What remans constant is individual creativity ,ability of think and showcase it .It is my way of showcasing recruiters about my efforts dedication and individuality .

AtliQ Hardware DataAnalytics

AtliQ Hardware DataAnalytics

AtliQ Hardware Company seeks to leverage SQL in depth data analysis to gain valuable insights into financial performance ,supply chain and sales trends.

HR Analytics

As data is ruling everywhere in industry ,lets hiring manager increase their efficiency using data .Designed POWER BI dashboard to track Employee data for HR team including working hours attendance performance and leaves .
Learnt visualization basics , DAX formula and to use measures .

Contact Me

Email

[email protected]

Github

https://github.com/projectsakshaya

Linkedin

https://www.linkedin.com/in/akshayanaikanalyst/

Call

+91 7208274842

Akshaya Naik

Data Aspirant

Download Resume

Resume

Excel Project

Resume Dashboard

From pdf to visuals ,Resume showcasing my skills efforts creativity in simplest way. In era of Open AI What remans constant is individual creativity ,ability of think and showcase it .It is my way of showcasing recruiters about my efforts dedication and individuality .

View Project
on GitHUB

Other Tools

Power Point presentation

Resume Dashboard

Excel for ETL(extract transform load) proecss

Resume Dashboard

Power Presentation for visualization

Project Details

In era of Open AI What remains constant is innovation ,ability of think and present .It is my way of showcasing recruiters about my efforts dedication and individuality .

Project video

SQL Project

AtliQ Hardware DataAnalytics

AtliQ Hardware Company seeks to leverage SQL in depth data analysis to gain valuable insights into financial performance ,supply chain and sales trends.

View Project
Engagement

View Project
on GitHUB

AtliQ Hardware DataAnalytics

Financial Analytics

AtliQ Hardware DataAnalytics

Visual Representation

Project Details

AtliQ Hardware Company seeks to leverage SQL in depth data analysis to gain valuable insights into financial performance ,supply chain and sales trends.

TOOLS USED
1.MYSQL
2.EXCEL
3.DOCS /PPT TO PRESENT

MY SQL
BASIC FUNCTION
USER DEFINED FUNCTIONS
STORED PROCEDURES
DATABASE VIEWS
WINDOW FUNCTION

DOMAIN KNOWLEDGE
1.Profit and loss statement
2.Gross Price ,net sales ,net invoice sales ,post and pre invoice sales ,cost of goods ,gross margin .
3.Supply chain Basics

Solved Problem statement stated by Product Owner
By using Stored procedures generated Customer Product wise report and by using database Views in SQL queries generated report ,various charts which contains top customer ,product and market for AtliQ Hardware . Generated fact accuracy report and comparison report for previous year .This could help them in decision making optimize inventory management and enhance operational efficiency.

Project video

PowerBI Project

HR Analytics

As data is ruling everywhere in industry ,lets hiring manager increase their efficiency using data .Designed POWER BI dashboard to track Employee data for HR team including working hours attendance performance and leaves . Learnt visualization basics , DAX formula and to use measures .

View Project
on GitHUB

POWER BI DATA OF ATTENDANCE

VISUALIZATION DASHBOARD

Project Details

Designed POWER BI dashboard to track Employee data for HR team including working hours attendance performance and leaves .
Learnt visualization basics , DAX formula and to use measures .

Live Interactive Dashboard