Powered by
Codebasics DA Bootcamp

Dhruv Chaudhary

Data Aspirant

+91 8290161222 [email protected]

Resume

Hello, I am

Dhruv Chaudhary.

2

Excel Projects

3

PowerBI Projects

About Me

I’m an aspiring Data Analyst passionate about transforming raw data into meaningful insights. With a Bachelor’s degree in Information Technology, I explored various tech domains before discovering my true interest in data analysis.
Through hands-on experience with Excel, Power BI, and SQL, I’ve gained a solid understanding of how data drives business decisions. During my six-month internship as a Data Analyst, I honed my technical skills and developed a solution-oriented mindset to tackle complex data challenges.
Beyond my internship, I’ve worked on business-focused projects that showcase my ability to extract insights, visualize trends, and present findings in a clear, actionable manner. These projects reflect my commitment to continuous learning and my drive to create real business value.
If you're looking for a problem-solver with fresh ideas and technical expertise, let’s connect and explore how I can contribute to your organization's success!

Key Skills

Microsoft Power BI

MySQL

Data Visualization

Dashboards

MS Excel

Problem Solving

Presentation Skills

My Projects

My Experience

Data Analyst Intern, WebKorps

July 2024 – Dec 20

Performed data gathering, cleaning and visualization in Power BI and Excel which helped in answering the underlying questions and answered the 'Why?' of problems.
Visualized Dashboards in Excel and Power BI, performed complicated DAX calculations to write measures.

Awards & Certificate

Excel: Mother of Business Intelligence

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

My SQL

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.

[email protected]

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

+ 91 8290161222

https://github.com/dhruvvchaudhary

PowerBI Project

Google Trends Analysis

Domain/Function: Website

I recently worked on an exciting project that analyzes global search trends using Google Trends data and dynamically visualizes insights in Power BI. This project focuses on identifying top and rising keywords based on real-time search interest over the last seven days.

View Project
Engagement

View Project
on GitHUB

Google Trends Analysis

Overview Page featuring a pop-up slicer, insights on rising and top keywords, and visualizations of overall search trends and last 7 days' search data

Google Trends Analysis

Designed a Keywords by Date page with a yearly, quarterly, and monthly slicer integrated into an area chart, allowing users to select specific keyword

Project Details

Project Overview
Tracked global search trends for user-specified keywords using SERP API and identified top rising and related keywords. Implemented interactive filtering by month, year, and quarter for deeper insights.

Features Implemented
Live data retrieval via SERP API – no manual updates needed.
Dynamic keyword handling via parameters.
Custom slicers for flexible filtering.
Custom shape map visualization using a .json file.
Figma-designed canvas background.
Pop-up country slicer and image-based slicers for an intuitive experience.
Tools Used
Power BI | Figma | SERP API

Key Findings
Most searched word: Power BI (61%).
Rising keyword: MS Copilot.
Top keyword: MS Power BI.
Declining search: "India Jobs."
Increasing searches: Data Analyst, Power BI, Software Engineer, The Developer.
Total searches (last 7 days): 19K+.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Domain/Function: Retail and E-Commerce

AtliQ Hardwares, a fast-growing consumer electronics company, struggles to compete with data-driven rivals due to its reliance on Excel for reporting. My objective is to implement a Power BI-based analytics system to enhance decision-making and drive business optimization.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

Data Model: Incorporating multiple tables to enable a comprehensive and seamlessly interconnected analysis.

Business Insights 360

Discover essential financial metrics and trends revealed through the project's analytics dashboard for informed decision-making.

Project Details

I developed a Power BI report for stakeholders in sales, marketing, finance, and executive teams, focusing on a robust data model that handles complex datasets while ensuring an intuitive, interactive design. This enabled drill-through insights for informed decision-making.

Enhancing my Power Query skills, I performed advanced transformations and utilized both basic and complex DAX formulas for deeper analysis. The data model integrated over ten interconnected tables, with carefully chosen visuals to convey key insights. Applying dashboard design principles, I ensured clarity and impact, incorporating features like bookmarks for an improved user experience.

Deployed via Power BI Service, the report evolved through stakeholder feedback. By analyzing key metrics across departments, it has empowered teams to make data-driven decisions, fostering a culture of analytical thinking and driving business success.

Live Interactive Dashboard

PowerBI Project

Hospital Emergency Room

Domain/Function: Health Sector

A hospital aims to improve emergency room efficiency by reducing wait times, increasing satisfaction scores etc. As a data analyst, I analyzed ER admissions, patient flow, and department referrals etc. My insights help enhance response times, streamline operations, and improve patient care.

View Project
on GitHUB

Hospital Emergency Room

Monitor key metrics and trends on a month-by-month basis to identify patterns and areas for improvement.

Hospital Emergency Room

Key Takeaways I derived from my analysis from monthly and consolidated view.

Project Details

Steps in project-
• Requirement Gathering/ Business Requirements
• Data Walkthrough
• Data Connection
• Data Cleaning / Quality Check
• Data Modeling
• Data Processing
• DAX Calculations
• Dashboard Lay outing
• Charts Development and Formatting
• Dashboard / Report Development
• Insights Generation
Dashboards-
1. Monthly View
2. Consolidated View
3. Patient Details
4. Key Takeaways
Tools Used-
1. Power BI
2. MS Excel
3. Dax Studio
Conclusion
The dataset reveals high patient volumes, moderate satisfaction levels and common referrals to general practice and orthopedics. Mondays and late night to early morning hours are particularly busy. The patient demographics show a diverse age and racial composition with nearly equal numbers of admitted and non-admitted patients. These insights can help optimize resource allocation and improve patient care in the emergency room.

Live Interactive Dashboard

Excel Project

Atliq Sales and Finance Analytics

Domain/Function: FMCG

This project evaluates AtliQ Hardware's financial health and market standing through reports like "Customer Net Sales Performance" and "Market Performance vs. Target." Leveraging Excel skills, it delivers actionable insights for informed strategic decisions.

View Project
on GitHUB

Atliq Sales and Finance Analytics

The Customer Performance Report reveals the net sales performance of each customer over multiple years.

Atliq Sales and Finance Analytics

Profit and Loss statement over the years with major focus on months for micro analysis.

Project Details

In this project, I created a dynamic sales report using Excel pivot tables, providing businesses with key insights into customer discounts, negotiation strategies, and untapped markets. These reports offer actionable recommendations, helping businesses refine sales tactics, enhance customer experiences, and boost revenue.

Through this process, I strengthened my expertise in:
1. Pivot tables
2. Power Query
3. Basic DAX functions
4. Effective Conditional Formatting
5. Report Presentation
6. Sales Domain Metrics

The core objective is to equip businesses with the insights and tools to track, evaluate, and optimize sales performance. Leveraging data-driven analysis, businesses can identify growth opportunities, adapt to market shifts, and maintain a competitive advantage in an ever-changing landscape.

Excel Project

Coffee Sales Insights

Domain/Function: Sales

The goal of this project is to create a dashboard of sales data for coffee store. The objective - transform raw data into actionable insights that drive smarter business decisions. The project involved a meticulous process, from collecting data to crafting visualizations that offer deep insights.

View Project
on GitHUB

Coffee Sales Insights

Final Dashboard which includes different slicers for various filtering, timeline, bar graphs and line chart.

Coffee Sales Insights

Line chart for insights into total sales over time. Bar graphs for finding top customer (country) and top individual customers.

Project Details

Skills Demonstrated
• Data Cleaning, Transformation, and Analysis
• Filtering, Sorting, and Excel Functions (XLOOKUP, IF, SWITCH)
• Pivot Tables and Pivot Charts
• Data Visualization and Dashboard Creation
Data Cleaning & Transformation
The project began with organizing datasets into "Tables" for better structure. Key steps included:
1. Data Quality Checks: Identified NULL values, blanks, duplicates, and ensured data consistency.
2. Data Enhancement: Used XLOOKUP to fetch customer details, created a Sales column, and employed IF functions for categorization.
Data Analysis
Three pivot tables were created to analyze sales trends based on date, customer demographics, and country-wise performance.
Data Visualization
A dynamic dashboard was built with pivot charts and interactive elements:
• Three Slicers for filtering
• One Timeline for trend analysis
The final dashboard provided a comprehensive view of coffee sales performance.