Skip to content

A curated guide and overview of my projects and case studies, demonstrating my skills and approach to data analysis.

Notifications You must be signed in to change notification settings

SimranRayait51/The-Portfolio

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

1 Commit
Β 
Β 

Repository files navigation

πŸ—ƒοΈ Simran's Portfolio

Welcome to my professional portfolio! This repository is a curated guide and overview of my data analysis projects and case studies. It showcases my skills and approach to data analysis, including work with SQL, Python, Tableau, and business intelligence.


πŸ’» Table of Content


SQL

Project Link Focus Area Description
🚩8Weeks-SQL-Challenges SQL queries, joins, aggregations, optimization, subqueries , Data Cleaning This repository is my logbook through the 8 Week SQL Challenge by Data With Danny β€” a hands-on journey to sharpen my SQL and data analysis skills, one real-world case study at a time.
βœ”οΈIPL Performance Analysis SQL queries, joins, aggregations, optimization, subqueries , Data Cleaning , PPT , Data Sorting , Report This project is to demonstrate how data analysis, particularly using SQL, can provide actionable insights into player selection strategies in the IPL auction. This analysis is driven by the idea that teams make multi-million-dollar decisions based on player statistics. Understanding which attributes (e.g., batting average, strike rate, boundary percentage) most affect the auction price can help teams make more informed, data-driven decisions.

Power Bi

Project Link Focus Area Description
πŸ“ŠStrategic Insights Dashboard Data Cleaning , Data Analysis , Data Visualization , Data Analysis Expression(Dax) A dynamic Power BI dashboard designed to deliver strategic insights across revenue, products, customers, and global sales performance. Built using Power Query and DAX with drillthrough, slicers, and interactive visuals.

Data Analysis

Project Link Focus Area Description
πŸ‘©β€πŸ’»Fitbit Fitness Tracker Case Study Excel , Data Cleaning , Data Visualization , Pivot Table and Charts , Power Query The goal of this case study is to analyze Fitbit fitness tracker data to provide marketing and business solutions to WeFit and its subsidiaries. By understanding customer trends, usage patterns, and activity data, we aim to help WeFit optimize its offerings and grow its business across multiple divisions, including LeanFit, FitWear, and Sleepy-Nights.

About

A curated guide and overview of my projects and case studies, demonstrating my skills and approach to data analysis.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published