Open to Work

Krishan Choudhary
turns raw data into decisions.

I'm a BCA student & aspiring Data Analyst who builds dashboards in Power BI, queries databases in SQL, and finds the story hiding inside spreadsheets.

Download Resume View Projects
01 / About

Detail-oriented, dashboard-obsessed.

I'm a detail-oriented, analytically driven fresher Data Analyst with hands-on project experience in Power BI, SQL, and Python.

I'm skilled at transforming raw, messy data into clear dashboards and actionable insights — through data cleaning, exploratory analysis, and visualization. I have a strong foundation in statistics and database querying, with a keen eye for spotting trends that actually support a decision.

02 / Projects

Dashboards & queries that answer real questions.

Zomato Restaurant Analytics Dashboard built in Power BI showing restaurant counts, ratings, and delivery metrics
Power BI

Zomato Restaurant Analytics Dashboard

A 4-page interactive dashboard analyzing 9,536 restaurants across 140 cities and 1M+ votes. Surfaced that only 25.69% of restaurants offer online delivery, found a major rating-quality gap (3% "Excellent" vs. 39% "Average"), and delivered 5 data-driven recommendations for executive decision-making.

Power BIDAXData Cleaning
View on GitHub
Superstore Sales Dashboard built in Power BI showing sales by region, category, and time
Power BI · Pandas · NumPy

Superstore Sales Dashboard

Analyzed 2 years of retail data — ₹1.6M in sales, 22K units, ₹175K profit — using Pandas and NumPy. Built an interactive dashboard with region/category/time filters, plus a 15-day sales forecast model to support demand planning across 4 regions and 3 categories.

Power BIPandasNumPyForecasting
View on GitHub
1-- Top 10 rock artists by track count
2SELECT ar.name, COUNT(t.track_id)
3FROM artists ar
4JOIN albums al ON ...
5JOIN tracks t ON ...
6GROUP BY ar.name
7ORDER BY COUNT(t.track_id) DESC
8LIMIT 10;
9-- → Led Zeppelin, 114 tracks
SQL · PostgreSQL · pgAdmin

Digital Music Store Database Analysis

Queried an 11-table relational database using joins, subqueries, and aggregations to answer real business questions. Used a nested subquery across 4 tables to extract 59 Rock listeners, ranked top artists (Led Zeppelin, 114 tracks), and applied window functions for revenue and customer analysis.

SQLJoinsSubqueriesAggregations
View on GitHub
03 / Skills

The toolkit behind the dashboards.

Visualization & BI

  • Power BI DAX · DASHBOARDS
  • Excel PIVOT · VLOOKUP
  • Power Query ETL
  • Charting & KPIs REPORTING

Programming

  • Python SCRIPTING
  • Pandas DATA WRANGLING
  • NumPy ANALYSIS
  • Jupyter Notebook EDA

Database & SQL

  • SQL MYSQL · PSQL
  • Joins & Subqueries QUERYING
  • Window Functions ANALYTICS
  • Aggregations REPORTING

Analytical Concepts

  • Data Cleaning CORE
  • EDA CORE
  • Statistical Analysis CORE
  • Data Wrangling CORE

Tools

  • Git / GitHub VERSIONING
  • Kaggle DATASETS
  • pgAdmin DB ADMIN
  • MS Excel REPORTING

Soft Skills

  • Analytical Thinking CORE
  • Problem Solving CORE
  • Attention to Detail CORE
  • Communication CORE

Let's turn your
data into decisions.

Looking for a Data Analyst Intern who's already shipped dashboards, not just studied them? Let's talk.

Email Me Download Resume
Emailkrishanchoudhary8742@gmail.com Phone+91 87428 42872 GitHubgithub.com/krishan_choudhary01 LinkedInlinkedin.com/in/krishan-choudhary