Portfolio - Zalak Kakadiya | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Zalak Kakadiya

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

👋 Hi there! I'm Zalak Kakadiya, and I have a keen interest in data with a background in Electronics and Communication Engineering.

🌟 My adventure with data started at Flavorcan International Inc., where I discovered the joy of telling stories through Excel.

🛠️ Now, I use tools like Excel, Power BI, and SQL to bring data to life and help businesses glow.

📊 Check out my portfolio just below—it's full of the data analysis work I love to do.

🚀 Though I'm new to the field of data analysis, I'm excited to join a team that loves data as much as I do, ready to dive in and explore what stories the data can tell us.

Key

Skills

SQL

Data Visulization

Problem-Solving

Attention to Detail

Time Management

Teamwork

My

Projects

Sales and Finance Report

Sales and Finance Report

Analyzed AtliQ Hardware's sales using Excel, revealing key trends and crafting reports to drive strategic decisions. Increased India's sales 3x and identified top products and markets.

Business Insights 360

Business Insights 360

AtliQ Hardware aims for a competitive edge through Power BI analytics. This dashboard covers Finance, Sales, Marketing, Supply Chain and Executive view throughout globally.

Box Office Analytics

Box Office Analytics

This SQL project examines movie data to find trends in box office earnings, ratings, studio outputs, and popular languages in films for strategic insights.

Awards

& Certificate

Microsoft Certified: Power BI Data Analyst Associate certification

Microsoft Certified: Power BI Data Analyst Associate certification

Contact Me

Email

[email protected]

Github

https://github.com/zalakbhagat

Linkedin

https://www.linkedin.com/in/zalak-kakadiya-601950133/

Call

+1 5199824029

Zalak Kakadiya

Data Aspirant

Download Resume

Resume

Excel Project

Sales and Finance Report

Analyzed AtliQ Hardware's sales using Excel, revealing key trends and crafting reports to drive strategic decisions. Increased India's sales 3x and identified top products and markets.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Report

Developed a sales report for AtliQ Hardware, showcasing customer growth trends and year-on-year sales increases to drive strategic decisions.

Sales and Finance Report

Analyzed P&L across global markets for AtliQ Hardware, revealing net sales and gross margin data to inform fiscal strategies.

Project Details

Addressing Atliq Hardware's data overwhelm, I transformed disjointed Excel files into a cohesive suite of reports, surfacing key sales trends and financial metrics for strategic clarity.

Deliverables:

Developed customer performance reports for targeted sales strategies.
Analyzed market data against targets, identifying top products and leading sales regions.
Created segmented P&L reports for in-depth financial analysis.

Result:
Empowered AtliQ with data insights to drive revenue, optimize operations, and strengthen market presence.

PowerBI Project

Business Insights 360

AtliQ Hardware aims for a competitive edge through Power BI analytics. This dashboard covers Finance, Sales, Marketing, Supply Chain and Executive view throughout globally.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

Comprehensive dashboard for real-time business insights into Finance, Sales, Marketing, Supply Chain, and Strategy with executive summary.

Business Insights 360

Real-time P&L tracking and net sales analysis for strategic business planning and performance optimization.

Project Details

Objective: Craft a detailed business dashboard to enhance decision-making within Finance, Sales, Marketing, Supply Chain, and Strategy.

Execution:

Began with a clear project overview and meticulous planning.
Progressed through data importation, exploration, and rigorous modeling.
Designed a user-centric dashboard showcasing key metrics for targeted decision-making.

Details:

Finance: Showcased financial health via interactive P&L statements.
Sales: Analyzed trends and established benchmarks.
Marketing: Assessed campaign impact and customer interactions.
Supply Chain: Monitored logistics and stock levels.
Executive: Aggregated critical KPIs for strategic oversight.

Outcome: Delivered a central analytical tool, empowering leaders with actionable insights for informed decisions, driving the company forward.

Live Interactive Dashboard

SQL Project

Box Office Analytics

This SQL project examines movie data to find trends in box office earnings, ratings, studio outputs, and popular languages in films for strategic insights.

View Project
Engagement

View Project
on GitHUB

Box Office Analytics

Identify high-quality Bollywood films from 2022 by selecting those with an IMDb rating above 7.

Box Office Analytics

A breakdown of movie counts by language showcasing market preferences.

Project Details

🎥 Box Office Analytics via SQL

📈 Objective: Extract key insights from film industry data
🌟 Focus: Bollywood hits, studio trends, peak production years, profit analysis, language preferences
🗓️ Highlight: 2022's high-IMDb Bollywood films, studio filmography, most active production year
💹 Profitability: Calculated net gains for top Hindi and English movies
🗣️ Languages: Mapped the prevalence of languages across films
🛠️ Tools: MySQL for RDBMS
🔍 Findings: Identified best-rated films, top studios, peak production times, and profit leaders
🎬 Insight: Offers a lens into industry dynamics, guiding data-driven decisions in cinema