18+
Analytics projects
End-to-end work across BI, SQL, Python, R, ML and statistics.
Open to entry-level analytics opportunities
Turning data into decisions through analytics, BI & machine learning.
Data analyst skilled in SQL, Python, Power BI, Tableau, and Excel, holding an Advanced Certification in Data Analytics from IIT Roorkee, in association with Intellipaat, and 18+ self-driven analytics projects across retail, SaaS, marketing, HR, manufacturing, and finance. I build practical analytics solutions that turn data into actionable business insights, using AI tools to accelerate SQL, Python, Excel, and dashboard workflows.
Professional Impact
Evidence, not just a skills list.
Selected outcomes from my projects and professional experience.
3
Live applications
Production-deployed Streamlit applications with interactive user flows.
94.2%
AUC-ROC
SaaS churn model using Gradient Boosting with a SQL cohort layer.
4.28%
MAPE
Monthly demand forecasting benchmark using SARIMAX and Prophet.
Why Hire Me
Practical analytics with business context.
I combine technical execution with clear reporting and business-oriented problem solving.
→
Strong foundation in Python, SQL, Excel and Power BI.
Comfortable moving from raw data and SQL transformations to analysis, dashboards and reporting.
→
Proven ability to deliver end-to-end analytics projects.
18+ projects spanning BI, SQL engineering, forecasting, machine learning, statistics and business analysis.
→
Hands-on experience deploying live Streamlit applications.
Three production-deployed apps demonstrate that the work goes beyond notebooks and static reports.
→
Experience across forecasting, A/B testing and machine learning.
Practical work includes churn prediction, demand forecasting, experimentation and recommendation systems.
→
AI-augmented workflow for faster analytics and visualisation development.
Uses AI tools for formula building, SQL drafting, Python scripting and visualization workflows while keeping the analytical work grounded in business requirements.
Resume
Two targeted resumes for analytics roles.
Use the Data Analyst version for technical analytics roles and the Business Analyst version for requirement, KPI and stakeholder-focused roles.
DATA ANALYST • 2026
Nikhil Tandon
Data Analyst · SQL · Python · Power BI · Tableau
18+ analytics projects3 live Streamlit appsPython · SQL · Power BIIIT Roorkee + Intellipaat
EducationB.Com (Hons), Amity University, Noida
Advanced CertificationData Analytics — iHUB DivyaSampark at IIT Roorkee, in association with Intellipaat
ExperienceFinance & Marketing Analytics Intern
Target RolesData Analyst · BI Analyst · Analytics Analyst
BUSINESS ANALYST • 2026
Nikhil Tandon
Business Analyst · KPI Reporting · Stakeholder Communication · BI
Requirements & KPI reportingSQL · Power BI · Excel3.20x ROAS analysis18+ analytics projects
EducationB.Com (Hons), Amity University, Noida
Analytics ProgramIntellipaat, in association with IIT Roorkee
ExperienceFinance & Marketing Analytics Intern
Target RolesBusiness Analyst · Data Analyst · BI Analyst
About
Analytics professional focused on practical business impact.
I’ve built a focused analytics portfolio through 18+ projects spanning customer analytics, forecasting, churn prediction, SQL engineering, BI dashboards, experimentation and recommendation systems across retail, SaaS, marketing, HR, manufacturing, and finance.
My toolkit combines Python, SQL, Excel, Power BI, Tableau and R with practical business-analysis skills such as requirement gathering, stakeholder communication, KPI reporting and cross-functional collaboration.
LocationNew Delhi, India
EducationB.Com (Hons), 2021–2024
Advanced certificationData Analytics — IIT Roorkee + Intellipaat
Target rolesData / Business / BI Analyst
Career Timeline
From commerce to analytics.
Jul 2025 — Aug 2026
Advanced Certification in Data Analytics
Intellipaat, in association with IIT Roorkee — focused on Data Analytics, SQL, Python and Power BI.
2024 — Present
Analytics Portfolio & Applied Projects
18+ self-driven projects across BI dashboards, SQL engineering, forecasting, machine learning, statistics and deployed applications.
2021 — 2024
Bachelor of Commerce (Honours)
Amity University, Noida.
May — Jul 2023
Finance & Marketing Analytics Intern
Ads Klick Media — analytics, reporting, KPI dashboards and stakeholder-facing insights.
Education
Education & structured analytics learning.
Academic foundation plus formal analytics training completed through 2024–2026.
2021 — 2024
Bachelor of Commerce (Honours)
Amity University, Noida
Commerce foundation supporting finance, business and analytical problem-solving work.
Aug 2024 — Jul 2025
Google Data Analytics Professional Certificate
Coursera
Structured analytics learning across the data-analysis lifecycle, visualisation and business communication.
Jul 2025 — Aug 2026
Data Analytics Certification Program
Intellipaat, in association with IIT Roorkee
Advanced analytics training spanning Data Analytics, SQL, Python and Power BI.
Featured Work
Selected work and practical outcomes.
A focused selection of projects that demonstrates BI, retail analytics, operations analysis and statistical problem-solving.
$2.3M salesPower BIDAX
Superstore Sales Performance Dashboard
Executive-style sales analysis covering revenue, profit margin, orders, customers, category performance and regional trends.
TableauOperations
Daikibo Manufacturing Downtime
Operations dashboard identifying high-downtime factories and failure-prone equipment to support maintenance prioritisation.
RRetail Analytics
Quantium Customer Segmentation
Customer segmentation analysis examining purchasing behaviour, customer types and sales patterns.
RExperimentation
Quantium Store Trial Analysis
Control-store selection and trial analysis comparing customer and sales performance to evaluate trial effectiveness.
Live Apps & Projects
Explore the wider portfolio.
Filter the work by the capability a recruiter wants to see.
NEWExcel FP&A
Budget vs Actual Financial Planning Model
Excel FP&A model using dynamic SUMIFS and XLOOKUP formulas for monthly and YTD variance analysis across Base, Upside and Downside scenarios.
NEWRetention
Customer Cohort & Retention Analysis
Built SaaS cohort retention analysis with SQL CTEs, joins and window functions, then surfaced retention curves and channel/plan performance in Power BI.
NEWHR Analytics
HR Workforce & Attrition Analytics
Analysed 1,470 employees and a 16.7% attrition rate across department, role, tenure, salary and overtime segments using SQL and Power BI.
NEW3.20x ROAS
Marketing Funnel & Campaign ROI Analysis
End-to-end funnel analysis across Impressions → Clicks → Leads → Customers, with CAC/ROAS/ROI analysis and a 15% budget-reallocation scenario.
NEWData Quality
Messy Data Cleaning & Data Quality Case Study
Profiled a 20,000-row retail intake, documented transparent cleaning rules, validated the result and produced a trusted analytical dataset with Excel, SQL and Python.
NEWOperations
Operations & Supply Chain Performance Analytics
Analysed 4,000 orders for on-time delivery, fulfilment, returns, stockouts, supplier performance and regional bottlenecks using SQL, Power BI and Excel.
LIVE APPStreamlit
Retail RFM Customer Segmentation
Production Streamlit app that calculates RFM metrics and segments uploaded customer data into VIP Champions, Core Loyalists, Regular Shoppers and At-Risk tiers.
LIVE APPML + SQL
Formula 1 Race Predictor
Random Forest prediction pipeline with temporal train/test split and pre-race features including grid position, season points, career wins and circuit.
LIVE APPStreamlit
FIFA World Cup Match Predictor
Historical tournament data, engineered predictive features and interactive win-probability simulations served through Streamlit.
94.2% AUC-ROCPython + SQL
SaaS Customer Churn Analytics Platform
Gradient Boosting churn model across 2,500+ records using a SQL cohort layer, CTEs, window functions and SMOTE, paired with a Chart.js risk dashboard.
$2.3M salesPower BI
Superstore Sales Performance Dashboard
Interactive KPI dashboard tracking sales, profit, margin, orders, customers, categories, regions and business growth opportunities.
4.28% MAPEForecasting
Retail Monthly Sales Forecasting Engine
ADF-validated, seasonally-differenced time series benchmark comparing SARIMAX and Facebook Prophet for monthly demand forecasting.
SQLETL
Chinook Data Engineering Pipeline
Transaction-safe database layer with relational constraints, TRY/CATCH handling, optimised views and rollback-controlled invoice ingestion procedures.
SQLRevenue Intelligence
Chinook Revenue Intelligence
Advanced revenue analysis using ranking and percentile logic to surface top-value customers, artists, genres and invoice behaviour.
StatisticsA/B Testing
Website Conversion A/B Testing
Validated a Design B rollout at alpha 0.05 using a two-sample t-test for session duration and chi-square testing for conversion rate.
RecommenderSVD
Netflix Movie Recommendation System
Collaborative-filtering recommendation engine using SVD matrix factorisation to generate personalised top-10 movie recommendations.
RRetail
Quantium Retail Analytics
Customer segmentation plus trial-store analysis covering control selection, correlation, sales uplift, customer uplift and trial effectiveness.
TableauOperations
Daikibo Manufacturing Downtime
Dashboard identifying high-downtime factories and failure-prone equipment to prioritise maintenance and operational improvement.
SQLCampaign Analytics
Customer Campaign Analytics
Relational campaign analysis connecting customer demographics and campaign interactions to conversion outcomes and marketing effectiveness.
PythonRandom Forest
Titanic Survival Analysis
End-to-end EDA, data cleaning, feature engineering and Random Forest modelling to understand the factors associated with passenger survival.
StatisticsSimulation
Central Limit Theorem Simulation
Python simulation demonstrating how the distribution of sample means approaches normality as sample size increases.
ExcelDashboard
Sales Performance Dashboard & Data Analysis
Advanced Excel dashboard analysing revenue, orders, average order value, categories, regions and sales trends for actionable business insights.
Skills
A toolkit built around analytics work.
Grouped directly around the capabilities represented in the current resume.
Languages & Querying
Programming, analysis and relational querying.
PythonPandasNumPyScikit-learnMatplotlibSeabornSQLT-SQLPostgreSQLMySQLRAdvanced Excel
BI & Visualization
Dashboarding, KPI reporting and data storytelling.
Power BIDAXData ModellingTableauStreamlitChart.jsGoogle AnalyticsKPI Dashboard DesignData Storytelling
Data Engineering
Reliable analytical layers from raw and relational data.
Data CleaningWranglingEDACTEsWindow FunctionsStored Procedures
ML & Statistics
Models and methods connected to analytical questions.
Random ForestGradient BoostingLogistic RegressionNeural NetworksA/B TestingRFM SegmentationTime Series Forecasting
Business Analysis
Turning analytical work into stakeholder-ready outputs.
Requirement GatheringStakeholder CommunicationCross-Functional CollaborationKPI Reporting
Tools & AI-Augmented Workflow
Development environments and AI-assisted repetitive analytics tasks.
Git / GitHubJupyterVS CodeMySQL WorkbenchExcel Pivot TablesVLOOKUPSQL Query WritingPython Scripting
Experience
Industry experience.
Finance & Marketing Analytics Intern
Ads Klick Media
May 2023 — Jul 2023
- Collaborated with cross-functional finance and marketing stakeholders, surfacing channel-level performance insights via Google Analytics and Excel that drove +20% reach and +25% engagement, informing weekly budget decisions.
- Gathered reporting requirements from stakeholders and created automated pivot-table KPI dashboards and reusable templates, eliminating repetitive manual reporting.
Certifications
Certifications & professional learning.
Selected credentials and applied learning relevant to analytics, BI and business problem-solving.
Aug 2026
Advanced Certification in Data Analytics
iHUB DivyaSampark at IIT Roorkee, in association with Intellipaat
Certificate of Completion issued 31-Aug-2026 · Certificate ID: IPTIH26080309.
Aug 2024 — Jul 2025
Google Data Analytics Professional Certificate
Coursera
Structured training in the analytics lifecycle, from data preparation and analysis to visualisation and business communication.
2024
Microsoft Excel Certification
Microsoft Excel
Supports the portfolio’s spreadsheet analysis, Pivot Table and VLOOKUP work.
2025 — 2026
Data Analytics Job Simulations
Tata GenAI, Deloitte & Quantium — Forage
Practical simulations covering business analytics and AI-enabled problem-solving in realistic work scenarios.
Let’s Connect
Open to the right analytics opportunity.
I’m interested in entry-level Data Analyst, Business Analyst and BI Analyst opportunities where I can contribute through data, reporting, dashboards and decision support.