Portfolio - Alish Chaudhary

Alish Chaudhary

Data Analyst

Resume

1

Excel Project

1

SQL Project

2

PowerBI Projects

About Me

Hi there! I’m Alish Chaudhary, an aspiring data analyst with a knack for turning numbers into stories. With a background in economics and a passion for making sense of data, I’ve found my true calling in the world of analytics. I may not have worked in a formal office (yet!), but I’ve spent countless hours honing my skills through real-world business projects that I proudly showcase in my portfolio 💼.
I thrive in Excel, PowerBI, SQL, and Python—basically, if it’s got numbers, I’m all over it! I love digging into data to uncover insights and turning dry statistics into something even your CEO would find interesting (promise!) 🎯.
Whether it's visualizing complex trends 📈 or presenting clear, actionable insights 📑, my goal is to help stakeholders see the bigger picture. When I’m not diving into datasets, you can find me crafting stories from them, ready to help make data-driven decisions in any setting 🚀.
Take a look at my projects, and let's talk about bringing your data to life! 💡

Key Skills

Excel

PowerQuery

PowerBI

MySQL

Python

My Projects

Profitability Insights: Analyzing Studio Performance in Bollywood and Hollywood

Domain/Function: Sales

𝗦𝗤𝗟 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲 | 𝗔𝘁𝗹𝗶𝗤 𝗛𝗮𝗿𝗱𝘄𝗮𝗿𝗲𝘀

Domain/Function: Executive Management

𝗔𝘁𝗹𝗶𝗤 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝟯𝟲𝟬

Domain/Function: Consumer Electronics and Computer Hardware

Shield Insurance Insights Dashboard

Domain/Function: Financial Services

My Experience

Data Analyst Intern – AtliQ Technologies | Dec 2024

Standardized and cleaned HR data by removing duplicates, normalizing IDs, and mapping status values, improving data quality.
Conducted attendance analysis to provide actionable insights, including remote work trends and peak attendance days.
Normalized the de-normalized client data into relational tables, enhancing database efficiency and integrity.
Performed variance analysis between benchmark and current data, identifying discrepancies in order and delivery metrics.
Debugged and optimized legacy SQL queries, resolving errors and improving performance for accurate reporting.
Automated weekly network operations reporting using Power Query, reducing manual effort and errors.
Completed comprehensive SCRUM training to enhance agile project management capabilities.
Created PowerBI Dashboard which improved decision making.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Python: Beginner to Advanced For Data Professionals

What is Business Analysis

Agile Requirements Foundations

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

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

Call Me

+91 9319426298

Excel Project

Profitability Insights: Analyzing Studio Performance in Bollywood and Hollywood

Domain/Function: Sales

This project provides a comprehensive analysis of the financial performance of film studios across Bollywood and Hollywood. By examining key metrics such as revenue, budget, and profit/loss (p/l) percentages, the project uncovers the most profitable the strategies that contribute to their success.

View Project
Engagement

Other Tools

Power Query

Analysis of Bollywood and Hollywood studios’ revenue, budget, and profit/loss percentages in Excel.

Comparison of top-grossing Hollywood and Bollywood movies, analyzing budgets, revenues, profits, and IMDb ratings.

Project Details

The analysis focuses on comparing the return on investment (ROI) for studios in both industries, identifying patterns in studio performance, and offering insights into the efficiency of resource allocation and production management.

🚀Profitability Analysis:
- Assess the profit margins of top studios in Bollywood and Hollywood.
- Identify studios with the highest return on investment (ROI) and examine the factors behind their success.

🚀Revenue vs. Budget Efficiency:
- Compare how efficiently studios manage their budgets relative to the revenue generated.
- Highlight the studios that achieve significant profits with lower budgets.

🚀Industry Comparison:
- Contrast the financial dynamics between Bollywood and Hollywood studios.
-Explore trends in profitability across different scales of production in both industries.

The analysis shows that both Bollywood and Hollywood have highly profitable studios, despite differences in scale and budget.

SQL Project

𝗦𝗤𝗟 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲 | 𝗔𝘁𝗹𝗶𝗤 𝗛𝗮𝗿𝗱𝘄𝗮𝗿𝗲𝘀

Domain/Function: Executive Management

As part of an executive management SQL challenge at AtliQ Hardwares, I analyzed 10 ad-hoc business requests using SQL to extract meaningful insights from company data. The objective was to support top-level management with data-driven decision-making.

View Project
Engagement

This query finds the top 5 Indian customers with the highest average pre-invoice discounts in 2021.

This SQL query calculates gross sales by channel for 2021, computes each channel's percentage of total sales, and orders results by sales volume.

Project Details

A hands-on SQL project that tested my ability to solve real-world business problems in the 𝗖𝗼𝗻𝘀𝘂𝗺𝗲𝗿 𝗚𝗼𝗼𝗱𝘀 𝗱𝗼𝗺𝗮𝗶𝗻. The challenge, designed for top-level management insights, helped me refine both my technical skills and my ability to present actionable insights.
I took on this challenge and tackled 𝟭𝟬 𝗮𝗱-𝗵𝗼𝗰 𝗿𝗲𝗾𝘂𝗲𝘀𝘁𝘀 from management, providing insights to drive smarter decisions.
📊𝗞𝗲𝘆 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗗𝗲𝗹𝗶𝘃𝗲𝗿𝗲𝗱
𝟭. 𝗠𝗮𝗿𝗸𝗲𝘁 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀: Identified markets where key customers like 𝘈𝘵𝘭𝘪𝘘 𝘌𝘹𝘤𝘭𝘶𝘴𝘪𝘷𝘦 operate in APAC, helping target expansion efforts.
𝟮. 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗧𝗿𝗲𝗻𝗱𝘀: Analyzed growth in unique products from 2020 to 2021 and identified top-performing products by division and segment.
𝟯. 𝗖𝗵𝗮𝗻𝗻𝗲𝗹 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻: Determined the channel with the highest gross sales in 2021 and its percentage contribution, aiding resource allocation.

PowerBI Project

𝗔𝘁𝗹𝗶𝗤 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝟯𝟲𝟬

Domain/Function: Consumer Electronics and Computer Hardware

AtliQ Business Insights 360 is a unified dashboard for 𝗳𝗶𝗻𝗮𝗻𝗰𝗲, 𝘀𝗮𝗹𝗲𝘀, 𝗺𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴, 𝘀𝘂𝗽𝗽𝗹𝘆 𝗰𝗵𝗮𝗶𝗻, and 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝘃𝗲 𝗱𝗮𝘁𝗮. It highlights 353.5% net sales growth, improved gross margin, and profitability challenges, guiding AtliQ’s strategic decisions.

View Project
Engagement

A snapshot of the dashboard displaying key metrics—Net Sales ($3.74B), Gross Margin (38.08%), and Net Profit Margin (-13.98%).

A snapshot from dashboard focusing on forecast accuracy, net error, and absolute error. It displays key metrics by customer and product.

Project Details

AtliQ Business Insights 360 🚀 provides a comprehensive 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 aimed at offering 𝗺𝘂𝗹𝘁𝗶-𝗱𝗶𝗺𝗲𝗻𝘀𝗶𝗼𝗻𝗮𝗹 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀 into key performance areas such as 𝗳𝗶𝗻𝗮𝗻𝗰𝗲, 𝘀𝗮𝗹𝗲𝘀, 𝗺𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴, 𝘀𝘂𝗽𝗽𝗹𝘆 𝗰𝗵𝗮𝗶𝗻, and 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝘃𝗲 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻-𝗺𝗮𝗸𝗶𝗻𝗴. The dashboard 𝗰𝗲𝗻𝘁𝗿𝗮𝗹𝗶𝘀𝗲𝘀 financial, operational, and sales metrics to enable data-driven decisions across multiple sectors of AtliQ's business.

𝗞𝗲𝘆 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀 🔑
🏦 Finance View
🧾 Sales View
🗣️ Marketing View
🚚 Supply-Chain View
👩‍💼 Executive View

𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀✍️
📊 Net Sales Growth: Net sales increased significantly from $823.85M in 2021 to $3.74B in 2022, reflecting a 353.5% growth.
📊 Gross Margin: A gross margin of 38.08% was achieved in 2022, a 4.37% increase over the previous year.
📊 Profitability Challenges: Despite strong sales and gross margin, the net profit margin declined to -13.98%, pointing to rising operational expenses.

Live Interactive Dashboard

PowerBI Project

Shield Insurance Insights Dashboard

Domain/Function: Financial Services

As a Data Analyst Intern at AtliQ Technologies, I created a Power BI dashboard for Shield Insurance, providing insights into revenue, customer trends, and policy distributions. The project enhanced my skills in data visualization, storytelling, and business intelligence! 🚀✨

View Project
Engagement

Other Tools

PowerQuery

The Shield Insurance Power BI Dashboard provides an overview of key business metrics. It enables data-driven decision-making.

Insights on policy preferences, sales modes, and customer demographics across different age groups.

Project Details

I built a 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 for 𝗦𝗵𝗶𝗲𝗹𝗱 𝗜𝗻𝘀𝘂𝗿𝗮𝗻𝗰𝗲 that unlocks key business insights—helping the company track revenue, customer trends, and policy distributions with a single glance. 📊

Here’s what I uncovered:
🔹 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗠𝗶𝗹𝗲𝘀𝘁𝗼𝗻𝗲: Shield Insurance hit $𝟵𝟴𝟵𝗠 in total revenue!
🔹 𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗚𝗿𝗼𝘄𝘁𝗵: 26.8K total customers, with the 𝟯𝟭-𝟰𝟬 𝗮𝗴𝗲 𝗴𝗿𝗼𝘂𝗽 being the most dominant.
🔹 𝗧𝗼𝗽 𝗥𝗲𝘃𝗲𝗻𝘂𝗲-𝗚𝗲𝗻𝗲𝗿𝗮𝘁𝗶𝗻𝗴 𝗖𝗶𝘁𝗶𝗲𝘀: 𝗗𝗲𝗹𝗵𝗶 𝗡𝗖𝗥 ($402M), 𝗠𝘂𝗺𝗯𝗮𝗶 ($240M), and 𝗛𝘆𝗱𝗲𝗿𝗮𝗯𝗮𝗱 ($161M).**
🔹 𝗦𝗮𝗹𝗲𝘀 𝗠𝗼𝗱𝗲 𝗧𝗿𝗲𝗻𝗱𝘀: 𝗢𝗳𝗳𝗹𝗶𝗻𝗲 𝗮𝗴𝗲𝗻𝘁𝘀 drive the most revenue (55.67%), but 𝗱𝗶𝗴𝗶𝘁𝗮𝗹 𝗰𝗵𝗮𝗻𝗻𝗲𝗹𝘀 are rapidly growing.

This project helped me dive deep into 𝗱𝗮𝘁𝗮 𝘃𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻, 𝘀𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴, 𝗮𝗻𝗱 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗶𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲 —transforming raw numbers into 𝗮𝗰𝘁𝗶𝗼𝗻𝗮𝗯𝗹𝗲 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀. 💡