interactive dashboard

The Google Data Analytics course expanded my knowledge in various aspects of data analysis. I gained expertise in data cleaning, analysis, and storytelling. It refreshed my logical thinking skills and SQL proficiency and I also learned to create impactful data visualizations and narratives using Tableau dashboards. This comprehensive experience refreshed my skills as a risk analyst and provided valuable insights, benefiting my data analytics career.

I was thrilled to apply my creativity and critical thinking in this field, as problem-solving has always been my true passion.

dengue progression dashboard

Tableau - Dengue Dashboard

As part of my Google Data Analytics capstone project, I developed an interactive Tableau dashboard. The purpose was to shed light on the dengue fever cases in the Philippines from 2016 to 2020. The first step in this rewarding journey was detailed data sourcing, ensuring that the information was both reliable and relevant. This was followed by a rigorous cleaning process, enhancing the data's accuracy for comprehensive analysis.

The second phase involved leveraging Tableau's visualization capabilities to create an intuitive, engaging dashboard. The goal was to transform complex data into digestible, visual insights. This project not only honed my data analytics skills but also highlighted the intersection of technology and public health. The resulting dashboard can serve as a valuable tool in facilitating informed decision-making for dengue control in the Philippines.

drill-down analytics

In Project Sparta's SP401 task, we were given the challenge of extensively analyzing term deposit subscriptions. As a risk analyst, I found this task particularly enjoyable and engaging, as it resonated with my skillset of data interpretation to create valuable insights and suggestions.

The data revealed that most subscribers were aged 26-40, married, educated to secondary/tertiary level, and predominantly management professionals. People with loans or defaults were less likely to subscribe. Month of May emerged as the peak subscription month, and a complicated relationship was observed with campaign calls - increased frequency led to decreased subscriptions, while longer durations increased them.

data cleaning and manipulation

In SP701 SQL for Data Engineering, we were assigned a task to clean and manipulate a table called "titanic." Our objectives were to handle the null values in the 'cabin' and 'age' columns and perform operations on the 'Name' column to extract the last name, title, and first name.

Throughout the course, I gained valuable knowledge about the Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes. Additionally, I had the opportunity to work with PostgreSQL for the first time. Although I was already familiar with SQL Server and BigQuery, using PostgreSQL was a new and rewarding experience. The course helped me enhance my skills in data engineering and SQL, enabling me to handle data cleaning and manipulation tasks effectively.

dynamic excel Dashboard

As a final project in our SP401 - Dashboard and Drill-down Analytics course in Project Sparta, we were assigned a dataset titled "QR code marketing" with the aim to develop an interactive dashboard utilizing MS Excel.

The learning I acquired during this task was immense, as I was unaware of the extensive capabilities MS Excel offered until I undertook this project. The course was remarkably thorough, providing a truly enjoyable and enlightening educational journey.

Storytelling using data

Smartwatch Presentation

As a final capstone project for SP503 Storytelling using data, we were tasked to create a 3-minute presentation with script for an Innovative Product or Sales. I chose to present smartwatches because I was really fascinated of the evolution of this lifechanging everyday device.

I created a presentation with the data that I gathered from all over the internet from it's history to evolution to benefits, key features, global revenue, market share and it's challenges.

Page updated

Google Sites

Report abuse