Powered by
Codebasics Data Analytics Bootcamp

Shivam Verma

Data Analysts | Business Analysts

[email protected]

Hello, I am

Shivam Verma.

About Me

👋 Hi there,
I’m Shivam Verma, an aspiring Data Analyst passionate about turning data into decisions. With a strong foundation in Excel, Power BI, and SQL, I thrive on exploring data, uncovering patterns, and creating insightful visualizations that drive meaningful impact.

📊 Why Data Analytics?
Because data tells stories — stories that can guide strategies, solve problems, and inspire innovation. I’m fascinated by how data, when analyzed effectively, becomes a powerful decision-making tool.

💡 What I Bring to the Table:

🔍 Analytical Mindset – I enjoy diving deep into datasets to extract insights and answer real-world questions.
📈 Visualization Skills – Proficient in building intuitive dashboards and visual reports using Power BI and Excel.
🤝 Collaborative Approach – I value teamwork and look forward to contributing to dynamic, data-driven environments where I can grow and make an impact.

Key Skills

Power BI

SQL

Python

Excel

Numpy

Pandas

Tableau

Microsoft Fabric

C++

C

Git & GitHub

VS Code

My Projects

My Experience

Data Analyst Intern – AtliQ Technologies, Remote
June 2025 – Nov 2025

Developed interactive Tableau dashboards analyzing 150K+ transactional sales records to identify revenue trends, profit margins, and high/low performing markets.
Delivered actionable insights that helped the sales team achieve 10% cost savings and optimized low-margin markets.
Automated reporting workflows, reducing 20% manual effort in data gathering and enabling faster decision-making.
Collaborated with cross-functional teams to design KPIs, monitor performance, and support data-driven strategy.
Utilized Tech Stack – SQL, Tableau, Python, Excel, ETL workflows, Google Workspace.

Awards & Certificate

Excel: Mother of Business Intelligence

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

Microsoft Fabric Mini: For Data Analysts

SQL Beginner to Advanced For Data Professionals

Tableau Mini

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/shivamverma9808/

https://github.com/shivamverma18

Customer Shopping Trends Analysis

Domain/Function: Data Analytics | Data Visualization

A data-driven analysis project using Python for exploration, SQL for deep querying, and Power BI for interactive visualization. It uncovers customer trends, purchasing patterns, and key business insights, helping organizations make informed decisions and optimize overall performance.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

Power BI

EDA

Python

Excel

Microsoft PowerPoint.

Customer Shopping Trends Analysis

End-to-end analytics project using Python, SQL, and Power BI to analyze data, create insights, build dashboards, present findings, and document work.

Customer Shopping Trends Analysis

Dashboard highlights customer trends, sales insights, and category performance for better decisions.

Project Details

👨🏻‍💻 Customer Shopping Trend Analysis Project
This project showcases a complete, industry-standard end-to-end data analytics workflow, reflecting the real responsibilities of modern data analysts. It covers all major stages of analysis, including data preparation, modeling, insight extraction, visualization, and reporting, transforming raw data into actionable business intelligence.

📌 Project Overview
The objective is to simulate a corporate-level analytics process capable of uncovering customer patterns, shopping behavior, and key performance drivers.

✅ Data Preparation & EDA (Python): Clean, model, and explore the raw dataset to identify trends and inconsistencies.
✅ Data Analysis (SQL): Perform business-oriented queries to understand customer segments, loyalty behavior, purchase frequency, and revenue contribution.
✅ Visualization (Power BI): Build an interactive dashboard showcasing customer trends, category performance, sales insights, and key business patterns.

AtliQ Sales Insights Dashboard

Domain/Function: Business Intelligence | Data Visualization | Sales Analytics

Built a real-time Tableau dashboard for AtliQ Technologies to uncover hidden sales and profit insights, reduce manual reporting, and support data-driven business decisions.

View Project
on GitHUB

View Project
on Tableau Public

Other Tools

Tableau Public – Dashboard development

MySQL – Data querying & transformation

Excel – Data preprocessing

ETL Techniques – Data cleaning & structuring

AtliQ Sales Insights Dashboard

Displays profit margins, quarterly profit %, and revenue-to-profit comparisons across markets.

AtliQ Sales Insights Dashboard

Visualizes total revenue trends by year, market, product, and customer.

Project Details

As a Data Analyst Intern at AtliQ Technologies, I developed an automated, interactive sales dashboard using Tableau to help business leaders uncover actionable insights from over 150,000+ sales records. The project focused on visualizing KPIs like revenue trends, profit margins, and top-performing products/customers. By leveraging MySQL for querying and Excel for initial analysis, I streamlined data pipelines and reduced manual reporting time by 20%. The dashboard empowered the sales and marketing teams to make faster, smarter decisions and achieve measurable cost savings.

COVID‑19 in India Analysis Dashboard

Domain/Function: Healthcare Informatics Dashboard , Pandemic Trend Analysis

A clean, interactive Tableau dashboard that visualizes COVID-19 case trends, testing efficiency, vaccination progress, and state-level comparisons across India.

View Project
on GitHUB

View Project
on Tableau Public

Other Tools

Tableau Desktop / Public — for data blending

dashboard creation & publishing

India State Map

Excel - for data preprocessing

COVID‑19 in India Analysis Dashboard

This Dashboard presents a multi‑facet analysis of the COVID‑19 situation in India—tracking trends, demographics, testing, vaccination, and state.

COVID‑19 in India Analysis Dashboard

This Dashboard presents a multi‑facet analysis of the COVID‑19 situation in India—tracking trends, demographics, testing, vaccination, and state.

Project Details

I created a interactive Tableau dashboard that brings India’s COVID‑19 story to life by blending multiple datasets—cases, vaccinations, testing data, demographics, and a custom state-level map—to deliver clear, interactive insights. The dashboard features a state-wise choropleth map, time-series trendlines (confirmed, recovered, deaths), demographic breakdowns (gender & age), vaccination dose/type comparisons, and state-wise testing positivity rates. Users can explore via synchronized filters for state and date, with tooltips revealing deeper insights. The workbook reflects hands-on skills in data blending, calculated metrics, map visualization, and responsive interactivity—all hosted on GitHub and live on Tableau Public to showcase my data storytelling capabilities

Zomato Sales Insights Dashboard

Domain/Function: Business Intelligence | Data Visualization | Sales Analytics

An interactive Tableau dashboard built using Zomato's food delivery sales data to analyze customer behavior, sales performance, and city-level insights with professional visual storytelling.

View Project
on GitHUB

View Project
on Tableau Public

Other Tools

Tableau 📊

MS Excel 📑 (for data source & preprocessing)

Data Cleaning & Filtering

Calculated Fields & Parameters in Tableau

Zomato Sales Insights Dashboard

An interactive Tableau dashboard built using Zomato's food delivery sales data to analyze customer behavior, sales performance, and city-level insight

Zomato Sales Insights Dashboard

An interactive Tableau dashboard built using Zomato's food delivery sales data to analyze customer behavior, sales performance, and city-level insight

Project Details

This project focuses on uncovering business insights from Zomato’s food delivery dataset through an engaging Tableau dashboard. The goal is to enable quick, data-driven decision-making for stakeholders in the online food delivery domain.

📌 Key Insights Delivered:

🧾 Total Orders, Sales & Profits

🏙️ Top Performing Cities & Customer Base

🕐 Time-wise Order Trends (Morning, Evening, Night)

🍽️ Cuisine Popularity & Item Preferences

🎯 Location-wise Business Strategy Recommendations

📈 The data was first cleaned and organized in Excel, then imported into Tableau. Using calculated fields, custom filters, parameters, and dashboard actions, a multi-layered visualization experience was created.

💼 Impact: The dashboard helps identify profitable cities, high-performing items, and optimal ordering times—empowering stakeholders to refine marketing and expansion strategies.

Retail Sales Analysis using MySQL

Domain/Function: Retail & E-Commerce Analytics

Retail Sales Analysis using SQL – A hands-on project to explore, clean, and analyze a retail sales dataset using SQL queries to extract business insights and customer behavior trends.

View Project
on GitHUB

Retail Sales Analysis using MySQL

A screenshot showing a structured SQL project sections on project overview, objectives, database setup, data cleaning, and SQL code for ha

Retail Sales Analysis using MySQL

A screenshot showing a shift-wise order count query, key findings, summarized reports, and a brief conclusion on business insights from sales data.

Project Details

In this project, I used MySQL to set up a retail sales database, clean and preprocess a messy CSV file (~2000 rows), handle nulls and data formatting issues, and perform Exploratory Data Analysis (EDA). I wrote various SQL queries to extract business insights like top customers, sales trends, high-value transactions, and category performance. The project demonstrates practical data analysis skills using SQL, from data cleaning to answering real-world business questions.

Coffee Shop Sales Analysis – Interactive Excel Dashboard

Domain/Function: Retail Analytics | Business Intelligence | Sales Performance | Excel Automation

An interactive, Excel-based dashboard built using Power Query and Pivot Charts to analyze sales performance of a coffee shop chain across time, category, and customer types.

View Project
on GitHUB

Other Tools

Microsoft Excel (Advanced) 📊

Pivot Tables & Charts 📈

Data Validation & Slicers 🎛️

Power Query ⚙️

Data Cleaning & Transformation Technique

Coffee Shop Sales Analysis – Interactive Excel Dashboard

An interactive, Excel-based dashboard built using Power Query and Pivot Charts to analyze sales performance of a coffee shop chain across time, catego

Coffee Shop Sales Analysis – Interactive Excel Dashboard

An interactive, Excel-based dashboard built using Power Query and Pivot Charts to analyze sales performance of a coffee shop chain across time, catego

Project Details

This project explores sales data from a fictional coffee shop and provides deep business insights using Microsoft Excel’s advanced features. It includes a highly visual dynamic dashboard created through Pivot Charts, Power Query, and interactive slicers.

📌 Key Insights Offered:

📆 Month-wise & Day-wise Sales Trends

🧾 Top-Selling Product Categories

👥 Customer Type Segmentation

🕒 Peak Order Timings

💳 Payment Method Distribution

📍 Branch-wise Sales Comparison

⚙️ The backend is powered by Power Query for automated data transformation, while the frontend uses Pivot Tables, Charts, and interactive slicers for seamless business storytelling.

💼 Impact: Enables managers and owners to gain instant visibility into operational performance and make data-driven decisions without needing advanced BI tools.

VerdantScan – AI-Powered Leaf Disease Detection System

Domain/Function: Artificial Intelligence, Deep Learning, Computer Vision, Agriculture Tech

VerdantScan is an AI-powered plant disease detection tool that uses deep learning to identify diseases from leaf images. Designed to aid farmers and agriculturists, it ensures fast and accurate diagnosis, helping in timely treatment and crop protection.

VerdantScan – AI-Powered Leaf Disease Detection System

Welcome to VerdantScan 🌿 Upload plant leaf image to detect diseases instantly using AI. VerdantScan analyzes the image and predicts its health status

VerdantScan – AI-Powered Leaf Disease Detection System

Welcome to VerdantScan 🌿 Upload plant leaf image to detect diseases instantly using AI. VerdantScan analyzes the image and predicts its health status

Project Details

VerdantScan is a smart web-based application developed to assist agriculturists, farmers, and plant enthusiasts in diagnosing plant leaf diseases. Using a Convolutional Neural Network (CNN)-based deep learning model trained on a diverse dataset of healthy and infected leaf images, the system classifies leaf conditions with high accuracy. The front-end interface allows users to upload images, which are then processed through the model to predict diseases such as rust, powdery mildew, or healthy foliage. The application integrates OpenCV for image pre-processing and TensorFlow/Keras for model training and inference. Deployed via Streamlit/Flask and hosted using GitHub, VerdantScan enhances agricultural productivity by enabling early and accurate disease detection. This project emphasizes real-world applications of AI in agriculture, promoting smart farming solutions.