Niraj pal

Data Analyst

[email protected] +91 9162184115

Resume

Hello, I am

Niraj pal.

1

Excel
Project

2

PowerBI
Projects

2

SQL
Projects

About Me

👋 Hello and Welcome to my Portfolio Website!

I’m Niraj Pal, an aspiring Data Analyst passionate about uncovering insights from data using Excel, Power BI, and SQL. Data's potential to drive impactful decisions fascinates me, and I’ve channeled this fascination into several business projects, which you can explore in my portfolio below.

🔍 Why Data?
Data tells powerful stories. I specialize in analyzing complex datasets, creating insightful visualizations, and deriving actionable recommendations.

💡 What I Bring to the Table:

Analytical Precision: Skilled in extracting meaningful insights to support decision-making.
Visual Storytelling: Proficient in crafting compelling data visualizations using Power BI.
Continuous Learning: Always exploring new data techniques and methodologies.

While I haven't yet worked in an organization, my projects reflect my dedication and analytical prowess. I look forward to contributing to a team that values data-driven strategies.

Key Skills

SQL

Managing Project Stakeholders

Introduction to strategic sourcing and category mgt in Supply Chain Management

Problem Solving

My Projects

Sales And Finance Analytics: AtliQ Hardware

Business Insights 360: AtliQ Hardware

Domain/Function: Brick and Mortar

AtliQ's Grand - Hospitality Analysis

Consumer Goods Ad-hoc Insights

Finance and Supply Chain Analytics at AtliQ

Awards & Certificate

Managing Project Stakeholders

Introduction to Strategic Sourcing and Category Management in Supply Chain Management

Accenture North America- Data Analytics and Visualization Job Simulation

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/niraj-pal-2802322a5/

Call Me

+91 9162184115

GitHub

https://github.com/nirajpal01

Excel Project

Sales And Finance Analytics: AtliQ Hardware

This project provides an in-depth analysis of the company's financial health and market position, generating reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using both fundamental and advanced Excel techniques.

View Project
Engagement

View Project
on GitHUB

Other Tools

Pivot Table

Power Query

Power Pivot

Customer Performance Report: Delivers a comprehensive analysis of each customer’s net sales performance over multiple years.

Market Performance vs. Target Report: Provides stakeholders with a detailed evaluation of the market's performance over the years, benchmarked against

Project Details

In this project, I crafted an advanced sales report using Excel pivot tables to empower businesses in determining optimal customer discounts, streamlining negotiations, and identifying growth opportunities in emerging markets. These comprehensive reports deliver actionable insights to refine sales strategies, enhance customer satisfaction, and boost revenue.

Skills Acquired:

🔶Proficient use of Excel pivot tables
🔶Advanced data analysis with Power Query
🔶Fundamental DAX (Data Analysis Expressions) knowledge
🔶Effective conditional formatting
🔶Report aesthetic enhancement techniques
🔶Deep understanding of sales metrics

This project equips businesses with essential tools and insights for monitoring, evaluating, and improving sales activities, unlocking new growth avenues, and maintaining a competitive edge in dynamic markets.

PowerBI Project

Business Insights 360: AtliQ Hardware

Domain/Function: Brick and Mortar

AtliQ Hardware encountered challenges managing extensive datasets in Excel. They transitioned to Power BI to enhance data comprehension and derive actionable insights in finance, sales, and supply chain. The project handled 1.8 million records using SQL, Power BI, Excel, and DAX Studio.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

Excel

MySQL

This is the main gateway of the dashboard, providing users with streamlined navigation to various analytical sections.

Data modeling encompassing more than 10 tables requires intricate structuring and integration to establish robust relationships and optimize data ret

Project Details

This project integrates Power BI, SQL, and Excel to tackle operational inefficiencies at AtliQ Hardware, a global leader in consumer electronics. Previous heavy reliance on Excel led to regional losses. Senior management initiated a data analytics transformation using last year's data to drive strategic enhancements.

🔶 Finance View: Provides a profit and loss overview, tracking Gross Margin (GM), Net Profit (NP), Net Sales (NS), and performance trends.
🔶 Sales View: Analyzes customer and product performance, unit economics, NS, and GM%.
🔶 Marketing View: Evaluates region and product metrics based on NS and GM%.
🔶 Supply Chain View: Monitors forecast accuracy, net error, and trends by customer and product.
🔶 Executive View: Insights into competitor market share, revenue trends, and top 5 customers.

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ's Grand - Hospitality Analysis

This project exemplifies the transformative power of data in the hospitality industry by analyzing critical metrics such as Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%, DBRN, and DSRN, offering actionable insights for improved performance and decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

Excel

MySQL

This central hub of the dashboard offers users easy access to various analytical sections, facilitating efficient navigation.

Overview of AtliQ Grands' Performance Metrics

Project Details

AtliQ Grands, a distinguished chain of five-star hotels with a 20-year legacy in India, faces challenges in market share and revenue within the luxury and business segments due to competitive pressures and management inefficiencies. To counteract this, the managing director is spearheading a strategic initiative to embed "Business and Data Intelligence" into operations, aiming to regain market share and drive revenue growth.

ACHIEVEMENTS:

🔶 Developed metrics as per the prescribed list.
🔶 Crafted a dashboard aligned with the stakeholder-provided mock-up.
🔶 Derived insights beyond the given metric list and dashboard specifications.
SKILLS UTILIZED:

🔶 Applied Power BI.
🔶 Utilized SQL.
🔶 Employed Excel.
🔶 Harnessed DAX Studio.

This initiative marks a pivotal step towards enhancing AtliQ Grands' competitive edge through advanced analytics and data-driven strategies.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Insights

Leveraged SQL, Excel, and PowerPoint to address 10 ad-hoc data requests, guiding Atliq's strategic direction. Key insights revealed a surge in unique products, the prominence of the 'Notebook' segment, and notable seasonal sales trends.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Provide a report with all the unique product counts for each segment and sort them in descending order of product counts.- wrote the SQL QUERY.

The SQL query yielded a result, which was subsequently visualized as a stacked bar chart illustrating product counts across segments.

Project Details

In the "Consumer Goods Domain" project at Atliq Hardware, I conducted a thorough database analysis to support strategic decision-making:

🔶Ad-hoc Requests Analysis: Addressed ten specific requests, extracting actionable insights for strategic decisions.
🔶Product Analysis: Identified a rise in unique products, with 'Notebooks' dominant and 'Accessories' showing growth.
🔶Sales Seasonality: Revealed seasonal sales trends impacting demand.
🔶Channel Importance: Highlighted the pivotal role of the 'Retailer' channel in sales.
🔶Market Dynamics: Explored the dynamic consumer goods market, emphasizing product diversity.
🔶Key Learnings: Enhanced skills in data analytics, market navigation, and strategy optimization.
🔶Skill Development: Strengthened proficiency in data analysis, problem-solving, and communication.

This project deepened my analytical prowess and provided valuable insights for optimizing strategies in the competitive consumer goods sector.

SQL Project

Finance and Supply Chain Analytics at AtliQ

This project used SQL to analyze AtliQ Hardware's datasets, transforming raw data into actionable insights to optimize sales, market dynamics, customer behaviors, and supply chain forecasting.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Excel

About AtliQ hardware and its Business Model.

I created a report on the top 5 customers by net sales for FY 2021, using SQL for data extraction and visualized the results in millions.

Project Details

This project centered on leveraging SQL to analyze AtliQ Hardware's extensive datasets, aiming to derive actionable insights into crucial facets such as sales trends, market dynamics, customer behaviors, and supply chain forecasting. The initiative was driven by the need to overcome performance bottlenecks associated with large Excel files, employing MySQL to efficiently transform raw data into invaluable business intelligence.

Key achievements included optimizing sales strategies, identifying lucrative growth opportunities, and conducting comprehensive market trend analyses. These insights were instrumental in guiding strategic decisions and enhancing operational efficiencies.

Through this project, I not only honed my SQL proficiency and data analysis skills but also gained a deeper understanding of business analytics, empowering me to contribute meaningfully to organizational success through informed decision-making and impactful insights.