Skip to content
View prasanta-deb-data's full-sized avatar
  • Envea India Private Limited
  • India 🇮🇳

Block or report prasanta-deb-data

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.

Content in all repositories owned by your account will be closed.
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
prasanta-deb-data/README.md

Prasanta Kumar Deb

Data Analyst | Business Intelligence | SQL • Python • Power BI • Excel

I am a CSD Engineer with 4+ years of professional experience, specializing in data analysis, business intelligence, reporting, and data-driven decision-making.

I work across the complete analytics lifecycle — from data extraction and cleaning to analysis, visualization, KPI development, and business recommendations.

My core toolkit includes SQL, Python, Power BI, Excel, SQL-Server, and DAX.


👨‍💻 About Me

  • 📊 CSD Engineer with 4+ years of professional experience
  • 🧮 Strong focus on SQL, Python, Power BI, Excel & Business Intelligence
  • 📈 Experienced in developing analytical dashboards and KPI reporting
  • 🗄️ Working with relational databases and structured datasets
  • 🔍 Focused on identifying trends, performance gaps, and business opportunities
  • 💡 Interested in turning complex data into clear, actionable insights

🛠️ Technical Skills

Languages & Analysis

SQL Python Pandas NumPy

Business Intelligence

Power BI DAX Power Query

Database

PostgreSQL

Excel

Advanced Excel Pivot Tables XLOOKUP VLOOKUP INDEX-MATCH Power Query

Tools

Git GitHub Jupyter Notebook VS Code


📊 GitHub Projects

🏨 AtliQ Grands — Hospitality Analytics

Power BI | DAX | Data Modeling | Business Analytics

An interactive hospitality analytics solution designed to evaluate hotel performance and identify opportunities for improving revenue and operational performance.

Key Analysis

  • Revenue performance
  • Occupancy
  • ADR
  • RevPAR
  • Booking platform performance
  • Property-level performance
  • Room category performance
  • Cancellation analysis
  • Weekday vs weekend performance

🔗 View Project →


📈 Business Insights 360

Power BI | DAX | Power Query | Data Modeling

A comprehensive business intelligence dashboard providing multiple business perspectives through a unified analytical solution.

Business Views

  • Finance
  • Sales
  • Marketing
  • Supply Chain
  • Executive

Key Analysis

  • Revenue performance
  • Profitability
  • Sales performance
  • Product analysis
  • Customer analysis
  • Regional performance
  • Business KPIs

🔗 View Project →


🚀 Upcoming Projects

Projects currently being developed and planned for publication on GitHub.

🌫️ Silchar Tarapur CAAQMS — AQI Analytics Platform

Python | PostgreSQL | Power BI

An end-to-end environmental data analytics platform focused on analyzing Continuous Ambient Air Quality Monitoring Station data.

Planned Analysis

  • AQI analysis
  • Pollutant trends
  • Daily, monthly & yearly analysis
  • Seasonal patterns
  • Extreme pollution events
  • Meteorological relationships
  • Data quality monitoring
  • Interactive Power BI dashboard

Status: In Development


🍔 QuickBite Express — Business Recovery Analytics

Python | SQL | Power BI | Business Analytics

A business case study focused on analyzing a food-tech company's performance following a major operational and reputational crisis.

Planned Analysis

  • Revenue impact
  • Customer retention
  • Order trends
  • Restaurant performance
  • Customer behavior
  • Recovery strategy
  • Business recommendations

Status: In Development


📊 Additional Analytics Projects

More projects covering different business domains will be added to the portfolio as they are completed.

Planned areas include:

Sales Analytics Finance Analytics Operations Analytics Customer Analytics


🔍 My Analytics Approach

Business Problem
       ↓
Data Extraction
       ↓
Data Cleaning
       ↓
Data Validation
       ↓
Exploratory Analysis
       ↓
Data Modeling
       ↓
KPI Development
       ↓
Dashboard
       ↓
Business Insights
       ↓
Recommendations

I focus on answering three key questions:

What happened? → Why did it happen? → What should we do next?


📌 Core Competencies

Area Skills
Data Analysis Python, Pandas, SQL
Database PostgreSQL
BI & Visualization Power BI, DAX
Data Transformation Power Query, Pandas
Excel Analytics Advanced Excel
Data Modeling Star Schema, Relationships
Reporting KPI & Interactive Dashboards
Business Analysis Trends, Variance, Performance
Version Control Git & GitHub

📫 Connect With Me

LinkedIn: [Your LinkedIn Profile]

Email: [Your Professional Email]

Portfolio: [Your Portfolio Website]


⭐ Thanks for visiting my GitHub

I build practical, business-focused analytics projects that transform raw data into meaningful insights and better decisions.

Data → Analysis → Insights → Decisions

Pinned Loading

  1. atliq-grands-hospitality-analytics atliq-grands-hospitality-analytics Public

    Power BI hospitality analytics dashboard analyzing revenue, occupancy, ADR, RevPAR, bookings, cancellations and property performance.

  2. atliq-hotels-revenue-occupancy-analytics atliq-hotels-revenue-occupancy-analytics Public

    End-to-end hotel revenue, occupancy, booking channel and customer experience analysis using Python and Pandas.

    Jupyter Notebook