📊 My Data Analyst Portfolio 📊

Welcome to my portfolio! I'm a dedicated data analyst on a mission to make sense of numbers and reveal valuable insights 🔎. Here, you'll discover a handpicked selection of projects highlighting my expertise in analyzing complex data and creating engaging visualizations 📈. Each project reflects my dedication to turning information into practical intelligence 🥸.

Recent Work

🔊 Data Analysis for Thesis on Sound Source Localization and Counting

Skills: Python, Data Visualization, ETL

  • Utilized various python packages such as Numpy and Scipy to preprocess the audio signals.
  • Recorded count and angles of sound sources to csv files.
  • Conducted data analysis on the csv files and used Matplotlib to visualize the data.
  • Extensively used Jupyter Notebooks to build algorithms and conduct analysis.

🧑‍🏫 Data Professional Survey Breakdown in Power BI

Skills: Power BI (Load, Transform, Visualize)

  • Enables analysis on a survey conducted on data professionals on their favorite programming language, salary, work-life balance, and difficulty breaking into data.
  • Loaded data from an Excel file and cleaned data for analysis.
  • Utilized cards, gauges, a bar chart, a column chart, a treemap, and a doughnut chart to support analysis of the data.

📱 Notes and Website Blocker Web App in Flask

Skills: Python, Web Development, Git, Github, SQL

  • Used Flask library in Python to make the website blocker and note-taking apps.
  • Note-taking app uses a SQLite database using SQLAlchemy object relational mapping (ORM) to store notes.
  • Actively used Git and Github during development for version control.
  • Deployed the web app into Heroku hosting site.
  • The website blocker utilizes the local device's hosts file and, as a result, will not function on an online server.

🌐 Web Scraping and ETL Framework in Python

Skills: Python, Web Scraping, ETL, SQL

  • Used a Jupyter Notebook to implement the Python script for the project.
  • Utilized BeautifulSoup to web scrape data from a Wikipedia table.
  • Loaded the extracted data into a SQLite database.
  • Transformed the data using Pandas and Numpy libraries in Python.
  • Conducted several SQL queries to verify data retrieval from the database.

⚕️ Medical Data Visualizer

Skills: Python, Data Visualization

  • Utilized Pandas to load and transform data from a csv file for analysis.
  • Used Seaborn and Matplotlib to construct a categorical bar graph to visualize the count of people with issues in their health, and a heat map to determine the correlation between each variable in the dataset.

📈 Page View Time Series Visualizer

Skills: Python, Data Visualization

  • Utilized Pandas to load and transform data from a csv file for analysis.
  • Used Seaborn and Matplotlib to construct a clustered column chart, a line chart, and box plots to visualize and analyze a website’s page views with respect to time.

💆 Salon Appointment Scheduler

Skills: SQL, PostgreSQL, Linux, Shell Scripting

  • Uses Linux command line to enable a salon’s customers to schedule appointments through a shell script.
  • Created a PostgreSQL database to store salon’s services, customer details, and appointment details.
  • Updates the database to match the status of customers’ appointments.

🧪 Periodic Table Database

Skills: SQL, PostgreSQL, Linux, Shell Scripting

  • Created a PostgreSQL database for storing elements along with their properties from the periodic table.
  • Implemented a Linux shell script that receives an element's name, symbol, or atomic number.
  • Checks if the received element is valid and present in the database.
  • Implements a query that returns the details of the specified element.

Get In Touch