Powered by
Codebasics Bootcamp

Jaideep Gupta

Tableau Developer

[email protected] +91 7786923528

Resume

Hello, I am

Jaideep Gupta.

1

PowerBI
Project

1

Excel
Project

1

Python
Project

1

Data Engineering
Project

About Me

I am Jaideep Gupta, currently working as a Tableau Developer with 4 years of experience across Tableau development, data analytics, and product analytics. My background includes building interactive dashboards, analyzing user behavior, tracking business KPIs, and delivering data-driven insights using SQL, Tableau, Power BI, and Excel. I have worked across domains such as Healthcare, Real Estate, CRM analytics, and product analytics, with experience in funnel analysis, cohort analysis, reporting automation, and business performance tracking. Along with industry experience, I have also mentored students and professionals in Economics, Statistics, and analytics tools, combining analytical thinking with strong problem-solving and communication skills.

Key Skills

Tableau

Power BI

Excel

SQL

MySql

Mixpanel

Office Suite

Mongo DB

My Projects

BI 360 – Customer, Market, and Finance Performance Dashboard

BI 360 – Customer, Market, and Finance Performance Dashboard

Domain/Function: Business Intelligence / Sales & Finance Analytics

PowerBI Project

Excel-Based Sales & Finance Analytics

Excel-Based Sales & Finance Analytics

Domain/Function: Sales & Financial Analytics (Business Intelligence using Excel)

Tableau Pharmacy Dashboard

Tableau Pharmacy Dashboard

Domain/Function: Pharmacy

AtliQ Hotels – Hospitality EDA

AtliQ Hotels – Hospitality EDA

Domain/Function: Hospitality Domain

AtliQ Commerce — End-to-End Data Engineering Platform

AtliQ Commerce — End-to-End Data Engineering Platform

Domain/Function: E-commerce

Data Engineering Project

My Experience

Kloudrac Group – Tableau Developer

Aug 2025 – Present

Developed and maintained 20+ Tableau dashboards across Healthcare and Real Estate domains, used by 35+ business users for daily operational and business decision-making.

Built a hospital CRM analytics suite covering lead conversion, patient funnel, booking revenue, and inventory, helping identify a 7% drop-off in patient conversion and bottleneck stages.

Wrote 50+ SQL queries for data extraction, validation, and transformation, reducing manual data-preparation effort by 18%.

Delivered Tableau Next and Salesforce Data Cloud demos, including agentic analytics and AI-driven insights, contributing to 4 client pitches.

Optimized Tableau dashboards using calculated fields, parameters, and dynamic filters, reducing average report generation time from 8 minutes to 3 minutes.

Freelance Data Analyst

Sep 2024 – Aug 2025

Delivered 9 end-to-end analytics projects involving data cleaning, transformation, dashboard development, and reporting using Tableau and Power BI across 4 industries.

Built KPI dashboards covering revenue, retention, lead conversion, and operational performance, improving reporting efficiency by 18%.

Trained 20+ professionals and students in SQL, Tableau, Power BI, and practical analytics workflows.

Brane Enterprises – Associate Solution Leader

Jan 2024 – Sep 2024

Led BI and reporting projects for 2 enterprise clients, managing the complete lifecycle from requirements gathering through stakeholder sign-off.

Reduced reporting turnaround time by 25% through reusable SQL templates and workflow automation.

Standardized KPI definitions with cross-functional teams, establishing a shared analytics framework used across 3 departments.

TutorBin – Product Analyst → Subject Matter Expert

Jun 2022 – Dec 2023

Product Analyst | Sep 2023 – Dec 2023

Analyzed user behavior using Mixpanel, identifying a 22% onboarding drop-off and supporting UX changes that increased feature adoption by 15%.

Built dashboards tracking 12K+ DAU, 30-day retention, conversion, and feature adoption for product and leadership teams.

Conducted funnel and cohort analysis to identify user drop-offs and inform product decisions, contributing to a 17% increase in engagement over 3 months.

Subject Matter Expert | Jun 2022 – Sep 2023

Mentored 100+ students and professionals in Statistics, SQL, Power BI, and Tableau, achieving a 92% satisfaction rating.

Created 35+ analytics case studies and educational resources for the platform's learning curriculum.

Managed a team of 6 interns, improving team output by 30% through structured mentoring and weekly reviews.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Microsoft Fabric Mini: For Data Analysts

Tableau Mini

Data Engineering Basics for Data Analysts

Project: Securities Pricing Data Pipeline using Docker, Airflow, Snowflake and AWS

Soft Skills Bootcamp: Communication, Productivity & Personal Branding

Python: Beginner to Advanced For Data Professionals

Certified Data Engineer

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]

LinkedIn

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

Call Me

+91 7786923528

GitHub

https://github.com/Jaideepgupta

PowerBI Project

BI 360 – Customer, Market, and Finance Performance Dashboard

Domain/Function: Business Intelligence / Sales & Finance Analytics

Developed an Excel-based BI solution featuring customer performance, market comparison, and financial reports (P&L by fiscal year, months, markets). Used Power Query for ETL, Power Pivot for modeling, and DAX for calculated measures, ensuring user-focused, actionable insights.

View Project
Engagement

View Project
on GitHUB

BI 360 – Customer, Market, and Finance Performance Dashboard

Excel Power Pivot data model linking multiple fact and dimension tables for BI analysis.

BI 360 – Customer, Market, and Finance Performance Dashboard

Dashboard home screen with navigation to Finance, Sales, Marketing, Supply Chain, and Executive views.

Project Details

Created an interactive Excel-based BI solution for comprehensive business performance monitoring. The dashboard includes five views:

Finance View: P&L statements by customer, product, country, and time period.

Sales & Marketing Views: Performance analysis by key metrics like Net Sales and Gross Margin.

Supply Chain View: Forecast accuracy, net error, and risk profiling by product/segment.

Executive View: Consolidated top business KPIs for decision-makers.
Applied ETL processes in Power Query for data cleaning/transformation, built a robust data model in Power Pivot, and used DAX to create calculated measures. Optimized design for quick filtering, interactivity, and executive-friendly navigation.

Live Interactive Dashboard

Excel Project

Excel-Based Sales & Finance Analytics

Domain/Function: Sales & Financial Analytics (Business Intelligence using Excel)

Developed an Excel-based Sales and Finance Analytics dashboard to evaluate market performance, customer profitability, and P&L by fiscal periods. Utilized Power Query, Power Pivot, and DAX for ETL, data modeling, and calculations to support data-driven business decisions.

View Project
Engagement

View Project
on GitHUB

Excel-Based Sales & Finance Analytics

A country-wise sales performance dashboard comparing actual sales (2019–2021) against sales targets for 2021. It highlights performance gaps (%) using

Excel-Based Sales & Finance Analytics

An annual P&L summary displaying Net Sales, COGS, Gross Margin, and Gross Margin % for each country from 2019 to 2021, with a YoY growth comparison (2

Project Details

Developed an Excel-based Sales and Finance Analytics Project to provide data-driven business insights. The Sales Report analyzed customer performance and compared market sales against targets, helping identify key trends and growth opportunities. The Finance Report featured Profit & Loss (P&L) analysis by fiscal year, month, and market to evaluate financial performance and support strategic decisions. Utilized Power Query for ETL, Power Pivot for data modeling, and DAX for calculated measures. Focused on creating interactive, well-formatted, and user-centric dashboards that streamline analysis and enhance decision-making efficiency.

Tableau Pharmacy Dashboard

Domain/Function: Pharmacy

Pharma Sales Performance dashboard tracking salesperson efficiency, doctor call activity, target achievement, and field coverage using Tableau — built for data-driven sales management.

View Project
on GitHUB

View Project
on

Tableau Pharmacy Dashboard

High-level executive view with Sales by City map, total sales of ₹46.88L (+2.27% vs PY), total doctor calls, monthly trends, sales by region (West/North/East), and sales by doctor class (A/B/C)

Tableau Pharmacy Dashboard

High-level executive view with Sales by City map, total sales of ₹46.88L (+2.27% vs PY), total doctor calls, monthly trends, sales by region (West/North/East), and sales by doctor class (A/B/C)

Project Details

A comprehensive Tableau dashboard analyzing pharma field sales performance across 5 salespersons, 4 cities, and 4 doctor specialties.
The dashboard covers effort vs output efficiency, monthly sales trends by city, salesperson target achievement, leave impact on field coverage, gift distribution by specialty and region, doctor call activity patterns, sales vs call effort contribution, doctor class coverage, call duration vs outcome quality, and reminder call discipline.
Built to help sales managers move from gut-feel decisions to data-backed interventions — identifying who is performing, where effort is misaligned with output, and which regions and specialties need strategic focus.

Python Project

AtliQ Hotels – Hospitality EDA

Domain/Function: Hospitality Domain

Exploratory Data Analysis of hotel bookings, occupancy, revenue, customer ratings, and property performance using Python, Pandas, NumPy, Matplotlib, and Seaborn.

View Project
on GitHUB

AtliQ Hotels – Hospitality EDA

Revenue performance across cities and months, highlighting differences in realized revenue by location and monthly revenue trends.

AtliQ Hotels – Hospitality EDA

Comparison of weekday and weekend hotel occupancy across cities to identify differences in demand patterns.

Project Details

This project presents an Exploratory Data Analysis (EDA) of AtliQ Grands hospitality data using Python. The analysis covers booking behavior, occupancy, revenue performance, property and room-class performance, booking channels, weekday vs. weekend demand, customer ratings, and cancellation patterns. Data cleaning, feature engineering, visualization, and business-oriented insight generation were performed using Pandas, NumPy, Matplotlib, Seaborn, and Jupyter Notebook. The underlying course-provided datasets are not included in the public portfolio.

Data Engineering Project

AtliQ Commerce — End-to-End Data Engineering Platform

Domain/Function: E-commerce

Built an end-to-end e-commerce data platform covering batch and real-time data engineering, from Azure SQL and Kafka ingestion through ADLS, Databricks, dbt, Airflow and Microsoft Fabric for analytics and reporting.

View Project
on GitHUB

AtliQ Commerce — End-to-End Data Engineering Platform

dbt lineage showing the transformation flow from Silver data through staging and intermediate models into dimensional and fact tables for the Gold layer.

AtliQ Commerce — End-to-End Data Engineering Platform

Real-time data engineering architecture using Python event producers, Confluent Kafka, Databricks Structured Streaming, Bronze-Silver-Gold processing, and Apache Airflow orchestration.

Project Details

Built an end-to-end data engineering platform for AtliQ Commerce covering both batch and real-time data pipelines.

Phase 1 implements a production-style batch architecture using Azure SQL as the source, Azure Data Factory for metadata-driven ingestion, ADLS Gen2 for storage, Databricks for Bronze/Silver processing, and dbt for Gold-layer dimensional modeling. Supplier price and marketing spend data were also integrated into the analytical layer. Microsoft Fabric and Power BI were used for reporting and business analytics.

Phase 2 adds an independent real-time speed lane using a Kafka producer, Confluent Cloud, and Databricks Structured Streaming. The streaming pipeline processes events through Bronze, Silver and Gold layers using explicit schemas, watermarking, deduplication and separate checkpoints. Apache Airflow orchestrates hourly data-quality checks, table optimization and daily summary refreshes.

GitHub and GitHub Actions were used for version control and CI/CD.

Already have an account? Sign in

or