Hi there! ๐๐ปโโ๏ธ
Welcome to my Portfolio Guide where I provide a walkthrough to all of my data analytics projects and courses.
Feel free to chat with me on LinkedIn about my projects!
Click on the project's title (bold and coloured in Blue) to view my projects! Thank you!
Project Name | Description | Excel Dashboard |
---|---|---|
๐ Climate Warming Stripes | Using just Microsoft Excel and just colours to avoid technical distractions, I recreated Ed Hawkins "#ShowYourStripes" color stripes to intuitively convey global warming trends to non-scientists. | Link |
๐น Sales Overview Report | This report contains 3 sheets linked via a hyper link that takes you from the weekly report, to monthly report and then anual report. Each report page shows sales trend, best selling product, and other sales insight. | Link |
๐ณ Personal Finance Budget Tracker | A project to track expenses. | Link |
Level: Intermediate SQL
Functions: Aggregations, Joins, CTEs, Window functions (aggregates, ranking, running total, partitioned averages), CASE WHEN statements, subqueries, nested subqueries, DATETIME functions, data type conversion, text and string manipulation
Project Name | Description | SQL Functions |
---|---|---|
๐Adventure Works | In this project, I measure the effect of changes from 2021 going back 2 years on the company's sales performance. | |
๐Sales Insight | Using SQL & Power BI to show key sales trend. |
Project Name | Description | Power BI Dashboard |
---|---|---|
๐ USA Food Waste Monitor | Insight on how much food is going uneaten in the United States. Why itโs happening, and where it goes. | Dashboard |
โฎ United Nation Sustainable Development Goals | Information of The United Nations Sustainable Development Goals, specifically focusing on the indicators they are measuring. | Dashboard |
๐ฝ A Restuarant Blueprint | Finding similarities between neighborhoods of Bangalore on the basis of food and audit. | Dashboard |
๐ผ Music Visualization | Recreated the โwarming stripesโ visualization but this time, from Popular music and their notes. | Dashboard |
๐ 2023 The Oscars Nominations | Using Infographic Designer custom visual to create an isotype chart for the 2023 Oscars Nomination. | Dashboard |
๐ต Spotify Holiday Music Picker | Built a Holiday Song Picker using the custom visual in Power BI and real data from Spotify Playlist to help select a song based on Artist, Tempo, or Key. | Dashboard |