Hi! I am Janhavi. ¶
Like a pirate that goes on a navigates the world using a map, a compass and a ship (and a hook) to find treasure, I use Python, SQL, Excel, and Power BI to extract valuable insights from data. I am graduating from the University of Alberta with a Bachelor of Science Specialization in Computing Science.
My Skills ¶
- Naturally curious
- Quick Learner
- Out of the box (sometimes weird) thinking
- Being a computer science student, I am great at googling
- Being a university student, I know the importance of deadlines
- Sometimes funny
Projects ¶
Sales Insights in SQL and Power BI: The project visualizes computer hardware sales and explores changes in revenue over time.
Power BI Report Link
SQL Script and Analysis on GitHub
Customer Demographics Dashboard in Excel: A dashboard showing buyer demographics for a bike sales company.
Download
Visualizing The Weeknd using Power BI and Python: The project visualizes The Weeknd’s top 5 most popular songs and his albums’ features. The dataset was obtained using a Python script that uses Spotify’s web API using the spotipy library.
Project Link
Expenditure Analyzer Using Excel: This is a calculator in excel that takes the expenditure and budget from the user and visualizes it. Assumes: rent is a fixed expense, the variable expenses are groceries, gas, subscriptions and miscellaneous.
Download
Employee Exit Survey Using Jupyter Notebooks, Python, Pandas and Matplotlib : The project analyzes employee exit survey data to determine the experience levels of employees who
had left the institutes of DETE and TAFE, which could help the concerned departments to further understand why
they were losing new and experienced employees.
Project Link
NGTL Projects over the years: A report on Nova Gas Transmission LTD.'s projects over the years in Alberta.
Project Link