Sanchita Dasgupta

Healthcare MIS & Data Analyst | Excel • SQL • Power BI

[email protected] +91 9874980347

Resume

Hello, I am

Sanchita Dasgupta.

1

Excel
Project

4

PowerBI
Projects

1

SQL
Project

About Me

Welcome to my portfolio
Healthcare-focused Data Analyst with a background in Nutrition, experienced in building dashboards, analyzing data, and delivering actionable insights using Excel, SQL, and Power BI.

Key Skills

Effective communication

EXCEL

MY SQL

POWER BI

PHYTON

Stakeholder management

My Projects

Sales Performance Dashboard (Business & Operational Insights)

Domain/Function: Buisness Sector

AtliQ Hardware Buisness Insights 360

Domain/Function: Brick& Motar ,E-commerce

Operational Efficiency Dashboard (Supply Chain & Process Analysis)

Domain/Function: FMCG

ATLiQ Hardware AdHoc requests On consumer Goods

Domain/Function: Consumer Goods

Performance Insights and Passenger Metrics Analysis for Goodcabs Operations in Tier-2 Cities

Domain/Function: Transporation & Mobility

Air Pollution Intelligence & Market Opportunity

Domain/Function: Consumer Appliances

My Experience

Product Delivery Specialist-Mihup.Ai
Jan 2025-Feb 2026

• Analyzed datasets to identify trends and performance gaps
• Created reports and dashboards using Excel and Power BI
• Tracked KPIs and supported data-driven decision-making
• Improved reporting accuracy and data validation processes

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

Scam Awareness Course

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

Google Analytics Basic-Introduction

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.

Mail Me

[email protected]

https://www.linkedin.com/in/-sanchitadasgupta/

Call Me

+91 9874980347

GitHub

https://github.com/Sanchitadg

Excel Project

Sales Performance Dashboard (Business & Operational Insights)

Domain/Function: Buisness Sector

"This project provides an in-depth analysis of Atliq Mart's sales performance, focusing on customer demographics, regional divisions, and other key segments. It also examines financial metrics such as gross margin, total cost, and overall profitability

View Project
Engagement

View Project
on GitHub, Linkdin

Other Tools

Power Query

PIVOT TABLE

DAX Measures

This dives into AtliQ Hardware's net sales performance, providing a comprehensive view of customer metrics across regions, divisions, and country.

This project analyzes AtliQ Hardware’s finance performance, covering net sales, COGS, and gross margin% to provide clear insights .

Project Details

Excel Project on Sales & Finance Analytics for AtliQ Hardware

🌍 Real-Time Insights:

Analyzed customer and product sales data across various countries and regions.
Focused on enhancing profitability with an increase in profit percentages year-over-year.
💡 Skills Enhanced:

Data Cleaning: Leveraged Power Query for efficient data handling.
Data Connectivity: Connected multiple tables for comprehensive insights.
Component Listing: Organized and listed key components.
Pivot Tables & DAX: Used advanced pivot tables and DAX measures for in-depth analysis

PowerBI Project

AtliQ Hardware Buisness Insights 360

Domain/Function: Brick& Motar ,E-commerce

This project provides a comprehensive overview of AltiQ Hardware's business insights across finance, sales, marketing, and supply chain domains. It aims to analyze data effectively to identify areas of loss and understand growth metrics, supporting strategic decisions for improved profitability .

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

POWER PIVOT

Dax Measures

Data modelling

Overview of finance, sales, marketing, supply chain, and executive metrics for AtliQ Hardware, highlighting key insights across all business areas.

Overview of AtliQ Hardware's business insights, showcasing Net Sales, Net Profit, Gross Margin, Forecast Accuracy, and regional sales trends.

Project Details

-Project Overview: Analyzed AltiQ Hardware's business data to extract actionable insights across finance, sales, marketing, and supply chain sectors.
Objective: Identified loss areas and growth metrics to drive strategic decisions, enhancing profitability and operational efficiency.
Key Learnings:
Data Cleaning: Mastered techniques for cleaning and preparing data for accurate analysis.
Data Modeling: Developed data models to establish relationships between tables and improve analytical depth.
DAX Measures: Applied DAX formulas to perform complex calculations, enabling detailed financial and sales analysis.
Visualizations: Created clear, impactful visuals to represent data trends and insights effectively.
Analytical Perspective: Gained a holistic understanding of data analytics processes, improving decision-making through comprehensive data examination.

Project video

Live Interactive Dashboard

PowerBI Project

Operational Efficiency Dashboard (Supply Chain & Process Analysis)

Domain/Function: FMCG

Analyzed contract renewal challenges by evaluating delivery KPIs (on-time, in-full) using DAX, Power Query, slicers, and visual tools like bar and line charts to generate actionable insights. Analyzed contract renewal challenges by evaluating delivery KPIs using DAX, Power Query.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

dax measures

Power query

This project analyzes KPI metrics, splitting data by cities and customers to identify underperformers and top achievers in delivery performance.

This project evaluates VOFR and LIFR rates based on product performance for AtliQ Mart.

Project Details

Business Problem: Addressed contract renewal challenges by analyzing delivery performance metrics: on-time, in-full, and both on-time and in-full.
Data Processing: Utilized Power Query for comprehensive data cleaning and preparation.
Analytical Techniques: Created DAX measures to calculate key performance indicators (KPIs) for delivery metrics.
Data Visualization: Designed interactive bar charts, line charts, and other visuals to highlight delivery trends.
Interactivity: Applied slicers and bookmarks to enable dynamic filtering and enhanced user navigation.
Insights Generation: Delivered actionable insights to improve contract renewal rates by identifying gaps in delivery performance.

Project video

Live Interactive Dashboard

SQL Project

ATLiQ Hardware AdHoc requests On consumer Goods

Domain/Function: Consumer Goods

Atliq Hardware faced challenges in deriving data-driven insights, prompting the creation of an SQL challenge to address this gap. Through this project, I gained hands-on experience with SQL functions like JOINs, CTEs, and GROUP BY, as well as DAX measures and Power BI visualizations.

View Project
Engagement

View Project
on GitHUB

View Project
on GitHub, Linkdin

Other Tools

Power BI

List of APAC markets where 'Atliq Exclusive' operates, shown in a table and map visualization

Highest and lowest manufacturing cost products with product code and costs detailed.

Project Details

Atliq Hardwares, a prominent computer hardware producer in India with a global presence, recognized a gap in generating actionable insights for data-driven decision-making. To address this, the management launched an SQL challenge aimed at evaluating candidates' technical and soft skills.

Key Insights from My Project:
🔹 SQL Mastery: Applied advanced concepts like WHERE, GROUP BY, COUNT DISTINCT, subqueries, CTEs, JOINS, UNION ALL, and ranking techniques (ROW_NUMBER, PARTITION BY) to analyze data effectively.
🔹 Power BI Proficiency: Leveraged DAX measures and designed interactive dashboards featuring line charts, bar graphs, and comprehensive data modeling to present insights visually.
🔹 Effective Communication: Presented findings and actionable recommendations through clear storytelling and impactful visualizations, showcasing a strong blend of technical and soft skills.

Project video

PowerBI Project

Performance Insights and Passenger Metrics Analysis for Goodcabs Operations in Tier-2 Cities

Domain/Function: Transporation & Mobility

Goodcabs, a cab service focused on tier-2 cities, supports local drivers while delivering excellent service. With operations in 10 cities, it aims to meet ambitious 2024 targets. To assess performance on key metrics like trip volume, satisfaction, and repeat rates, the Chief of Operations assigned

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

Dax

Excel

A snapshot of the Goodcabs performance report dashboard showcasing views for executive summary, city-wise performance, and trend analysis.

A snapshot of the executive dashboard showcasing key KPI metrics with detailed city-wise performance insights for enhanced decision-making.

Project Details

Goodcabs, a cab service company focused on tier-2 cities, has built a strong presence in the Indian market over two years by supporting local drivers and providing excellent passenger service. Operating in 10 tier-2 cities, the company has ambitious targets for 2024 to enhance growth and passenger satisfaction. Key performance metrics, including trip volume, passenger satisfaction, repeat passenger rate, trip distribution, and the balance between new and repeat passengers, are to be assessed as part of these efforts. The Chief of Operations, requiring immediate insights, assigned this critical analysis to his team to evaluate the company's performance effectively. The project will involve data cleaning, DAX modeling, and MySQL to generate actionable insights.

Project video

Live Interactive Dashboard

PowerBI Project

Air Pollution Intelligence & Market Opportunity

Domain/Function: Consumer Appliances

Exploring pollution severity, health impacts, key demand drivers, regulatory challenges, and emerging market opportunities related to air pollution in India’s urban and rural regions.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

Dax

Data Modelling

This the home page of the dashboard which helps to naviagates the page

This dashboard represents the pollution severity , AQI trends by dynamic filters of regional side of india

Project Details

Air pure innovations is a startup looking for its product launch in India before the product launch they want to know the proper research of the Indian States conditions , This analytical dashboard is contains pollution severity , risk mapping , health impact ,vehicl used , Ev adoption rate and overall market opportunity to understand the requirement and demand air purier