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.
From BCA classrooms to real-world analytics projects.
β’ 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.
My analytics toolkit
Tools and concepts I use to go from raw data to insights.
Dashboard & end-to-end projects
Real datasets, practical questions, and decision-focused dashboards.
Healthcare Patient Analytics Dashboard
Power BI β’ Healthcare AnalyticsDesigned 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.
Telecom Customer Churn β Revenue & Risk Dashboard
Power BI β’ Customer AnalyticsBuilt 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.
Pharmacy Sales & Profitability Analysis
Power BI β’ SnowflakeDesigned 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.
Department Operations β End-to-End Analytics
Fabric β’ Power BIBuilt 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.
Annual Mobile Sales Report
End-to-End β’ BIBuilt 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.
Weather Forecasting Dashboard
End-to-End β’ APICreated 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.
Blinkit Retail Sales & Outlet Performance Analysis
End-to-End β’ BIBuilt 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.
Sales Analysis Dashboard
BI β’ SalesDeveloped 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.
Applicant Analytics Dashboard (Internship Project)
Looker Studio β’ PostgreSQLBuilt 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.
Database & SQL-focused work
Clean schemas, analytical queries, and business-focused SQL analysis.
CRM Sales Opportunities Insights Using SQL
SQL & AnalyticsDesigned 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.
Brazilian E-commerce (Olist) Data Analysis
SQL β’ Advanced AnalyticsPerformed 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.
Zepto Sales Insights using SQL
SQL & AnalyticsAnalysed 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 Data Analysis Project
SQL & Business InsightsPerformed 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.
Python-driven data & business analysis
Exploratory analysis, automation, and insight-driven problem solving using Python.
Toy Store E-Commerce Performance Analysis
Python & Business InsightsPerformed 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.
Telecom Customer Churn Analysis
Python β’ EDA β’ Business InsightsPerformed 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.
Sales Analysis using Python
Python & EDAPerformed 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.
Diwali Sales Analysis
Python & EDAConducted 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.
Certifications & virtual programs
Structured learning that supports my self-driven practice.
Data Visualization Associate Internship β Star Performer
Saint Louis University β’ Excelerate β’ Mar 2026
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
Microsoft β’ Dec 2025
Databricks Accredited Databricks Fundamentals
Databricks Academy β’ Jan 2026
Fundamentals of Analytics on AWS β Part 1
AWS Training & Certification β’ Feb 2026
Fundamentals of Analytics on AWS β Part 2
AWS Training & Certification β’ Mar 2026
Integrating Amazon S3 Tables with Amazon SageMaker Lakehouse
AWS Training & Certification β’ Mar 2026
Claude 101
Anthropic β’ 2026
AI Fluency: Framework & Foundations
Anthropic β’ 2026
Snowflake Hands-On Essentials
Snowflake β’ Badge 1
Collaboration, Marketplace & Cost Estimation
Snowflake β’ Badge 2
HackerRank SQL (Advanced) Certificate
HackerRank β’ Feb 2026
Deloitte Data Analytics Job Simulation
Virtual Experience β’ Aug 2025
Tata Data Visualization Program
Forage β’ Aug 2025
SQL for Data Analysis
Simplilearn
Career Essentials in Data Analysis
Microsoft & LinkedIn Learning
Career Essentials in Data Analysis
Microsoft & LinkedIn Learning
HP LIFE β Data Science & Analytics
HP Foundation β’ Aug 2025
Power BI Certification
SkillCourse
30-Days SQL Micro Course
SkillCourse β’ Instructor: Satish Dhawale
Excel Automation using ChatGPT
Simplilearn & Microsoft
Business Analytics with Excel
Microsoft & Simplilearn
Databricks 14 Days AI Challenge
Databricks β’ Indian Data Club β’ Codebasics β’ 2026
IDC β 21 Days SQL Challenge
IDC | 2025
Letβs talk about data
Open to internships, full-time roles, and collaboration ideas.