Madhan B

Technical Data Analyst

[email protected] +91 7305486497

Resume

Hello, I am

Madhan B.

2

PowerBI
Projects

1

Excel
Project

1

Python
Project

About Me

I'm a Data Analyst who loves working with data to help businesses grow. I know data analysis, which means I know how to make sure data is accurate and useful.

I'm skilled in using tools like Power BI and Advanced Excel, as well as programming languages like SQL and Python. These skills help me analyze data and create reports that help businesses make smart decisions.

Key Skills

SQL

Excel

Power BI

My Projects

Telangana Growth Analysis

CodeX Energy Drink

Domain/Function: F & B

Sales and Finance Analytics of AtliQ Hardwares

Domain/Function: Sales And Finance

AirBnb EDA Analysis

Domain/Function: AirBnb

My Experience

Technical Data Analyst

Datumlyze Pvt. Ltd.
Date of Employment: Feb2023– Present

As a Technical Data Analyst, I specialize in leveraging Excel to transform raw data into actionable insights. I have extensive experience in data analysis, reporting, and data visualization, using advanced Excel functions like PivotTables, VLOOKUP to automate tasks and streamline processes. My key achievements include:

Automating monthly and quarterly reports, reducing generation time by 4 hours.
Building dynamic dashboards and visual reports to track KPIs and trends for business decision-making.
Cleaning and transforming large datasets, ensuring accuracy and consistency for analysis.
Collaborating with cross-functional teams to provide tailored data insights and predictive models.

I also excel in training team members on best practices in data handling and reporting, ensuring efficient data-driven decision-making within the organization.

Awards & Certificate

Excel: Mother of Business Intelligence

SQL Beginner to Advanced For Data Professionals

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

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.

Mail Me

[email protected]

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

Call Me

+91 7305486497

GitHub

https://github.com/Bmadhan97?tab=repositories

PowerBI Project

Telangana Growth Analysis

Telangana Growth Analysis project to find overall revenue distribution in various districts, vehicles sold, and Investments. We Provide Insights to Telangana Growth for for sustained growth in the next 5 years based on your analysis

View Project
Engagement

View Project
on GitHUB

Transportation Analysis For Telangana Growth Analysis

Telangana State Industrial Project Approval and Self Certification System

Project Details

⚙ Approach:
To achieve this, Power BI for visualization for the dashboard, DAX formula, Google, and Chatgpt for research.

💎 Key Insights
Highest Revenue District, Vehicle Sold and Investments
💵 Rangareddy
💵 Hyderabad
💵 Medchal_Malkajgiri

🌏 Top 5 Documents Revenue by District
💵 Rangareddy
💵 Hyderabad
💵 Medchal_Malkajgiri
💵 Sangareddy
💵 Hanumankonda

🌏 Top 3 District Growth 2022-2021

📈 Rangareddy
📈 Karimnagar
📈 Hyderabad

🌏 Bottom 3 District Growth 2022-2021

📈 Warangal
📈 Nirmal
📈 Jagtial

Live Interactive Dashboard

PowerBI Project

CodeX Energy Drink

Domain/Function: F & B

CodeX conducted a survey in those 10 cities and received results from 10k respondents. The survey was based on consumer behaviour questions like their purchasing habits, their feedback about energy drinks available in the market, pricing, packaging etc.

Consumer preference over drinks

Demographic View

Project Details

About The Project The project is about an imaginary beverage company called CodeX.

CodeX CodeX is a German beverage company which is recently launched in India. They launched their energy drink in 10 cities in India.

CodeX conducted a survey in those 10 cities and received results from 10k respondents. The survey was based on consumer behaviour questions like their purchasing habits, their feedback about energy drinks available in the market, pricing, packaging etc. The survey question file is attached at the end of this article.

Their Marketing Team wants their Data Analyst to convert these survey results to meaningful insights which the team can use to drive actions.

The Marketing Team have asked to share certain insights. They have also asked to share meaningful recommendations from the data or external factors etc.

Excel Project

Sales and Finance Analytics of AtliQ Hardwares

Domain/Function: Sales And Finance

▶ AtliQ is Hardware Company that sells Products like PC ,Mouse, Keyboard etc to different Customers across the Market. ▶ Products are Categorized by Division ▶ Markets are Categorized by Sub Zone ▶ Sub Zones are further Categorized by Region

Year Sales

Months Sales

Project Details

Project Name : Sales and Finance Analytics of AtliQ Hardwares

About AtliQ :

▶ AtliQ is Hardware Company that sells Products like PC ,Mouse, Keyboard etc to different Customers across the Market.

▶ Products are Categorized by Division

▶ Markets are Categorized by Sub Zone

▶ Sub Zones are further Categorized by Region

Objective ✅

To generate

✔ 1️⃣ Sales report which contains

🔸 Customer Performance based on Net sales 🔸 Market Performance Vs Target based on Net Sales 🔸 Top 10 Products based on the percentage increase in their net sales from 2020 to 2021 🔸 "Division" report to present the net sales data for 2020 and 2021, along with the growth percentage 🔸 Top 5 and Bottom 5 Products in terms of Quantity Sold 🔸 New products that AtliQ began selling in 2021 🔸 Top 5 countries in terms of net sales in 2021.

Python Project

AirBnb EDA Analysis

Domain/Function: AirBnb

The goal of this project is to: Analyze room types, prices, and availability across different neighborhoods. Understand host behavior and listing patterns. Detect potential outliers in prices. Provide recommendations for guests and hosts based on insigths.

To create a geographical plot that shows price and number of guests for each room type (e.g., Entire Home, Private Room, Shared Room) on a map

To compare the price of Airbnb listings across different neighborhoods, you can create a bar plot that shows the average price for each neighborhood.

Project Details

In this project, we’ll perform Exploratory Data Analysis (EDA) on Airbnb data using Python, specifically focusing on Pandas, Matplotlib, and Seaborn. The goal is to uncover insights into factors such as pricing, location, and availability, which can provide actionable business insights for Airbnb hosts and property managers.

Dataset Overview
We'll work with a dataset containing various features such as:

Listing Details: Price, room type, property type.
Availability: Number of nights available.
Location Data: Latitude, Longitude.
Reviews: Number of reviews, review scores.
Tools & Libraries
Pandas: For data manipulation.
Matplotlib/Seaborn: For visualization.
Numpy: For numerical operations.
Step-by-Step Process
Step 1: Data Preprocessing
First, we load the dataset and clean the data:

Check Missing Values: Identify and handle missing data.
Data Types: Ensure columns are in the appropriate data types.
Remove Duplicates: Eliminate duplicate entries.
python
Copy code