Apoorv Verma

I’m a Data Analyst who thrives on solving real-world problems through meaningful, data-driven solutions. I developed a strong foundation in data strategy, analytics, and technology while pursuing my Master’s in Management Information Systems from the University of Illinois at Chicago. My experience spans around ride-sharing, Sales & Finance, Healthcare, and Defense, where I’ve honed my proficiency in crafting impactful insights and scalable solutions that transform complex datasets into clear, actionable outcomes.

Apoorv Verma
Resume GitHub LinkedIn Tableau

My Work

A curated selection of my technical and analytical projects, spanning business intelligence dashboards, Predictive modeling, Automation tools, and AI-integrated platforms. Built using tools like Tableau, Power BI, Python, SQL,Snowflake and cloud platforms, these projects reflect my ability to turn complex datasets into actionable insights across industries such as Aviation, Finance, Healthcare, and Mobility.

Delta Airline Data Visualization on Tableau

Analyzed Delta Airlines’ 2023 flight delays using Tableau, uncovering trends & insights through interactive visualizations and Geographic Mapping.

UEFA Champions League Analysis on Tableau

Visualized UEFA Champions League data using Tableau, showcasing Top players, Coaches, Goals while delivering an engaging and interactive dashboard to explore historical performance metrics.

Credit Card Complaints Analysis on Tableau

Developed a Tableau dashboard to analyze 86,000+ credit card complaints across the U.S. Highlighting billing disputes, response times, and state-wise volumes. Enabled stakeholders to monitor performance and identify key consumer pain points.

Road Accidents-Analytical Dashboard on Tableau

Designed a Tableau dashboard to analyze 140K+ road accidents and 195K+ casualties in the UK. Visualized key factors such as Vehicle type, Weather, Road Surface, and Accident Locations to uncover safety trends and risks.

Amazon Sales Analysis Power BI dashboard

Developed an interactive Power BI dashboard to analyze Amazon product sales, tracking over $21M in YTD revenue, product category performance, and weekly trends. Included filters for product category and quarter, along with top-performing products by sales and reviews.

HR Analytics Power BI dashboard

Built an HR analytics dashboard in Power BI to track key metrics such as attrition rate, job satisfaction, age distribution, and department-wise breakdowns across 1,400+ employees. Visualized patterns by gender, education, and job role to support data-driven workforce planning and retention strategies.

Netflix Content Analysis – SQL Project

Analyzed Netflix's movie and TV show data using SQL to solve 15 real-world business problems. Explored content trends by type, genre, country, and release year. Extracted insights on audience ratings, top-performing actors, and keyword-based categorization, enabling data-backed content strategy decisions.

Geospatial Mapping System – DRDO

Engineered a world map plotting system using OpenStreetMap, Python, and PostgreSQL (PostGIS) for DRDO's Scientific Analysis Group. Built automated geospatial pipelines and implemented shortest-path algorithms for military navigation. Enabled secure, real-time visualization of classified defense regions with precise coordinate-based mapping and threat assessment features.

Stock Market Analysis - Price Movement Prediction

Built predictive models using Logistic Regression, SVM, and Naive Bayes to forecast NIFTY-50 stock price movements with up to 93% accuracy. Cleaned Data and processed 470K+ records from 52 companies using SQL and Python, applied feature engineering, reduced multicollinearity with PCA, and boosted overall model performance.

Clustering & Classification of U.S. Health Data on Processed Food Consumption – Predictive Modeling

Analyzed 91K+ U.S. health records to identify disease and diet trends across age and state groups. Applied SQL and clustering algorithms (K-Means, OPTICS) to uncover correlations in processed food consumption. Enabled data-driven insights for public health and wellness strategy.

SQL

My SQL work spans projects in finance, healthcare, and defense—supporting tasks such as geospatial mapping, stock market analysis, food consumption clustering and content analytics for Netflix. I’ve used SQL with relational databases to manage structured data, write optimized queries, and drive automation. These projects highlight SQL’s role in predictive modeling, classification, and large-scale data exploration.

Tableau

Take a look at some of my Tableau dashboards—ranging from Delta Airlines analysis and UEFA Champions League stats to Credit Card Complaint Trends, Weather visualizations, and many more. Each project showcases my ability to turn raw data into intuitive, interactive visualizations that tell a compelling story and drive data-informed decisions.

Power BI

Explore a variety of Power BI dashboards I’ve developed—from sales performance insights on Amazon products and HR analytics to ride analysis for Uber bookings. These dashboards are designed to simplify large datasets, highlight business trends, and support strategic decisions through dynamic, interactive visuals tailored for operational clarity.