Adventure Works Analysis

Analyzed the store's monthly sales and investigated on the sudden loss of profit.

Construction and Repair Contracts Analysis

This analysis shows the discrepancies in the differences between the original and revised prices of the contracts. Within the construction industry, having a proper estimate of the contracts' prices is important to avoid the reduction of profits.

Super Store Analysis

A descriptive analysis of the store's best products and location. The data was summarized and filtered through SQL. Then used Google Sheets and Google Sheets to build a report. And Looker Studio for the creation of the dashboard for better visual and navigation.

Data Analyst Job Openings

Summarizes the open data analyst roles on the Jobstreet website within the Philippines. The data was collected through Web Scraper, cleaned on Excel, and visualized on Data Studio to easily filter the jobs based on work setup and work shifts.

QR Code Marketing

I developed a Dashboard using Excel which changes the charts based on the selected KPI. I've made use of advanced formulas and built-in functions of Excel such as Camera and Name Manager.

Manila Construction Trend Diagnostic and Predictive Analysis

Shows if there is a significant trend in construction projects per quarter of the year. Then performed regression analysis to identify the pattern of occurring projects and predict future construction activities.