Powered by
Codebasics DA Bootcamp

Ananthi S

Data Aspirant

[email protected]

Resume

Hello, I am

Ananthi S.

1

Excel Project

2

PowerBI Projects

2

SQL Projects

About Me

👋 Welcome to my portfolio!

I’m Ananthi, a passionate data aspirant eager to turn complex data into meaningful insights.

🎓 I hold a Bachelor’s degree in Computer Science and Engineering with a strong foundation in analytical and technical problem-solving.

📊 Microsoft Certified: Power BI Data Analyst Associate(PL-300). I specialize in designing insightful dashboards and analytical solutions that support data-informed decisions.

💻 Proficient in Advanced Excel, SQL, and Power BI. I focus on data cleaning, visualization, and storytelling to drive meaningful insights.

🚀 Take a look at my portfolio projects to see how I apply these skills to real-world business scenarios.

Key Skills

EXCEL

MYSQL

POWER BI

PROBLEM SOLVING ABILITY

DATA CLEANING

DATA MODELLING

STAKEHOLDER MANAGEMENT

EFFECTIVE COMMUNICATION

My Projects

My Experience

Zoho Corporation Pvt Ltd (Sept 2022 - May 2023)

Project Trainee | Zoho CRM | Internship

• Completed an 8-month internship with the Zoho CRM team, gaining hands-on experience in software troubleshooting and client issue resolution.
• Handled and resolved customer tickets using Java, ensuring timely and effective solutions to improve user satisfaction.
• Enhanced system functionality through debugging and optimization, strengthening problem-solving and analytical skills in a live product environment.

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

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Power BI Desktop for Business Intelligence

Microsoft Power BI Desktop for Business Intelligence

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.

[email protected]

https://www.linkedin.com/in/ananthi-s-3a0b0221

https://github.com/s-anu

Excel Project

Sales and Finance Analytics

Domain/Function: IT Hardware Sales Analysis

This Excel project aims to analyze the financial health and performance of the business through insights on Customer Net Sales Performance, Market Performance vs. Target, Profit and Loss Statement by fiscal year, and by fiscal quarters for each year

View Project
on GitHUB

Sales and Finance Analytics

Customer Net Sales Performance displays the yearly net sales performance for each customer.

Sales and Finance Analytics

Market Performance vs Target Report

Project Details

This project offers a comprehensive view of the company’s financial and market performance, uncovering insights on sales growth, customer contribution, and target achievement. By combining data cleaning, analytical modeling, and visualization techniques in Excel, it transformed raw data into actionable business intelligence. The analysis supports data-driven decision-making by identifying strengths, performance gaps, and growth opportunities.

Key Learnings:
• Strengthened understanding of ETL processes for clean, reliable data.
• Built data models for structured financial analysis.
• Enhanced Power Query and Power Pivot skills for efficient reporting.
• Derived key metrics to highlight growth and profitability trends.
• Gained a deeper understanding of financial and P&L dynamics.

PowerBI Project

Business Insights 360

Domain/Function: IT Hardware

This Power BI project analyzes over 1M data entries across finance, sales, marketing, and supply chain for AtliQ Hardware, addressing key business needs and delivering insights that enable data-driven decisions and strategic growth in both e-commerce and retail sectors.

View Project
on GitHUB

Business Insights 360

Home Page

Business Insights 360

Finance View

Project Details

• Developed an interactive Power BI report with dedicated views for Finance, Sales, Marketing, Supply Chain, and Executive Management to deliver holistic business insights.
• Built a Home Page navigation system using bookmarks and buttons for a seamless user experience.
• Connected and transformed raw data using Power Query for cleaning, merging, and aggregation.
• Designed an optimized star schema data model with fact and dimension tables to ensure efficiency and faster refresh times.
• Created advanced DAX measures and calculated columns for KPIs such as revenue, profit margin, product performance, and forecast accuracy.
• Implemented dynamic visuals, slicers, drill-throughs, and conditional formatting for interactive, real-time analysis.
• Developed an Executive Summary view consolidating key KPIs for quick decision-making by leadership.
• Enhanced scalability and usability through consistent design, optimized queries, and role-based insights.

Live Interactive Dashboard

PowerBI Project

Business Performance Analytics

Domain/Function: Manufacturing & Retail Analytics

This Power BI project analyzes the business performance of AdventureWorks Cycles, a manufacturing company, by transforming raw data into interactive dashboards to track KPIs, compare regional sales, evaluate product trends, and identify high-value customers.

View Project
on GitHUB

Business Performance Analytics

Executive View

Business Performance Analytics

Map : Provides a global view of sales distribution by country. Helps identify regional sales performance trends.

Project Details

To deliver a comprehensive data model and interactive dashboard that empowers stakeholders to monitor sales performance, profit trends, customer insights, and product-level metrics for data-driven strategic decisions.
• Enhanced ability to translate business goals into measurable KPIs.
• Improved proficiency in Power Query for efficient data transformation.
• Utilized filters, slicers, and complex parameters for user-driven customization and drill-down analysis.
• Built robust data relationships, calculated columns, and DAX measures to uncover key business insights.
• Enabled dynamic insights with custom tooltips and interactive visuals.
• Gained a deeper understanding of sales dynamics, customer segmentation, and product-level performance to support strategic decision-making.

SQL Project

Employee Layoff Exploratory Data Analysis

Domain/Function: Layoff Analytics (Workforce & Employment Analytics)

This SQL project focuses on cleaning and preprocessing a layoffs dataset by handling duplicates, nulls, and inconsistencies, then storing the refined data in a staging table. It also performs EDA to uncover layoff trends across companies, industries, locations, and time periods.

View Project
on GitHUB

Employee Layoff Exploratory Data Analysis

Year-wise total layoffs by companies

Employee Layoff Exploratory Data Analysis

Maximum and Minimum layoffs by location

Project Details

Insights
• Identify industries and locations most affected by layoffs.
• Analyze layoff trends over time to understand economic impacts.
• Highlight top companies contributing to layoffs each year.
• Provide valuable insights for workforce planning and market predictions.

SQL Project

Data Analysis in Consumer Goods Domain

Domain/Function: Consumer Goods

Conducted in-depth analysis of sales and operations data for AtliQ Hardware to uncover insights on customer segmentation, product performance, and business trends. Solved 10 ad-hoc requests using advanced SQL, revealing key products, discount patterns, and regional performance.

View Project
on GitHUB

Data Analysis in Consumer Goods Domain

Total quantity sold per quarter during the fiscal year 2020.

Data Analysis in Consumer Goods Domain

Get the Top 3 products in each division that have a high total_sold_quantity in the fiscal year 2021

Project Details

This project aims to answer key business questions such as:
• What is the percentage increase in unique products in 2021 vs. 2020?
• Which segment recorded the highest growth in unique products between 2020 and 2021?
• Who are the top 5 customers receiving the highest average pre-invoice discounts in the Indian market for FY 2021?
• Which channel contributed the most to gross sales in FY 2021, and what was its percentage share?
By combining data extraction, transformation, and reporting techniques, this project demonstrated how SQL can drive meaningful business insights and guide strategic decision-making through structured analysis.