Nachiketa Mandal

Data Aspirant

[email protected]

Resume

Hello, I am

Nachiketa Mandal.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

About Me

👉A detail-oriented Data Analyst with expertise in SQL, Power BI, and Excel, specializing in transforming raw data into actionable insights.
👉Proficient in data modeling, visualization, and business intelligence, with a strong ability to identify trends, optimize processes, and enhance decision-making.
👉Adept at statistical analysis, forecasting, and stakeholder collaboration to drive business efficiency.
👉Skilled in handling large datasets, automating reports, and developing dashboards to improve operational performance.
👉Passionate about leveraging data to boost business growth and efficiency.
😊I am a strong advocate of learning in public, regularly sharing my experiences and insights to help others in the data analytics community. Feel free to connect with me at [email protected] to learn and grow together.

Key Skills

Excel

Power BI

SQL

Communication Skill

Presentation Skill

My Projects

Sales Analytics(FMCG)

Domain/Function: Finance and Sales

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

Domain/Function: Finance , Marketing, Sales, Operation

Electric Vehicles Analysis In India

Domain/Function: Finance and Sales

Consumer Goods Analysis

Domain/Function: Executive Management

Shield Insurance

Domain/Function: Insurance

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

GitHub

https://github.com/Nachiketamandal

Excel Project

Sales Analytics(FMCG)

Domain/Function: Finance and Sales

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

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

Domain/Function: Finance , Marketing, Sales, Operation

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights .

View Project
Engagement

View Project
on GitHUB

This home page features a display of all dashboards, including the refresh date and project details.

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

Electric Vehicles Analysis In India

Domain/Function: Finance and Sales

AtliQ Motors is an automotive giant from the USA specializing in electric vehicles (EV). Their market share rose to 25% in electric and hybrid vehicles segment in North America.They wanted to launch their bestselling models in India where market share is less than 2%.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 3+ tables

Project Details

In this project, the goal is to do detailed market study of existing EV/Hybrid market in India. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 3+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Give 3 recomandation ot AtliQ Motors
9. Sales, Market , State metrics

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Analysis

Domain/Function: Executive Management

Using SQL queries answered 10 ad-hoc requests, making data the compass for Atliq's journey to success. SQL, Excel, and PowerPoint tools are used.Key insights included a significant increase in unique products, a dominant 'Notebook' segment and seasonal sales trends

View Project
Engagement

View Project
on GitHUB

SQL query finds top customers by average discount pct for FY 2021 in India

SQL query finds top 3 product by each division for FY 2021

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights.
Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Sales seasonality and the pivotal role of the 'Retailer' channel were uncovered.
Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.
The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.

Project video

PowerBI Project

Shield Insurance

Domain/Function: Insurance

Explored Shield Insurance customer behavior & sales trends using Power BI in a data analytics bootcamp by Codebasics. Completed an end-to-end project during my data analytics internship, analyzing provided CSV files.

View Project
Engagement

This general view provides a snapshot of revenue and customer trends, enabling exploration of key insights.

Age Group Analysis view offers monthly customer trends, sales mode distribution, policy preferences, settlement percentages,& customer distribution.

Project Details

Employed Power BI for an in-depth analysis of Shield Insurance. Explored revenue, customer behavior, city trends, sales modes, and age group dynamics. Generated a comprehensive report leading to strategic decisions and actionable recommendations. Contributed to an 8-10% revenue growth projection and expanded market presence via data-driven insights.