About Me
Hey there! 👋 I'm Vishnu, your go-to data specialist who turns business puzzles into data-driven solutions.As a Data & BI Analyst, I've mastered the art of transforming raw data into insights that actually make sense (and hopefully dollars too). Think of me as your data translator - I speak both SQL and human, making complex analytics digestible for everyone from CEOs to your friendly neighborhood marketing team.My superpower? Taking mountains of data and turning them into clear, actionable strategies that help businesses grow. I specialize in building dashboards that tell stories, not just show numbers, and creating reports that people actually want to read.When I'm not diving deep into datasets, you'll find me on the soccer field working on my footwork, or watching Manchester United play (which sometimes feels like analyzing another kind of data - the data of disappointment 😅).Let's connect and explore how we can use data to fuel your business growth. After all, in a world drowning in information, wouldn't it be nice to have someone who can help you swim?P.S. I promise my insights are more reliable than United's defense!
Experience
One Community | October 2024 - Present
Data Analyst (Volunteer)
Philadelphia, PA, US
PrimePay | June 2024 - October 2024
Data Analyst
Philadelphia, PA, US
PrimePay | June 2023 - September 2023
Data Analyst Intern
Philadelphia, PA, US
Algonomy | June 2021 - March 2022
Data Analyst
Bangalore, KA, IN
PowerGrid | June 2020 - September 2020
Data Analyst Intern
New Delhi, DL, IN
Skills
Power BI | Excel | Tableau | SQL | Azure |Python | AWS | Salesforce
SQL - 5 years
Excel - 4 years
Python - 4 years
Power BI - 3 years
Data Analytics - 3 years
Data Visualization - 3 years
Database Modeling - 3 years
ETL Development - 3 years
Apache Airflow - 3 years
Predictive Analytics - 3 years
Machine Learning - 3 years
Dashboard Building - 3 years
PostgreSQL - 3 years
Salesforce - 2 years
Tableau - 2 years
Docker - 2 years
AWS - 1 year
Azure - 1 year
The listed experience reflects practical, hands-on involvement, not solely formal work experience
Featured Projects
Power BI
FLIGHT STATUS DASHBOARD
This flight status dashboard, created using Power BI, summarizes flight trends, delays, cancellations, top cities, airlines, and cancellation reasons.
Power BI
Store Sales Dashboard
This sales dashboard, created using Power BI, highlights key metrics like total sales, profit, product performance, sales type, and payment modes.
Power BI
HR Attrition Analysis Dashboard
This is an HR dashboard analyzing employee attrition patterns at IBM across different factors including job roles, education, age, distance from work, and satisfaction levels.
Tableau
British Airways Reviews Dashboard
British Airways performance dashboard displays customer ratings across services, timeframes, aircraft types, and countries, highlighting strengths and areas for improvement.
Tableau
Emergency Room Dashboard
Diverse ER data showing patient demographics, wait times, satisfaction, and referrals. Highlights gender balance, age trends, racial diversity, and common medical needs.
Apache Airflow
Amazon Data Engineering Books ETL Project
Apache Airflow ETL pipeline that extracts Amazon book data via API, transforms it with SQL, and loads into PostgreSQL using Docker.
SQL
patient-centric healthcare database
This ER diagram represents a patient-centric healthcare database, capturing patient demographics, medical history (procedures, medications, allergies, immunizations), and geographic data, with standardized reference tables ensuring consistency, scalability, and compliance.
Certifications
Microsoft Certified Power BI Data Analyst PL -300
Python for Data Science, AI and Development
Power BI
Flight Status Dashboard
Tools: Power BI, DAX, POWERQUERY
Dataset Link5 Key Questions:
1. Which cities have the highest flight volume?
2. What percentage of flights are delayed by different airlines?
3. What are the primary reasons for flight cancellations?
4. Which days of the week experience the most flight cancellations?
5. What is the overall breakdown of on-time, delayed, and cancelled flights?Here are my takeaways:1. The cities with the highest flight volume are Atlanta (347K flights), Chicago (286K flights), and Dallas-Fort Worth (240K flights). These major hubs handle a significant portion of air traffic.2. United Airlines leads in flight delays at 53.3%, followed closely by Southwest at 51.4%. Spirit, JetBlue, and Frontier also show high delay percentages, ranging from 40.7% to 48.2%.3. Flight cancellations are primarily due to Weather issues (57.3%) and Airline/carrier (28.3%). National Air System-related reasons account for 14.4% of cancellations.4. Sunday appears to have the highest percentage of flight cancellations at 2.3%, with Saturday following at 1.7%. Other days of the week show lower cancellation rates.5. Overall, 58% of flights are on time, while 40.5% experience delays. Only 1.5% of flights are cancelled. This indicates that while most flights operate as scheduled, delays affect a significant portion of air travel.
Power BI
Store Sales Dashboard
Tools: Power BI, DAX, POWERQUERY
Dataset Link5 Key Questions:
1. How do total sales and profit vary across months and days?
2. Which products generate the highest sales?
3. What is the distribution of sales across direct sales and online channels?
4. How does the mode of payment impact sales performance?
5. How does profit percentage relate to total sales?Here are my takeaways:1. Monthly and daily sales trends show significant variation. January has the highest monthly sales at 41K, while March and April have the lowest at around 27K-29K. Daily sales fluctuate between 4K and 20K, with several peaks throughout the month.2. The top-selling products are Product41 and Product30, both generating 23K in sales. They're followed by Product42 (21K) and Product19 (20K). Other products like Product10, Product44, Product32, and Product05 all contribute 16K each to total sales.3. Sales channels show a clear preference for direct sales, accounting for 51.85% of total sales. Online sales make up 33.36% of the total, with the remaining portion likely attributed to other channels not specified in the image.4. Payment modes are fairly evenly split, with a slight preference for cash transactions. Cash payments account for 50.3% of sales, while online payments make up 49.7%. This balanced distribution suggests customers are comfortable with both payment methods.5. The overall profit percentage stands at 21%, with total sales of 401K resulting in a total profit of 69K. This indicates a healthy profit margin for the supermarket, though it's important to note that this percentage remains constant despite variations in monthly sales figures.
Tableau
Emergency Room Dashboard
Tools: Tableau, Excel
Dataset Link5 Key Questions:
1. How does the gender distribution of ER patients break down, and are there any notable trends?
2. What is the relationship between average wait time and patient satisfaction scores?
3. Which age group consistently accounts for the majority of ER visits, and how do the visit patterns change over time?
4. What are the top three racial demographics represented in ER visits, and how significant is the difference between them?
5. Which medical departments receive the most patient referrals from the ER, and what might this suggest about common health issues?Here are my takeaways:1. The gender distribution shows 51.05% male patients, 48.69% female patients, and 0.26% non-conforming patients. There's a slight majority of male patients, with a small but notable percentage identifying as non-conforming.2. The average wait time is 35.26 minutes, while the average patient satisfaction score is 4.99/10. This relatively low satisfaction score might be influenced by the wait time, though other factors are likely involved given the complexity of ER experiences.3. The 19-65 age group consistently accounts for the majority of ER visits from April 2019 to October 2020. The 0-18 age group is the second largest, followed by the 66+ group. The pattern appears relatively stable over time, with some minor fluctuations.4. The top three racial demographics are White (2,571 patients), African American (1,951 patients), and Two or More Races (1,557 patients). While White patients form the largest group, there's significant representation from other racial categories, indicating a diverse patient population.5. General Practice receives the most referrals (1,840), followed by Orthopedics (995) and Physiotherapy (276). This suggests that many ER visits may be for non-emergency issues that could be handled by general practitioners, while musculoskeletal problems (addressed by orthopedics and physiotherapy) are also common reasons for ER visits.
Tableau
British Airways Reviews Dashboard
Tools: Tableau, Excel
Dataset Link5 Key Questions:
1. What is the highest-rated aspect of British Airways' service, and how does it compare to the lowest-rated?
2. How has the overall rating trend changed from 2017 to 2023?
3. Which aircraft type receives the best customer ratings, and does this correlate with the number of reviews?
4. What insights can be drawn from the geographical distribution of ratings shown on the map?
5. How do the newer aircraft models (e.g., Boeing 787) compare in ratings to older models (e.g., Boeing 747-400)?Here are my takeaways:1. Cabin Staff Service is the highest-rated aspect at 3.3, significantly outperforming Entertainment, which scores lowest at 1.4. This suggests comparatively better service but a need to improve onboard entertainment options since it is rated out of 10.2. The overall rating trend shows high volatility from 2017 to 2023, with notable dips around 2021 and 2023. This could reflect service disruptions, possibly related to the global pandemic and its aftermath.3. The Boeing 747-400 receives the highest rating (4.7) despite having fewer reviews (97) than some other aircraft. This indicates that quantity of reviews doesn't necessarily correlate with higher ratings.4. The map suggests varying customer satisfaction across different countries, with some European and African nations showing darker blue (potentially higher ratings). However, the limited visible data makes it difficult to draw definitive conclusions about geographical trends.5. Newer aircraft like the Boeing 787 (4.4) rate well, but interestingly, the older Boeing 747-400 (4.7) outperforms it. This suggests that age of aircraft model alone doesn't determine customer satisfaction.
POWER BI
HR Attrition Analysis Dashboard
Tools: Power BI, DAX, PowerQuery
Dataset Link5 Key Questions:
1. Why is attrition highest among Sales Representatives (39.76%)?
2. Why does attrition decrease with education level?
3. Why is younger workforce (18-25) leaving at 35.8%?
4. What explains the 61.3% satisfaction rate despite high attrition?
5. How does distance from home impact retention?Here are my takeaways:1. Sales positions show the highest turnover at nearly 40%, likely due to high-pressure environments, commission-based pay structures, and competitive market conditions. The data suggests a need to reevaluate the sales department's work culture, compensation packages, and career development opportunities. Regular check-ins and improved support systems could help reduce this rate.2. Education shows a clear inverse relationship with attrition - from 18.24% for high school graduates to 10.42% for doctorate holders. This pattern suggests that higher education leads to more specialized roles, better job satisfaction, clearer career paths, and possibly better compensation packages. Investment in employee education could be a retention strategy.3. The 18-25 age group's high attrition (35.8%) reflects a broader trend of job-hopping among younger professionals. This generation prioritizes rapid career growth, work-life balance, and diverse experiences. Companies need stronger early-career development programs, mentorship opportunities, and clear advancement paths to retain young talent.4. The disconnect between high satisfaction (61.3%) and high attrition (16.1%) indicates that satisfaction alone doesn't ensure retention. External factors such as competitive job offers, career growth opportunities, work-life balance, and market conditions play crucial roles. This suggests the need for a more comprehensive retention strategy beyond job satisfaction.5. The distance-attrition relationship shows significant spikes (up to 42.9%) at certain distances, suggesting commute time significantly impacts retention. This data supports the case for hybrid work models, relocation assistance, or satellite office locations. Companies should consider flexible work arrangements to accommodate employees with challenging commutes.
Amazon Data Engineering Books ETL Project
Tools: Apache aIRFLOW, POSTGRESQL, DOCKER, PYTHON
Complete Project LinkAmazon Data Engineering Books ETLThis project is an ETL (Extract, Transform, Load) pipeline that fetches data on Amazon's data engineering books, transforms the data, and loads it into a PostgreSQL database.Technologies Used1. Apache Airflow
2. Docker
3. PostgreSQL
4. PythonProject OverviewI've created an impressive ETL (Extract, Transform, Load) project using the following technologies:Apache Airflow: An open-source workflow orchestration platform used to programmatically author, schedule, and monitor data pipelines.
Docker: A containerization platform that allows me to package my application and its dependencies into a single, portable container.
PostgreSQL: An open-source relational database management system used as the destination for the data I'm extracting and transforming.
API: I've utilized API calls to fetch data on Amazon's data engineering books, which serves as the source data for my ETL process.
The key steps in my project are:Data Extraction: I'm using API calls to fetch data on Amazon's data engineering books. This represents the "Extract" step of the ETL process.Data Transformation: Once the data is extracted, I'm using SQL to clean the data by removing any trailing data and converting the data types to the appropriate format. This is the "Transform" step.Data Loading: The transformed data is then loaded into a PostgreSQL database, which represents the "Load" step.Orchestration with Apache Airflow: I'm using Apache Airflow to orchestrate the entire ETL process, allowing me to schedule, monitor, and manage the data pipeline.Docker Containerization: To ensure consistency and ease of deployment, I'm running the entire project within a Docker container.This comprehensive ETL solution allows me to regularly and reliably fetch data from the Amazon API, transform it, and load it into a PostgreSQL database for further analysis or reporting.FeaturesFetches data on data engineering books from the Amazon API.
Transforms the data by removing any trailing data and converting data types to the appropriate format.
Loads the transformed data into a PostgreSQL database.
Uses Apache Airflow to schedule, monitor, and manage the ETL process.
Runs the entire application within a Docker container for easy deployment and consistency.
Patient Centric Healthcare Database Project
Tools: SQL, SQL Flow, Oracle SQL Developer
This ER diagram represents a patient-centric healthcare database, designed to track key information about patients and their medical history, treatments, and demographic details. Let me break it down:Key Entity: PATIENT
The central table is the PATIENT table, which captures essential details about each individual, such as:
Demographics: First name, last name, gender, race, ethnicity, marital status, and birthdate.
Contact information: ZIP code and details about their living place (country, state, and city).
Identification: SSN, passport number, or other identifiers.
Healthcare-specific fields: Insurance details, healthcare expenses, and coverage data.This table links to various other entities that expand upon the patient's demographics, conditions, and treatments.Supporting Tables for Demographics
1. GENDER, ETHNICITY, RACE, and MARITAL_STATUS:
These are reference tables providing descriptive information (e.g., "Male", "Asian", "Married").
Each patient in the PATIENT table is associated with entries in these tables through their respective IDs.2. COUNTRY, STATE, CITY, and COUNTY:
These tables provide geographical information about the patient's living or birth location.
Each links hierarchically, enabling detailed reporting and aggregation at different administrative levels.Medical History and Treatment
1. PATIENT_PROCEDURE:
Tracks procedures the patient has undergone.
Links to:
PROCEDURE: Describes the type of procedure (e.g., "Appendectomy").
REASON: Indicates the reason for the procedure (e.g., "Appendicitis").
Captures procedure dates and associated costs.2. PATIENT_MEDICATION:
Tracks medications prescribed to the patient.
Links to:
MEDICATION: A catalog of medications (e.g., "Aspirin").
REASON: Indicates why the medication was prescribed.
Includes details about start/stop dates, dosages, and costs.3. PATIENT_ALLERGY:
Tracks allergies the patient has.
Links to:
ALLERGY: A catalog of known allergens (e.g., "Peanuts").
Includes dates when the allergy was identified and its resolution (if any).4. PATIENT_IMMUNIZATION:
Tracks immunizations the patient has received.
Links to:
IMMUNIZATION: Describes the type of immunization (e.g., "Flu Shot").
Captures immunization dates and costs.5. PATIENT_IMAGING_STUDY:
Tracks imaging studies performed on the patient.
Links to:
MODALITY: Imaging modality used (e.g., "MRI").
BODYSITE: Indicates the body part being scanned.
Includes details like imaging study dates and associated procedure codes.Reference Tables for Medical Data
MEDICATION, PROCEDURE, ALLERGY, and IMMUNIZATION:
Maintain catalogs of medications, procedures, allergens, and immunizations for standardization.MODALITY and BODYSITE:
Provide descriptive details for imaging-related procedures.REASON:
Standardizes reasons for medical actions.Relationships and Key Points
The PATIENT table serves as the hub, connecting to various tables that capture more granular information about the patient's medical and demographic history.
Reference tables like GENDER, RACE, and COUNTRY ensure data consistency and allow flexibility for future expansion.
Relationships are clearly defined, such as:
One patient can have multiple procedures, medications, or immunizations.
Standardized codes (e.g., for medications or procedures) simplify data entry and reporting.This database is designed to be both scalable and HIPAA-compliant, supporting effective patient care, analytics, and reporting. Let me know if you'd like clarification on any specific area!