Kamalpreet Kaur
Data analystI'm Kamalpreet Kaur, a passionate data analyst. With a robust skill set in SQL, Tableau, Excel, Power Query, and GitHub.Explore my projects to see how I leverage data to drive impactful decisions and optimize performance.From improving patient outcomes in healthcare to enhancing content strategies for entertainment platforms.my work demonstrates a commitment to excellence and innovation in data analysis.
Harmonizing Data: Insights into Music Store Operations through Data Analysis
The project showcased proficiency in SQL and the ability to combine various queries to extract meaningful insights from complex data.
It demonstrated the ability to analyze employee hierarchy, invoice distribution, revenue streams, customer engagement, and music preferences.
The project also highlighted the ability to identify VIP customers and prolific music creators, and to discover lengthy songs in the catalog.
Click Here
Sales Management Analysis
Extracted dataset through public repositoriesExecuted complex SQL queries such as Joins, Temp Tables, Windows Functions, Aggregate Function and exported the dataset to GitHub.Created an interactive dashboard in Tableau to demonstrate detailed overview of sales per customer and compare sales to the budgetClick Here!
Cyclistic Bike Sharing Project
Analyzed dataset for bike sharing company in Chicago.Created an interactive dashboard in Tableau to demonstrate how annual members and casual members use the bike differently.Determined how to convert casual riders to annual members using marketing strategies.
Click Here!
Amazon Bestselling Books Analysis 2009-19
Analyzed dataset for best selling books of amazon whether its fiction or non-fiction.I tried to find out the reason behind a book becoming bestsellerI performed an exploratory analysis and used and experimented with different scenarios.Created an interactive dashboard in Tableau using different factors.Click Here!
Certifications
Google Data Analytics Certificate, Coursera. View here!
SQL for Data Science, UCD. View Here!
Data Visualization with Tableau, UCD. View Here!
Excel Fundamentals for Data analysis, Macquarie University. View Here!