Picture of Me!

Hey! I'm Jason Bo Tonogbanua ðŸ‘‹

I'm a data analyst with a strong passion for analyzing and bringing data to life.

This is my tool stack

Excel Logo
Excel
Power Bi Logo
Power Bi
Tableau Logo
Tableau
MySQL Logo
MySQL

Here are some of my projects

  • Maven Career Dashboard

    Maven Career Dashboard

    Excel, Data Prep, Data Visualization, Pivot Table

    Created a dashboard that would help analyze different careers across different states in the USA. The average number of employees and average wages can be seen from the visuals created. This dashboard is intended to help high school students explore different career opportunities in the USA.

  • Booking Dashbooard

    Booking Dashboard

    Excel, Data Prep, Data Visualization, Pivot Table

    This dashboard analyzes the performance of Maven Hotel during July and August. The main problem arises from the cancellation of customers that costs the company around $1 million lost in revenue. It can be seen from the dashboard that during July and August are the months were the company loses the most sales. It can then be further analyze that overbooking same month reservations can help the company resolve the issue.

  • Car subscription project

    Maven Toy Store Dashboard

    Excel, Data Prep, Data Visualization, Pivot Table

    This dashboard summarizes the different perfomances of Maven Toys accross Los Angeles, Chicago, and New York. This dashboard is intended to be updated monthly as this is an interactive dashboard. This dashboard summarizes the total revenue that all stores made and it shows the monthly and yearly change. The dashboard also ranks the different store performances across the different cities and it also shows the products that made the company the most money and the products the company needs to address.

  • Service Scoring Dashboard

    Service Scoring Dashboard

    Excel, Data Prep, Data Visualization, Pivot Table

    This dashboard summarizes the performance of employees in the Service department. It shows the overall leaders and weekly leaders. It breaksdown the hit and miss of employees based on their overall score.

  • Movie Rental Store Analysis Using SQL

    Movie Rental Store Analysis Using SQL

    MySQL, SQL

    Provided analysis of a movie rental store using MySQL. Used the basics of query statements to provide insights to the stakeholders.

  • Database Creation

    Database Administration

    MySQL, SQL

    Created a store database in MySQL. Populated the databased using DDL and DML. Provided user and security management.

  • Database Creation

    E-commerce SQL Analysis

    MySQL, SQL

    Used SQL to analyze E-commerce website. Conducted traffic sources analysis, website performance analysis, website performance analysis, channel portfolios analysis, product-level analysis, and etc.