Powered by
Codebasics DA Bootcamp

Anshul Nigam

Data Analyst

+91 8839101289 [email protected]

Resume

Hello, I am

Anshul Nigam.

1

Excel Project

2

PowerBI Projects

2

SQL Projects

1

Python Project

About Me

Hello! I'm Anshul Nigam, an aspiring data analyst with a passion for turning complex data into clear, actionable insights. With a Master's in Business Administration specializing in finance and a solid background in the cable telecommunication industry, I've developed a keen eye for detail and a knack for uncovering hidden patterns.

In my profile, you'll find a showcase of my projects, demonstrating my ability to tackle real-world challenges with innovative solutions. From financial forecasting to customer behavior analysis, my work highlights my dedication to precision and clarity.

If you're looking for a data analyst with a strong finance background and proven skills in Excel, Power BI, SQL, and Python, let's connect! I can harness the power of data to elevate your decision-making and drive your business forward.

Key Skills

MySQL

Power Query

Power Pivot

Python

Pandas

My Projects

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

+ 91 8839101289

https://github.com/anshulnigam77

PowerBI Project

Business Insights 360

Domain/Function: PC & Electronics Industry

AtliQ Hardware is a company which engages in selling PC electronic items. This report provide insights to Finance, Sales, Marketing, Executive & Supply Chain Departments & providing them data in concise and visualistic form so they can extracts insights for their needs.

View Project
Engagement

Other Tools

excel

sql

Business Insights 360

Business Insights

Business Insights 360

Data Modeling

Project Details

Introduction:

This project involves developing a Power BI report that provides a comprehensive analysis of business performance across various dimensions, including finance, sales, marketing, supply chain, and executive overview. The report aims to offer detailed insights through interactive dashboards, enabling informed decision-making.

Objectives:

• P&L statement view for customers, products, countries, or aggregations over any time period.
• Sales analysis on Net Sales, Gross Margin.
• Marketing analysis on Net Sales, Gross Margin, Net Profit.
• Supply chain view for forecast accuracy, net error, ABS error, risk profiles.
• Executive dashboard consolidating top insights.

Methodology:

Iterative development with feedback loops, using Power BI, DAX, data models and MySQL as data source.

Conclusion:

This Power BI report will provide a comprehensive view of business performance, aiding strategic decisions with data-driven insights.

Live Interactive Dashboard

PowerBI Project

CodeX: Marketing Survey Analytics

Domain/Function: Food & Beverage Industry

CodeX, a German beverage company, launched its energy drink in 10 Indian cities and surveyed 10,000 respondents. I am tasked with deriving insights on brand awareness, market share, consumer preferences, and purchase behaviors to guide targeted strategies for increasing brand visibility and market.

Other Tools

excel

CodeX: Marketing Survey Analytics

Marketing Survey Analytics

CodeX: Marketing Survey Analytics

Data Modeling

Project Details

Introduction:

CodeX, a German beverage company, launched its energy drink in 10 Indian cities and surveyed 10,000 respondents to understand market dynamics and consumer behavior. This report analyzes the survey data using Power BI to provide actionable insights.

Objective:

•Identify key demographic segments.
•Understand consumer preferences for taste, packaging, and pricing.
•Evaluate CodeX’s brand recognition against competitors.
•Analyze marketing channel effectiveness.
•Gather product feedback for improvements.
•Examine purchase behavior to refine strategies.

Methodology:

Survey data was collected, cleaned, and analyzed using Power BI, focusing on demographics, preferences, competition, marketing reach, product experience, and purchase behavior.

Conclusion:

Insights from the analysis will guide CodeX in enhancing brand visibility, tailoring products, and optimizing marketing strategies to establish a strong presence in India.

Live Interactive Dashboard

SQL Project

Ad-hoc Sales Analysis

Domain/Function: Computer Parts & Peripherals Industry

Ad-hoc Sales Analysis for a company which engages in selling computer components. I extracted valuable insights into sales performance, identified trends, and generated reports for the year 2021 to support data-driven decision-making.

View Project
on GitHUB

Other Tools

excel

Ad-hoc Sales Analysis

Query to find sales per customer

Ad-hoc Sales Analysis

Exporting results to excel to add visualisation

Project Details

The project requires to analyze sales data for computer peripherals company for the year 2021 in SQL to extract meaningful insights.

Project objective:

1. Create a total gross sales report for year 2021
2. Create total gross sales report by months
3. Create total gross sales report by years
4. Identify Market Share of all customers
5. Identify Forecast Accuracy of all customers

Technical Skills:

• Master DDL and DML fundamentals.
• Understand SQL Clauses' power.
• Utilize Functions for data manipulation.
• Use Aggregate Functions for data summarization.
• Learn Group By for insightful analysis.
• Explore Join Techniques for data relationships.
• Solve challenges with Subqueries and CTEs.
• Enhance insights with Window Functions.

SQL Project

Monday Coffee: Market Analysis

Domain/Function: Retail coffee and snacks store industry

This project analyzes the sales data of Monday Coffee, an online coffee retailer since January 2023, to identify consumer demand and sales performance trends. The analysis aims to recommend the top three major cities in India for opening new coffee shop locations, ensuring strategic expansion based

View Project
on GitHUB

Other Tools

Excel

Monday Coffee: Market Analysis

Morning Coffee: Market Analysis

Monday Coffee: Market Analysis

Recommendations

Project Details

Objective:
The goal of this project is to analyze the sales data of Monday Coffee, a company that has been selling its products online since January 2023, and to recommend the top three major cities in India for opening new coffee shop locations based on consumer demand and sales performance.

Key Questions:
1.Coffee Consumers Count
2.Total Revenue from Coffee Sales
3.Sales Count for Each Product
4.Average Sales Amount per City
5.City Population and Coffee Consumers
6.Top Selling Products by City
7.Customer Segmentation by City
8.Average Sale vs Rent
9.Monthly Sales Growth
10.Market Potential Analysis

Recommendations:
City 1: Pune
1.Average rent per customer is very low.
2.Highest total revenue.
City 2: Delhi
1.Highest estimated coffee consumers at 7.7 million.
2.Highest total number of customers, which is 68.
City 3: Jaipur
1.Highest number of customers, which is 69.
2.Average rent per customer is 156.

Excel Project

AtliQ Hardware: Finance & Sales Report

Domain/Function: Electronic Hardwares Industry

AtliQ Hardware is a company which engages in selling electronic hardware. This project features sales and finance reports for AtliQ Hardware from 2018-2021, with comprehensive data analytics conducted in Excel.

View Project
on GitHUB

AtliQ Hardware: Finance & Sales Report

Sales Performance of Customers

AtliQ Hardware: Finance & Sales Report

Gross Margin%

Project Details

The project includes detailed analyses of sales trends, financial performance, and key metrics to provide insights into the company's operations over the period of 2018-2021.

Project objective:

1. Create a customer performance report
2. Conduct a comprehensive comparison between market performance and sales targets
3. Create Profit and Loss (P&L) reports by Fiscal Year & Months
4. Create Profit and Loss (P&L) reports by Markets

Technical Skills:

• Proficiency in ETL methodology.
• Skills to generate a date table using Power Query.
• Ability to derive fiscal months and quarters.
• Establishing data model relationships with Power Pivot.
• Proficiency in incorporating supplementary data into an existing data model.
• Utilizing DAX to create calculated columns.

Python Project

Elections Data Analysis

Domain/Function: Media & Telecommunications Industry

A private media company, intended to telecast a show on the Lok Sabha elections of 2024 in India. The focus of the show was to present unbiased insights from the 2014 and 2019 elections, with a particular emphasis on lesser-explored themes such as voter turnout percentages etc.

View Project
Engagement

View Project
on GitHUB

Other Tools

excel

Elections Data Analysis

Jupyter Notebook

Elections Data Analysis

% split of votes of parties at the national level for 2014 and 2019

Project Details

Overview:
AtliQ Media, a private media company, planned a show on the 2024 Lok Sabha elections in India, aiming to provide unbiased insights from the 2014 and 2019 elections, focusing on voter turnout percentages.

Objective:
Analyze the 2014 and 2019 Lok Sabha election data to answer 15 questions, including voter turnout, party performance, voting patterns, and correlations with socio-economic factors.

Action:
Using Python, Jupyter Notebook, Pandas, and Matplotlib/Pyplot:
1. Collect and Clean Data.
2. Analyze Data to answer 15 key questions.
3. Create Visualizations for where it is needed.

Result:
The project answered all 15 questions, revealing:
•Variations in voter turnout across constituencies and states.
•Changes in party dominance and voter preferences.
•Unique voting behaviors, such as high NOTA votes.
•Correlations between voter turnout and socio-economic factors.
•Gender distribution trends among candidates.