Hello, It's Me

Carlo de Guzman

And I'm a

Greetings! I'm Carlo de Guzman, a goal-oriented and persevering fresh graduate of Far Eastern University - Institute of Technology with a Bachelor of Science in Information Technology, specializing in Service Management and Business Analytics who is an aspiring Data Analyst. Curious, a great team player, and with a desire for continuous learning. I am excited to bring my passion and dedication to the field!


I have acquired several data analyst credentials, such as data analytics courses and certifications, a hackathon, and an internship in this field. This hones my skills in using tools like Microsoft Excel, PostgreSQL, and Power BI, and gaining practical experience in data cleaning and transformation, analyzing reports, creating dashboards, and presenting data for these are essential to a Data Analyst. I'm confident that my strong foundation and eagerness to learn will enable me to excel as a data analyst and make valuable contributions to your organization!

View Resume

About Me

Data Analyst

As a data analyst enthusiast, I have pursued various learning opportunities and practical experiences in this field since June 2022. I have acquired several data analyst credentials, such as data analytics courses and certifications, a conference, a hackathon, and an internship completion in this field.

I also enrolled in two long-term paid data courses: Google Data Analytics and Refocus Digital Academy for Data Analytics. These courses have enabled me to demonstrate my skills in data cleaning and transformation, analysis, and visualization, using tools such as Microsoft Excel, PostgreSQL, and Power BI. I have applied these skills to solo and group projects that solved scenario-based problems with data-driven solutions, which I have showcased in my website portfolio.

Furthermore, I have gained hands-on experience as a Data Analyst Intern at Timefree Innovations, a company that provides digital transformations for various industries. I was responsible for creating charts, performing data entry tasks, and resolving Microsoft Excel issues for their client’s website, Samsung.

I graduated with a Bachelor of Science in Information Technology with a Specialization in Service Management and Business Analytics degree from Far Eastern University – Institute of Technology in February 2024. My academic and online education have prepared me to become a competent Data Analyst. I have found the start of my data analytics journey to be rewarding and challenging, and I am eager to learn more and apply my skills in the corporate world.

My Services

Microsoft Excel


Microsoft Excel allows data analysts to efficiently clean, organize, manipulate, analyze, and visualize large sets of data using a variety of functions and tools. I can proceed to Data cleaning until Data Visualization in Excel or we can use PostgreSQL and Power BI for better data preparation and visualization.

PostgreSQL



PostgreSQL allows data analysts to leverage its powerful query engine and analytics features to clean, manipulate, analyze, and extract insights from large and complex datasets. I mainly used PostgreSQL for data preparation and data process.

Power BI



Power BI enables data analysts to quickly and easily transform from various sources into visually compelling and interactive insights, allowing for better-informed business decisions. I can also clean and organize the data with Power BI.

Featured Projects

Olist E-Commerce Analysis

This is a Brazilian e-commerce public dataset of orders made at the Olist Store. The dataset has information on 100,000 orders from 2016 to 2018 made at multiple marketplaces in Brazil. The dataset includes details such as the status of the order, the price and payment information, customer location, and product attributes.

Data Analysis of Taming Tardiness in a Hospital Company (Group Project)

Employee tardiness is common in many organizations, and this has been a persistent problem for many companies. Our primary goal is to assist our CEO in resolving employee tardiness and how to manage it.

Strategic Expansion Analysis: Identifying High-Potential States for Smartwatch Market Expansion

A Los Angeles-based startup aims to expand its innovative health tracker smartwatch beyond California, venturing into a new state for increased market reach and growth potential.

The Uphill Advantage: Adventure Works’ Strategic Sales Climb

Adventure Works Bike Shop aims to analyze their historical sales data to extract valuable insights and inform strategic marketing decisions.







Featured Achievements

Business Intelligence with Power BI End-to-End Solutions

April 2024

We emphasized data preparation, establishing clear relationships between data sets, data analysis, and data visualization. Additionally, we explored creating DAX measures to create some financial metrics. I’m excited about applying these skills and look forward to our continuous learning journey. Notably, the capstone project narrative report for this data project is titled ‘The Uphill Advantage: Adventure Works’ Strategic Sales Climb’, which was featured in my projects.”

View Certificate

Excel Fundamentals

February 2024

This 16-hour course refreshed and enhanced my skills in Excel to manipulate, analyze, and visualize data in a variety of ways. I enhanced my skills in working with different data types, creating formulas and functions, and building charts and pivot tables.

View Certificate

2nd Philippine Conference on Data Analytics

September 2023

I'm thrilled to share that I had the incredible opportunity to participate in the 2nd Philippine Conference on Data Analytics with the theme, "Data Analytics for Good Governance: Driving Solutions for a Better Future" that was held on 28 September 2023 at the FEU Tech Innovation Center in Manila City.
This event brought together a remarkable group of professionals and data analytics enthusiasts, all passionate about harnessing the power of data for positive change.
During the conference, I had the privilege of witnessing some outstanding data-driven projects that showcased the transformative impact of analytics in various sectors. The enthusiasm for gaining insights from data was palpable, and I had the pleasure of making new friends and valuable connections who share my passion for data-driven
decision-making.

View Certificate

The Core and Advanced Tracks of the Data Analytics Course

June 2022 – September 2023

I'm thrilled to share that I've successfully completed the Refocus Digital Academy for Data Analytics Course! Throughout this journey, I've tackled assignments and solo and group projects using a variety of powerful data analytics tools, including Excel, PostgreSQL, Power BI, and Python. This course has equipped me with the skills and knowledge needed to thrive in the data analytics field. I'm eager to apply what I've learned to the tech world, where I plan to drive business growth through data-driven strategies.
I'd also like to invite you to check out my Final Project in Refocus on LinkedIn(or the 4th project on Feautred Projects), titled "Strategic Expansion Analysis: Identifying High-Potential States for Smartwatch Market Expansion." It's a culmination of my hard work and showcases the practical insights I've gained. Join me on this exciting data journey as we uncover opportunities that will shape our strategic decisions in the ever-evolving smartwatch market! Let's make data-driven decisions together!

View Certificate

Data Analytics and Visualization Virtual Experience

July 2023

I’m happy to share that I’ve obtained a new certification: Data Analytics and Visualization Virtual Experience from Forage! where I have completed practical tasks in Project Understanding, Data Cleaning and Modeling, Data Visualization & Storytelling, and Presenting to the Client. It's a great opportunity for me to learn more about how Accenture companies analyze and visualize data!

View Certificate

Data Analytics 101

March 2023 - April 2023

I’m happy to share that I’ve obtained a new certification: Data Analytics 101 from Bayan Academy! This 30-day program covered Foundational Skills as a Data Analyst using Excel and Power BI. I'm grateful for this opportunity to improve my data analytics skills and gain valuable insights. Excited to use my new knowledge in future projects!

View Certificate

Information Technology Specialist - Python

March 2023

I passed a proctored exam on Python complete with identity verification at a Certiport Authorized Testing Center. As a holder of the Information Technology Specialist - Python certification from Certiport, I have demonstrated my ability to recognize, write, and debug Python code that can logically solve problems. This certification is globally recognized by industries as the professional standard for basic Python competency, and it showcases my knowledge and skills in the Python programming language. Having passed the exam, I have showcased my ability to use Python to solve problems and my dedication to continually improving my skills. This certification can help open doors to new career opportunities.

View Badge

Google Data Analytics Certificate

September 2022 – January 2023

One of my biggest accomplishments was completing a Google Course named "Google Data Analytics" through Coursera. This certification program included data understanding, data analyzation, and data visualization. It required a lot of concentration and effort, and we had the chance to accomplish a capstone project. This certification has given me the courage to take on new challenges in my profession and this qualification will also help me stand out in a crowded employment market. I am grateful for having the opportunity to have finished this program, and I believe it has equipped me with the skills and knowledge to begin my future career as a data analyst.

View Certificate

The Core Track of the Data Analytics Course

June 2022 – Oct 2022

I have completed the core track of the Data Analytics program of Refocus. This was the first Course that peaked my interest in becoming a Data Analyst as I will graduate 2-3 years from now as a Business Analyst Student. The core track comprises of Microsoft Excel and PostgreSQL. I have completed 50 hours of video lectures, assessments, and self-study. With 14 assignments passed a lot of skills acquired. During the core track, I have also finished the Group Project: Elevating Yellavate which gave me the opportunity to be the SQL Lead in the team.

View Certificate

Information Technology Specialist - Databases

July 2021

I passed a proctored exam on Databases complete with identity verification at a Certiport Authorized Testing Center at Far Eastern University – Institute of Technology. This certification is globally recognized by industries as the professional standard for basic Databases competency, and it showcases my knowledge and skills in the SQL programming language. Additionally, this certification is evidence of my commitment to keeping pace with rapidly changing technology, which positions me for increased skills, efficiency, and earning potential in my future career roles.

View Badge