Final-year BCA student turning data into insights
Portrait of Amit Kumar Mishra

Hi, I'm Amit, a data analytics enthusiast who loves SQL, dashboards & real-world business problems.

I'm a final-year BCA student with a strong hands on experience in data analytics, skilled in SQL, Python, Excel, Power BI, Snowflake, and Microsoft Fabric. I enjoy cleaning messy data, building dashboards, and extracting insights that actually help teams make better decisions.

SQL β€’ Python β€’ Excel
Power BI β€’ Looker Studio β€’ Fabric
Snowflake β€’ Databricks β€’ PostgreSQL
Download Resume (PDF)
Projects
5+analytics builds
Tools
10+in stack
Experience
2industry role

From BCA classrooms to real-world analytics projects.

Currently:
β€’ Final-year BCA student focused on data analytics
β€’ Building portfolio projects in SQL, Power BI, and Python
β€’ Learning modern platforms like Snowflake, Microsoft Fabric and Databricks to work with cloud data and lakehouse architectures.
Bachelor of Computer Applications
Harish Chandra P.G. College, Varanasi
2023 – 2026 β€’ Coursework in DBMS, CS fundamentals, operations and programming (C, C++, Java, SQL, HTML)
Data Intern
Thomas Cook India Limited
Aug 2025 – Oct 2025 β€’ Used Excel, SQL &Power BI to analyse sales data and support strategies that boosted 30% sales performance.
Data Analyst Associate Intern
Excelerate
Feb 2026 – Mar 2026 β€’ Selected for a competitive early remote internship. Designed business-ready dashboards and applied analytical storytelling techniques to transform raw datasets into clear, decision-focused insights.

My analytics toolkit

Tools and concepts I use to go from raw data to insights.

Programming & Querying
Core
SQL Python NumPy Pandas Matplotlib Seaborn PySpark
Data Visualisation
Core
Power BI Tableau Looker Studio Excel dashboards
Databases
Core
MySQL PostgreSQL MS SQL Server
Cloud & Modern Data
Growing
Snowflake Microsoft Fabric Databricks AWS
Analytics Workflow
Core
Data cleaning EDA Dashboarding Business insights
Tools & Productivity
Core
Excel Google Sheets Jupyter / Colab MS Office
Version Control
Core
Git GitHub

Dashboard & end-to-end projects

Real datasets, practical questions, and decision-focused dashboards.

Healthcare Patient Analytics Dashboard

Power BI β€’ Healthcare Analytics

Designed a multi-page Power BI healthcare analytics dashboard to analyze patient diagnostics, clinical symptoms, blood test insights, and demographic trends. The dashboard enables healthcare professionals to identify high-risk patients, monitor symptom patterns, and evaluate diagnostic indicators for better clinical decision-making.

Power BI DAX Data Modeling Healthcare Analytics Data Visualization
Healthcare Patient Analytics Power BI Dashboard

Telecom Customer Churn – Revenue & Risk Dashboard

Power BI β€’ Customer Analytics

Built an interactive Power BI dashboard to analyze telecom customer churn, revenue loss, and contract risk. The dashboard identifies high-risk customer segments, contract performance, and revenue impact to support retention strategies and reduce churn-driven revenue leakage.

Power BI DAX Data Modeling Customer Analytics Churn Analysis
Telecom Customer Churn Power BI Dashboard

Pharmacy Sales & Profitability Analysis

Power BI β€’ Snowflake

Designed a multi-page Power BI dashboard to analyze sales performance and profitability across a pharmacy network. The analysis focuses on geographic performance, pharmacy-level benchmarking, product mix, and promotion impact to answer real business questions and support strategic decision-making.

Power BI Snowflake DAX Data Modeling Business Analytics Data Storytelling
Pharmacy Sales and Profitability Power BI Dashboard

Department Operations – End-to-End Analytics

Fabric β€’ Power BI

Built a complete analytics solution using Microsoft Fabricβ€”starting from raw Excel files to a fully automated Power BI report. The project includes a Lakehouse, Dataflows, Data Pipelines, Warehouse SQL transformations, and a semantic model powering insights on project budgets, capital allocation, and department-wise financial performance.

Microsoft Fabric Power BI Dataflow Gen2 SQL Warehouse DAX
Department Operations Power BI Dashboard

Annual Mobile Sales Report

End-to-End β€’ BI

Built an interactive Power BI dashboard to track mobile sales performance across brands, models, and cities. Analysed sales volume, transactions, customer ratings, and payment methods to highlight what drives revenue.

Power BI Excel Data modelling
Screenshot of Annual Mobile Sales Report dashboard

Weather Forecasting Dashboard

End-to-End β€’ API

Created a Power BI report powered by a live Weather API, showing a 7-day forecast with temperature trends, humidity, AQI, wind speed and rain probability. The data refreshes automatically through API integration to keep the dashboard up to date.

Power BI REST API JSON
Screenshot of Weather Forecasting Power BI dashboard

Blinkit Retail Sales & Outlet Performance Analysis

End-to-End β€’ BI

Built an end-to-end Power BI analytics solution to analyze Blinkit grocery sales and outlet performance. The dashboard uncovers how product categories, outlet characteristics, visibility, and ratings influence overall sales outcomes and operational efficiency.

Power BI Power Query Retail Analytics Sales Performance
Blinkit Retail Sales Power BI Dashboard

Sales Analysis Dashboard

BI β€’ Sales

Developed a Power BI dashboard to analyse overall sales performance: revenue by category and region, discount vs revenue, profit analysis, and key KPIs. The dashboard helps stakeholders quickly identify high-performing segments and areas needing attention.

Power BI Excel / CSV Sales analytics
Screenshot of Sales Analysis Power BI dashboard

Applicant Analytics Dashboard (Internship Project)

Looker Studio β€’ PostgreSQL

Built an interactive Looker Studio dashboard connected to a live PostgreSQL (Supabase) database to analyze applicant trends, program demand, geographic distribution, and recruitment channel performance. Delivered a real-time, filterable analytics solution to support admissions and recruitment decision-making.

Looker Studio PostgreSQL Supabase Data Modeling Dashboard Design Cloud Data Pipeline
Applicant Analytics Dashboard - Internship Project

Database & SQL-focused work

Clean schemas, analytical queries, and business-focused SQL analysis.

CRM Sales Opportunities Insights Using SQL

SQL & Analytics

Designed a relational database structure for CRM sales data and wrote SQL queries to analyse performance by agent, product, and region. Explored win/loss patterns, sales trends, and basic revenue forecasting to surface opportunities for improvement.

SQL Joins & CTEs Analytical queries

Brazilian E-commerce (Olist) Data Analysis

SQL β€’ Advanced Analytics

Performed advanced SQL analysis on the Brazilian Olist e-commerce dataset to uncover business insights related to sales performance, customer behavior, delivery efficiency, and product demand. The project includes cohort analysis, RFM customer segmentation, revenue trends, retention analysis, and seller performance evaluation to support data-driven decision-making for e-commerce businesses.

SQL CTEs Window Functions RFM Segmentation Cohort Analysis Business Analytics

Zepto Sales Insights using SQL

SQL & Analytics

Analysed Zepto sales data using SQL to understand customer orders, product performance, and city-wise demand. Designed queries to track total revenue, average order value, repeat customers, and top-performing product categories to support data-driven decision-making for business growth.

SQL Joins & CTEs Window functions Sales analytics

SQL Data Analysis Project

SQL & Business Insights

Performed data cleaning, aggregation, and business-driven analytics using SQL. Extracted KPIs such as total revenue, customer retention, product popularity, and time-based trends. Delivered actionable insights for stakeholders based on raw transactional data.

SQL CASE statements Window functions Data cleaning

Python-driven data & business analysis

Exploratory analysis, automation, and insight-driven problem solving using Python.

Toy Store E-Commerce Performance Analysis

Python & Business Insights

Performed exploratory and business-driven analysis on a toy store e-commerce dataset using Python. Evaluated funnel conversion, revenue leakage from refunds, customer behavior, and product performance to uncover actionable growth opportunities.

Python Pandas EDA Funnel Analysis Cohort Analysis RFM Segmentation

Telecom Customer Churn Analysis

Python β€’ EDA β€’ Business Insights

Performed exploratory data analysis on telecom customer data to identify key factors driving customer churn. Analyzed customer demographics, subscription patterns, contract types, and service usage to uncover churn trends and actionable retention insights.

Python Pandas NumPy Matplotlib Seaborn EDA

Sales Analysis using Python

Python & EDA

Performed exploratory data analysis on multi-month sales data using Python. Cleaned and transformed raw transactional data, analyzed sales trends by month, city, product, and time of purchase, and identified patterns to support business and marketing decisions.

Python Pandas NumPy EDA Matplotlib Data Cleaning

Diwali Sales Analysis

Python & EDA

Conducted exploratory data analysis on Diwali sales data to understand customer demographics, purchasing behavior, and product category performance. The analysis highlights key trends to support targeted marketing and festive-season sales optimization.

Python Pandas NumPy EDA Matplotlib Seaborn

Certifications & virtual programs

Structured learning that supports my self-driven practice.

Internship

Data Visualization Associate Internship – Star Performer

Saint Louis University β€’ Excelerate β€’ Mar 2026

Recognized as a Star Performer during the Data Visualization Associate Early Remote Internship for outstanding performance in building analytical dashboards, interpreting data insights, and delivering impactful visualizations.

Data Visualization Associate Internship Star Performer Certificate
Microsoft

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)

Microsoft β€’ Dec 2025

Earned the DP-600 certification validating hands-on expertise in Microsoft Fabric, including Lakehouse architecture, Dataflows Gen2, Warehouses, Semantic Models, DAX, SQL analytics, and end-to-end Power BI reporting with automated data pipelines.

Microsoft DP-600 Fabric Analytics Engineer Associate Certificate
Databricks

Databricks Accredited Databricks Fundamentals

Databricks Academy β€’ Jan 2026

Successfully completed the Databricks Fundamentals accreditation, covering core concepts of the Databricks Lakehouse Platform, data engineering basics, notebooks, Delta Lake, and collaborative analytics workflows.

Databricks Accredited Databricks Fundamentals Certificate
AWS

Fundamentals of Analytics on AWS – Part 1

AWS Training & Certification β€’ Feb 2026

Completed AWS training focused on analytics fundamentals including data storage, processing, and cloud-based analytics workflows using the AWS ecosystem.

AWS Fundamentals of Analytics Certificate
AWS

Fundamentals of Analytics on AWS – Part 2

AWS Training & Certification β€’ Mar 2026

Completed advanced AWS analytics training covering cloud-based data processing, analytics workflows, and scalable data solutions using AWS analytics services.

AWS Fundamentals of Analytics Part 2 Certificate
AWS

Integrating Amazon S3 Tables with Amazon SageMaker Lakehouse

AWS Training & Certification β€’ Mar 2026

Completed AWS training on integrating Amazon S3 tables with SageMaker Lakehouse to enable scalable analytics workflows and cloud-based data processing using AWS data services.

AWS SageMaker Lakehouse Certificate
AI

Claude 101

Anthropic β€’ 2026

Completed Claude 101 training focused on working with Anthropic's Claude AI models, prompt engineering concepts, and practical applications of generative AI for problem-solving and productivity.

Claude 101 Certificate - Anthropic
AI

AI Fluency: Framework & Foundations

Anthropic β€’ 2026

Completed the AI Fluency program focused on core artificial intelligence concepts, responsible AI practices, and practical applications of modern generative AI systems for real-world problem solving.

AI Fluency Framework and Foundations Certificate
Snowflake

Snowflake Hands-On Essentials

Snowflake β€’ Badge 1

Essentials workshop focused on getting started with Snowflake, data loading, querying, and core concepts for cloud data warehousing.

Snowflake Hands-On Essentials certificate
Snowflake

Collaboration, Marketplace & Cost Estimation

Snowflake β€’ Badge 2

Workshop covering collaboration, data marketplace, performance considerations, and cost estimation for real Snowflake workloads.

Snowflake Collaboration and Cost Estimation certificate
SQL Advanced

HackerRank SQL (Advanced) Certificate

HackerRank β€’ Feb 2026

Successfully cleared the HackerRank SQL (Advanced) certification exam, demonstrating strong proficiency in complex joins, window functions, advanced querying techniques, performance optimization, and real-world problem-solving using SQL.

HackerRank SQL Advanced Certificate
Industry

Deloitte Data Analytics Job Simulation

Virtual Experience β€’ Aug 2025

Practised solving client-style analytics tasks, focusing on storytelling with data and stakeholder-ready outputs.

Deloitte Data Analytics Job Simulation certificate
Visualization

Tata Data Visualization Program

Forage β€’ Aug 2025

Learned how to turn business problems into clear visual narratives using charts and dashboards.

Tata Data Visualization certificate
SQL

SQL for Data Analysis

Simplilearn

Focused on analytical SQL for real business use cases including joins, filtering, aggregation, window functions, and subqueries.

SQL for Data Analysis certificate
Foundations

Career Essentials in Data Analysis

Microsoft & LinkedIn Learning

Overview of the data analyst role, core tools, and the mindset required to work with data in business environments.

Career Essentials in Data Analysis certificate
Foundations

Career Essentials in Data Analysis

Microsoft & LinkedIn Learning

Completed the full professional learning path covering data analysis fundamentals, visualization, analytics workflows, and practical business-focused data skills with real-world scenarios.

Career Essentials in Data Analysis Certificate
Analytics

HP LIFE – Data Science & Analytics

HP Foundation β€’ Aug 2025

Covered fundamentals of data science and analytics, focusing on real-world business applications.

HP LIFE Data Science & Analytics certificate
Power BI

Power BI Certification

SkillCourse

Demonstrates practical skills in building interactive dashboards, data modelling, DAX, and sharing reports for stakeholders.

Power BI certificate
SQL

30-Days SQL Micro Course

SkillCourse β€’ Instructor: Satish Dhawale

Completed a structured 30-day SQL program covering querying fundamentals, joins, filtering, aggregations, subqueries, and hands-on exercises designed for real-world analytics work.

30-Days SQL Micro Course Certificate
Automation

Excel Automation using ChatGPT

Simplilearn & Microsoft

Focused on automating Excel workflows and reports using AI, prompts, and integrations to speed up data analysis tasks.

Excel Automation using ChatGPT certificate
Excel

Business Analytics with Excel

Microsoft & Simplilearn

Covered analytical principles using Microsoft Excel including data cleaning, pivot tables, KPI tracking, and scenario analysis.

Business Analytics with Excel certificate
AI β€’ Databricks

Databricks 14 Days AI Challenge

Databricks β€’ Indian Data Club β€’ Codebasics β€’ 2026

Successfully completed the 14 Days AI Challenge, gaining hands-on exposure to AI concepts, modern data workflows, and Databricks ecosystem tools through guided learning and practical exercises.

Databricks 14 Days AI Challenge Certificate
SQL

IDC β€” 21 Days SQL Challenge

IDC | 2025

Completed a structured 21-day SQL challenge focused on hands-on practice with joins, CTEs, window functions and analytical queries.

IDC 21 Days SQL Challenge certificate

Let’s talk about data

Open to internships, full-time roles, and collaboration ideas.

Phone
+91 9839979503
Location
Ballia, Uttar Pradesh, India (IST)