Skip to content
View ankitasaha1's full-sized avatar

Block or report ankitasaha1

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ankitasaha1/README.md

ankitasaha1/ankitasaha1 is a ✨ special ✨ repository because its README.md (this file) appears on your GitHub profile.

Hi, I'm Ankita Saha (she/her) 👋

Data Analyst | SQL • Power BI • Tableau

I turn raw, messy datasets into clear business decisions — building end-to-end analytics projects across banking, fintech, energy, agriculture and e-commerce domains.

🔍 What I Do

  • 🧹 Data cleaning and preparation using SQL and Excel
  • 📊 Interactive dashboard development in Power BI and Tableau
  • 🔎 Exploratory data analysis to uncover actionable business insights
  • 📝 Documenting analytical workflows for transparency and reproducibility

🛠️ Tools & Skills

Visualization & BI
Power BI · Tableau Public · DAX · Power Query

Database & Query
SQL · DB Browser for SQLite · Data Cleaning · EDA

Spreadsheet Analysis
Excel · Pivot Tables · VLOOKUP · XLOOKUP

Analysis Techniques
Customer Segmentation · Churn Analysis · RFM Analysis · Trend Analysis

📌 Featured Projects

🏦 Bank Customer Churn Analysis
SQL + Tableau | Identified 51% churn rate in 46-60 age group, 100% churn for 4+ product customers

🌍 Global Layoffs Trend Analysis
SQL (SQLite) + Tableau | Cleaned real-world messy data using window functions, CTEs and self-join logic

💰 Indian Personal Finance Behaviour
Power BI + DAX | Identified gender financial literacy paradox across 1,000 respondents

☀️ Solar Power Generation Analysis
Power BI + Data Modelling | Identified 24% generation gap from equipment fault

🌾 Smart Farming Crop Yield Analysis
Tableau + Geographic Mapping | Analysed IoT data from 500 farms globally

🛒 Ecom Express Sales Analysis
Power BI + DAX | Quantified ₹167.87M revenue lost to cancellations

  • 🌱 I’m currently honing my skills in SQL, python, and learning trending tools like Microsoft Fabric to engage in industry relevant trends.
  • 👯 I’m looking to collaborate on independent projects based work on similar fields.

📫 Let's Connect

LinkedIn Tableau Gmail

📍 Kolkata, India
💼 Open to: Jr Data Analyst | BI Analyst | MIS Analyst | Operations Analyst roles

Pinned Loading

  1. bank-customer-churn-analysis bank-customer-churn-analysis Public

    End-to-end data analysis project on bank customer churn using SQL (SQLite), Tableau | Data Cleaning, EDA & Interactive Dashboard

  2. E-com-express-sales-performance E-com-express-sales-performance Public

    Interactive Power BI sales dashboard analysing ₹389.99M revenue and ₹167.87M cancellation impact for Ecom Express | Excel Data Cleaning | DAX | Data Modelling

  3. global-layoffs-trend-analysis global-layoffs-trend-analysis Public

    End-to-end global tech layoffs analysis using SQL data cleaning with window functions and CTEs, EDA and interactive Tableau dashboard | 2020-2024

  4. indian-personal-finance-behaviour indian-personal-finance-behaviour Public

    Power BI dashboard analyzing personal behaviour, protection cover patterns, fintech adoption across 1000 indian respondents in different city tiers, genders, age groups and employment types

  5. smart-farming-crop-yield-tableau smart-farming-crop-yield-tableau Public

    Tableau Dashboard analysing smart farming data to identify key factors impacting crop yield across irrigation, soil, other factors.

  6. solar-power-plant-data-analysis solar-power-plant-data-analysis Public

    Power BI dashboard analyzing 2 Indian solar power plants data generation, detecting equipment faults, and power generation gaps in inverter levels