Portfolio - Lekhana K

Hello, I am

Lekhana K

Data Aspirant

About Me.

I’m an aspiring Data Analyst with a Master’s degree in Agricultural Statistics and nearly two years of professional experience as a Crop Modeller, working with agricultural, weather, soil, and field data.

My experience sparked my passion for data analytics and uncovering meaningful insights. To pursue this interest, I have systematically upgraded my skills in Excel, SQL, Power BI, and Python, applying them through hands-on projects to transform raw data into actionable insights.

With a strong statistical foundation, an analytical mindset, and a passion for problem-solving, I aspire to leverage data to solve real-world business challenges and support smarter, data-driven decisions.

2

PowerBI Projects

Skills.

Excel

Power BI

Statistics

Effective Communication

Projects.

Awards & Certificate.

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 4.0

Contact.

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.

Download CV

[email protected]

https://www.linkedin.com/in/lekhana-k-22b209262/?isSelfProfile=true

PowerBI Project

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

Domain/Function: Finance, Sales and Marketing

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

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

An interactive Power BI dashboard showcasing financial KPIs, sales trends, net sales and product/customer performance with dynamic filters.

An executive-level Power BI dashboard summarizing key business KPIs, revenue contribution, forecast accuracy, top customers and products, and regional performance to support strategic decision-making.

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

Codex Survey Insights

Domain/Function: Food and Beverage Industry

CodeX is a German beverage company that launched its energy drink in 10 Indian cities. My goal is to analyze survey data from 10K respondents to understand consumer preferences, buying behavior, and brand perception. The analysis identified market opportunities and insights to improve brand awarenes

An interactive dashboard analyzing consumer responses, brand perceptions, health concerns, taste experiences, and consumption frequency across competing energy drink brands.

A dashboard highlighting marketing channel effectiveness, brand selection factors, purchase locations, price preferences, desired product improvements, and consumer interest in natural or organic energy drinks.

Project Details

## CodeX – Energy Drink Survey Insights

The goal of this project is to analyze consumer survey data and provide actionable insights that help CodeX understand the Indian energy drink market. The focus is on the following:

1. Consumer Behavior and Preferences
2. Brand Perception and Market Positioning
3. Data-Driven Marketing Strategies

### I learned the following things in this project

1. Data cleaning and preparation
2. Exploratory Data Analysis (EDA)
3. Analyzing survey data from 10,000 respondents
4. Identifying customer segments and purchasing patterns
5. Analyzing brand perception and consumer preferences
6. Creating meaningful data visualizations
7. Identifying effective marketing channels
8. Translating data into actionable business insights
9. Developing recommendations to improve brand awareness and market growth

Project video

Live Interactive Dashboard

Already have an account? Sign in