Portfolio - Bindiya Kamal | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Hello, I am

Bindiya Kamal

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

"Hello! I have a strong passion for working with data—I find joy in cleaning and visualizing it using tools like Power BI. I'm dedicated to continuously learning and enhancing my skills, always eager to explore new technologies. I thrive on tackling challenges and transforming complex data into valuable insights."

Key

Skills

R

SQL

Time Management

Python

My

Projects

Sales and Finance Analysis Report

Sales and Finance Analysis Report

Using Microsoft Excel, I transformed raw data into a meaningful dataset. By employing Pivot Tables, I generated insightful reports for AtliQ Hardware Company.

Business 360

I created an interactive dashboard for easy analysis of the finance, supply chain, marketing, and sales performance of AtliQ Hardware Company to take better data-driven decisions.

Bellabeat Case Study

Bellabeat Case Study

The main focus of this case study is to analyze smart devices fitness data and determine how it could help unlock new growth opportunities for Bellabeat.

Consumer-Goods-Ad-Hoc-Analysis

Consumer-Goods-Ad-Hoc-Analysis

In this project, we are using SQL to analyze data from a database containing information about customers, products, sales, and manufacturing costs. The goal is to answer specific business questions and provide insights based on the data.

Awards

& Certificate

Google Data Analytics Professional Certificate

Google Data Analytics Professional Certificate

Contact Me

Email

[email protected]

Github

https://github.com/bindiyakamal

Linkedin

https://linkedin.com/in/bindiyakamal

Call

+91 9072840460

Bindiya Kamal

Data Aspirant

Download Resume

Resume

Excel Project

Sales and Finance Analysis Report

Using Microsoft Excel, I transformed raw data into a meaningful dataset. By employing Pivot Tables, I generated insightful reports for AtliQ Hardware Company.

View Project
on GitHUB

Sales and Finance Analysis Report

Top-Performing and Underperforming Reports of AtliQ Hardware Company.

Sales and Finance Analysis Report

Top-Selling New Products at AtliQ Hardware Company in 2021.

Project Details

I designed sales reports for AtliQ Hardware Company to analyze the top-performing countries, new best-selling products, and underperforming countries and products. With these reports, it is easy to analyze and make well-informed data-driven decisions suitable for the company. I also created profit and loss reports by markets and months, gross margin percentages by quarters and fiscal year. Through these reports, I can assist AtliQ Company's businesses in making smarter decisions. They can focus on products that are performing well, formulate strategies for areas that need improvement, and plan for the future based on the trends I discovered.

Project video

PowerBI Project

Business 360

I created an interactive dashboard for easy analysis of the finance, supply chain, marketing, and sales performance of AtliQ Hardware Company to take better data-driven decisions.

Finance View

Supply Chain View

Project Details

Developed a multi-functional interactive Power BI dashboard to analyze the AtliQ Hardware Companies net sales performance, customer performance, total revenue contribution over years, revenue contributions.

Live Interactive Dashboard

Bellabeat Case Study

The main focus of this case study is to analyze smart devices fitness data and determine how it could help unlock new growth opportunities for Bellabeat.

View Project
on GitHUB

Bellabeat Case Study

Total Steps vs Calories

Bellabeat Case Study

Hourly steps taken throughout the day

Project Details

Business Task :
To Identify trends in how consumers use non-Bellabeat smart devices to apply insights into Bellabeat’s marketing strategy.
This case study follows 6 Phases : ask, prepare, process, analyze, share, and act Phase. I have completed all the cleaning, removed data, checked for NA and errors, and created visualizations for easy understanding using R Studio. Using formulas, I gained meaningful insights into how many calories are burned in relation to total steps, inactive time of Bellabeat users, steps taken in a day, and hourly steps taken throughout the day. Based on these visualizations, I have formulated useful recommendations to improve Bellabeat's marketing strategies.

SQL Project

Consumer-Goods-Ad-Hoc-Analysis

In this project, we are using SQL to analyze data from a database containing information about customers, products, sales, and manufacturing costs. The goal is to answer specific business questions and provide insights based on the data.

View Project
on GitHUB

Consumer-Goods-Ad-Hoc-Analysis

List of markets in which customer "Atliq Exclusive" operates its business in the APAC region.

Consumer-Goods-Ad-Hoc-Analysis

A report with all the unique product counts for each segment.

Project Details

The main aim in this project is to answer specific questions and find useful insights .
Tasks:
1.Find Market Information
2.Compare Product Variety
3.Identify Popular Product Segments
4.Yearly Segment Comparison
5.Cost Analysis
6.Discount Analysis
7.Calculate Gross Sales
8.Quarterly Sales Summary
9.Sales Channel Performance
10.Top Products by Division