Portfolio - Ekanshi Saxena | Codebasics

Powered by
Codebasics DA Bootcamp

Ekanshi Saxena

Data Aspirant

EMAIL

[email protected]

PHONE

+91 9456974451

About Me

Welcome to My Portfolio Website! 🚀
Hello! I'm Ekanshi Saxena, an aspiring Data Analyst passionate about transforming data into meaningful insights. I thrive on uncovering patterns, telling data-driven stories, and helping businesses make smarter decisions.

What Fuels My Passion? 🔍
I seek opportunities that challenge my analytical mindset and allow me to apply my expertise in data analysis to solve real-world business problems.

Why Consider Me? 📊
With hands-on experience in data cleaning, visualization, and dashboarding, I have built a strong foundation in handling and interpreting data efficiently. I excel in problem-solving, collaboration, and adaptability, ensuring insights translate into action.

What Makes Me Stand Out? 🎯
I am highly adaptable, detail-oriented, and passionate about using data to drive decisions. Eager to contribute, grow, and make an impact—let’s connect!

1

Excel Project

7

PowerBI Projects

3

SQL Projects

Key Skills

Excel

Power BI

Effective Communication

Problem-Solving

Stakeholder Management

SQL

MySQL

Python

Tableau

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Tableau Mini

Microsoft Fabric Mini: For Data Analysts

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

The Data Science Course: Complete Data Science Bootcamp 2024

The Data Science Course: Complete Data Science Bootcamp 2024

100 Days of Code: The Complete Python Pro Bootcamp

100 Days of Code: The Complete Python Pro Bootcamp

Let's Work Together!

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.

EMAIL

[email protected]

Call Me

+91 9456974451

LinkedIn

https://www.linkedin.com/in/ekanshisaxena

GitHub

https://github.com/its-ekanshi

Excel Project

Sales & Finance Analytics Report (FMCG)

Domain/Function: Sales & Finance/Data Analytics

Analyzed sales and financial data to uncover key trends, optimize revenue streams, and improve financial decision-making. Used Excel functions, Power Query, and visualization techniques to create an insightful report, helping businesses track performance and profitability.

View Project
Engagement

View Project
on GitHUB

Sales & Finance Analytics Report (FMCG)

Net Sales Performance (2019-2021) across customers, showing growth trends and business impact.

Sales & Finance Analytics Report (FMCG)

Performance of divisions with Net Sales, COGS, Gross Margin, and GM% for financial analysis and decision-making.

Project Details

Sales & Finance Analytics Report provides a deep dive into business performance by analyzing key financial and sales metrics. This report focuses on revenue trends, profit margins, sales growth, and cost analysis to offer actionable insights. Using data cleaning, processing, and visualization techniques, it highlights top-selling products, regional sales performance, and financial efficiency. The interactive report enables businesses to track KPIs, identify improvement areas, and make strategic, data-driven decisions to enhance profitability and operational efficiency.

PowerBI Project

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

Domain/Function: Business Intelligence/Data Analytics

Business Insights 360 is a comprehensive data analysis project that uncovers key business trends, performance metrics, and growth opportunities. Using data visualization and dashboarding, it provides actionable insights to enhance decision-making and drive business success.

View Project
Engagement

View Project
on GitHUB

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

Finance View dashboard showing Net Sales, Gross Margin, and profitability trends for financial performance analysis.

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

Executive View dashboard providing a high-level summary of key business insights across finance, sales, and marketing.

Project Details

Business Insights 360 is a data-driven analysis project designed to provide a 360-degree view of business performance. It focuses on key metrics like sales trends, revenue growth, customer behavior, and operational efficiency. By leveraging data visualization and interactive dashboards, this project helps identify opportunities, track KPIs, and make informed decisions. The insights derived empower businesses to optimize strategies, improve profitability, and drive growth through data-backed decision-making.

Live Interactive Dashboard

PowerBI Project

AtliQ Grands - Hospitality Revenue Analytics Dashboard

Domain/Function: Hospitality/Revenue

Hospitality Analytics provides data-driven insights into hotel performance, occupancy rates, revenue trends, and customer behavior. Using data visualization and business intelligence techniques, this project helps optimize operations, enhance guest experiences, and improve profitability.

View Project
Engagement

View Project
on GitHUB

AtliQ Grands - Hospitality Revenue Analytics Dashboard

"Hospitality Analytics Dashboard showcasing revenue, occupancy, RevPAR, ADR, and key performance metrics across cities and categories."

AtliQ Grands - Hospitality Revenue Analytics Dashboard

"Hospitality Analytics Dashboard displaying revenue, occupancy, RevPAR, ADR, and key performance indicators for Bangalore in June 2022."

Project Details

Hospitality Analytics is a data-driven project designed to analyze key performance metrics in the hospitality industry. It focuses on occupancy rates, revenue per available room (RevPAR), customer behavior, and booking trends to help businesses make informed decisions. By leveraging data visualization, dashboarding, and business intelligence techniques, the project provides actionable insights to optimize operations, enhance guest experiences, and improve profitability. The analysis helps identify market trends, peak booking periods, and areas for operational efficiency, enabling better decision-making for hospitality businesses.

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights (Consumer Goods)

Domain/Function: Consumer Goods/Ad-Hoc Business Analytics

This project involved solving 10 ad-hoc SQL queries to extract key business insights for Atliq Hardware. Techniques like Joins, CTEs, and Window Functions were used to analyze sales, profitability, and customer trends, with insights visualized in Power BI. 🚀

View Project
Engagement

View Project
on GitHUB

Ad-Hoc Insights (Consumer Goods)

"Unique product counts by segment, sorted in descending order. Notebooks, Accessories, and Peripherals contribute 83% of total manufactured products."

Ad-Hoc Insights (Consumer Goods)

"Retailer leads gross sales (73.21%), followed by Direct (15.48%) and Distributor (11.31%). Distributor has growth potential."

Project Details

Ad-Hoc Insights - SQL Analysis for Atliq Hardware 📊🔍

This project focuses on analyzing business performance through SQL-based ad-hoc requests for Atliq Hardware. Using Joins, CTEs, Subqueries, and Window Functions, I extracted key insights on sales trends, gross profit, contribution %, and customer behavior. The results were visualized in Power BI to present clear, data-driven insights for decision-making.

Key Takeaways:
✅ Optimized SQL queries for business analysis
✅ Extracted actionable insights on profitability & sales
✅ Created interactive Power BI visualizations

Sales Performance Dashboard using Tableau

Domain/Function: B2B Sales/Sales Analytics & BI

Built an interactive Tableau dashboard to analyze AtliQ Hardware’s sales data. Delivered insights on revenue trends, top customers/products, and profitability. Automated reports to support data-driven decisions and save analysts’ manual effort.

View Project
Engagement

View Project
on GitHUB

View Project
on

Sales Performance Dashboard using Tableau

Tableau dashboard showing revenue & sales quantity by market, top customers/products, and revenue trends across years and months.

Sales Performance Dashboard using Tableau

Sales and profit dashboard showing revenue by markets, profit margins, customer-level breakdown, and sales channel split (E-Commerce vs Brick & Mortar

Project Details

Designed a Tableau dashboard for AtliQ Hardware to uncover actionable sales insights and reduce manual reporting efforts. The dashboard analyzes revenue trends across cities, years, and months, and highlights the top 5 customers and products by revenue and sales quantity. It also showcases market-level profitability and performance, enabling the sales team to make faster, data-driven decisions. MySQL was used to query and prepare the raw sales data, while Excel supported early data cleaning. The dashboard helps automate regular reports, saving up to 20% of analysts' time and contributing to a 10% cost-saving opportunity. This project blends data analysis and visualization to drive operational efficiency and smarter business strategy.

PowerBI Project

Wavecon Telecom - 5G Launch Impact Analysis

Domain/Function: Telecom/Business Impact Analytics (5G Launch)

Analyzed the impact of 5G launch on Wavecon’s KPIs using a Power BI dashboard. Identified revenue trends, underperforming metrics, and evaluated post-launch plan performance to guide data-driven decisions on plan continuation or discontinuation.

View Project
Engagement

View Project
on GitHUB

Wavecon Telecom - 5G Launch Impact Analysis

Power BI dashboard showcasing revenue trends, KPIs, and city-wise performance before and after the 5G launch at Wavecon Telecom.

Wavecon Telecom - 5G Launch Impact Analysis

Revenue analysis for mobile plans, highlighting the Elite Saver Pack with total revenue, monthly revenue breakdown, and top cities like Mumbai & Delhi

Project Details

Led a dashboard-driven analysis for Wavecon Telecom to evaluate the business impact of its 5G launch. Using Power BI, I examined revenue trends, KPI fluctuations, and individual plan performance before and after the launch. The analysis highlighted underperforming KPIs, top and bottom-performing plans, and provided insights on whether certain plans should be continued, modified, or discontinued. I also investigated plan discontinuations post-launch and the reasons behind them. The project empowered data-driven decision-making by clearly visualizing the 5G rollout’s financial and operational implications, aligning with strategic business goals.

Live Interactive Dashboard

PowerBI Project

FMCG Supply Chain Service Level Analytics Dashboard

Domain/Function: FMCG/Supply Chain Analytics

A supply chain analytics project for AtliQ Mart to track daily service levels across cities using OT, IF, and OTIF metrics. It aims to identify delivery inefficiencies and improve customer satisfaction before nationwide expansion.

View Project
Engagement

View Project
on GitHUB

FMCG Supply Chain Service Level Analytics Dashboard

Service Delivery Analysis showing OT %, IF %, and OTIF % across customers, highlighting delivery gaps and performance trends with a comparative scatte

FMCG Supply Chain Service Level Analytics Dashboard

Key Metric Trends showing OT % fluctuations across months and cities, revealing seasonal patterns and long-term supply chain performance insights.

Project Details

This project was developed for AtliQ Mart, an FMCG company facing service-level issues that led to contract losses with key customers. The objective was to track and improve delivery performance using three critical KPIs: On-Time Delivery (OT%), In-Full Delivery (IF%), and On-Time In-Full (OTIF%). By analyzing daily order data across Surat, Ahmedabad, and Vadodara, the project provides actionable insights into late or partial deliveries. A dynamic Power BI dashboard was created to help the supply chain team monitor customer-level performance against target service levels. The solution enables timely interventions, drives operational excellence, and supports AtliQ Mart’s plan to expand into metro and Tier-1 cities.

Live Interactive Dashboard

SQL Project

SQL-Based Instagram Influencer Marketing Performance Analysis

Domain/Function: Social Media/Marketing Analytics

Analyzed a tech influencer’s Instagram activity using SQL to uncover insights on content performance, reach, and audience growth. Identified high-performing formats, peak engagement periods, and strategic posting patterns for better content decisions.

View Project
Engagement

View Project
on GitHUB

SQL-Based Instagram Influencer Marketing Performance Analysis

SQL questions 1–6 focused on post types, impressions, weekends, monthly stats, likes by category, and post category trends.

SQL-Based Instagram Influencer Marketing Performance Analysis

SQL tasks for engagement analysis: percentage breakdown by post type, quarterly report on comments & saves, top follower gain dates, and stored proced

Project Details

This project focuses on analyzing a tech influencer’s Instagram performance using structured data and SQL. By working with three tables—fact_content, fact_account, and dim_dates—I answered 10 key business questions related to impressions, reach, likes, comments, and follower growth. The goal was to identify trends in content type performance, audience engagement patterns across time, and top-performing post categories. Reels emerged as the most effective format, while weekends and months like May and June saw the highest growth. I also created a stored procedure to summarize post shares by week. This analysis enables better decision-making for content strategy and engagement optimization.

PowerBI Project

Shield Insurance

Domain/Function: Insurance/Sales & Customer Analytics

Analyzed sales and customer data for Shield Insurance using Power BI. Explored city-wise performance, age group behavior, and sales channel trends to uncover actionable insights and support data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Shield Insurance

Overview of total customers, revenue, city-wise performance, age groups, and monthly trends across Shield Insurance’s operations.

Shield Insurance

Breakdown of revenue and customers by sales channels with monthly trends, highlighting performance across offline and online modes.

Project Details

This Power BI project was developed as part of a virtual internship with a focus on the insurance domain. The goal was to analyze and visualize sales and customer data for Shield Insurance to uncover actionable insights. The dataset included information on customer demographics, revenue trends, and sales across four channels: Offline-Agent, Offline-Direct, Online-App, and Online-Website. Key KPIs such as total revenue, customer count, monthly trends, and expected claim settlements were explored. The dashboard enabled dynamic filtering by city, age group, and sales mode. Major insights revealed that Delhi NCR contributed the highest revenue, the 31–40 age group was the most valuable segment, and offline-agent sales dominated. Strategic recommendations were provided to improve mobile engagement, target underperforming cities, and tailor offerings based on customer behavior.

Live Interactive Dashboard

PowerBI Project

HR Analytics Dashboard for Employee Attendance & Leave Patterns

Domain/Function: Human Resources/Workforce Analytics

Developed an interactive HR analytics dashboard using Power BI to track employee attendance, WFH trends, and sick leaves from April to June 2022. Enabled data-driven workforce planning with key insights on presence patterns and remote work behavior.

View Project
Engagement

View Project
on GitHUB

HR Analytics Dashboard for Employee Attendance & Leave Patterns

Visual showing key HR analytics areas like Employee Churn, Time to Hire, Organizational Culture, Capacity, Capability, and Leadership.

HR Analytics Dashboard for Employee Attendance & Leave Patterns

Power BI dashboard showing employee attendance, WFH %, and SL % trends by date, weekday, and employee from Apr to Jun 2022.

Project Details

This HR Analytics project focuses on analyzing employee attendance, Work From Home (WFH), and Sick Leave (SL) trends from April to June 2022 using Power BI. The dashboard provides insights into workforce behavior by tracking key metrics like Attendance %, WFH %, and SL % across different days, weeks, and months. It highlights patterns such as peak WFH on Fridays, higher SL on Mondays, and overall attendance consistency. The dashboard allows HR teams to monitor employee presence effectively, identify anomalies, and support policy-making through data-driven insights. Power BI was used for data modeling, DAX calculations, and interactive visualization, enabling seamless exploration of employee-level and date-wise data.

Live Interactive Dashboard

PowerBI Project

CodeX Marketing Analytics – Consumer Insights for Energy Drink Launch

Domain/Function: Food & Beverage (F&B)/Marketing Analytics

Analyzed survey data from 10,000 respondents to uncover key marketing insights for CodeX, a new energy drink brand. Identified target audience, pricing strategy, consumer preferences, and recommended data-driven campaigns to boost market presence.

View Project
Engagement

View Project
on GitHUB

CodeX Marketing Analytics – Consumer Insights for Energy Drink Launch

“Respondent demographics by age, gender, city, and preferred marketing channels.”

CodeX Marketing Analytics – Consumer Insights for Energy Drink Launch

“CodeX performance on availability, price, packaging, brand perception, and health concerns.”

Project Details

Analyzed survey data from 10,000 respondents to generate actionable marketing insights for CodeX, a new energy drink brand entering the Indian market. Identified key consumer segments, preferred product features, pricing expectations, and purchasing behavior. Developed a Power BI dashboard and presentation to support data-driven decisions in branding, product positioning, and promotional strategies.

Live Interactive Dashboard

SQL Project

CodeX F&B Data Analytics

Domain/Function: Food & Beverage/ Marketing Analytics

Analyzed survey data from 10 K+ respondents across 10 Indian cities to deliver key marketing insights for CodeX’s energy drink launch—covering demographics, preferences, pricing, and campaigns.

View Project
Engagement

View Project
on GitHUB

CodeX F&B Data Analytics

SQL query analyzing energy drink preference by gender, showing respondent counts for male, female, and non-binary individuals.

CodeX F&B Data Analytics

SQL query analyzing preferred energy drink ingredients, ranked by total respondents. Caffeine is the most preferred, followed by vitamins and sugar.

Project Details

I analyzed survey responses from over 10,000 consumers across 10 Indian cities to support the market launch of CodeX, a German energy drink entering India. Using SQL, I cleaned and aggregated the data to reveal key patterns: the primary demographic (age 15–30), strong interest in caffeinated portable cans, and a preferred price range of ₹50–₹99. Building on this, I developed a dynamic Power BI dashboard showcasing insights across demographics, consumer preferences, competitor comparison, brand awareness, and purchase behavior. The outcome is a clear set of data-driven marketing recommendations—from pricing and positioning to targeting and promotional channels—geared toward improving CodeX's brand performance during its launch.