Sagar Vijay
Portfolio

"Surpass numerical boundaries by translating raw data into actionable insights."
I am data enthusiast well-versed in SQL, Python, Tableau, and Excel.

@sagarvj

OLYMPICS HISTORY
(SQL & TABALEAU)

Analysed Olympic History (1896-2016) containg more than 270,000 rows of dataset on PostgreSQL.
Further visualized the data for better understanding on Tableau.
Click above to view SQL code | Click below to view Tableau Dashboard

NETFLIX Growth
Analysis (Tableau)

This project aims to conduct growth analysis on Netflix, delving into data on total TV shows and movies categorized by country, year, genre and many more. The analysis provides insights into the platform's evolving content landscape and expansion dynamics.

CUSTOMER PURCHASING HABITS
- RFM analysis (Tableau)

RFM analysis: Recency (When did they last order ?) | Frequency (How often they make purchases ?) | Monetary value (How much money they spent ?) is a marketing analysis tool used to identify a firm's best clients based on the nature of their spending habits. Further, it showcases Avg. order value, Total Products and Unique products purchased by the individual customers.

Performance Monitoring
(Tableau)

This project analyzes Total sales, quantity and profit ratio of latest year vs previous year. Further, showcases latest year sales by subcategory with reference of previous year sales. By filtering out them by category, segment and ship mode.

Heatlth Survey analysis
(Tableau)

This project analyzes the health survey released by the National Family Health Survey (NFHS), 2019-21. The data indicate that more than 57% of women in India are anemic, and more than 18.7% of men above the age of 15 consume alcohol. Additionally, the dashboard delves into district-level statistics.

AIRLINE TRAFFIC analysis
(Tableau)

This project analyzes Post-Covid Airline traffic of all countries by individual date. With this dashboard it is clear that US has the most complex airline network of all countries. Purpose of this project is to learn makeline feature in Tableau and use of the same in business.

Tech Stack Survey analysis (Python)

Stack Overflow is the largest online community for developers to learn and excel in programming. Every year, SO conducts a survey to deliver industry leading insights. In May 2023 over 90,000 developers responded to our annual survey about how they learn and level up, which tools they're using, which ones they want. The analysis is done via Python libraries Pandas, Matplotlib & Seaborn.

NETFLIX WEB SCRAPER
(PYTHON)

This project successfully extracts valuable data on Netflix shows and movies using Python. Which includes comprehensive information on content, genres, cast, and more. It can be goldmine for data analysts, enabling in-depth insights into user preferences, content trends, and regional variations.

MONTHLY BUDGET TRACKER
(SpreadSheet)

Corrected version: "This project is built on Google Sheets, comprising income and expense columns to track transactions and summarize each month. The spreadsheet is supported by data validation, conditional formatting, and advanced formulas."

HEALTH TRACKER
(SpreadSheet)

Corrected version: "This project is built on Google Sheets and aims to track habits, recording them every month, and showcasing progress based on daily task completion. The spreadsheet is supported by data validation, conditional formatting, and advanced formulas."