Check out my latest projects below
Built a dashboard that shows Financial and Revenue insights for an India based 5 STARTS Hotel chain business.
As the brand was facing revenue issues, the issues needed to be found at different layers to identify the specific
areas of improvement based on the data they have collected over the years. This project gives anyone a solid
understanding of concepts like ADR, RevPAR, DSRN, DBRN, Occupancy and many KPIs which are important in this domain.
Tools used: Microsoft Excel, Power Query, Power BI
Developed an interactive dashboard and visuals showing the Nintendo Game trends over the last 20+ years.
Tools used: MySQL, Microsoft Excel, Tableau
Done data cleaning, trasnformation and wrote SQL queries such as dropping unwanted columns and records, Creating aggregated colmuns, Left/Right/Self Joins.
Tools used: MS SQL Server and T-SQL Concepts
Build a web based application where anyone can enter the keywords to identify whether the email is SPAM.
Tools used: Python, Pandas, Scikit-Learn Machine Learning, NLP, Statistics, MatplotLib
Developed a Power BI dashboard using real data having 200K+ records in SQL. Used MySQL for data analysis, and visualized important sales KPIs after modelling the data and performing ETL in Power Query.
Tools used: MySQL, SQL, ETL, Power BI