Monojit Biswas

About Me

Data Analyst | Power BI | SQL | Python Developer

I’m a data-driven professional with expertise in data analysis, business intelligence, and automation, dedicated to transforming raw data into meaningful, actionable insights. I specialize in developing interactive dashboards and automated reporting systems using Power BI, SQL, and Python to support data-informed decision-making.

Passionate about development, process optimization, and artificial intelligence, I’m constantly exploring innovative ways to make workflows smarter and more efficient. I believe in combining data, automation, and AI to uncover insights that drive real business impact.

View Portfolio Let's Connect

Technical Skills

Data Visualization

Power BI95%

Tableau85%

Excel (Advanced)90%

Programming

Python90%

SQL95%

R75%

Libraries & Tools

Pandas & NumPy90%

Matplotlib & Seaborn85%

DAX & M Query88%

Databases & Cloud

MySQL / PostgreSQL90%

Azure / AWS70%

Git & Version Control85%

Featured Projects

Sales Analytics Dashboard

Interactive Power BI dashboard analyzing $2M+ in sales data across 5 regions, providing real-time insights into revenue trends, customer segmentation, and performance KPIs.

Power BI DAX SQL

View Dashboard
Code

Customer Churn Prediction

Machine learning model using Python to predict customer churn with 87% accuracy, helping reduce churn rate by 15% through targeted retention strategies.

Python Scikit-learn Pandas

View on GitHub
Demo

Database Optimization Project

Optimized complex SQL queries and database structure, reducing query execution time by 60% and improving overall application performance for 10,000+ daily users.

SQL PostgreSQL Performance Tuning

View on GitHub
Case Study

Automated Reporting System

Developed Python automation to generate and distribute 50+ weekly reports, saving 20 hours per week and ensuring stakeholders receive timely insights.

Python Automation Excel

View on GitHub
Documentation

HR Analytics Dashboard

Comprehensive HR dashboard tracking employee performance, attendance, and engagement metrics across 500+ employees, enabling data-driven HR decisions.

Power BI HR Analytics DAX

View Dashboard
Code

Market Basket Analysis

Implemented association rule mining to analyze purchasing patterns, identifying key product relationships that increased cross-selling revenue by 22%.

Python SQL Data Mining

View on GitHub
Notebook

Professional Experience

Senior Data Analyst

November 2021 - Present

Shree Ji Steel Private Limited

Delivered enterprise-level analytics solutions by designing and launching 15+ dynamic Power BI dashboards powered by SQL and Python-based ETL pipelines.
Engineered automated data workflows handling 1M+ records, improving efficiency and minimizing manual intervention across multiple departments.
Enhanced database performance through SQL optimization, cutting processing time by nearly half and accelerating dashboard refresh speeds.
Built Python-driven automation tools to streamline recurring reporting tasks, freeing up 30+ analyst hours each week.
Collaborated with cross-functional teams to define key metrics and design actionable visualizations for executive decision-making.
Contributed to overall data strategy by standardizing reporting frameworks and mentoring junior analysts in BI best practices.

Data Analyst

September 2019 - August 2021

SDP & Associates

Developed Excel-based reporting templates for monthly business reviews
Created interactive dashboards analyzing customer behavior and sales trends
Collaborated with cross-functional teams to define KPIs and success metrics
Assisted in database management and SQL query optimization
Presented data-driven insights to C-level executives influencing strategic decisions

Data Analyst Portfolio