WHAT IS ACTUALLY MENTIONED / ANALYZED IN YOUR POWER BI FILE

Sales Performance Dashboard (Core Section)

This section focuses on how Blinkit’s sales are behaving.

What is shown:

• Total Sales / Revenue

• Total Orders

• Average Order Value (AOV)

• Sales trend over time (daily / weekly / monthly)

• Growth or decline patterns

What this analysis does:

• Shows whether sales are increasing, stable, or volatile

• Identifies peak demand periods

• Helps understand seasonality and short-term spikes

In simple terms:

This dashboard tells how much Blinkit is selling, when it is selling the most, and how sales are
trending over time.

Marketing KPI Dashboard

This is where marketing performance is evaluated.

What is shown:

• Key marketing KPIs such as:

o Campaign-linked sales

o Performance benchmarks

• Comparison of sales during campaigns vs non-campaign periods

What this analysis does:

• Measures effectiveness of marketing initiatives

• Identifies whether campaigns are actually driving sales

• Helps separate impact-driven campaigns from low-impact ones

In business language:

This dashboard evaluates whether marketing efforts are converting into actual revenue instead of
just increasing visibility.
 Customer Behavior & Demand Analysis

This part analyzes how customers are behaving on Blinkit.

What is shown:

• Order frequency patterns

• Repeat purchase behavior

• Demand concentration during specific time periods

• High-activity vs low-activity customer segments

What this analysis does:

• Shows Blinkit’s dependence on repeat customers

• Highlights convenience-driven and impulse purchasing

• Identifies demand-heavy windows

Meaning:

This section explains who is buying, how often they buy, and when they are most active.

Sales Pattern & Performance Benchmarking

This section focuses on comparative performance.

What is shown:

• Sales across different periods

• High-performing vs low-performing time frames

• Benchmarks to evaluate performance consistency

What this analysis does:

• Helps management understand what “good performance” looks like

• Identifies gaps where performance drops

• Supports data-backed performance evaluation

Simply:

This dashboard helps compare performance across time and identify improvement areas.

ROI-Oriented Insights (Analytical Layer)

This is not just visuals—this is interpretation.

What is analyzed:
 • Relationship between marketing activity and sales uplift

• Cost vs outcome logic (even if costs are proxy-based)

• Identification of efficient vs inefficient efforts

What this analysis does:

• Supports ROI-focused decision-making

• Helps optimize marketing spends

• Moves analysis from descriptive to evaluative

In one line:

This part focuses on whether the results justify the effort.

Why Power BI Was Used (Very Important)

Your .pbix file mainly demonstrates:

• Data cleaning & transformation

• Interactive dashboards

• Drill-down analysis

• Visual storytelling for business decisions

So your Power BI file is not just charts — it is a decision-support system.

ONE-PARAGRAPH SUMMARY (WHAT YOUR FILE CONTAINS)

The Power BI file contains dashboards analyzing Blinkit’s sales performance, marketing KPIs, and
customer behavior patterns. It visualizes revenue and order trends over time, evaluates marketing
effectiveness by comparing campaign-driven sales, analyzes customer demand and repeat
purchasing behavior, and derives ROI-focused insights. Overall, the file converts raw operational and
marketing data into interactive dashboards that support data-driven business decisions.
WHAT IS ACTUALLY COVERED IN

“THE FUTURE OF SUSTAINABLE MOBILITY IN INDIA THROUGH ELECTRIC VEHICLES (STRATEGY &
MARKETING)”

This project is a strategy- and market-oriented analysis of India’s EV ecosystem. It evaluates why EVs
are critical for sustainable mobility, how the Indian EV market is evolving, and what strategic and
marketing levers will drive adoption.

Sustainable Mobility & Role of EVs

The project starts by defining sustainable mobility and positioning EVs as a strategic solution.

What is covered:

• Transport contributes ~12–14% of India’s CO₂ emissions

• EVs offer:

o Zero tailpipe emissions

o 3–4× higher energy efficiency than ICE vehicles

o Lower lifecycle operating costs

• Alignment with:

o India’s climate commitments

o Energy security goals

o Reduction in oil imports

This section establishes why EVs are not optional but necessary for India’s long-term mobility
strategy.

Indian EV Market Overview

This section analyzes current market reality using data.

What is shown:

• EV penetration increased from <1% in 2018 to ~7–8% in FY25

• Over 6.5 million EVs currently operating in India

• Segment-wise penetration:

o Two-wheelers & three-wheelers dominate volumes

o Passenger EVs growing but still low penetration

• India identified as one of the fastest-growing EV markets globally

This explains where the market stands today and which segments are driving adoption.
 Policy & Regulatory Landscape

This section evaluates government intervention as a growth catalyst.

What is covered:

• Central role of government in EV adoption

• FAME II scheme:

o Outlay of ₹10,000+ crore

o Focus on demand incentives, manufacturing, and charging

• GST reduced to 5% on EVs

• State-level EV policies (Delhi, Maharashtra, Tamil Nadu, Karnataka)

• National target of 30% EV penetration by 2030

This shows that policy support is a structural driver, not a short-term push.

Technology Trends in Electric Vehicles

This part analyzes future-facing technologies shaping the EV ecosystem.

Technologies discussed:

• Solid-state batteries (higher density, safety, lifespan)

• Battery swapping (lower downtime, cost reduction)

• Connected EVs (software, diagnostics, predictive maintenance)

• Recycling & second-life batteries (sustainability + cost efficiency)

This explains how technology improvements will reduce cost, improve experience, and
accelerate adoption.

Market Forces & Competitive Dynamics

This section applies strategic market analysis.

What is covered:

• High competition with incumbents and startups

• Segment leadership:

o 2W/3W: Ola, Ather, TVS, Bajaj

o Passenger EVs: Tata Motors, MG, Mahindra

• High consumer price sensitivity

• Battery suppliers hold strong power (35–40% of EV cost)

This explains competitive pressure and cost dynamics in the EV industry.

Consumer Readiness & Adoption Drivers

This section focuses on demand-side behavior.

Key drivers analyzed:

• Lower running cost (₹0.8–1.2/km vs ₹2.5–3.5/km for ICE)

• Lower maintenance

• Improved charging access

• Government incentives

• Urban consumer readiness

• Rising environmental awareness

This shows why consumers are now more willing to adopt EVs.

EV Charging Infrastructure in India

This section highlights infrastructure as the key enabler.

What is covered:

• 30,000+ public charging stations in India

• 5× growth in last 3–4 years

• Urban and highway concentration

• Fast chargers expanding on national highways

• Public–private partnerships driving expansion

• Uneven rural and inter-city coverage remains a challenge

This directly links infrastructure growth to adoption confidence.

EV Adoption Forecast (2025–2030)

This is the analytical forecasting section.

What is forecasted:

• EV penetration:

o ~8% in FY25 → ~30% by 2030

o ~15–16 million vehicles by 2030

• CAGR of 40–45%

• Volume led by 2W/3W

• Value growth driven by passenger EVs

Assumptions used:

• Continued policy support

• Charging infrastructure scaling

• Battery cost decline of 6–8% annually

• Expansion into Tier-2 cities

This shows how adoption is projected using infrastructure, cost, and demand factors.

Strategy & Marketing Framework for EV Growth

This section applies the 4Ps of Marketing.

Strategy covered:

Product

• Reliable range

• Connected features

• Strong warranties

• Urban-commute focus

Price

• TCO-based pricing

• Financing & leasing

• Battery-as-a-service

Place

• Urban markets, highways, Tier-2 cities

• Hybrid online–offline distribution

Promotion

• Cost savings messaging

• Environmental benefits

• Digital campaigns, influencers, test drives, education

Key Challenges & Risks

The project clearly acknowledges risks:

• Economic: subsidy dependence, price sensitivity

• Operational: charging gaps, supply chain dependence

• Technological: battery life, safety, standardization

• Regulatory: policy changes, incentive reduction

This shows balanced, realistic analysis.

Future Outlook & Opportunities

Identified opportunity areas:

• Mass adoption in 2W/3W

• Urban passenger EVs

• EV financing & leasing

• Battery-as-a-service

• Charging & energy management

• Fleet electrification & last-mile delivery

Conclusion & Key Takeaways

Final conclusions:

• EVs are central to sustainable mobility in India

• Policy + technology + cost decline = adoption acceleration

• Infrastructure is the single biggest enabler

• Strategic marketing will determine long-term success

ONE-LINE SUMMARY OF WHAT YOUR PROJECT CONTAINS

The project provides a strategic and marketing-oriented analysis of India’s electric vehicle ecosystem,
covering policy support, market dynamics, technology trends, consumer readiness, infrastructure
growth, adoption forecasting, and strategic frameworks to drive sustainable EV adoption.
PROJECT OVERVIEW (STARTING STATEMENT – VERY IMPORTANT)

“My project is titled Impact of Key Macroeconomic Indicators on Indian Stock Market Returns.
The objective of this project was to understand how overall economic conditions influence stock
market performance in India. Instead of doing heavy statistical research, I focused on concept clarity
— understanding why stock markets move when economic indicators like GDP, inflation, interest
rates, or exchange rates change.”

PAGE 1 – INTRODUCTION (WHAT THIS PAGE TELLS)

“In the introduction, I explained the importance of the stock market in the economy and how it
reflects investor confidence. I also introduced macroeconomic indicators and explained that they
represent the overall health of the economy. The idea was to set the base that stock markets and the
economy are closely connected.”

PAGE 2 – WHY I CHOSE THIS PROJECT

“This page explains my motivation for choosing the topic. Stock markets react immediately to
economic news like RBI policies or inflation data. I wanted to understand why that happens and how
investors interpret economic signals. This topic helped me connect theoretical economics with real
market movements.”

PAGE 3 – OBJECTIVES OF THE PROJECT

“Here, I clearly defined what I wanted to learn from the project. The objectives were to understand
macroeconomic indicators, study their impact on stock market returns, and improve my
understanding of the Indian stock market. This page shows the direction and purpose of the project.”

PAGE 4 – MACROECONOMIC INDICATORS OVERVIEW

“This section gives a basic explanation of macroeconomic indicators. I introduced GDP, inflation,
interest rates, and exchange rates, and explained that these indicators are used by governments,
investors, and businesses to judge economic performance.”

PAGE 5 – GDP AND STOCK MARKET

“On this page, I explained the relationship between GDP growth and stock market performance.
Higher GDP growth usually leads to better corporate earnings and higher investor confidence, which
positively impacts stock prices. This section highlights why economic growth supports equity
markets.”

PAGE 6 – INFLATION AND STOCK MARKET

PAGE 7 – INTEREST RATES AND STOCK MARKET

“This page explains how interest rates influence stock prices. When interest rates rise, borrowing
becomes expensive and investments slow down, which can negatively affect stock markets. Lower
interest rates support market growth. This shows the inverse relationship between interest rates and
equity markets.”

PAGE 8 – EXCHANGE RATE AND STOCK MARKET

“In this section, I explained how exchange rate movements affect Indian companies and foreign
investors. A weaker rupee benefits exporters but hurts import-dependent firms. Exchange rate
changes also impact foreign investment flows into the Indian stock market.”

PAGE 9 – INDIAN STOCK MARKET OVERVIEW

“This page provides a brief overview of the Indian stock market structure, including NSE, BSE, NIFTY
50, and SENSEX. I explained that these indices reflect overall market performance and respond to
economic and policy changes.”

PAGE 10 – CONCLUSION

“In the conclusion, I summarized that macroeconomic indicators have a strong influence on stock
market returns. Stable economic growth, controlled inflation, favorable interest rates, and a stable
exchange rate support positive market performance. The key takeaway is that investors should track
economic indicators along with company fundamentals.”

PAGE 11 – LEARNING FROM THE PROJECT

“This page highlights what I personally learned from the project. It improved my understanding of
how economics and finance are linked and helped me understand why markets react to economic
news. It also strengthened my basic market awareness.”

PAGE 12 – REFERENCES

“Finally, I mentioned the sources used such as RBI, NSE, BSE, and business news platforms to show
that the project is based on reliable and authentic information.”

ONE-LINE FINAL CLOSING (VERY IMPRESSIVE)

INTERVIEW TIP

If the panel interrupts and says “Explain in short”, say this:

“In short, my project explains how changes in economic indicators like GDP, inflation, interest rates,
and exchange rates influence investor behavior and stock market returns in India.”