Portfolio - K. Anila

SQL Project

Analyse Promotions and Provide Tangible Insights to Sales Director

Domain/Function: Domain: FMCG Function: Sales / Promotions

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products.

View Project
on GitHUB

Analyse Promotions and Provide Tangible Insights to Sales Director

list of products with a base price greater than 500 and that are featured in promo type of 'BOGOF'

a report that provides an overview of the number of stores in each city.

Project Details

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Now the sales director wants to understand which promotions did well and which did not so that they can make informed decisions for their next promotional period.

Sales director Bruce Haryali wanted this immediately but the analytics manager Tony is engaged on another critical project. Tony decided to give this work to Peter Pandey who is the curious data analyst of AtliQ Mart. Since these insights will be directly reported to the sales director, Tony also provided some notes to Peter to support his work.

SQL Project

Provide Insights to Management in Consumer Goods Domain

Domain/Function: Consumer Goods | Executive Management

Domain: Consumer Goods | Function: Executive Management Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.

View Project
on GitHUB

Provide Insights to Management in Consumer Goods Domain

APAC Markets – Atliq Exclusive

Unique Products by Segment (Desc)

Project Details

As part of a SQL challenge for a junior data analyst role at Atliq Hardwares—a leading computer hardware company—I addressed 10 ad hoc business requests outlined in the 'ad-hoc-requests.pdf'. The task was to extract insights using SQL queries from the company's sales and customer databases. The goal was to support executive management in making data-informed decisions. I translated raw data into actionable insights, focusing on performance trends, customer behavior, and sales drivers. The final output was a well-structured presentation designed for senior leadership, highlighting key metrics and visual summaries to facilitate strategic decision-making.

PowerBI Project

The World of LEGO Through Data

Domain/Function: Toy Industry

An interactive Power BI dashboard analyzing LEGO sets across pricing, age suitability, product complexity, and theme trends. Uncovers key insights for enthusiasts, retailers, and manufacturers using data-driven storytelling.

View Project
Engagement

View Project
on GitHUB

Visualizing LEGO’s pricing trends, top themes, and product categories—insights on what drives value in the LEGO universe.

Exploring LEGO’s release trends—top themes, set categories, and how product launches evolved across decades.

Project Details

Understanding trends in the toy industry is essential for innovation and growth. This LEGO Insights Dashboard offers a comprehensive view of LEGO set performance, including pricing strategies, set complexity, age demographics, theme popularity. Built using Power BI, it transforms detailed LEGO dataset into actionable insights.

What It Covers:
Set Trends & Releases: Track set launches over time and identify peak release periods.
Pricing & Revenue: Analyze pricing distribution and average revenue across themes.
Age Recommendation: Discover how LEGO sets cater to different age groups.
Set Complexity: Explore the evolution of set size and piece count.
Theme Popularity: Identify the most loved LEGO themes and subthemes.

Skills Applied:
Data Preparation & Modeling using Power Query
DAX for KPI Calculation & Conditional Insights
Visual Storytelling with Interactive Charts and Filters
Consumer Product Analysis and Trend Identification

Live Interactive Dashboard

PowerBI Project

Airbnb Business Pulse: Insights Dashboard

Domain/Function: Hospitality and Travel

Unlock actionable insights with the Airbnb Business Pulse Dashboard! Built using Power BI, this interactive tool tracks revenue, occupancy rates, guest satisfaction, and regional performance. Ideal for stakeholders to optimize pricing, marketing, and operations using data-driven decisions.

View Project
Engagement

View Project
on GitHUB

Airbnb Business Pulse: Insights Dashboard

Home page of the Airbnb Performance Insights Dashboard with views for Finance, Listings, Location, Customers, and Bookings for data-driven insights.

Finance view of the Airbnb Performance Insights Dashboard displaying revenue, occupancy rates, room type analysis, top neighborhoods, and host earning

Project Details

Airbnb Business Pulse Dashboard

Understanding Airbnb’s business performance is key to making data-driven decisions. This Airbnb Business Pulse Dashboard offers a comprehensive view of revenue trends, occupancy rates, and guest satisfaction across regions. Built using Power BI, it transforms complex data into actionable insights for stakeholders.

What It Covers:
Revenue Insights: Track top-earning neighborhoods and monitor profitability.
Occupancy Trends: Analyze seasonal trends and market demand.
Guest Satisfaction: Evaluate reviews to enhance guest experience.
Regional Performance: Identify high-performing areas and growth opportunities.

Skills Applied:
Data Cleaning & Transformation using Power Query
Interactive Dashboard Creation with DAX
Business Performance Analysis for Strategic Decision-Making

This dashboard turns raw data into meaningful insights, empowering businesses to optimize operations and maximize profitability.

Live Interactive Dashboard

PowerBI Project

Atliq Analytics Portal: Empowering Smarter Business Decisions

Domain/Function: Business Analytics / Data Visualization

Atliq Analytics Portal is a dynamic Power BI dashboard offering 360-degree business insights across finance, sales, marketing, supply chain, and executive functions. Empowering stakeholders with real-time data, it enhances decision-making, boosts profitability, and drives business growth.

View Project
Engagement

View Project
on GitHUB

Atliq Analytics Portal: Empowering Smarter Business Decisions

Finance View of Atliq Analytics Portal with Net Sales, GM%, Net Profit%, P&L statements, sales trends, and interactive filters.

Executive View of Atliq Analytics Portal displaying Net Sales, GM%, Profit%, market share trends, key insights, and top customers/products.

Project Details

The Atliq Analytics Portal is a comprehensive Power BI dashboard that delivers real-time business insights, enabling Atliq Hardware to make data-driven decisions with confidence. It provides a consolidated view of key metrics across finance, sales, marketing, supply chain, and executive management.

Key features include profitability tracking, market performance analysis, sales trends, and forecast accuracy monitoring. Interactive visualizations and customizable filters offer a seamless user experience for stakeholders.

This project enhanced my skills in data transformation, visualization, and dashboard design using Power BI. By identifying underperforming products and cost inefficiencies, Atliq Hardware reduced operational expenses and boosted revenue.

Explore how data can transform business strategy with the Atliq Analytics Portal.

Project video

Live Interactive Dashboard

Excel Project

MGNREGA Insights: Unlocking Employment Trends with Data

Domain/Function: Employment Analysis, Policy Impact Assessment

Analyze MGNREGA's employment trends across states using this interactive dashboard. Gain insights into worker participation rates, job card utilization, and regional disparities. Designed to provide policymakers with actionable data for improving rural employment programs.

View Project
Engagement

View Project
on GitHUB

MGNREGA Insights: Unlocking Employment Trends with Data

Interactive MGNREGA Dashboard analyzing state-wise job card issuance, active worker participation, and utilization trends.

State wise Worker Participation Analysis Dashboard for MGNREGA, displaying active worker percentages, top and bottom states, and participation trends.

Project Details

Understanding employment patterns is crucial for effective policymaking. This MGNREGA Worker Participation Rate Dashboard offers a clear view of how job cards are utilized across Indian states. Built using Excel and Power BI, it reveals participation trends, highlights regional disparities, and provides actionable insights for policymakers.

What It Covers:
State-wise Analysis: Compare total vs. active workers to spot regional variations.
Utilization Trends: Evaluate how efficiently job cards are being used.
Performance Gaps: Identify states lagging behind in worker engagement.
Data-Driven Decisions: Support policy reforms with reliable insights.

Skills Applied:
Data Cleaning & Transformation using Power Query
Interactive Dashboard Creation with Pivot Tables & DAX
Public Policy Analytics for Impact Assessment

This dashboard transforms raw data into stories that matter.

Excel Project

SalesPulse: Unlocking Business Insights with Excel

Domain/Function: Sales and Financial Analysis

SalesPulse is a smart sales analysis tool that brings clarity to complex data using Excel. From identifying top-performing products to understanding market trends, it transforms raw numbers into actionable insights that fuel business growth.

View Project
Engagement

View Project
on GitHUB

SalesPulse: Unlocking Business Insights with Excel

This Excel report shows the Top 10 Products of AtliQ Hardwares, with a comparison of revenue between 2020 and 2021.

This Excel report for AtliQ Hardwares showcases the Market Performance vs Target across different countries from 2019 to 2021, with all values in USD.

Project Details

Ever wondered what your sales data is trying to tell you? SalesPulse unlocks those stories. Built using Excel’s powerful functions and Power Query, this project dives deep into customer behavior, market performance, and financial health. It’s like having a business crystal ball — but backed by data.

Key Insights:
Customer Performance Report – Spot sales trends across three years.
Market vs. Target Analysis – Track goal progress and refine strategies.
Top 10 Products Report – Identify profit drivers and optimize inventory.
Profit & Loss Insights – Visualize margins, revenue, and expenses.

What I Gained:
Mastered data cleaning and transformation using Power Query.
Built interactive dashboards with Pivot Tables and formulas.
Visualized complex data for better decision-making.
Developed actionable insights to drive business growth.

Hello, I am

K. Anila

2

3

2

About

Key

My

Analyse Promotions and Provide Tangible Insights to Sales Director

Provide Insights to Management in Consumer Goods Domain

The World of LEGO Through Data

Airbnb Business Pulse: Insights Dashboard

Atliq Analytics Portal: Empowering Smarter Business Decisions

MGNREGA Insights: Unlocking Employment Trends with Data

SalesPulse: Unlocking Business Insights with Excel

Awards

Contact Me

Email

Github

Linkedin

Call

K. Anila

Download Resume