Portfolio - shivani whachal | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

shivani whachal

Data Science

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

3

Python Projects

About Me

Data Analyst & BI Specialist | Excel, SQL, Power BI, Python

I help businesses turn raw, messy data into clear dashboards, reports, and insights for better decision-making. With hands-on experience across sales, HR, hospitality, telecom, and customer datasets, I specialize in data cleaning, transformation, analysis, and visualization.

I’ve built KPI dashboards, automated Excel reports, and performed SQL analysis on real business case studies and datasets. My approach is simple: understand the business problem first, then use data to solve it.

If you need help organizing data, building dashboards, creating reports, or extracting insights from SQL/Excel files, I can deliver structured, business-ready results.

Key Skills

Python

MYSQL

Excel

Data Visualization

Data Cleaning

ETL Process

Power BI

Tableau

Statistics Analysis

Data Transformation

Data Modeling

CRM

Hubspot

Enrichment

My Projects

Hospitality Performance Analytics: A Power BI Key Metrics Dashboard

Hospitality Performance Analytics: A Power BI Key Metrics Dashboard

Domain/Function: Hospitality Domain

PowerBI Project

Telecom Project Insight

Telecom Project Insight

Domain/Function: Telecom Project

PowerBI Project

Atliq Sales-Insight

Atliq Sales-Insight

Domain/Function: Sales

PowerBI Project

YouTube-Video-Performance-Analysis-for-Netflix-India

YouTube-Video-Performance-Analysis-for-Netflix-India

Domain/Function: Social Media Analysis

Sales Product Analysis and Visualization Using Python

Sales Product Analysis and Visualization Using Python

Domain/Function: Sales

Data-Manipulation-SurveyMonkey

Data-Manipulation-SurveyMonkey

Domain/Function: ETL, Manipulation

Walmart Sales Data Analysis

Walmart Sales Data Analysis

Domain/Function: Sales

Sales Project | Code Basics (AtliQ) | Excel Report

Sales Project | Code Basics (AtliQ) | Excel Report

Domain/Function: Sales Project

My Experience

CRM & Data Operations Analyst — Spyne (B2B SaaS)

Managed HubSpot CRM with Super Admin access, designing and optimizing the entire B2B data structure for SDR and sales workflows.
Scraped, enriched, and structured B2B company data, converting raw data into SDR-friendly lead intelligence including verified contacts, titles, emails, and firmographics.
Designed and implemented HubSpot workflows for lead assignment, lifecycle stages, contact segmentation, and automated follow-ups.
Standardized data entry, properties, and pipelines to ensure clean CRM architecture for sales scalability.
Built processes for lead enrichment and qualification, enabling SDR teams to connect with high-quality prospects efficiently.
Practiced real-time CRM optimization including list segmentation, property management, automation logic, and testing of workflows to improve sales operations.

Research Analyst — McLine Studios (B2B Architecture & Renovation Services)

Conducted large-scale market research on 5,000–10,000 companies across diverse industries to identify high-potential B2B leads, directly supporting business development strategy.
Built and maintained a structured database of 20,000+ company records, ensuring data accuracy, enrichment, and usability for outreach and decision-making.
Identified decision-makers, verified emails, company revenue, employee size, and industry relevance to create sales-ready intelligence for outreach campaigns.
Transformed raw company information into actionable B2B insights used by the sales and marketing team to target the right prospects efficiently.

Freelance Data Analyst — Ruchika School, Bhubaneswar

Analyzed 15+ years (2008–2024) of student performance data to compute subject averages, top 5% scores, and success rates across 90%, 80%, and 70% benchmarks.
Identified subject-wise academic strengths, weak areas, and performance patterns over time.
Evaluated teacher contributions and subject trends to propose data-driven academic improvement strategies.
Delivered insights aligned with institutional goals to enhance student outcomes and academic excellence.

SQL Data Analyst Intern — Hubblemind

Analyzed workforce data for 2,500 employees across 10 departments to compute department-specific office expense requirements.
Used advanced SQL queries (JOIN, WITH, GROUP BY, ORDER BY) in MySQL Workbench to uncover financial and organizational insights.
Identified employee distribution trends to optimize budget allocation and resource planning.

What Makes My Experience Unique

Across all roles, I have consistently worked at the intersection of:
Data Analysis + Business Intelligence + B2B Lead Intelligence + CRM Systems
I don’t just analyze data — I prepare data that businesses can directly act upon, whether for:
Sales outreach
CRM automation
Academic strategy
Financial planning
Business development

Awards & Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

CB Cert

Microsoft Fabric Mini: For Data Analysts

Data Analysis with R Programming

Data Analysis with R Programming

The Complete Python Developer

The Complete Python Developer

Google Data Analytics Professional Certificate

Google Data Analytics Professional Certificate

Ask Questions to Make Data-Driven Decisions

Ask Questions to Make Data-Driven Decisions

Share Data Through the Art of Visualization

Share Data Through the Art of Visualization

Prepare Data for Exploration

Prepare Data for Exploration

Foundations: Data, Data, Everywhere

Foundations: Data, Data, Everywhere

Analyze Data to Answer Questions

Analyze Data to Answer Questions

Process Data from Dirty to Clean

Process Data from Dirty to Clean

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]

LinkedIn

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

GitHub

https://github.com/shivaniwac

PowerBI Project

Hospitality Performance Analytics: A Power BI Key Metrics Dashboard

Domain/Function: Hospitality Domain

Created a Power BI dashboard for hotel performance analysis, featuring key metrics like revenue, RevPAR, ADR, and occupancy rates. Used DAX for dynamic calculations, interactive slicers, and data modeling. The dashboard provides insights into booking trends, market performance.

View Project
Engagement

View Project
on GitHUB

Other Tools

PowerBi

Advance Excel

Hospitality Performance Analytics: A Power BI Key Metrics Dashboard

Hotel performance metrics dashboard with revenue, ADR, occupancy rate, RevPAR, and booking platform analysis in Power BI.

Hospitality Performance Analytics: A Power BI Key Metrics Dashboard

Overview of hotel staff roles and their impact on guest satisfaction in the hospitality industry.

Project Details

In this project, I developed a comprehensive Power BI dashboard to analyze hotel performance, focusing on key metrics like revenue, RevPAR, ADR, occupancy rates, and realization percentage. I incorporated interactive elements such as filters, slicers, and tooltips to enhance user experience and make data-driven decision-making easier.

A key challenge was ensuring accurate calculations across different booking platforms, which I solved using advanced DAX functions like IF, VAR, RETURN, and HASONEFILTER. The dashboard provides deep insights into weekday vs. weekend trends, property-specific performance, and booking behavior.

This project helped me strengthen my expertise in Power BI and DAX, reinforcing best practices in data visualization and modeling. The learning experience was guided by Codebasics, and I successfully applied these skills to create a dynamic, user-friendly, and impactful dashboard for the hospitality domain.

Live Interactive Dashboard

PowerBI Project

Telecom Project Insight

Domain/Function: Telecom Project

Led a data-driven project to evaluate Atliqo’s performance after the 5G rollout, combining SQL analysis with Power BI to deliver strategic insights and visualizations.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Telecom Project Insight

.

Telecom Project Insight

.

Project Details

This project focused on analyzing Atliqo’s market performance following the rollout of 5G services. Using SQL, I worked with sales and subscriber data to compare key metrics before and after implementation, uncovering trends in revenue, customer adoption, and market share movement.

I independently built a Power BI dashboard that visualized these insights through interactive charts and KPIs, highlighting a ₹32B revenue jump and shifts in plan-level performance. The dashboard was designed to support both strategic and operational decision-making, offering a clear view of the company’s growth trajectory post-5G.

Taking this on as my first unguided project, it was a major milestone that allowed me to apply all I’d learned — from structured query building to impactful data storytelling — while building confidence in delivering business-focused analysis from start to finish.

Live Interactive Dashboard

PowerBI Project

Atliq Sales-Insight

Domain/Function: Sales

Analyzed AtliQ’s sales data using SQL and Power BI to uncover revenue trends and identify high-performing markets and customers. Focused on profitability and performance insights across regions and product lines.

View Project
on GitHUB

Other Tools

Excel

SQL

Atliq Sales-Insight

The dashboard showcases key sales insights including total revenue, sales quantity, and monthly revenue trends. It highlights performance by market (c

Atliq Sales-Insight

..

Project Details

This project focuses on analyzing the sales data of AtliQ to derive strategic insights into revenue generation and profitability across different markets. The primary goals were to identify high-profit zones, uncover loss-making regions, and analyze product and customer performance. Using SQL, I performed data cleaning and validation, then visualized the findings in Power BI for clear and actionable business insights. The report includes revenue trends, sales quantity by city, and the top 5 products and customers contributing to revenue, enabling stakeholders to make data-driven decisions for growth.

Live Interactive Dashboard

Python Project

YouTube-Video-Performance-Analysis-for-Netflix-India

Domain/Function: Social Media Analysis

This project analyzes YouTube video performance for Netflix India, identifying patterns between video attributes (duration, tags, publishing time) and viewer engagement. Insights aim to optimize content strategy for higher views, likes, and comments on the platform.

View Project
Engagement

View Project
on GitHUB

YouTube-Video-Performance-Analysis-for-Netflix-India

It’s a horizontal bar chart showing the Top 10 Most Viewed Videos (with titles like Mighty Little Bheem, Bheem Cooks the Best Pongal, etc.).

YouTube-Video-Performance-Analysis-for-Netflix-India

There's a smooth KDE curve (line) showing the overall distribution shape Looks like most videos have around 20 tags 📈

Project Details

This project involves analyzing the performance of YouTube videos related to Netflix India. The dataset contains various metadata such as video ID, title, description, tags, view count, like count, comment count, published date, and video duration. The goal of this analysis is to identify trends, patterns, and actionable insights that Netflix India can use to optimize their YouTube content strategy.

Dataset
Video ID: A unique identifier for each YouTube video.
Title: The title of the video.
Description: A brief explanation of the video content.
Tags: Keywords that categorize the video content.
Published Date: The timestamp when the video was published on YouTube.
View Count: The number of times the video has been viewed.
Like Count: The number of likes the video has received.
Comment Count: The number of comments the video has garnered.
Duration: The length of the video in ISO 8601 format

Python Project

Sales Product Analysis and Visualization Using Python

Domain/Function: Sales

This project explores a Kaggle dataset using Python in Jupyter Notebook. It involves data analysis, visualization, and storytelling using libraries like Seaborn and Plotly. The workflow highlights Python’s power in uncovering insights through exploratory data analysis and interactive visualizations.

View Project
Engagement

View Project
on GitHUB

View Project
on Jupyter Notebook

Other Tools

Jupyter Notebook

Excel

Sales Product Analysis and Visualization Using Python

This bar chart shows the best-selling products by revenue. The MacBook Pro Laptop leads with $8M, followed by the iPhone, ThinkPad, Google Phone, and

Sales Product Analysis and Visualization Using Python

Conclusion

Project Details

This project explores a Kaggle dataset using Python in Jupyter Notebook, focusing on data analysis and visualization. It begins with data cleaning and exploration using Pandas and NumPy, followed by insightful visualizations with Seaborn and Matplotlib. Interactive charts with Plotly enhance data storytelling, making trends and patterns more interpretable. The project showcases the power of Python in extracting meaningful insights and presenting them effectively, demonstrating key skills in data manipulation, exploratory data analysis (EDA), and visualization techniques.

Python Project

Data-Manipulation-SurveyMonkey

Domain/Function: ETL, Manipulation

This script processes SurveyMonkey data collected from an employee question-answer survey. Importing Datasets: Load different sheets from an Excel file. Renaming Columns: Update column names for better readability and consistency.

View Project
on GitHUB

View Project
on Jupyter Notebook, Excel

Other Tools

Jupyter Notebook

Pandas

Numpy

Data Mnipulation

Data-Manipulation-SurveyMonkey

Raw Data

Data-Manipulation-SurveyMonkey

Python Queries.

Project Details

This script processes SurveyMonkey data collected from an employee question-answer survey. The company is interested in two key metrics:
Respondents with Non-Null Answers: How many respondents provided answers without any null values. Repeated Answers by the Same Respondent: How many answers were given by the same respondent two or more times. The data manipulation involves several steps using Python with the pandas and os libraries:

Importing Datasets: Load different sheets from an Excel file. Renaming Columns: Update column names for better readability and consistency. Data Grouping and Analysis: Perform grouping operations to count unique respondents and identify repeated answers. Creating Final Output: Generate a final sheet with the manipulated data and save it as an Excel file.

SQL Project

Walmart Sales Data Analysis

Domain/Function: Sales

This project explores Walmart Sales data to analyze top-performing branches, product trends, and customer behavior. It involves data wrangling, feature engineering, and EDA to uncover insights on sales strategies, peak sales periods, customer segments, and profitability, helping business performance

View Project
Engagement

View Project
on GitHUB

View Project
on Kaggle Walmart Sales Forecasting Competition

Other Tools

Mysql

Advance Excel

GitHub

Walmart Sales Data Analysis

Explaining Process of ETL AND EDA

Walmart Sales Data Analysis

SQL queries for feature engineering in Walmart sales data, adding time of day, day name, and month name columns for sales trend analysis.

Project Details

This project analyzes Walmart Sales data to uncover trends in product performance, sales, and customer behavior. Using data from the Kaggle Walmart Sales Forecasting Competition, the goal is to optimize sales strategies and improve business decisions.

The analysis includes:

Product Analysis: Identifying top and underperforming product lines.

Sales Analysis: Examining trends to assess sales strategy effectiveness.

Customer Analysis: Understanding customer segments, purchase patterns, and revenue contribution.

The process involves data wrangling, database creation, feature engineering (adding time-based insights), and exploratory data analysis (EDA). Key insights will help Walmart refine its sales approach, enhance customer engagement, and maximize profitability.

Excel Project

Sales Project | Code Basics (AtliQ) | Excel Report

Domain/Function: Sales Project

Designed and developed a comprehensive sales dashboard to uncover key revenue insights and market trends. Utilizing data modeling and advanced DAX measures, the analysis identified Amazon as the top revenue driver in 2021 ($82.1M) while highlighting underperforming entities like Nova ($0.4M).

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Power BI

Sales Project | Code Basics (AtliQ) | Excel Report

The mission is to transform sales data into strategic insights for growth, while the vision aims to lead in data-driven analytics for better decision.

Sales Project | Code Basics (AtliQ) | Excel Report

Key Takeways.

Project Details

• Created sales dashboards with measures and data modelling to analyse key metrics, revealing Amazon as the top revenue contributor in 2021 with $82.1M, while identifying underperforming entities like Nova at $0.4M.
• Generated actionable insights on top-performing products and markets, highlighting India as the leading contributor with $161M in revenue.