Nandan Kumar S

Data Analyst

[email protected] +91 8217737198

Resume

Hello, I am

Nandan Kumar S.

1

Excel
Project

1

PowerBI
Project

About Me

Welcome to my portfolio I'm an ambitious and driven Data Analyst with a unique blend of technical and analytical skills. Although my academic background is in Aeronautical Engineering, I've discovered a profound passion for data analysis, where I excel in uncovering insights that drive business decisions.
Equipped with Excel, PowerBI, SQL, and Python, I transform complex data into actionable intelligence. Despite lacking traditional industry experience, I've honed my skills through numerous business projects that demonstrate my ability to analyze data, identify trends, and provide meaningful insights.
My portfolio showcases these projects in detail, highlighting my ability to apply data analysis techniques to real-world problems. I'm eager to join a dynamic team where I can contribute to driving innovation and growth. Let's connect and explore how we can leverage data to achieve exceptional results together.

Key Skills

Excel

Power Bi

Effective Communication

Stakeholder Management

My Projects

Sales Analytics

Domain/Function: FMCG

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

Domain/Function: Business

Awards & Certificate

Excel: Mother of Business Intelligence

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/nandan-kumar-s-30b069213/

Call Me

+91 8217737198

GitHub

https://github.com/Nandankumars

Excel Project

Sales Analytics

Domain/Function: FMCG

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
Engagement

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

Project Overview:

In this project, I created a sales report using Excel pivot tables to help businesses optimize their sales strategies. The report enables businesses to:

1. Optimize Customer Discounts: Determine effective discounts to enhance customer satisfaction and drive sales.
2. Facilitate Consumer Negotiations: Provide data-driven insights for better negotiations.
3. Identify Expansion Opportunities: Highlight promising countries for business expansion.

Key Skills Acquired:

1. Pivot Tables: Aggregated and analyzed data efficiently.
2. Power Query: Imported, transformed, and loaded data.
3. DAX (Basics): Created calculated fields and measures.
4. Conditional Formatting: Visually highlighted key trends.
5. Report Beautification: Designed visually appealing reports.

Overall, this project helps businesses make data-driven decisions to optimize sales strategies, enhance customer satisfaction, and maximize revenue.

PowerBI Project

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

Domain/Function: Business

AtliQ Hardwares, a rapidly expanding consumer electronics company, struggles to compete using data due to reliance on Excel reports. My goal is to implement an advanced analytics solution with Power BI to provide insights and enable informed decision-making.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to create a comprehensive Power BI report for stakeholders in sales, marketing, finance, and the executive team. Focus areas include:

1. Robust Data Modeling: Ensuring data integrity and relationships.
2. User-empathetic Report Design: Tailoring for easy navigation.
3. Drillable Insights: Enabling detailed analysis with interactive visuals.

Key learnings:

1. Power Query: Mastering basic and advanced operations.
2. DAX Formulas: Understanding basic and complex formulas.
3. Data Modeling: Integrating over 10 tables.
4. Visual Selection & Formatting: Choosing the right visuals.
5. Dashboard Design Principles: Applying best practices.
6. Bookmarks: Enhancing navigation.
7. Deployment in Power BI Service: Successfully deploying online.