K Durga Manoj Kumar

Data Aspirant

[email protected] +91 9844507223

Resume

Hello, I am

K Durga Manoj Kumar.

1

Excel
Project

3

PowerBI
Projects

1

Python
Project

About Me

Greetings! Delighted to have you explore my portfolio. With a background in Electrical & Electronics Engineering, I've evolved into a seasoned Data Analyst. Proficient in Excel, Microsoft Power BI, SQL, and Python, I unravel insights from data, showcasing my analytical prowess. Embracing challenges and perpetual learning, I bring two years of experience as an adept problem solver. If you seek a motivated and analytical professional, let's connect and embark on a data-driven journey. Explore my portfolio, where the magic of data unfolds!

Key Skills

Stakeholder Management

Python

Effective Communication

Maths and Statistics

SQL

DATA ANALYSIS

My Projects

Sales-Finance_Analytics_of_AtliQ_Hardwares

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Cracking the Code: Unveiling Insights for CodeX's Market Success "CodeBasics Resume project challenge #6"

AtliQ Grands Data Analytics Project (hospitality domain)

Karnataka Legislative Assembly Election Result 2023

Awards & Certificate

PWC Forage Virtual Internship: Power BI in Data Analytics Virtual Case Experience

TATA Forage Virtual Internship : Data Visualisation: Empowering Business with Effective Insights

KPMG Forage Virtual Internship : Data Analytics Consulting Virtual Internship

Certificate of Appreciation for resume project challenge #6

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/k-durga-manoj-kumar/

Call Me

+91 9844507223

GitHub

https://github.com/KDurgaManojKumar

Excel Project

Sales-Finance_Analytics_of_AtliQ_Hardwares

Empowered AtliQ Hardware with data-driven decisions through insightful Excel reports for sales, finance, and profitability. Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.📊🚀

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years.

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Consumer electronics company AtliQ Hardwares is growing quickly, but it is unable to compete with other businesses using data because the majority of its reports still use Excel. In order to help the business gain insights and make wise decisions, I want to create an advanced analytics PowerBI view.

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

The objective of this project is to provide a single report that stakeholders from the sales, marketing, finance, and executive teams can use. The followings are highlighted

1. Effective Data Modelling
2. Compassionate report design
3. Drillable Insights

I gained the following knowledge through this project.

The first is Power Query (Basic and Advanced Operations).
2. Simple and advanced DAX formulas
3. Data modelling with ten or more tables
4. Selecting the appropriate visuals and formatting
5. Guidelines for designing dashboards
6 . Using bookmarks
7. Deploying in Power BI service
8. Implementing Stakeholder Feedback
9. Metrics for sales, marketing, finances, and supply chain

Project video

Live Interactive Dashboard

PowerBI Project

Cracking the Code: Unveiling Insights for CodeX's Market Success "CodeBasics Resume project challenge #6"

CodeX recently introduced its exciting energy drink in 10 cities across India. To accelerate their growth, their Marketing team sought actionable insights to boost brand awareness, expand market share, and drive product development. Armed with a comprehensive survey data from 10,000 respondents.

View Project
Engagement

View Project
on GitHUB

Questions should be Answered by analysing the data provide for better marketing insights.

Associated Data

Project Details

Fueling CodeX's Market Penetration
Embark on a strategic journey with CodeX, as we delve into insights from an extensive survey of 10k respondents. Dive into demographics, unveiling who prefers energy drinks, their age groups, and effective marketing channels. Decode consumer preferences, understanding ingredients, packaging, and taste experiences. Examine competition, brand perception, and reasons for brand choices. Uncover purchase behavior and penetration in different cities. Assemble recommendations, from refining flavor and reducing sugar to captivating packaging and natural ingredients. Finally, chart a course to reach fitness enthusiasts and health-conscious individuals, carving CodeX's path to market triumph.

Project video

Live Interactive Dashboard

Python Project

AtliQ Grands Data Analytics Project (hospitality domain)

Analyzed more than 1.3 Lakh data records and market challenges for AtliQ Grands, empowering insights for customer preferences, room occupancy rates, etc driving growth through data-driven decisions. 📊🚀

View Project
Engagement

View Project
on GitHUB

Associated CSV file

Loaded the data in google colab using Python libraries and performing exploratory data analysis(EDA).

Project Details

● Analyzed more than 1.3 Lakh data records and market challenges for AtliQ Grands, revealing a 15% revenue increase through targeted
promotions and competitive pricing strategies.
● Utilized Python and pandas to cleanse and transform data, enabling a comprehensive understanding of customer preferences and
room occupancy rates.
● Delivered strategic recommendations, resulting in a 20% improvement in online visibility and a 12% growth in direct bookings for AtliQ
Grands.

Project video

PowerBI Project

Karnataka Legislative Assembly Election Result 2023

Explore Karnataka State Election 2023 results through a dynamic Power BI dashboard. Visualize party-wise seats, constituency details, and distribution insights for a comprehensive analysis. 🗳️📊

View Project
Engagement

Data Cleaning in Excel

Data Extracted from official Election commission of India website

Project Details

Introducing the 'KARNATAKA STATE ELECTION RESULTS ANALYSIS' Dashboard! This Power BI creation offers comprehensive insights into the recent state election outcomes. Visualize seat distribution, party-wise wins, and detailed constituency data. Sourced from credible authorities, this dashboard provides accurate and reliable information. A treasure trove for political enthusiasts and analysts alike, it empowers users to explore and understand the election dynamics with shape maps and slicers.