Learning • Building • Analyzing

Santanu Jana

Data Analyst
SQL Python Power BI Excel
→ |
Explore Projects Download Resume Contact Me

Revenue Growth

0

%

SQL Expertise

Advanced Queries

Dashboard Insights

Power BI Master

Data Accuracy

0

%

Explore My Work

About Me

Santanu Jana
10+ Projects
Python, SQL, Power BI & Excel

Professional Summary

Aspiring Data Analyst with hands-on experience in SQL, Python, Excel, Power BI, and exploratory data analysis. Passionate about transforming raw datasets into actionable insights through dashboards, business intelligence, and data storytelling.

Career Objective

Seeking an entry-level Data Analyst position where I can leverage my analytical skills, technical expertise, and passion for data-driven decision making to contribute to organizational success while continuing to grow professionally.

Learning Journey

Currently expanding my expertise in advanced analytics, machine learning fundamentals, and cloud-based data solutions. Committed to continuous learning through hands-on projects, online courses, and staying updated with industry trends.

Data Analysis Roadmap

  • Master SQL & Database Management
  • Python for Data Analysis & Visualization
  • Business Intelligence with Power BI
  • Advanced Statistics & A/B Testing
  • Machine Learning Fundamentals

Technical Skills

Programming

Python SQL PostgreSQL SQLite DAX Queries

Data Visualization

Power BI Excel Dashboards Matplotlib Seaborn Tableau Google Sheets Dashboards

Analysis

EDA Data Cleaning Business Metrics Statistical Analysis ETL Pipelines KPIs Trend Analysis

Tools & Libraries

VS Code GitHub DBeaver Google Colab Pandas NumPy DB Visualizer Excel Beautiful Soup Google Sheets

Featured Projects

Amazon Prime EDA

IPL Data Analysis using Power BI

Developed an interactive dashboard to analyze IPL match data and player performance metrics.

Power BI Data Modeling Dax Data Visualization Power BI Dashboard
GitHub Live Demo
Amazon prime eda project

Amazon Prime Movies & TV Shows EDA using Python

Conducted exploratory data analysis on Amazon Prime's movie and TV show content to identify viewing patterns and user preferences.

Python Pandas Matplotlib NumPy Data Analysis
GitHub Live Demo
Revenue Trend Analysis

Hospital Emergency Room System using Excel

Designed and implemented a comprehensive system for managing emergency room operations and patient data.

Excel Power Query Power Pivot Excel Dashboard
GitHub Live Demo
Bookstore Sales Analysis

Bookstore Sales Analysis using SQL

Conducted comprehensive analysis of bookstore sales data to identify trends, customer preferences, and revenue drivers.

SQL PostgreSQL Data Analysis Data Modeling
GitHub Live Demo
Amazon Prime EDA

Amazon Prime Movies & TV Shows EDA

Conducted exploratory data analysis on Amazon Prime's movie and TV show content to identify viewing patterns and user preferences.

Python Pandas Matplotlib NumPy Data Analysis
GitHub Live Demo
Coffee Shop SQL Analysis

Bookstore Sales Analysis using SQL

conducted comprehensive sales analysis using SQL queries to identify trends and customer behavior.

SQL PostgreSQL Data Analysis Data Modeling
GitHub Live Demo
Revenue Trend Analysis

Customer Revenue Trend Analysis

Performed monthly revenue growth analysis using SQL window functions.

SQL Analytics
GitHub Live Demo
Power BI Dashboard

IPL Data Analysis using Power BI

Conducted in-depth analysis of IPL dataset using Power BI to uncover insights about player performance, team strategies, and match outcomes.

Power BI Data Modeling Dax Data Visualization Power BI Dashboard
GitHub Live Demo
Excel Dashboard

Hospital ER System

Developed a comprehensive hospital emergency room management system using Excel for data tracking and reporting.

Excel Power Query Power Pivot Excel Dashboard
GitHub Live Demo

Learning Journey & Experience

Certifications & Learning Journey

Continuous upskilling in data analytics, business intelligence, and data-driven problem solving.

Data Analyst Career Roadmap Progress

SQL Mastery
Python Analytics
Visualization
Business Intelligence
Advanced Analytics
Completed

SQL & Database Analytics

Mastered relational database querying, joins, aggregations, window functions, CASE statements, date functions, and business-focused SQL analysis using PostgreSQL and SQLite.

SQL PostgreSQL Joins Window Functions CTEs Business Analytics
Ongoing

Python for Data Analysis

Building strong analytical programming skills through Python, data cleaning, exploratory data analysis, automation, and dataset manipulation.

Python Pandas NumPy EDA Data Cleaning
Ongoing

Power BI Dashboard Development

Creating interactive business dashboards, KPI reporting systems, and insightful visual storytelling solutions for data-driven decision making.

Power BI DAX Dashboards KPI Visualization
Active Learning

Business Analytics & Data Storytelling

Developing business intelligence thinking by interpreting metrics, identifying trends, and converting data into actionable insights.

Business Metrics Revenue Analysis Trend Analysis Storytelling

Committed to continuous learning and practical project-based growth in modern data analytics.

Professional Experience

Computer Application Teacher

Educational Institution

Present

Teaching programming fundamentals and computational thinking to students.

  • Teaching C/C++ programming fundamentals to 100+ students
  • Developing curriculum and hands-on coding exercises
  • Mentoring students in problem-solving and logical thinking
  • Integrating data analysis concepts into computer science education

Get In Touch

Email

santannu947@gmail.com

LinkedIn

linkedin.com/in/santanujana

GitHub

github.com/Santanu-72

Resume

Download Resume

Send Me a Message